Sunday, December 30, 2007

Business Events Oracle, step by step guide

Business Events Oracle, step by step guide.

Described below is a sample of setting up Business Events in Oracle Applications ( 11.5.10) onwards.

The first step to setting up business events is to making sure you have the right responsibilities. You will have to request the system administrator to provide you "Work Flow Administrator" responsibility.

Work Flow Administrator --> Business Events --> Search

Image1

Search for the events you want to attach custom logic to. In this example, the event used is

oracle.apps.jtf.cac.task.createTask

Each time a new task gets created the events will get triggered. Attach the custom pl/sql function that you want to fire associated with this event.

Image2

Now the next step is defining the custom function handling the logic. The standard signature of all subscription functions is

myfunc(p_guid in RAW, p_event in ou noCopy WF_EVENT_T) return varchar2.

You can get the values passed by the event using GeValueForParameter();

CREATE OR REPLACE PACKAGE BODY APPS.test_BE_Pkg IS

FUNCTION my_test_task_business_event(p_subscrition_guid IN RAW,

p_event IN OUT NOCOPY WF_EVENT_T )RETURN VARCHAR2 IS

l_task_id NUMBER;

l_task_status VARCHAR2(30);

l_task_num VARCHAR2(30);

l_event_name VARCHAR2(240) := p_event.getEventName();

BEGIN

l_task_id := p_event.GetValueForParameter('TASK_ID');

INSERT INTO my_temp VALUES ( l_task_id ,l_task_id);

COMMIT;

SELECT sts.NAME,

a.task_number

INTO l_task_status ,

l_task_num

FROM jtf_task_statuses_vl sts,

jtf_tasks_b a

WHERE a.task_id = l_task_id

AND a.task_status_id = sts.task_status_id;

INSERT INTO my_temp VALUES(l_task_num,l_task_status);

RETURN 'SUCCESS';

COMMIT;

END my_test_task_business_event;

END test_BE_Pkg;

/

10 comments:

Anonymous said...

[url=http://is.gd/YQX4gm][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://spymobile54vx.carbonmade.com/projects/4790185]Android-Handy Spion App Kostenlos [/url] [url=http://youthofknowledge.webs.com/apps/profile/109034678/]Hoe Vindt U Een Verloren Mobiele Telefoon Zonder Gps[/url] [url=http://archive.org/details/idmacsumpmar] Selena Espion Gomez Enfants 3d [/url] [url=http://spymobile32im89zk.carbonmade.com/projects/4789781]Prueba Gratuita De Cellspyexposed [/url] [url=http://archive.org/details/kyaveboosym]Cell Phone Gps Software Reviews[/url] http://spymobile54vx.carbonmade.com/projects/4790185 text monitoring iphone 4s Handy Tracker Gps Spion Iphone app Free cell phone spy sem telefone de destino applications espion telephone Android mobiele telefoon spy software detectie
Piada De Perseguidor Do GPS Celular
LEGO Cars 2 Spy Jet Evasion
Gunstige Versteckte Spion-Kameras WLAN
http://post.gmane.org/post.php?group=gmane.comp.debugging.valgrind free download mobile spy for blackberry como ler minha mensagens de texto on-line tmobile telefone de pilha de videovigilancia
[url=http://larmuk.webs.com/apps/profile/109034678/]Buy Mobile Spy Online[/url] [url=http://archive.org/details/eseavrilka]Puede Realizar Un Seguimiento Gps De Mi Telefono[/url] http://archive.org/details/sausatoha anti logiciels espions gratuits anti-spion mobiele pro v1.3.1 basta batteri overvakning app iphone 4

Anonymous said...

Just desire to say your article is as surprising.

The clearness in your post is simply great and i could assume you are an expert on this subject.
Well with your permission allow me to grab your feed
to keep up to date with forthcoming post. Thanks a million and please keep up the rewarding work.


My homepage ... Belajar SEO

mathew delport said...

This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
Fita Chennai reviews
Hadoop Training in Chennai
Big Data Training in Chennai

peter son said...

Thanks for your informative article on ios mobile application development. Your article helped me to explore the future of mobile apps developers. Having sound knowledge on mobile application development will help you to float in mobile application development. iOS Training in Chennai | iOS Training Institutes in Chennai

Anonymous said...

Pokemon Go hacks, tricks, and secrets have been flooding the internet this week. If you are still not aware of Pokemon GO game, you might be living in a cave. Anyways here’s a brief description: It’s a pseudo reality game where players hunt virtual Pokémon on their phones in real-life locations. It uses the camera and GPS on the player’s device to catch Pokémon. Pokemon GO hacks anywhere apk | Pokemon GO Gps hack

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

svr online Training said...

Nice Post.....Salesforce Training Online

techvelocity partners said...

Great post
Risk management consulting services
ROI consultant minnesota
consulting company minnesota

instagram video downloader apk said...

Very Interesting and wonderfull information keep sharing

Anonymous said...

Many thanks for your informative post, People should follow your Oracle DBA Training blog for getting more information and their basic needs.