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;

/

11 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

Unknown 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

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

svrtechnologies said...

Nice Post.....Salesforce Training Online

Unknown 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.

Peter hollens said...

Very Interesting and wonderfull information keep sharing Instagram Video Downloader

KITS Technologies said...

I really liked your blog post.Much thanks again. Awesome.
MSBI training
Mule ESB training
Mulesoft training
Testing tools training
VM Ware training

INFYCLE TECHNOLOGIES said...

Infycle Technologies, the best software training institute in Chennai offers the leading Python course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.