eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_BUSINESS_EVENT_V2PVT dependencies on HZ_EVENT_PKG

Line 32: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

28:
29: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
30:
31: -- commenting the following line as part of bug4369710 fix
32: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
33:
34:
35: --Get the item key
36: l_key := HZ_EVENT_PKG.item_key( l_event_name );

Line 36: l_key := HZ_EVENT_PKG.item_key( l_event_name );

32: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
33:
34:
35: --Get the item key
36: l_key := HZ_EVENT_PKG.item_key( l_event_name );
37:
38: -- commenting the following line(s) as part of bug4369710 fix
39: /*
40: IF l_exist = 'Y' THEN

Line 49: hz_event_pkg.AddParamEnvToList(l_list);

45: -- initialization of object variables
46: l_list := WF_PARAMETER_LIST_T();
47:
48: -- Add Context values to the list
49: hz_event_pkg.AddParamEnvToList(l_list);
50:
51: l_param := WF_PARAMETER_T( NULL, NULL );
52:
53: -- fill the parameters list

Line 61: HZ_EVENT_PKG.raise_event(

57: l_list(l_list.last) := l_param;
58:
59:
60: -- Raise Event
61: HZ_EVENT_PKG.raise_event(
62: p_event_name => l_event_name,
63: p_event_key => l_key,
64: p_parameters => l_list );
65:

Line 97: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

93: -- delete from HZ_PARAMS exists.
94: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
95:
96: -- commenting the following line(s) as part of bug4369710 fix
97: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
98:
99: --Get the item key
100: l_key := HZ_EVENT_PKG.item_key( l_event_name );
101:

Line 100: l_key := HZ_EVENT_PKG.item_key( l_event_name );

96: -- commenting the following line(s) as part of bug4369710 fix
97: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
98:
99: --Get the item key
100: l_key := HZ_EVENT_PKG.item_key( l_event_name );
101:
102: -- commenting the following line(s) as part of bug4369710 fix
103: /*
104: IF l_exist = 'Y' THEN

Line 116: hz_event_pkg.AddParamEnvToList(l_list);

112: -- initialization of object variables
113: l_list := WF_PARAMETER_LIST_T();
114:
115: -- Add Context values to the list
116: hz_event_pkg.AddParamEnvToList(l_list);
117: l_param := WF_PARAMETER_T( NULL, NULL );
118:
119: -- fill the parameters list
120: l_list.extend;

Line 126: HZ_EVENT_PKG.raise_event(

122: l_param.SetValue( p_person_rec.party_rec.party_id );
123: l_list(l_list.last) := l_param;
124:
125: -- Raise Event
126: HZ_EVENT_PKG.raise_event(
127: p_event_name => l_event_name,
128: p_event_key => l_key,
129: p_parameters => l_list );
130:

Line 162: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

158:
159: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
160:
161: -- commenting the following line(s) as part of bug4369710 fix
162: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
163:
164: --Get the item key
165: l_key := HZ_EVENT_PKG.item_key( l_event_name );
166:

Line 165: l_key := HZ_EVENT_PKG.item_key( l_event_name );

161: -- commenting the following line(s) as part of bug4369710 fix
162: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
163:
164: --Get the item key
165: l_key := HZ_EVENT_PKG.item_key( l_event_name );
166:
167: -- commenting the following line(s) as part of bug4369710 fix
168: /*
169: IF l_exist = 'Y' THEN

Line 180: hz_event_pkg.AddParamEnvToList(l_list);

176: l_list := WF_PARAMETER_LIST_T();
177:
178:
179: -- Add Context values to the list
180: hz_event_pkg.AddParamEnvToList(l_list);
181: l_param := WF_PARAMETER_T( NULL, NULL );
182:
183: -- fill the parameters list
184: l_list.extend;

Line 190: HZ_EVENT_PKG.raise_event(

186: l_param.SetValue( p_group_rec.party_rec.party_id );
187: l_list(l_list.last) := l_param;
188:
189: -- Raise Event
190: HZ_EVENT_PKG.raise_event(
191: p_event_name => l_event_name,
192: p_event_key => l_key,
193: p_parameters => l_list );
194:

Line 227: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

223:
224: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
225:
226: -- commenting the following line(s) as part of bug4369710 fix
227: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
228:
229: --Get the item key
230: l_key := HZ_EVENT_PKG.item_key( l_event_name );
231:

Line 230: l_key := HZ_EVENT_PKG.item_key( l_event_name );

226: -- commenting the following line(s) as part of bug4369710 fix
227: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
228:
229: --Get the item key
230: l_key := HZ_EVENT_PKG.item_key( l_event_name );
231:
232: -- commenting the following line(s) as part of bug4369710 fix
233: /*
234: IF l_exist = 'Y' THEN

Line 245: hz_event_pkg.AddParamEnvToList(l_list);

241: l_list := WF_PARAMETER_LIST_T();
242:
243:
244: -- Add Context values to the list
245: hz_event_pkg.AddParamEnvToList(l_list);
246: l_param := WF_PARAMETER_T( NULL, NULL );
247:
248: -- fill the parameters list
249: l_list.extend;

Line 255: HZ_EVENT_PKG.raise_event(

251: l_param.SetValue( p_group_rec.party_rec.party_id );
252: l_list(l_list.last) := l_param;
253:
254: -- Raise Event
255: HZ_EVENT_PKG.raise_event(
256: p_event_name => l_event_name,
257: p_event_key => l_key,
258: p_parameters => l_list );
259:

Line 290: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

286: -- delete from HZ_PARAMS exists.
287: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
288:
289: -- commenting the following line(s) as part of bug4369710 fix
290: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
291:
292: --Get the item key
293: l_key := HZ_EVENT_PKG.item_key( l_event_name );
294:

Line 293: l_key := HZ_EVENT_PKG.item_key( l_event_name );

289: -- commenting the following line(s) as part of bug4369710 fix
290: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
291:
292: --Get the item key
293: l_key := HZ_EVENT_PKG.item_key( l_event_name );
294:
295: -- commenting the following line(s) as part of bug4369710 fix
296: /*
297: IF l_exist = 'Y' THEN

Line 307: hz_event_pkg.AddParamEnvToList(l_list);

303: -- initialization of object variables
304: l_list := WF_PARAMETER_LIST_T();
305:
306: -- Add Context values to the list
307: hz_event_pkg.AddParamEnvToList(l_list);
308: l_param := WF_PARAMETER_T( NULL, NULL );
309:
310:
311: -- fill the parameters list

Line 318: HZ_EVENT_PKG.raise_event(

314: l_param.SetValue( p_organization_rec.party_rec.party_id );
315: l_list(l_list.last) := l_param;
316:
317: -- Raise Event
318: HZ_EVENT_PKG.raise_event(
319: p_event_name => l_event_name,
320: p_event_key => l_key,
321: p_parameters => l_list );
322:

Line 355: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

351:
352: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
353:
354: -- commenting the following line(s) as part of bug4369710 fix
355: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
356:
357: --Get the item key
358: l_key := HZ_EVENT_PKG.item_key( l_event_name );
359:

Line 358: l_key := HZ_EVENT_PKG.item_key( l_event_name );

354: -- commenting the following line(s) as part of bug4369710 fix
355: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
356:
357: --Get the item key
358: l_key := HZ_EVENT_PKG.item_key( l_event_name );
359:
360: -- commenting the following line(s) as part of bug4369710 fix
361: /*
362: IF l_exist = 'Y' THEN

Line 373: hz_event_pkg.AddParamEnvToList(l_list);

369: -- initialization of object variables
370: l_list := WF_PARAMETER_LIST_T();
371:
372: -- Add Context values to the list
373: hz_event_pkg.AddParamEnvToList(l_list);
374: l_param := WF_PARAMETER_T( NULL, NULL );
375:
376:
377: -- fill the parameters list

Line 384: HZ_EVENT_PKG.raise_event(

380: l_param.SetValue( p_organization_rec.party_rec.party_id );
381: l_list(l_list.last) := l_param;
382:
383: -- Raise Event
384: HZ_EVENT_PKG.raise_event(
385: p_event_name => l_event_name,
386: p_event_key => l_key,
387: p_parameters => l_list );
388:

Line 423: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

419:
420: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
421:
422: -- commenting the following line(s) as part of bug4369710 fix
423: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
424:
425: --Get the item key
426: l_key := HZ_EVENT_PKG.item_key( l_event_name );
427:

Line 426: l_key := HZ_EVENT_PKG.item_key( l_event_name );

422: -- commenting the following line(s) as part of bug4369710 fix
423: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
424:
425: --Get the item key
426: l_key := HZ_EVENT_PKG.item_key( l_event_name );
427:
428: -- commenting the following line(s) as part of bug4369710 fix
429: /*
430: IF l_exist = 'Y' THEN

Line 441: hz_event_pkg.AddParamEnvToList(l_list);

437: -- initialization of object variables
438: l_list := WF_PARAMETER_LIST_T();
439:
440: -- Add Context values to the list
441: hz_event_pkg.AddParamEnvToList(l_list);
442: l_param := WF_PARAMETER_T( NULL, NULL );
443:
444:
445: -- fill the parameters list

Line 457: HZ_EVENT_PKG.raise_event(

453: l_param.SetValue( p_party_created );
454: l_list(l_list.last) := l_param;
455:
456: -- Raise Event
457: HZ_EVENT_PKG.raise_event(
458: p_event_name => l_event_name,
459: p_event_key => l_key,
460: p_parameters => l_list );
461:

Line 494: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

490:
491: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
492:
493: -- commenting the following line(s) as part of bug4369710 fix
494: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
495:
496: --Get the item key
497: l_key := HZ_EVENT_PKG.item_key( l_event_name );
498:

Line 497: l_key := HZ_EVENT_PKG.item_key( l_event_name );

493: -- commenting the following line(s) as part of bug4369710 fix
494: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
495:
496: --Get the item key
497: l_key := HZ_EVENT_PKG.item_key( l_event_name );
498:
499: -- commenting the following line(s) as part of bug4369710 fix
500: /*
501: IF l_exist = 'Y' THEN

Line 513: hz_event_pkg.AddParamEnvToList(l_list);

509: -- initialization of object variables
510: l_list := WF_PARAMETER_LIST_T();
511:
512: -- Add Context values to the list
513: hz_event_pkg.AddParamEnvToList(l_list);
514: l_param := WF_PARAMETER_T( NULL, NULL );
515:
516:
517: -- fill the parameters list

Line 524: HZ_EVENT_PKG.raise_event(

520: l_param.SetValue( p_relationship_rec.relationship_id );
521: l_list(l_list.last) := l_param;
522:
523: -- Raise Event
524: HZ_EVENT_PKG.raise_event(
525: p_event_name => l_event_name,
526: p_event_key => l_key,
527: p_parameters => l_list );
528:

Line 562: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

558:
559: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
560:
561: -- commenting the following line(s) as part of bug4369710 fix
562: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
563:
564: --Get the item key
565: l_key := HZ_EVENT_PKG.item_key( l_event_name );
566:

Line 565: l_key := HZ_EVENT_PKG.item_key( l_event_name );

561: -- commenting the following line(s) as part of bug4369710 fix
562: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
563:
564: --Get the item key
565: l_key := HZ_EVENT_PKG.item_key( l_event_name );
566:
567: -- commenting the following line(s) as part of bug4369710 fix
568: /*
569: IF l_exist = 'Y' THEN

Line 578: hz_event_pkg.AddParamEnvToList(l_list);

574: -- initialization of object variables
575: l_list := WF_PARAMETER_LIST_T();
576:
577: -- Add Context values to the list
578: hz_event_pkg.AddParamEnvToList(l_list);
579: l_param := WF_PARAMETER_T( NULL, NULL );
580:
581:
582: -- fill the parameters list

Line 589: HZ_EVENT_PKG.raise_event(

585: l_param.SetValue( p_party_site_rec.party_site_id );
586: l_list(l_list.last) := l_param;
587:
588: -- Raise Event
589: HZ_EVENT_PKG.raise_event(
590: p_event_name => l_event_name,
591: p_event_key => l_key,
592: p_parameters => l_list );
593:

Line 625: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

621:
622: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
623:
624: -- commenting the following line(s) as part of bug4369710 fix
625: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
626:
627: --Get the item key
628: l_key := HZ_EVENT_PKG.item_key( l_event_name );
629:

Line 628: l_key := HZ_EVENT_PKG.item_key( l_event_name );

624: -- commenting the following line(s) as part of bug4369710 fix
625: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
626:
627: --Get the item key
628: l_key := HZ_EVENT_PKG.item_key( l_event_name );
629:
630: -- commenting the following line(s) as part of bug4369710 fix
631: /*
632: IF l_exist = 'Y' THEN

Line 644: hz_event_pkg.AddParamEnvToList(l_list);

640: -- initialization of object variables
641: l_list := WF_PARAMETER_LIST_T();
642:
643: -- Add Context values to the list
644: hz_event_pkg.AddParamEnvToList(l_list);
645: l_param := WF_PARAMETER_T( NULL, NULL );
646:
647:
648: -- fill the parameters list

Line 655: HZ_EVENT_PKG.raise_event(

651: l_param.SetValue( p_party_site_rec.party_site_id );
652: l_list(l_list.last) := l_param;
653:
654: -- Raise Event
655: HZ_EVENT_PKG.raise_event(
656: p_event_name => l_event_name,
657: p_event_key => l_key,
658: p_parameters => l_list );
659:

Line 691: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

687:
688: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
689:
690: -- commenting the following line(s) as part of bug4369710 fix
691: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
692:
693: --Get the item key
694: l_key := HZ_EVENT_PKG.item_key( l_event_name );
695:

Line 694: l_key := HZ_EVENT_PKG.item_key( l_event_name );

690: -- commenting the following line(s) as part of bug4369710 fix
691: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
692:
693: --Get the item key
694: l_key := HZ_EVENT_PKG.item_key( l_event_name );
695:
696: -- commenting the following line(s) as part of bug4369710 fix
697: /*
698: IF l_exist = 'Y' THEN

Line 708: hz_event_pkg.AddParamEnvToList(l_list);

704: -- initialization of object variables
705: l_list := WF_PARAMETER_LIST_T();
706:
707: -- Add Context values to the list
708: hz_event_pkg.AddParamEnvToList(l_list);
709: l_param := WF_PARAMETER_T( NULL, NULL );
710:
711:
712: -- fill the parameters list

Line 719: HZ_EVENT_PKG.raise_event(

715: l_param.SetValue( p_party_site_use_rec.party_site_use_id );
716: l_list(l_list.last) := l_param;
717:
718: -- Raise Event
719: HZ_EVENT_PKG.raise_event(
720: p_event_name => l_event_name,
721: p_event_key => l_key,
722: p_parameters => l_list );
723:

Line 756: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

752:
753: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
754:
755: -- commenting the following line(s) as part of bug4369710 fix
756: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
757:
758: --Get the item key
759: l_key := HZ_EVENT_PKG.item_key( l_event_name );
760:

Line 759: l_key := HZ_EVENT_PKG.item_key( l_event_name );

755: -- commenting the following line(s) as part of bug4369710 fix
756: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
757:
758: --Get the item key
759: l_key := HZ_EVENT_PKG.item_key( l_event_name );
760:
761: -- commenting the following line(s) as part of bug4369710 fix
762: /*
763: IF l_exist = 'Y' THEN

Line 774: hz_event_pkg.AddParamEnvToList(l_list);

770: -- initialization of object variables
771: l_list := WF_PARAMETER_LIST_T();
772:
773: -- Add Context values to the list
774: hz_event_pkg.AddParamEnvToList(l_list);
775: l_param := WF_PARAMETER_T( NULL, NULL );
776:
777:
778: -- fill the parameters list

Line 785: HZ_EVENT_PKG.raise_event(

781: l_param.SetValue( p_party_site_use_rec.party_site_use_id );
782: l_list(l_list.last) := l_param;
783:
784: -- Raise Event
785: HZ_EVENT_PKG.raise_event(
786: p_event_name => l_event_name,
787: p_event_key => l_key,
788: p_parameters => l_list );
789:

Line 824: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

820:
821: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
822:
823: -- commenting the following line(s) as part of bug4369710 fix
824: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
825:
826: --Get the item key
827: l_key := HZ_EVENT_PKG.item_key( l_event_name );
828:

Line 827: l_key := HZ_EVENT_PKG.item_key( l_event_name );

823: -- commenting the following line(s) as part of bug4369710 fix
824: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
825:
826: --Get the item key
827: l_key := HZ_EVENT_PKG.item_key( l_event_name );
828:
829: -- commenting the following line(s) as part of bug4369710 fix
830: /* IF l_exist = 'Y' THEN
831: --Set Parameter

Line 839: hz_event_pkg.AddParamEnvToList(l_list);

835: -- initialization of object variables
836: l_list := WF_PARAMETER_LIST_T();
837:
838: -- Add Context values to the list
839: hz_event_pkg.AddParamEnvToList(l_list);
840: l_param := WF_PARAMETER_T( NULL, NULL );
841:
842:
843: -- fill the parameters list

Line 850: HZ_EVENT_PKG.raise_event(

846: l_param.SetValue( p_org_contact_rec.org_contact_id );
847: l_list(l_list.last) := l_param;
848:
849: -- Raise Event
850: HZ_EVENT_PKG.raise_event(
851: p_event_name => l_event_name,
852: p_event_key => l_key,
853: p_parameters => l_list );
854:

Line 887: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

883:
884: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
885:
886: -- commenting the following line(s) as part of bug4369710 fix
887: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
888:
889: --Get the item key
890: l_key := HZ_EVENT_PKG.item_key( l_event_name );
891:

Line 890: l_key := HZ_EVENT_PKG.item_key( l_event_name );

886: -- commenting the following line(s) as part of bug4369710 fix
887: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
888:
889: --Get the item key
890: l_key := HZ_EVENT_PKG.item_key( l_event_name );
891:
892: -- commenting the following line(s) as part of bug4369710 fix
893: /*
894: IF l_exist = 'Y' THEN

Line 906: hz_event_pkg.AddParamEnvToList(l_list);

902: -- initialization of object variables
903: l_list := WF_PARAMETER_LIST_T();
904:
905: -- Add Context values to the list
906: hz_event_pkg.AddParamEnvToList(l_list);
907: l_param := WF_PARAMETER_T( NULL, NULL );
908:
909:
910: -- fill the parameters list

Line 917: HZ_EVENT_PKG.raise_event(

913: l_param.SetValue( p_org_contact_rec.org_contact_id );
914: l_list(l_list.last) := l_param;
915:
916: -- Raise Event
917: HZ_EVENT_PKG.raise_event(
918: p_event_name => l_event_name,
919: p_event_key => l_key,
920: p_parameters => l_list );
921:

Line 953: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

949:
950: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
951:
952: -- commenting the following line(s) as part of bug4369710 fix
953: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
954:
955: --Get the item key
956: l_key := HZ_EVENT_PKG.item_key( l_event_name );
957:

Line 956: l_key := HZ_EVENT_PKG.item_key( l_event_name );

952: -- commenting the following line(s) as part of bug4369710 fix
953: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
954:
955: --Get the item key
956: l_key := HZ_EVENT_PKG.item_key( l_event_name );
957:
958: -- commenting the following line(s) as part of bug4369710 fix
959: /*
960: IF l_exist = 'Y' THEN

Line 969: hz_event_pkg.AddParamEnvToList(l_list);

965: -- initialization of object variables
966: l_list := WF_PARAMETER_LIST_T();
967:
968: -- Add Context values to the list
969: hz_event_pkg.AddParamEnvToList(l_list);
970: l_param := WF_PARAMETER_T( NULL, NULL );
971:
972:
973: -- fill the parameters list

Line 980: HZ_EVENT_PKG.raise_event(

976: l_param.SetValue( p_org_contact_role_rec.org_contact_role_id );
977: l_list(l_list.last) := l_param;
978:
979: -- Raise Event
980: HZ_EVENT_PKG.raise_event(
981: p_event_name => l_event_name,
982: p_event_key => l_key,
983: p_parameters => l_list );
984:

Line 1017: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1013:
1014: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1015:
1016: -- commenting the following line(s) as part of bug4369710 fix
1017: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1018:
1019: --Get the item key
1020: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1021:

Line 1020: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1016: -- commenting the following line(s) as part of bug4369710 fix
1017: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1018:
1019: --Get the item key
1020: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1021:
1022: -- commenting the following line(s) as part of bug4369710 fix
1023: /*
1024: IF l_exist = 'Y' THEN

Line 1035: hz_event_pkg.AddParamEnvToList(l_list);

1031: -- initialization of object variables
1032: l_list := WF_PARAMETER_LIST_T();
1033:
1034: -- Add Context values to the list
1035: hz_event_pkg.AddParamEnvToList(l_list);
1036: l_param := WF_PARAMETER_T( NULL, NULL );
1037:
1038:
1039: -- fill the parameters list

Line 1046: HZ_EVENT_PKG.raise_event(

1042: l_param.SetValue( p_org_contact_role_rec.org_contact_role_id );
1043: l_list(l_list.last) := l_param;
1044:
1045: -- Raise Event
1046: HZ_EVENT_PKG.raise_event(
1047: p_event_name => l_event_name,
1048: p_event_key => l_key,
1049: p_parameters => l_list );
1050:

Line 1084: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1080:
1081: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1082:
1083: -- commenting the following line(s) as part of bug4369710 fix
1084: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1085:
1086: --Get the item key
1087: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1088:

Line 1087: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1083: -- commenting the following line(s) as part of bug4369710 fix
1084: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1085:
1086: --Get the item key
1087: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1088:
1089: -- commenting the following line(s) as part of bug4369710 fix
1090: /*
1091: IF l_exist = 'Y' THEN

Line 1100: hz_event_pkg.AddParamEnvToList(l_list);

1096: -- initialization of object variables
1097: l_list := WF_PARAMETER_LIST_T();
1098:
1099: -- Add Context values to the list
1100: hz_event_pkg.AddParamEnvToList(l_list);
1101: l_param := WF_PARAMETER_T( NULL, NULL );
1102:
1103:
1104: -- fill the parameters list

Line 1111: HZ_EVENT_PKG.raise_event(

1107: l_param.SetValue( p_location_rec.location_id );
1108: l_list(l_list.last) := l_param;
1109:
1110: -- Raise Event
1111: HZ_EVENT_PKG.raise_event(
1112: p_event_name => l_event_name,
1113: p_event_key => l_key,
1114: p_parameters => l_list );
1115:

Line 1149: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1145:
1146: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1147:
1148: -- commenting the following line(s) as part of bug4369710 fix
1149: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1150:
1151: --Get the item key
1152: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1153:

Line 1152: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1148: -- commenting the following line(s) as part of bug4369710 fix
1149: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1150:
1151: --Get the item key
1152: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1153:
1154: -- commenting the following line(s) as part of bug4369710 fix
1155: /*
1156: IF l_exist = 'Y' THEN

Line 1167: hz_event_pkg.AddParamEnvToList(l_list);

1163: -- initialization of object variables
1164: l_list := WF_PARAMETER_LIST_T();
1165:
1166: -- Add Context values to the list
1167: hz_event_pkg.AddParamEnvToList(l_list);
1168: l_param := WF_PARAMETER_T( NULL, NULL );
1169:
1170:
1171: -- fill the parameters list

Line 1178: HZ_EVENT_PKG.raise_event(

1174: l_param.SetValue( p_location_rec.location_id );
1175: l_list(l_list.last) := l_param;
1176:
1177: -- Raise Event
1178: HZ_EVENT_PKG.raise_event(
1179: p_event_name => l_event_name,
1180: p_event_key => l_key,
1181: p_parameters => l_list );
1182:

Line 1227: -- l_exist := hz_event_pkg.exist_subscription( l_event_name );

1223:
1224: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1225:
1226: -- commenting the following line(s) as part of bug4369710 fix
1227: -- l_exist := hz_event_pkg.exist_subscription( l_event_name );
1228:
1229: --Get the item key
1230: l_key := hz_event_pkg.item_key( l_event_name );
1231:

Line 1230: l_key := hz_event_pkg.item_key( l_event_name );

1226: -- commenting the following line(s) as part of bug4369710 fix
1227: -- l_exist := hz_event_pkg.exist_subscription( l_event_name );
1228:
1229: --Get the item key
1230: l_key := hz_event_pkg.item_key( l_event_name );
1231:
1232: -- commenting the following line(s) as part of bug4369710 fix
1233: /*
1234: IF l_exist = 'Y' THEN

Line 1249: hz_event_pkg.addparamenvtolist(l_list);

1245: -- initialization of object variables
1246: l_list := WF_PARAMETER_LIST_T();
1247:
1248: -- Add Context values to the list
1249: hz_event_pkg.addparamenvtolist(l_list);
1250: l_param := WF_PARAMETER_T( NULL, NULL );
1251:
1252:
1253: -- fill the parameters list

Line 1260: hz_event_pkg.raise_event(

1256: l_param.setvalue( p_contact_point_rec.contact_point_id );
1257: l_list(l_list.last) := l_param;
1258:
1259: -- Raise Event
1260: hz_event_pkg.raise_event(
1261: p_event_name => l_event_name,
1262: p_event_key => l_key,
1263: p_parameters => l_list );
1264:

Line 1314: --l_exist := hz_event_pkg.exist_subscription( l_event_name );

1310:
1311: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1312:
1313: -- commenting the following line(s) as part of bug4369710 fix
1314: --l_exist := hz_event_pkg.exist_subscription( l_event_name );
1315:
1316: --Get the item key
1317: l_key := hz_event_pkg.item_key( l_event_name );
1318:

Line 1317: l_key := hz_event_pkg.item_key( l_event_name );

1313: -- commenting the following line(s) as part of bug4369710 fix
1314: --l_exist := hz_event_pkg.exist_subscription( l_event_name );
1315:
1316: --Get the item key
1317: l_key := hz_event_pkg.item_key( l_event_name );
1318:
1319: -- commenting the following line(s) as part of bug4369710 fix
1320: /*
1321: IF l_exist = 'Y' THEN

Line 1344: hz_event_pkg.addparamenvtolist(l_list);

1340: -- initialization of object variables
1341: l_list := WF_PARAMETER_LIST_T();
1342:
1343: -- Add Context values to the list
1344: hz_event_pkg.addparamenvtolist(l_list);
1345: l_param := WF_PARAMETER_T( NULL, NULL );
1346:
1347:
1348: -- fill the parameters list

Line 1355: hz_event_pkg.raise_event(

1351: l_param.setvalue( p_contact_point_rec.contact_point_id );
1352: l_list(l_list.last) := l_param;
1353:
1354: -- Raise Event
1355: hz_event_pkg.raise_event(
1356: p_event_name => l_event_name,
1357: p_event_key => l_key,
1358: p_parameters => l_list );
1359:

Line 1393: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1389:
1390: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1391:
1392: -- commenting the following line(s) as part of bug4369710 fix
1393: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1394:
1395: --Get the item key
1396: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1397:

Line 1396: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1392: -- commenting the following line(s) as part of bug4369710 fix
1393: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1394:
1395: --Get the item key
1396: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1397:
1398: -- commenting the following line(s) as part of bug4369710 fix
1399: /*
1400: IF l_exist = 'Y' THEN

Line 1408: hz_event_pkg.AddParamEnvToList(l_list);

1404: */
1405: -- initialization of object variables
1406: l_list := WF_PARAMETER_LIST_T();
1407:
1408: hz_event_pkg.AddParamEnvToList(l_list);
1409: l_param := WF_PARAMETER_T( NULL, NULL );
1410:
1411: -- fill the parameters list
1412: l_list.extend;

Line 1418: HZ_EVENT_PKG.raise_event(

1414: l_param.SetValue( p_contact_preference_rec.contact_preference_id );
1415: l_list(l_list.last) := l_param;
1416:
1417: -- Raise Event
1418: HZ_EVENT_PKG.raise_event(
1419: p_event_name => l_event_name,
1420: p_event_key => l_key,
1421: p_parameters => l_list );
1422:

Line 1456: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1452:
1453: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1454:
1455: -- commenting the following line(s) as part of bug4369710 fix
1456: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1457:
1458: --Get the item key
1459: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1460:

Line 1459: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1455: -- commenting the following line(s) as part of bug4369710 fix
1456: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1457:
1458: --Get the item key
1459: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1460:
1461: -- commenting the following line(s) as part of bug4369710 fix
1462: /*
1463: IF l_exist = 'Y' THEN

Line 1474: hz_event_pkg.AddParamEnvToList(l_list);

1470: -- initialization of object variables
1471: l_list := WF_PARAMETER_LIST_T();
1472:
1473: -- Add Context values to the list
1474: hz_event_pkg.AddParamEnvToList(l_list);
1475: l_param := WF_PARAMETER_T( NULL, NULL );
1476:
1477: -- fill the parameters list
1478: l_list.extend;

Line 1484: HZ_EVENT_PKG.raise_event(

1480: l_param.SetValue( p_contact_preference_rec.contact_preference_id );
1481: l_list(l_list.last) := l_param;
1482:
1483: -- Raise Event
1484: HZ_EVENT_PKG.raise_event(
1485: p_event_name => l_event_name,
1486: p_event_key => l_key,
1487: p_parameters => l_list );
1488:

Line 1526: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1522:
1523: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1524:
1525: -- commenting the following line(s) as part of bug4369710 fix
1526: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1527:
1528: --Get the item key
1529: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1530:

Line 1529: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1525: -- commenting the following line(s) as part of bug4369710 fix
1526: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1527:
1528: --Get the item key
1529: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1530:
1531: -- commenting the following line(s) as part of bug4369710 fix
1532: /*
1533: IF l_exist = 'Y' THEN

Line 1545: hz_event_pkg.AddParamEnvToList(l_list);

1541: -- initialization of object variables
1542: l_list := WF_PARAMETER_LIST_T();
1543:
1544: -- Add Context values to the list
1545: hz_event_pkg.AddParamEnvToList(l_list);
1546: l_param := WF_PARAMETER_T( NULL, NULL );
1547:
1548: -- fill the parameters list
1549: l_list.extend;

Line 1570: HZ_EVENT_PKG.raise_event(

1566: l_param.SetValue( p_create_profile_amt );
1567: l_list(l_list.last) := l_param;
1568:
1569: -- Raise Event
1570: HZ_EVENT_PKG.raise_event(
1571: p_event_name => l_event_name,
1572: p_event_key => l_key,
1573: p_parameters => l_list );
1574:

Line 1610: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1606:
1607: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1608:
1609: -- commenting the following line(s) as part of bug4369710 fix
1610: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1611:
1612: --Get the item key
1613: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1614:

Line 1613: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1609: -- commenting the following line(s) as part of bug4369710 fix
1610: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1611:
1612: --Get the item key
1613: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1614:
1615: -- commenting the following line(s) as part of bug4369710 fix
1616: /*
1617: IF l_exist = 'Y' THEN

Line 1629: hz_event_pkg.AddParamEnvToList(l_list);

1625: -- initialization of object variables
1626: l_list := WF_PARAMETER_LIST_T();
1627:
1628: -- Add Context values to the list
1629: hz_event_pkg.AddParamEnvToList(l_list);
1630: l_param := WF_PARAMETER_T( NULL, NULL );
1631:
1632: -- fill the parameters list
1633: l_list.extend;

Line 1654: HZ_EVENT_PKG.raise_event(

1650: l_param.SetValue( p_create_profile_amt );
1651: l_list(l_list.last) := l_param;
1652:
1653: -- Raise Event
1654: HZ_EVENT_PKG.raise_event(
1655: p_event_name => l_event_name,
1656: p_event_key => l_key,
1657: p_parameters => l_list );
1658:

Line 1692: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1688:
1689: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1690:
1691: -- commenting the following line(s) as part of bug4369710 fix
1692: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1693:
1694: --Get the item key
1695: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1696:

Line 1695: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1691: -- commenting the following line(s) as part of bug4369710 fix
1692: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1693:
1694: --Get the item key
1695: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1696:
1697: -- commenting the following line(s) as part of bug4369710 fix
1698: /*
1699: IF l_exist = 'Y' THEN

Line 1710: hz_event_pkg.AddParamEnvToList(l_list);

1706: -- initialization of object variables
1707: l_list := WF_PARAMETER_LIST_T();
1708:
1709: -- Add Context values to the list
1710: hz_event_pkg.AddParamEnvToList(l_list);
1711: l_param := WF_PARAMETER_T( NULL, NULL );
1712:
1713: -- fill the parameters list
1714: l_list.extend;

Line 1720: HZ_EVENT_PKG.raise_event(

1716: l_param.SetValue( p_cust_account_rec.cust_account_id );
1717: l_list(l_list.last) := l_param;
1718:
1719: -- Raise Event
1720: HZ_EVENT_PKG.raise_event(
1721: p_event_name => l_event_name,
1722: p_event_key => l_key,
1723: p_parameters => l_list );
1724:

Line 1756: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1752:
1753: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1754:
1755: -- commenting the following line(s) as part of bug4369710 fix
1756: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1757:
1758: --Get the item key
1759: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1760:

Line 1759: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1755: -- commenting the following line(s) as part of bug4369710 fix
1756: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1757:
1758: --Get the item key
1759: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1760:
1761: -- commenting the following line(s) as part of bug4369710 fix
1762: /*
1763: IF l_exist = 'Y' THEN

Line 1773: hz_event_pkg.AddParamEnvToList(x_list => l_list,

1769: l_list := WF_PARAMETER_LIST_T();
1770:
1771: -- Add Context values to the list
1772: /* 3456489. Added org_id as a parameter. */
1773: hz_event_pkg.AddParamEnvToList(x_list => l_list,
1774: p_org_id => p_cust_acct_relate_rec.org_id);
1775: l_param := WF_PARAMETER_T( NULL, NULL );
1776:
1777: -- fill the parameters list

Line 1789: HZ_EVENT_PKG.raise_event(

1785: l_param.SetValue( p_cust_acct_relate_rec.related_cust_account_id );
1786: l_list(l_list.last) := l_param;
1787:
1788: -- Raise Event
1789: HZ_EVENT_PKG.raise_event(
1790: p_event_name => l_event_name,
1791: p_event_key => l_key,
1792: p_parameters => l_list );
1793:

Line 1827: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1823:
1824: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1825:
1826: -- commenting the following line(s) as part of bug4369710 fix
1827: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1828:
1829: --Get the item key
1830: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1831:

Line 1830: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1826: -- commenting the following line(s) as part of bug4369710 fix
1827: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1828:
1829: --Get the item key
1830: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1831:
1832: -- commenting the following line(s) as part of bug4369710 fix
1833: /*
1834: IF l_exist = 'Y' THEN

Line 1846: hz_event_pkg.AddParamEnvToList(x_list => l_list,

1842: l_list := WF_PARAMETER_LIST_T();
1843:
1844: -- Add Context values to the list
1845: /* 3456489. Added org_id as a parameter. */
1846: hz_event_pkg.AddParamEnvToList(x_list => l_list,
1847: p_org_id => p_cust_acct_relate_rec.org_id);
1848: l_param := WF_PARAMETER_T( NULL, NULL );
1849:
1850: -- fill the parameters list

Line 1862: HZ_EVENT_PKG.raise_event(

1858: l_param.SetValue( p_cust_acct_relate_rec.related_cust_account_id );
1859: l_list(l_list.last) := l_param;
1860:
1861: -- Raise Event
1862: HZ_EVENT_PKG.raise_event(
1863: p_event_name => l_event_name,
1864: p_event_key => l_key,
1865: p_parameters => l_list );
1866:

Line 1902: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1898:
1899: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1900:
1901: -- commenting the following line(s) as part of bug4369710 fix
1902: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1903:
1904: --Get the item key
1905: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1906:

Line 1905: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1901: -- commenting the following line(s) as part of bug4369710 fix
1902: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1903:
1904: --Get the item key
1905: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1906:
1907: -- commenting the following line(s) as part of bug4369710 fix
1908: /*
1909: IF l_exist = 'Y' THEN

Line 1919: hz_event_pkg.AddParamEnvToList(l_list);

1915: -- initialization of object variables
1916: l_list := WF_PARAMETER_LIST_T();
1917:
1918: -- Add Context values to the list
1919: hz_event_pkg.AddParamEnvToList(l_list);
1920: l_param := WF_PARAMETER_T( NULL, NULL );
1921:
1922: -- fill the parameters list
1923: l_list.extend;

Line 1934: HZ_EVENT_PKG.raise_event(

1930: l_param.SetValue( p_create_profile_amt );
1931: l_list(l_list.last) := l_param;
1932:
1933: -- Raise Event
1934: HZ_EVENT_PKG.raise_event(
1935: p_event_name => l_event_name,
1936: p_event_key => l_key,
1937: p_parameters => l_list );
1938:

Line 1972: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

1968:
1969: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
1970:
1971: -- commenting the following line(s) as part of bug4369710 fix
1972: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1973:
1974: --Get the item key
1975: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1976:

Line 1975: l_key := HZ_EVENT_PKG.item_key( l_event_name );

1971: -- commenting the following line(s) as part of bug4369710 fix
1972: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
1973:
1974: --Get the item key
1975: l_key := HZ_EVENT_PKG.item_key( l_event_name );
1976:
1977: -- commenting the following line(s) as part of bug4369710 fix
1978: /*
1979: IF l_exist = 'Y' THEN

Line 1990: hz_event_pkg.AddParamEnvToList(l_list);

1986: -- initialization of object variables
1987: l_list := WF_PARAMETER_LIST_T();
1988:
1989: -- Add Context values to the list
1990: hz_event_pkg.AddParamEnvToList(l_list);
1991: l_param := WF_PARAMETER_T( NULL, NULL );
1992:
1993: -- fill the parameters list
1994: l_list.extend;

Line 2000: HZ_EVENT_PKG.raise_event(

1996: l_param.SetValue( p_customer_profile_rec.cust_account_profile_id );
1997: l_list(l_list.last) := l_param;
1998:
1999: -- Raise Event
2000: HZ_EVENT_PKG.raise_event(
2001: p_event_name => l_event_name,
2002: p_event_key => l_key,
2003: p_parameters => l_list );
2004:

Line 2037: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2033:
2034: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2035:
2036: -- commenting the following line(s) as part of bug4369710 fix
2037: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2038:
2039: --Get the item key
2040: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2041:

Line 2040: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2036: -- commenting the following line(s) as part of bug4369710 fix
2037: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2038:
2039: --Get the item key
2040: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2041:
2042: -- commenting the following line(s) as part of bug4369710 fix
2043: /*
2044: IF l_exist = 'Y' THEN

Line 2053: hz_event_pkg.AddParamEnvToList(l_list);

2049: -- initialization of object variables
2050: l_list := WF_PARAMETER_LIST_T();
2051:
2052: -- Add Context values to the list
2053: hz_event_pkg.AddParamEnvToList(l_list);
2054: l_param := WF_PARAMETER_T( NULL, NULL );
2055:
2056: -- fill the parameters list
2057: l_list.extend;

Line 2063: HZ_EVENT_PKG.raise_event(

2059: l_param.SetValue( p_cust_profile_amt_rec.cust_acct_profile_amt_id );
2060: l_list(l_list.last) := l_param;
2061:
2062: -- Raise Event
2063: HZ_EVENT_PKG.raise_event(
2064: p_event_name => l_event_name,
2065: p_event_key => l_key,
2066: p_parameters => l_list );
2067:

Line 2101: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2097:
2098: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2099:
2100: -- commenting the following line(s) as part of bug4369710 fix
2101: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2102:
2103: --Get the item key
2104: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2105:

Line 2104: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2100: -- commenting the following line(s) as part of bug4369710 fix
2101: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2102:
2103: --Get the item key
2104: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2105:
2106: -- commenting the following line(s) as part of bug4369710 fix
2107: /*
2108: IF l_exist = 'Y' THEN

Line 2118: hz_event_pkg.AddParamEnvToList(l_list);

2114: -- initialization of object variables
2115: l_list := WF_PARAMETER_LIST_T();
2116:
2117: -- Add Context values to the list
2118: hz_event_pkg.AddParamEnvToList(l_list);
2119: l_param := WF_PARAMETER_T( NULL, NULL );
2120:
2121: -- fill the parameters list
2122: l_list.extend;

Line 2128: HZ_EVENT_PKG.raise_event(

2124: l_param.SetValue( p_cust_profile_amt_rec.cust_acct_profile_amt_id );
2125: l_list(l_list.last) := l_param;
2126:
2127: -- Raise Event
2128: HZ_EVENT_PKG.raise_event(
2129: p_event_name => l_event_name,
2130: p_event_key => l_key,
2131: p_parameters => l_list );
2132:

Line 2167: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2163:
2164: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2165:
2166: -- commenting the following line(s) as part of bug4369710 fix
2167: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2168:
2169: --Get the item key
2170: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2171:

Line 2170: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2166: -- commenting the following line(s) as part of bug4369710 fix
2167: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2168:
2169: --Get the item key
2170: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2171:
2172: -- commenting the following line(s) as part of bug4369710 fix
2173: /*
2174: IF l_exist = 'Y' THEN

Line 2184: hz_event_pkg.AddParamEnvToList(x_list => l_list,

2180: l_list := WF_PARAMETER_LIST_T();
2181:
2182: -- Add Context values to the list
2183: /* 3456489. Added org_id as a parameter. */
2184: hz_event_pkg.AddParamEnvToList(x_list => l_list,
2185: p_org_id => p_cust_acct_site_rec.org_id);
2186: l_param := WF_PARAMETER_T( NULL, NULL );
2187:
2188: -- fill the parameters list

Line 2195: HZ_EVENT_PKG.raise_event(

2191: l_param.SetValue( p_cust_acct_site_rec.cust_acct_site_id );
2192: l_list(l_list.last) := l_param;
2193:
2194: -- Raise Event
2195: HZ_EVENT_PKG.raise_event(
2196: p_event_name => l_event_name,
2197: p_event_key => l_key,
2198: p_parameters => l_list );
2199:

Line 2232: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2228:
2229: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2230:
2231: -- commenting the following line(s) as part of bug4369710 fix
2232: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2233:
2234: --Get the item key
2235: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2236:

Line 2235: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2231: -- commenting the following line(s) as part of bug4369710 fix
2232: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2233:
2234: --Get the item key
2235: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2236:
2237: -- commenting the following line(s) as part of bug4369710 fix
2238: /*
2239: IF l_exist = 'Y' THEN

Line 2251: hz_event_pkg.AddParamEnvToList(x_list => l_list,

2247: l_list := WF_PARAMETER_LIST_T();
2248:
2249: -- Add Context values to the list
2250: /* 3456489. Added org_id as a parameter. */
2251: hz_event_pkg.AddParamEnvToList(x_list => l_list,
2252: p_org_id => p_cust_acct_site_rec.org_id);
2253: l_param := WF_PARAMETER_T( NULL, NULL );
2254:
2255: -- fill the parameters list

Line 2262: HZ_EVENT_PKG.raise_event(

2258: l_param.SetValue( p_cust_acct_site_rec.cust_acct_site_id );
2259: l_list(l_list.last) := l_param;
2260:
2261: -- Raise Event
2262: HZ_EVENT_PKG.raise_event(
2263: p_event_name => l_event_name,
2264: p_event_key => l_key,
2265: p_parameters => l_list );
2266:

Line 2302: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2298:
2299: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2300:
2301: -- commenting the following line(s) as part of bug4369710 fix
2302: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2303:
2304: --Get the item key
2305: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2306:

Line 2305: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2301: -- commenting the following line(s) as part of bug4369710 fix
2302: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2303:
2304: --Get the item key
2305: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2306:
2307: -- commenting the following line(s) as part of bug4369710 fix
2308: /*
2309: IF l_exist = 'Y' THEN

Line 2322: hz_event_pkg.AddParamEnvToList(x_list => l_list,

2318: l_list := WF_PARAMETER_LIST_T();
2319:
2320: -- Add Context values to the list
2321: /* 3456489. Added org_id as a parameter. */
2322: hz_event_pkg.AddParamEnvToList(x_list => l_list,
2323: p_org_id => p_cust_site_use_rec.org_id);
2324: l_param := WF_PARAMETER_T( NULL, NULL );
2325:
2326: -- fill the parameters list

Line 2348: HZ_EVENT_PKG.raise_event(

2344: l_param.SetValue( p_create_profile_amt );
2345: l_list(l_list.last) := l_param;
2346:
2347: -- Raise Event
2348: HZ_EVENT_PKG.raise_event(
2349: p_event_name => l_event_name,
2350: p_event_key => l_key,
2351: p_parameters => l_list );
2352:

Line 2386: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2382:
2383: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2384:
2385: -- commenting the following line(s) as part of bug4369710 fix
2386: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2387:
2388: --Get the item key
2389: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2390:

Line 2389: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2385: -- commenting the following line(s) as part of bug4369710 fix
2386: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2387:
2388: --Get the item key
2389: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2390:
2391: -- commenting the following line(s) as part of bug4369710 fix
2392: /*
2393: IF l_exist = 'Y' THEN

Line 2404: hz_event_pkg.AddParamEnvToList(x_list => l_list,

2400: l_list := WF_PARAMETER_LIST_T();
2401:
2402: -- Add Context values to the list
2403: /* 3456489. Added org_id as a parameter. */
2404: hz_event_pkg.AddParamEnvToList(x_list => l_list,
2405: p_org_id => p_cust_site_use_rec.org_id);
2406: l_param := WF_PARAMETER_T( NULL, NULL );
2407:
2408: -- fill the parameters list

Line 2415: HZ_EVENT_PKG.raise_event(

2411: l_param.SetValue( p_cust_site_use_rec.site_use_id );
2412: l_list(l_list.last) := l_param;
2413:
2414: -- Raise Event
2415: HZ_EVENT_PKG.raise_event(
2416: p_event_name => l_event_name,
2417: p_event_key => l_key,
2418: p_parameters => l_list );
2419:

Line 2454: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2450:
2451: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2452:
2453: -- commenting the following line(s) as part of bug4369710 fix
2454: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2455:
2456: --Get the item key
2457: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2458:

Line 2457: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2453: -- commenting the following line(s) as part of bug4369710 fix
2454: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2455:
2456: --Get the item key
2457: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2458:
2459: -- commenting the following line(s) as part of bug4369710 fix
2460: /*
2461: IF l_exist = 'Y' THEN

Line 2470: hz_event_pkg.AddParamEnvToList(l_list);

2466: -- initialization of object variables
2467: l_list := WF_PARAMETER_LIST_T();
2468:
2469: -- Add Context values to the list
2470: hz_event_pkg.AddParamEnvToList(l_list);
2471: l_param := WF_PARAMETER_T( NULL, NULL );
2472:
2473: -- fill the parameters list
2474: l_list.extend;

Line 2480: HZ_EVENT_PKG.raise_event(

2476: l_param.SetValue( p_cust_account_role_rec.cust_account_role_id );
2477: l_list(l_list.last) := l_param;
2478:
2479: -- Raise Event
2480: HZ_EVENT_PKG.raise_event(
2481: p_event_name => l_event_name,
2482: p_event_key => l_key,
2483: p_parameters => l_list );
2484:

Line 2518: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2514:
2515: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2516:
2517: -- commenting the following line(s) as part of bug4369710 fix
2518: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2519:
2520: --Get the item key
2521: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2522:

Line 2521: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2517: -- commenting the following line(s) as part of bug4369710 fix
2518: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2519:
2520: --Get the item key
2521: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2522:
2523: -- commenting the following line(s) as part of bug4369710 fix
2524: /*
2525: IF l_exist = 'Y' THEN

Line 2536: hz_event_pkg.AddParamEnvToList(l_list);

2532: -- initialization of object variables
2533: l_list := WF_PARAMETER_LIST_T();
2534:
2535: -- Add Context values to the list
2536: hz_event_pkg.AddParamEnvToList(l_list);
2537: l_param := WF_PARAMETER_T( NULL, NULL );
2538:
2539: -- fill the parameters list
2540: l_list.extend;

Line 2546: HZ_EVENT_PKG.raise_event(

2542: l_param.SetValue( p_cust_account_role_rec.cust_account_role_id );
2543: l_list(l_list.last) := l_param;
2544:
2545: -- Raise Event
2546: HZ_EVENT_PKG.raise_event(
2547: p_event_name => l_event_name,
2548: p_event_key => l_key,
2549: p_parameters => l_list );
2550:

Line 2583: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2579:
2580: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2581:
2582: -- commenting the following line(s) as part of bug4369710 fix
2583: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2584:
2585: --Get the item key
2586: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2587:

Line 2586: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2582: -- commenting the following line(s) as part of bug4369710 fix
2583: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2584:
2585: --Get the item key
2586: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2587:
2588: -- commenting the following line(s) as part of bug4369710 fix
2589: /*
2590: IF l_exist = 'Y' THEN

Line 2599: hz_event_pkg.AddParamEnvToList(l_list);

2595: -- initialization of object variables
2596: l_list := WF_PARAMETER_LIST_T();
2597:
2598: -- Add Context values to the list
2599: hz_event_pkg.AddParamEnvToList(l_list);
2600: l_param := WF_PARAMETER_T( NULL, NULL );
2601:
2602: -- fill the parameters list
2603: l_list.extend;

Line 2609: HZ_EVENT_PKG.raise_event(

2605: l_param.SetValue( p_role_responsibility_rec.responsibility_id );
2606: l_list(l_list.last) := l_param;
2607:
2608: -- Raise Event
2609: HZ_EVENT_PKG.raise_event(
2610: p_event_name => l_event_name,
2611: p_event_key => l_key,
2612: p_parameters => l_list );
2613:

Line 2647: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2643:
2644: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2645:
2646: -- commenting the following line(s) as part of bug4369710 fix
2647: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2648:
2649: --Get the item key
2650: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2651:

Line 2650: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2646: -- commenting the following line(s) as part of bug4369710 fix
2647: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2648:
2649: --Get the item key
2650: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2651:
2652: -- commenting the following line(s) as part of bug4369710 fix
2653: /*
2654: IF l_exist = 'Y' THEN

Line 2665: hz_event_pkg.AddParamEnvToList(l_list);

2661: -- initialization of object variables
2662: l_list := WF_PARAMETER_LIST_T();
2663:
2664: -- Add Context values to the list
2665: hz_event_pkg.AddParamEnvToList(l_list);
2666: l_param := WF_PARAMETER_T( NULL, NULL );
2667:
2668: -- fill the parameters list
2669: l_list.extend;

Line 2675: HZ_EVENT_PKG.raise_event(

2671: l_param.SetValue( p_role_responsibility_rec.responsibility_id );
2672: l_list(l_list.last) := l_param;
2673:
2674: -- Raise Event
2675: HZ_EVENT_PKG.raise_event(
2676: p_event_name => l_event_name,
2677: p_event_key => l_key,
2678: p_parameters => l_list );
2679:

Line 2714: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2710:
2711: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2712:
2713: -- commenting the following line(s) as part of bug4369710 fix
2714: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2715:
2716: --Get the item key
2717: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2718:

Line 2717: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2713: -- commenting the following line(s) as part of bug4369710 fix
2714: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2715:
2716: --Get the item key
2717: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2718:
2719: -- commenting the following line(s) as part of bug4369710 fix
2720: /*
2721: IF l_exist = 'Y' THEN

Line 2730: hz_event_pkg.AddParamEnvToList(l_list);

2726: -- initialization of object variables
2727: l_list := WF_PARAMETER_LIST_T();
2728:
2729: -- Add Context values to the list
2730: hz_event_pkg.AddParamEnvToList(l_list);
2731: l_param := WF_PARAMETER_T( NULL, NULL );
2732:
2733: -- fill the parameters list
2734: l_list.extend;

Line 2740: HZ_EVENT_PKG.raise_event(

2736: l_param.SetValue( p_class_category_rec.class_category );
2737: l_list(l_list.last) := l_param;
2738:
2739: -- Raise Event
2740: HZ_EVENT_PKG.raise_event(
2741: p_event_name => l_event_name,
2742: p_event_key => l_key,
2743: p_parameters => l_list );
2744:

Line 2778: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2774:
2775: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2776:
2777: -- commenting the following line(s) as part of bug4369710 fix
2778: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2779:
2780: --Get the item key
2781: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2782:

Line 2781: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2777: -- commenting the following line(s) as part of bug4369710 fix
2778: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2779:
2780: --Get the item key
2781: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2782:
2783: -- commenting the following line(s) as part of bug4369710 fix
2784: /*
2785: IF l_exist = 'Y' THEN

Line 2796: hz_event_pkg.AddParamEnvToList(l_list);

2792: -- initialization of object variables
2793: l_list := WF_PARAMETER_LIST_T();
2794:
2795: -- Add Context values to the list
2796: hz_event_pkg.AddParamEnvToList(l_list);
2797: l_param := WF_PARAMETER_T( NULL, NULL );
2798:
2799: -- fill the parameters list
2800: l_list.extend;

Line 2806: HZ_EVENT_PKG.raise_event(

2802: l_param.SetValue( p_class_category_rec.class_category );
2803: l_list(l_list.last) := l_param;
2804:
2805: -- Raise Event
2806: HZ_EVENT_PKG.raise_event(
2807: p_event_name => l_event_name,
2808: p_event_key => l_key,
2809: p_parameters => l_list );
2810:

Line 2844: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2840:
2841: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2842:
2843: --Get the item key
2844: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2845:
2846: -- initialization of object variables
2847: l_list := WF_PARAMETER_LIST_T();
2848:

Line 2850: hz_event_pkg.AddParamEnvToList(l_list);

2846: -- initialization of object variables
2847: l_list := WF_PARAMETER_LIST_T();
2848:
2849: -- Add Context values to the list
2850: hz_event_pkg.AddParamEnvToList(l_list);
2851: l_param := WF_PARAMETER_T( NULL, NULL );
2852:
2853: -- fill the parameters list
2854: l_list.extend;

Line 2865: HZ_EVENT_PKG.raise_event(

2861: l_param.SetValue( p_class_code_rec.code );
2862: l_list(l_list.last) := l_param;
2863:
2864: -- Raise Event
2865: HZ_EVENT_PKG.raise_event(
2866: p_event_name => l_event_name,
2867: p_event_key => l_key,
2868: p_parameters => l_list );
2869:

Line 2905: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2901: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2902:
2903:
2904: --Get the item key
2905: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2906:
2907: -- initialization of object variables
2908: l_list := WF_PARAMETER_LIST_T();
2909:

Line 2911: hz_event_pkg.AddParamEnvToList(l_list);

2907: -- initialization of object variables
2908: l_list := WF_PARAMETER_LIST_T();
2909:
2910: -- Add Context values to the list
2911: hz_event_pkg.AddParamEnvToList(l_list);
2912: l_param := WF_PARAMETER_T( NULL, NULL );
2913:
2914: -- fill the parameters list
2915: l_list.extend;

Line 2926: HZ_EVENT_PKG.raise_event(

2922: l_param.SetValue( p_class_code_rec.code );
2923: l_list(l_list.last) := l_param;
2924:
2925: -- Raise Event
2926: HZ_EVENT_PKG.raise_event(
2927: p_event_name => l_event_name,
2928: p_event_key => l_key,
2929: p_parameters => l_list );
2930:

Line 2964: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

2960:
2961: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
2962:
2963: -- commenting the following line(s) as part of bug4369710 fix
2964: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2965:
2966: --Get the item key
2967: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2968:

Line 2967: l_key := HZ_EVENT_PKG.item_key( l_event_name );

2963: -- commenting the following line(s) as part of bug4369710 fix
2964: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
2965:
2966: --Get the item key
2967: l_key := HZ_EVENT_PKG.item_key( l_event_name );
2968:
2969: -- commenting the following line(s) as part of bug4369710 fix
2970: /*
2971: IF l_exist = 'Y' THEN

Line 2980: hz_event_pkg.AddParamEnvToList(l_list);

2976: -- initialization of object variables
2977: l_list := WF_PARAMETER_LIST_T();
2978:
2979: -- Add Context values to the list
2980: hz_event_pkg.AddParamEnvToList(l_list);
2981: l_param := WF_PARAMETER_T( NULL, NULL );
2982:
2983: -- fill the parameters list
2984: l_list.extend;

Line 3000: HZ_EVENT_PKG.raise_event(

2996: l_param.SetValue( p_class_code_relation_rec.sub_class_code );
2997: l_list(l_list.last) := l_param;
2998:
2999: -- Raise Event
3000: HZ_EVENT_PKG.raise_event(
3001: p_event_name => l_event_name,
3002: p_event_key => l_key,
3003: p_parameters => l_list );
3004:

Line 3038: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3034:
3035: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3036:
3037: -- commenting the following line(s) as part of bug4369710 fix
3038: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3039:
3040: --Get the item key
3041: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3042:

Line 3041: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3037: -- commenting the following line(s) as part of bug4369710 fix
3038: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3039:
3040: --Get the item key
3041: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3042:
3043: -- commenting the following line(s) as part of bug4369710 fix
3044: /*
3045: IF l_exist = 'Y' THEN

Line 3056: hz_event_pkg.AddParamEnvToList(l_list);

3052: -- initialization of object variables
3053: l_list := WF_PARAMETER_LIST_T();
3054:
3055: -- Add Context values to the list
3056: hz_event_pkg.AddParamEnvToList(l_list);
3057: l_param := WF_PARAMETER_T( NULL, NULL );
3058:
3059: -- fill the parameters list
3060: l_list.extend;

Line 3076: HZ_EVENT_PKG.raise_event(

3072: l_param.SetValue( p_class_code_relation_rec.sub_class_code );
3073: l_list(l_list.last) := l_param;
3074:
3075: -- Raise Event
3076: HZ_EVENT_PKG.raise_event(
3077: p_event_name => l_event_name,
3078: p_event_key => l_key,
3079: p_parameters => l_list );
3080:

Line 3113: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3109:
3110: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3111:
3112: -- commenting the following line(s) as part of bug4369710 fix
3113: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3114:
3115:
3116: --Get the item key
3117: l_key := HZ_EVENT_PKG.item_key( l_event_name );

Line 3117: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3113: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3114:
3115:
3116: --Get the item key
3117: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3118:
3119: -- commenting the following line(s) as part of bug4369710 fix
3120: /*
3121: IF l_exist = 'Y' THEN

Line 3130: hz_event_pkg.AddParamEnvToList(l_list);

3126: -- initialization of object variables
3127: l_list := WF_PARAMETER_LIST_T();
3128:
3129: -- Add Context values to the list
3130: hz_event_pkg.AddParamEnvToList(l_list);
3131: l_param := WF_PARAMETER_T( NULL, NULL );
3132:
3133: -- fill the parameters list
3134: l_list.extend;

Line 3140: HZ_EVENT_PKG.raise_event(

3136: l_param.SetValue( p_code_assignment_rec.code_assignment_id );
3137: l_list(l_list.last) := l_param;
3138:
3139: -- Raise Event
3140: HZ_EVENT_PKG.raise_event(
3141: p_event_name => l_event_name,
3142: p_event_key => l_key,
3143: p_parameters => l_list );
3144:

Line 3179: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3175:
3176: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3177:
3178: -- commenting the following line(s) as part of bug4369710 fix
3179: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3180:
3181: --Get the item key
3182: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3183:

Line 3182: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3178: -- commenting the following line(s) as part of bug4369710 fix
3179: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3180:
3181: --Get the item key
3182: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3183:
3184: -- commenting the following line(s) as part of bug4369710 fix
3185: /*
3186: IF l_exist = 'Y' THEN

Line 3197: hz_event_pkg.AddParamEnvToList(l_list);

3193: -- initialization of object variables
3194: l_list := WF_PARAMETER_LIST_T();
3195:
3196: -- Add Context values to the list
3197: hz_event_pkg.AddParamEnvToList(l_list);
3198: l_param := WF_PARAMETER_T( NULL, NULL );
3199:
3200: -- fill the parameters list
3201: l_list.extend;

Line 3207: HZ_EVENT_PKG.raise_event(

3203: l_param.SetValue( p_code_assignment_rec.code_assignment_id );
3204: l_list(l_list.last) := l_param;
3205:
3206: -- Raise Event
3207: HZ_EVENT_PKG.raise_event(
3208: p_event_name => l_event_name,
3209: p_event_key => l_key,
3210: p_parameters => l_list );
3211:

Line 3244: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3240:
3241: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3242:
3243: -- commenting the following line(s) as part of bug4369710 fix
3244: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3245:
3246:
3247: --Get the item key
3248: l_key := HZ_EVENT_PKG.item_key( l_event_name );

Line 3248: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3244: --l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3245:
3246:
3247: --Get the item key
3248: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3249:
3250: -- commenting the following line(s) as part of bug4369710 fix
3251: /*
3252: IF l_exist = 'Y' THEN

Line 3261: hz_event_pkg.AddParamEnvToList(l_list);

3257: -- initialization of object variables
3258: l_list := WF_PARAMETER_LIST_T();
3259:
3260: -- Add Context values to the list
3261: hz_event_pkg.AddParamEnvToList(l_list);
3262: l_param := WF_PARAMETER_T( NULL, NULL );
3263:
3264: -- fill the parameters list
3265: l_list.extend;

Line 3281: HZ_EVENT_PKG.raise_event(

3277: l_param.SetValue( p_class_category_use_rec.column_name );
3278: l_list(l_list.last) := l_param;
3279:
3280: -- Raise Event
3281: HZ_EVENT_PKG.raise_event(
3282: p_event_name => l_event_name,
3283: p_event_key => l_key,
3284: p_parameters => l_list );
3285:

Line 3319: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3315:
3316: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3317:
3318: -- commenting the following line(s) as part of bug4369710 fix
3319: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3320:
3321: --Get the item key
3322: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3323:

Line 3322: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3318: -- commenting the following line(s) as part of bug4369710 fix
3319: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3320:
3321: --Get the item key
3322: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3323:
3324: -- commenting the following line(s) as part of bug4369710 fix
3325: /*
3326: IF l_exist = 'Y' THEN

Line 3337: hz_event_pkg.AddParamEnvToList(l_list);

3333: -- initialization of object variables
3334: l_list := WF_PARAMETER_LIST_T();
3335:
3336: -- Add Context values to the list
3337: hz_event_pkg.AddParamEnvToList(l_list);
3338: l_param := WF_PARAMETER_T( NULL, NULL );
3339:
3340: -- fill the parameters list
3341: l_list.extend;

Line 3357: HZ_EVENT_PKG.raise_event(

3353: l_param.SetValue( p_class_category_use_rec.column_name );
3354: l_list(l_list.last) := l_param;
3355:
3356: -- Raise Event
3357: HZ_EVENT_PKG.raise_event(
3358: p_event_name => l_event_name,
3359: p_event_key => l_key,
3360: p_parameters => l_list );
3361:

Line 3396: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3392:
3393: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3394:
3395: -- commenting the following line(s) as part of bug4369710 fix
3396: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3397:
3398: --Get the item key
3399: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3400:

Line 3399: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3395: -- commenting the following line(s) as part of bug4369710 fix
3396: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3397:
3398: --Get the item key
3399: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3400:
3401: -- commenting the following line(s) as part of bug4369710 fix
3402: /*
3403: IF l_exist = 'Y' THEN

Line 3412: hz_event_pkg.AddParamEnvToList(l_list);

3408: -- initialization of object variables
3409: l_list := WF_PARAMETER_LIST_T();
3410:
3411: -- Add Context values to the list
3412: hz_event_pkg.AddParamEnvToList(l_list);
3413: l_param := WF_PARAMETER_T( NULL, NULL );
3414:
3415: -- fill the parameters list
3416: l_list.extend;

Line 3422: HZ_EVENT_PKG.raise_event(

3418: l_param.SetValue( p_person_language_rec.language_use_reference_id );
3419: l_list(l_list.last) := l_param;
3420:
3421: -- Raise Event
3422: HZ_EVENT_PKG.raise_event(
3423: p_event_name => l_event_name,
3424: p_event_key => l_key,
3425: p_parameters => l_list );
3426:

Line 3460: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );

3456:
3457: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3458:
3459: -- commenting the following line(s) as part of bug4369710 fix
3460: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3461:
3462: --Get the item key
3463: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3464:

Line 3463: l_key := HZ_EVENT_PKG.item_key( l_event_name );

3459: -- commenting the following line(s) as part of bug4369710 fix
3460: -- l_exist := HZ_EVENT_PKG.exist_subscription( l_event_name );
3461:
3462: --Get the item key
3463: l_key := HZ_EVENT_PKG.item_key( l_event_name );
3464:
3465: -- commenting the following line(s) as part of bug4369710 fix
3466: /*
3467: IF l_exist = 'Y' THEN

Line 3477: hz_event_pkg.AddParamEnvToList(l_list);

3473: -- initialization of object variables
3474: l_list := WF_PARAMETER_LIST_T();
3475:
3476: -- Add Context values to the list
3477: hz_event_pkg.AddParamEnvToList(l_list);
3478: l_param := WF_PARAMETER_T( NULL, NULL );
3479:
3480: -- fill the parameters list
3481: l_list.extend;

Line 3487: HZ_EVENT_PKG.raise_event(

3483: l_param.SetValue( p_person_language_rec.language_use_reference_id );
3484: l_list(l_list.last) := l_param;
3485:
3486: -- Raise Event
3487: HZ_EVENT_PKG.raise_event(
3488: p_event_name => l_event_name,
3489: p_event_key => l_key,
3490: p_parameters => l_list );
3491:

Line 3526: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3522:
3523:
3524: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3525: -- commenting the following line as part of bug4369710 fix
3526: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3527:
3528: --Get the item key
3529: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3530: -- commenting the following line as part of bug4369710 fix

Line 3529: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3525: -- commenting the following line as part of bug4369710 fix
3526: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3527:
3528: --Get the item key
3529: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3530: -- commenting the following line as part of bug4369710 fix
3531:
3532: IF l_yn = 'Y' THEN
3533: --Set Parameter

Line 3541: hz_event_pkg.AddParamEnvToList(l_list);

3537: -- initialization of object variables
3538: l_list := wf_parameter_list_t();
3539:
3540: -- Add Context values to the list
3541: hz_event_pkg.AddParamEnvToList(l_list);
3542: l_param := WF_PARAMETER_T( NULL, NULL );
3543:
3544: -- fill the parameters list
3545: l_list.extend;

Line 3551: hz_event_pkg.raise_event( p_event_name => l_event_name

3547: l_param.SetValue(P_BILLING_PREFERENCES_REC.BILLING_PREFERENCES_ID);
3548: l_list(l_list.last) := l_param;
3549:
3550: -- Raise Event
3551: hz_event_pkg.raise_event( p_event_name => l_event_name
3552: ,p_event_key => l_key
3553: ,p_parameters => l_list);
3554: l_list.DELETE;
3555:

Line 3584: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3580:
3581:
3582: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3583: -- commenting the following line as part of bug4369710 fix
3584: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3585:
3586: --Get the item key
3587: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3588: -- commenting the following line as part of bug4369710 fix

Line 3587: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3583: -- commenting the following line as part of bug4369710 fix
3584: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3585:
3586: --Get the item key
3587: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3588: -- commenting the following line as part of bug4369710 fix
3589:
3590: IF l_yn = 'Y' THEN
3591: --Set Parameter

Line 3599: hz_event_pkg.AddParamEnvToList(l_list);

3595: -- initialization of object variables
3596: l_list := wf_parameter_list_t();
3597:
3598: -- Add Context values to the list
3599: hz_event_pkg.AddParamEnvToList(l_list);
3600: l_param := WF_PARAMETER_T( NULL, NULL );
3601:
3602: -- fill the parameters list
3603: l_list.extend;

Line 3609: hz_event_pkg.raise_event( p_event_name => l_event_name

3605: l_param.SetValue(P_BILLING_PREFERENCES_REC.BILLING_PREFERENCES_ID);
3606: l_list(l_list.last) := l_param;
3607:
3608: -- Raise Event
3609: hz_event_pkg.raise_event( p_event_name => l_event_name
3610: ,p_event_key => l_key
3611: ,p_parameters => l_list);
3612: l_list.DELETE;
3613:

Line 3641: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3637:
3638:
3639: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3640: -- commenting the following line as part of bug4369710 fix
3641: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3642:
3643: --Get the item key
3644: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3645: -- commenting the following line as part of bug4369710 fix

Line 3644: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3640: -- commenting the following line as part of bug4369710 fix
3641: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3642:
3643: --Get the item key
3644: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3645: -- commenting the following line as part of bug4369710 fix
3646:
3647: IF l_yn = 'Y' THEN
3648: --Set Parameter

Line 3656: hz_event_pkg.AddParamEnvToList(l_list);

3652: -- initialization of object variables
3653: l_list := wf_parameter_list_t();
3654:
3655: -- Add Context values to the list
3656: hz_event_pkg.AddParamEnvToList(l_list);
3657: l_param := WF_PARAMETER_T( NULL, NULL );
3658:
3659: -- fill the parameters list
3660: l_list.extend;

Line 3666: hz_event_pkg.raise_event( p_event_name => l_event_name

3662: l_param.SetValue(P_BANK_ACCT_USES_REC.BANK_ACCOUNT_USES_ID);
3663: l_list(l_list.last) := l_param;
3664:
3665: -- Raise Event
3666: hz_event_pkg.raise_event( p_event_name => l_event_name
3667: ,p_event_key => l_key
3668: ,p_parameters => l_list);
3669: l_list.DELETE;
3670:

Line 3698: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3694:
3695:
3696: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3697: -- commenting the following line as part of bug4369710 fix
3698: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3699:
3700: --Get the item key
3701: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3702: -- commenting the following line as part of bug4369710 fix

Line 3701: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3697: -- commenting the following line as part of bug4369710 fix
3698: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3699:
3700: --Get the item key
3701: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3702: -- commenting the following line as part of bug4369710 fix
3703:
3704: IF l_yn = 'Y' THEN
3705: --Set Parameter

Line 3713: hz_event_pkg.AddParamEnvToList(l_list);

3709: -- initialization of object variables
3710: l_list := wf_parameter_list_t();
3711:
3712: -- Add Context values to the list
3713: hz_event_pkg.AddParamEnvToList(l_list);
3714: l_param := WF_PARAMETER_T( NULL, NULL );
3715:
3716: -- fill the parameters list
3717: l_list.extend;

Line 3723: hz_event_pkg.raise_event( p_event_name => l_event_name

3719: l_param.SetValue(P_BANK_ACCT_USES_REC.BANK_ACCOUNT_USES_ID);
3720: l_list(l_list.last) := l_param;
3721:
3722: -- Raise Event
3723: hz_event_pkg.raise_event( p_event_name => l_event_name
3724: ,p_event_key => l_key
3725: ,p_parameters => l_list);
3726: l_list.DELETE;
3727:

Line 3755: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3751:
3752:
3753: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3754: -- commenting the following line as part of bug4369710 fix
3755: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3756:
3757: --Get the item key
3758: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3759: -- commenting the following line as part of bug4369710 fix

Line 3758: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3754: -- commenting the following line as part of bug4369710 fix
3755: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3756:
3757: --Get the item key
3758: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3759: -- commenting the following line as part of bug4369710 fix
3760:
3761: IF l_yn = 'Y' THEN
3762: --Set Parameter

Line 3770: hz_event_pkg.AddParamEnvToList(l_list);

3766: -- initialization of object variables
3767: l_list := wf_parameter_list_t();
3768:
3769: -- Add Context values to the list
3770: hz_event_pkg.AddParamEnvToList(l_list);
3771: l_param := WF_PARAMETER_T( NULL, NULL );
3772:
3773: -- fill the parameters list
3774: l_list.extend;

Line 3780: hz_event_pkg.raise_event( p_event_name => l_event_name

3776: l_param.SetValue(P_SUSPENSION_ACTIVITY_REC.SUSPENSION_ACTIVITY_ID);
3777: l_list(l_list.last) := l_param;
3778:
3779: -- Raise Event
3780: hz_event_pkg.raise_event( p_event_name => l_event_name
3781: ,p_event_key => l_key
3782: ,p_parameters => l_list);
3783: l_list.DELETE;
3784:

Line 3812: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3808:
3809:
3810: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3811: -- commenting the following line as part of bug4369710 fix
3812: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3813:
3814: --Get the item key
3815: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3816:

Line 3815: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3811: -- commenting the following line as part of bug4369710 fix
3812: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3813:
3814: --Get the item key
3815: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3816:
3817: IF l_yn = 'Y' THEN
3818: --Set Parameter
3819: hz_param_pkg.setparameter(l_key, p_suspension_activity_rec, 'NEW');

Line 3826: hz_event_pkg.AddParamEnvToList(l_list);

3822: -- initialization of object variables
3823: l_list := wf_parameter_list_t();
3824:
3825: -- Add Context values to the list
3826: hz_event_pkg.AddParamEnvToList(l_list);
3827: l_param := WF_PARAMETER_T( NULL, NULL );
3828:
3829: -- fill the parameters list
3830: l_list.extend;

Line 3836: hz_event_pkg.raise_event( p_event_name => l_event_name

3832: l_param.SetValue(P_SUSPENSION_ACTIVITY_REC.SUSPENSION_ACTIVITY_ID);
3833: l_list(l_list.last) := l_param;
3834:
3835: -- Raise Event
3836: hz_event_pkg.raise_event( p_event_name => l_event_name
3837: ,p_event_key => l_key
3838: ,p_parameters => l_list);
3839: l_list.DELETE;
3840:

Line 3872: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3868:
3869:
3870: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3871: -- commenting the following line as part of bug4369710 fix
3872: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3873:
3874: --Get the item key
3875: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3876: -- commenting the following line as part of bug4369710 fix

Line 3875: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3871: -- commenting the following line as part of bug4369710 fix
3872: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3873:
3874: --Get the item key
3875: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3876: -- commenting the following line as part of bug4369710 fix
3877: /*
3878: IF l_yn = 'Y' THEN
3879: --Set Parameter

Line 3887: hz_event_pkg.AddParamEnvToList(l_list);

3883: -- initialization of object variables
3884: l_list := wf_parameter_list_t();
3885:
3886: -- Add Context values to the list
3887: hz_event_pkg.AddParamEnvToList(l_list);
3888: l_param := WF_PARAMETER_T( NULL, NULL );
3889:
3890: -- fill the parameters list
3891: l_list.extend;

Line 3897: hz_event_pkg.raise_event( p_event_name => l_event_name

3893: l_param.SetValue(P_STOCK_MARKETS_REC.STOCK_EXCHANGE_ID);
3894: l_list(l_list.last) := l_param;
3895:
3896: -- Raise Event
3897: hz_event_pkg.raise_event( p_event_name => l_event_name
3898: ,p_event_key => l_key
3899: ,p_parameters => l_list);
3900: l_list.DELETE;
3901:

Line 3930: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3926:
3927:
3928: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3929: -- commenting the following line as part of bug4369710 fix
3930: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3931:
3932: --Get the item key
3933: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3934: -- commenting the following line as part of bug4369710 fix

Line 3933: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3929: -- commenting the following line as part of bug4369710 fix
3930: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3931:
3932: --Get the item key
3933: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3934: -- commenting the following line as part of bug4369710 fix
3935: /*
3936: IF l_yn = 'Y' THEN
3937: --Set Parameter

Line 3945: hz_event_pkg.AddParamEnvToList(l_list);

3941: -- initialization of object variables
3942: l_list := wf_parameter_list_t();
3943:
3944: -- Add Context values to the list
3945: hz_event_pkg.AddParamEnvToList(l_list);
3946: l_param := WF_PARAMETER_T( NULL, NULL );
3947:
3948: -- fill the parameters list
3949: l_list.extend;

Line 3955: hz_event_pkg.raise_event( p_event_name => l_event_name

3951: l_param.SetValue(P_STOCK_MARKETS_REC.STOCK_EXCHANGE_ID);
3952: l_list(l_list.last) := l_param;
3953:
3954: -- Raise Event
3955: hz_event_pkg.raise_event( p_event_name => l_event_name
3956: ,p_event_key => l_key
3957: ,p_parameters => l_list);
3958: l_list.DELETE;
3959:

Line 3988: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

3984:
3985:
3986: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
3987: -- commenting the following line as part of bug4369710 fix
3988: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3989:
3990: --Get the item key
3991: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3992: -- commenting the following line as part of bug4369710 fix

Line 3991: l_key := HZ_EVENT_PKG.item_key(l_event_name);

3987: -- commenting the following line as part of bug4369710 fix
3988: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
3989:
3990: --Get the item key
3991: l_key := HZ_EVENT_PKG.item_key(l_event_name);
3992: -- commenting the following line as part of bug4369710 fix
3993: /*
3994: IF l_yn = 'Y' THEN
3995: --Set Parameter

Line 4003: hz_event_pkg.AddParamEnvToList(l_list);

3999: -- initialization of object variables
4000: l_list := wf_parameter_list_t();
4001:
4002: -- Add Context values to the list
4003: hz_event_pkg.AddParamEnvToList(l_list);
4004: l_param := WF_PARAMETER_T( NULL, NULL );
4005:
4006: -- fill the parameters list
4007: l_list.extend;

Line 4013: hz_event_pkg.raise_event( p_event_name => l_event_name

4009: l_param.SetValue(P_SECURITY_ISSUED_REC.SECURITY_ISSUED_ID);
4010: l_list(l_list.last) := l_param;
4011:
4012: -- Raise Event
4013: hz_event_pkg.raise_event( p_event_name => l_event_name
4014: ,p_event_key => l_key
4015: ,p_parameters => l_list);
4016: l_list.DELETE;
4017:

Line 4046: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4042:
4043:
4044: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4045: -- commenting the following line as part of bug4369710 fix
4046: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4047:
4048: --Get the item key
4049: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4050: -- commenting the following line as part of bug4369710 fix

Line 4049: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4045: -- commenting the following line as part of bug4369710 fix
4046: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4047:
4048: --Get the item key
4049: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4050: -- commenting the following line as part of bug4369710 fix
4051: /*
4052: IF l_yn = 'Y' THEN
4053: --Set Parameter

Line 4061: hz_event_pkg.AddParamEnvToList(l_list);

4057: -- initialization of object variables
4058: l_list := wf_parameter_list_t();
4059:
4060: -- Add Context values to the list
4061: hz_event_pkg.AddParamEnvToList(l_list);
4062: l_param := WF_PARAMETER_T( NULL, NULL );
4063:
4064: -- fill the parameters list
4065: l_list.extend;

Line 4071: hz_event_pkg.raise_event( p_event_name => l_event_name

4067: l_param.SetValue(P_SECURITY_ISSUED_REC.SECURITY_ISSUED_ID);
4068: l_list(l_list.last) := l_param;
4069:
4070: -- Raise Event
4071: hz_event_pkg.raise_event( p_event_name => l_event_name
4072: ,p_event_key => l_key
4073: ,p_parameters => l_list);
4074: l_list.DELETE;
4075:

Line 4104: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4100:
4101:
4102: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4103: -- commenting the following line as part of bug4369710 fix
4104: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4105:
4106: --Get the item key
4107: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4108: -- commenting the following line as part of bug4369710 fix

Line 4107: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4103: -- commenting the following line as part of bug4369710 fix
4104: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4105:
4106: --Get the item key
4107: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4108: -- commenting the following line as part of bug4369710 fix
4109: /*
4110: IF l_yn = 'Y' THEN
4111: --Set Parameter

Line 4119: hz_event_pkg.AddParamEnvToList(l_list);

4115: -- initialization of object variables
4116: l_list := wf_parameter_list_t();
4117:
4118: -- Add Context values to the list
4119: hz_event_pkg.AddParamEnvToList(l_list);
4120: l_param := WF_PARAMETER_T( NULL, NULL );
4121:
4122: -- fill the parameters list
4123: l_list.extend;

Line 4129: hz_event_pkg.raise_event( p_event_name => l_event_name

4125: l_param.SetValue(P_FINANCIAL_REPORTS_REC.FINANCIAL_REPORT_ID);
4126: l_list(l_list.last) := l_param;
4127:
4128: -- Raise Event
4129: hz_event_pkg.raise_event( p_event_name => l_event_name
4130: ,p_event_key => l_key
4131: ,p_parameters => l_list);
4132: l_list.DELETE;
4133:

Line 4163: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4159:
4160:
4161: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4162: -- commenting the following line as part of bug4369710 fix
4163: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4164:
4165: --Get the item key
4166: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4167: -- commenting the following line as part of bug4369710 fix

Line 4166: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4162: -- commenting the following line as part of bug4369710 fix
4163: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4164:
4165: --Get the item key
4166: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4167: -- commenting the following line as part of bug4369710 fix
4168: /*
4169: IF l_yn = 'Y' THEN
4170: --Set Parameter

Line 4179: hz_event_pkg.AddParamEnvToList(l_list);

4175: -- initialization of object variables
4176: l_list := wf_parameter_list_t();
4177:
4178: -- Add Context values to the list
4179: hz_event_pkg.AddParamEnvToList(l_list);
4180: l_param := WF_PARAMETER_T( NULL, NULL );
4181:
4182: -- fill the parameters list
4183: l_list.extend;

Line 4189: hz_event_pkg.raise_event( p_event_name => l_event_name

4185: l_param.SetValue(P_FINANCIAL_REPORTS_REC.FINANCIAL_REPORT_ID);
4186: l_list(l_list.last) := l_param;
4187:
4188: -- Raise Event
4189: hz_event_pkg.raise_event( p_event_name => l_event_name
4190: ,p_event_key => l_key
4191: ,p_parameters => l_list);
4192: l_list.DELETE;
4193:

Line 4222: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4218:
4219: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4220:
4221: -- commenting the following line as part of bug4369710 fix
4222: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4223:
4224: --Get the item key
4225: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4226: -- commenting the following line as part of bug4369710 fix

Line 4225: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4221: -- commenting the following line as part of bug4369710 fix
4222: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4223:
4224: --Get the item key
4225: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4226: -- commenting the following line as part of bug4369710 fix
4227: /*
4228: IF l_yn = 'Y' THEN
4229: --Set Parameter

Line 4237: hz_event_pkg.AddParamEnvToList(l_list);

4233: -- initialization of object variables
4234: l_list := wf_parameter_list_t();
4235:
4236: -- Add Context values to the list
4237: hz_event_pkg.AddParamEnvToList(l_list);
4238: l_param := WF_PARAMETER_T( NULL, NULL );
4239:
4240: -- fill the parameters list
4241: l_list.extend;

Line 4247: hz_event_pkg.raise_event( p_event_name => l_event_name

4243: l_param.SetValue(P_FINANCIAL_NUMBERS_REC.FINANCIAL_NUMBER_ID);
4244: l_list(l_list.last) := l_param;
4245:
4246: -- Raise Event
4247: hz_event_pkg.raise_event( p_event_name => l_event_name
4248: ,p_event_key => l_key
4249: ,p_parameters => l_list);
4250: l_list.DELETE;
4251:

Line 4281: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4277:
4278:
4279: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4280: -- commenting the following line as part of bug4369710 fix
4281: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4282:
4283: --Get the item key
4284: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4285: -- commenting the following line as part of bug4369710 fix

Line 4284: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4280: -- commenting the following line as part of bug4369710 fix
4281: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4282:
4283: --Get the item key
4284: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4285: -- commenting the following line as part of bug4369710 fix
4286: /*
4287: IF l_yn = 'Y' THEN
4288: --Set Parameter

Line 4297: hz_event_pkg.AddParamEnvToList(l_list);

4293: -- initialization of object variables
4294: l_list := wf_parameter_list_t();
4295:
4296: -- Add Context values to the list
4297: hz_event_pkg.AddParamEnvToList(l_list);
4298: l_param := WF_PARAMETER_T( NULL, NULL );
4299:
4300: -- fill the parameters list
4301: l_list.extend;

Line 4307: hz_event_pkg.raise_event( p_event_name => l_event_name

4303: l_param.SetValue(P_FINANCIAL_NUMBERS_REC.FINANCIAL_NUMBER_ID);
4304: l_list(l_list.last) := l_param;
4305:
4306: -- Raise Event
4307: hz_event_pkg.raise_event( p_event_name => l_event_name
4308: ,p_event_key => l_key
4309: ,p_parameters => l_list);
4310: l_list.DELETE;
4311:

Line 4340: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4336:
4337:
4338: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4339: -- commenting the following line as part of bug4369710 fix
4340: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4341:
4342: --Get the item key
4343: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4344: -- commenting the following line as part of bug4369710 fix

Line 4343: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4339: -- commenting the following line as part of bug4369710 fix
4340: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4341:
4342: --Get the item key
4343: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4344: -- commenting the following line as part of bug4369710 fix
4345: /*
4346: IF l_yn = 'Y' THEN
4347: --Set Parameter

Line 4355: hz_event_pkg.AddParamEnvToList(l_list);

4351: -- initialization of object variables
4352: l_list := wf_parameter_list_t();
4353:
4354: -- Add Context values to the list
4355: hz_event_pkg.AddParamEnvToList(l_list);
4356: l_param := WF_PARAMETER_T( NULL, NULL );
4357:
4358: -- fill the parameters list
4359: l_list.extend;

Line 4365: hz_event_pkg.raise_event( p_event_name => l_event_name

4361: l_param.SetValue(P_CERTIFICATIONS_REC.CERTIFICATION_ID);
4362: l_list(l_list.last) := l_param;
4363:
4364: -- Raise Event
4365: hz_event_pkg.raise_event( p_event_name => l_event_name
4366: ,p_event_key => l_key
4367: ,p_parameters => l_list);
4368: l_list.DELETE;
4369:

Line 4398: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4394:
4395:
4396: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4397: -- commenting the following line as part of bug4369710 fix
4398: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4399:
4400: --Get the item key
4401: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4402: -- commenting the following line as part of bug4369710 fix

Line 4401: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4397: -- commenting the following line as part of bug4369710 fix
4398: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4399:
4400: --Get the item key
4401: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4402: -- commenting the following line as part of bug4369710 fix
4403: /*
4404: IF l_yn = 'Y' THEN
4405: --Set Parameter

Line 4413: hz_event_pkg.AddParamEnvToList(l_list);

4409: -- initialization of object variables
4410: l_list := wf_parameter_list_t();
4411:
4412: -- Add Context values to the list
4413: hz_event_pkg.AddParamEnvToList(l_list);
4414: l_param := WF_PARAMETER_T( NULL, NULL );
4415:
4416: -- fill the parameters list
4417: l_list.extend;

Line 4423: hz_event_pkg.raise_event( p_event_name => l_event_name

4419: l_param.SetValue(P_CERTIFICATIONS_REC.CERTIFICATION_ID);
4420: l_list(l_list.last) := l_param;
4421:
4422: -- Raise Event
4423: hz_event_pkg.raise_event( p_event_name => l_event_name
4424: ,p_event_key => l_key
4425: ,p_parameters => l_list);
4426: l_list.DELETE;
4427:

Line 4456: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4452:
4453:
4454: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4455: -- commenting the following line as part of bug4369710 fix
4456: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4457:
4458: --Get the item key
4459: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4460: -- commenting the following line as part of bug4369710 fix

Line 4459: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4455: -- commenting the following line as part of bug4369710 fix
4456: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4457:
4458: --Get the item key
4459: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4460: -- commenting the following line as part of bug4369710 fix
4461: /*
4462: IF l_yn = 'Y' THEN
4463: --Set Parameter

Line 4471: hz_event_pkg.AddParamEnvToList(l_list);

4467: -- initialization of object variables
4468: l_list := wf_parameter_list_t();
4469:
4470: -- Add Context values to the list
4471: hz_event_pkg.AddParamEnvToList(l_list);
4472: l_param := WF_PARAMETER_T( NULL, NULL );
4473:
4474: -- fill the parameters list
4475: l_list.extend;

Line 4481: hz_event_pkg.raise_event( p_event_name => l_event_name

4477: l_param.SetValue(P_PER_INTEREST_REC.PERSON_INTEREST_ID);
4478: l_list(l_list.last) := l_param;
4479:
4480: -- Raise Event
4481: hz_event_pkg.raise_event( p_event_name => l_event_name
4482: ,p_event_key => l_key
4483: ,p_parameters => l_list);
4484: l_list.DELETE;
4485:

Line 4516: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4512:
4513:
4514: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4515: -- commenting the following line as part of bug4369710 fix
4516: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4517:
4518: --Get the item key
4519: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4520: -- commenting the following line as part of bug4369710 fix

Line 4519: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4515: -- commenting the following line as part of bug4369710 fix
4516: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4517:
4518: --Get the item key
4519: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4520: -- commenting the following line as part of bug4369710 fix
4521: /*
4522: IF l_yn = 'Y' THEN
4523: --Set Parameter

Line 4532: hz_event_pkg.AddParamEnvToList(l_list);

4528: -- initialization of object variables
4529: l_list := wf_parameter_list_t();
4530:
4531: -- Add Context values to the list
4532: hz_event_pkg.AddParamEnvToList(l_list);
4533: l_param := WF_PARAMETER_T( NULL, NULL );
4534:
4535: -- fill the parameters list
4536: l_list.extend;

Line 4542: hz_event_pkg.raise_event( p_event_name => l_event_name

4538: l_param.SetValue(P_PER_INTEREST_REC.PERSON_INTEREST_ID);
4539: l_list(l_list.last):= l_param;
4540:
4541: -- Raise Event
4542: hz_event_pkg.raise_event( p_event_name => l_event_name
4543: ,p_event_key => l_key
4544: ,p_parameters => l_list);
4545: l_list.DELETE;
4546:

Line 4575: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4571:
4572:
4573: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4574: -- commenting the following line as part of bug4369710 fix
4575: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4576:
4577: --Get the item key
4578: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4579: -- commenting the following line as part of bug4369710 fix

Line 4578: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4574: -- commenting the following line as part of bug4369710 fix
4575: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4576:
4577: --Get the item key
4578: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4579: -- commenting the following line as part of bug4369710 fix
4580: /*
4581: IF l_yn = 'Y' THEN
4582: --Set Parameter

Line 4590: hz_event_pkg.AddParamEnvToList(l_list);

4586: -- initialization of object variables
4587: l_list := wf_parameter_list_t();
4588:
4589: -- Add Context values to the list
4590: hz_event_pkg.AddParamEnvToList(l_list);
4591: l_param := WF_PARAMETER_T( NULL, NULL );
4592:
4593: -- fill the parameters list
4594: l_list.extend;

Line 4600: hz_event_pkg.raise_event( p_event_name => l_event_name

4596: l_param.SetValue(P_CITIZENSHIP_REC.CITIZENSHIP_ID);
4597: l_list(l_list.last) := l_param;
4598:
4599: -- Raise Event
4600: hz_event_pkg.raise_event( p_event_name => l_event_name
4601: ,p_event_key => l_key
4602: ,p_parameters => l_list);
4603: l_list.DELETE;
4604:

Line 4636: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4632:
4633:
4634: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4635: -- commenting the following line as part of bug4369710 fix
4636: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4637:
4638: --Get the item key
4639: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4640: -- commenting the following line as part of bug4369710 fix

Line 4639: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4635: -- commenting the following line as part of bug4369710 fix
4636: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4637:
4638: --Get the item key
4639: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4640: -- commenting the following line as part of bug4369710 fix
4641: /*
4642: IF l_yn = 'Y' THEN
4643: --Set Parameter

Line 4652: hz_event_pkg.AddParamEnvToList(l_list);

4648: -- initialization of object variables
4649: l_list := wf_parameter_list_t();
4650:
4651: -- Add Context values
4652: hz_event_pkg.AddParamEnvToList(l_list);
4653: l_param := WF_PARAMETER_T( NULL, NULL );
4654:
4655: -- fill the parameters list
4656: l_list.extend;

Line 4662: hz_event_pkg.raise_event( p_event_name => l_event_name

4658: l_param.SetValue(P_CITIZENSHIP_REC.CITIZENSHIP_ID);
4659: l_list(l_list.last) := l_param;
4660:
4661: -- Raise Event
4662: hz_event_pkg.raise_event( p_event_name => l_event_name
4663: ,p_event_key => l_key
4664: ,p_parameters => l_list);
4665: l_list.DELETE;
4666:

Line 4696: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4692:
4693:
4694: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4695: -- commenting the following line as part of bug4369710 fix
4696: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4697:
4698: --Get the item key
4699: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4700: -- commenting the following line as part of bug4369710 fix

Line 4699: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4695: -- commenting the following line as part of bug4369710 fix
4696: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4697:
4698: --Get the item key
4699: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4700: -- commenting the following line as part of bug4369710 fix
4701: /*
4702: IF l_yn = 'Y' THEN
4703: --Set Parameter

Line 4711: hz_event_pkg.AddParamEnvToList(l_list);

4707: -- initialization of object variables
4708: l_list := wf_parameter_list_t();
4709:
4710: -- Add Context values to the list
4711: hz_event_pkg.AddParamEnvToList(l_list);
4712: l_param := WF_PARAMETER_T( NULL, NULL );
4713:
4714: -- fill the parameters list
4715: l_list.extend;

Line 4721: hz_event_pkg.raise_event( p_event_name => l_event_name

4717: l_param.SetValue(P_EDUCATION_REC.EDUCATION_ID);
4718: l_list(l_list.last) := l_param;
4719:
4720: -- Raise Event
4721: hz_event_pkg.raise_event( p_event_name => l_event_name
4722: ,p_event_key => l_key
4723: ,p_parameters => l_list);
4724: l_list.DELETE;
4725:

Line 4757: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4753:
4754:
4755: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4756: -- commenting the following line as part of bug4369710 fix
4757: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4758:
4759: --Get the item key
4760: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4761: -- commenting the following line as part of bug4369710 fix

Line 4760: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4756: -- commenting the following line as part of bug4369710 fix
4757: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4758:
4759: --Get the item key
4760: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4761: -- commenting the following line as part of bug4369710 fix
4762: /*
4763: IF l_yn = 'Y' THEN
4764: --Set Parameter

Line 4773: hz_event_pkg.AddParamEnvToList(l_list);

4769: -- initialization of object variables
4770: l_list := wf_parameter_list_t();
4771:
4772: -- Add Context values to the list
4773: hz_event_pkg.AddParamEnvToList(l_list);
4774: l_param := WF_PARAMETER_T( NULL, NULL );
4775:
4776: -- fill the parameters list
4777: l_list.extend;

Line 4783: hz_event_pkg.raise_event( p_event_name => l_event_name

4779: l_param.SetValue(P_EDUCATION_REC.EDUCATION_ID);
4780: l_list(l_list.last) := l_param;
4781:
4782: -- Raise Event
4783: hz_event_pkg.raise_event( p_event_name => l_event_name
4784: ,p_event_key => l_key
4785: ,p_parameters => l_list);
4786: l_list.DELETE;
4787:

Line 4819: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4815:
4816:
4817: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4818: -- commenting the following line as part of bug4369710 fix
4819: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4820:
4821: --Get the item key
4822: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4823: -- commenting the following line as part of bug4369710 fix

Line 4822: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4818: -- commenting the following line as part of bug4369710 fix
4819: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4820:
4821: --Get the item key
4822: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4823: -- commenting the following line as part of bug4369710 fix
4824: /*
4825: IF l_yn = 'Y' THEN
4826: --Set Parameter

Line 4835: hz_event_pkg.AddParamEnvToList(l_list);

4831: -- initialization of object variables
4832: l_list := wf_parameter_list_t();
4833:
4834: -- Add Context values to the list
4835: hz_event_pkg.AddParamEnvToList(l_list);
4836: l_param := WF_PARAMETER_T( NULL, NULL );
4837:
4838: -- fill the parameters list
4839: l_list.extend;

Line 4845: hz_event_pkg.raise_event( p_event_name => l_event_name

4841: l_param.SetValue(P_EMP_HISTORY_REC.EMPLOYMENT_HISTORY_ID);
4842: l_list(l_list.last) := l_param;
4843:
4844: -- Raise Event
4845: hz_event_pkg.raise_event( p_event_name => l_event_name
4846: ,p_event_key => l_key
4847: ,p_parameters => l_list);
4848: l_list.DELETE;
4849:

Line 4878: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4874:
4875:
4876: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4877: -- commenting the following line as part of bug4369710 fix
4878: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4879:
4880: --Get the item key
4881: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4882: -- commenting the following line as part of bug4369710 fix

Line 4881: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4877: -- commenting the following line as part of bug4369710 fix
4878: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4879:
4880: --Get the item key
4881: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4882: -- commenting the following line as part of bug4369710 fix
4883: /*
4884: IF l_yn = 'Y' THEN
4885: --Set Parameter

Line 4893: hz_event_pkg.AddParamEnvToList(l_list);

4889: -- initialization of object variables
4890: l_list := wf_parameter_list_t();
4891:
4892: -- Add Context values to the list
4893: hz_event_pkg.AddParamEnvToList(l_list);
4894: l_param := WF_PARAMETER_T( NULL, NULL );
4895:
4896: -- fill the parameters list
4897: l_list.extend;

Line 4903: hz_event_pkg.raise_event( p_event_name => l_event_name

4899: l_param.SetValue(P_EMP_HISTORY_REC.EMPLOYMENT_HISTORY_ID);
4900: l_list(l_list.last) := l_param;
4901:
4902: -- Raise Event
4903: hz_event_pkg.raise_event( p_event_name => l_event_name
4904: ,p_event_key => l_key
4905: ,p_parameters => l_list);
4906: l_list.DELETE;
4907:

Line 4936: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4932:
4933:
4934: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4935: -- commenting the following line as part of bug4369710 fix
4936: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4937:
4938: --Get the item key
4939: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4940: -- commenting the following line as part of bug4369710 fix

Line 4939: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4935: -- commenting the following line as part of bug4369710 fix
4936: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4937:
4938: --Get the item key
4939: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4940: -- commenting the following line as part of bug4369710 fix
4941: /*
4942: IF l_yn = 'Y' THEN
4943: --Set Parameter

Line 4951: hz_event_pkg.AddParamEnvToList(l_list);

4947: -- initialization of object variables
4948: l_list := wf_parameter_list_t();
4949:
4950: -- Add Context values to the list
4951: hz_event_pkg.AddParamEnvToList(l_list);
4952: l_param := WF_PARAMETER_T( NULL, NULL );
4953:
4954: -- fill the parameters list
4955: l_list.extend;

Line 4961: hz_event_pkg.raise_event( p_event_name => l_event_name

4957: l_param.SetValue(P_WORK_CLASS_REC.WORK_CLASS_ID);
4958: l_list(l_list.last) := l_param;
4959:
4960: -- Raise Event
4961: hz_event_pkg.raise_event( p_event_name => l_event_name
4962: ,p_event_key => l_key
4963: ,p_parameters => l_list);
4964: l_list.DELETE;
4965:

Line 4995: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

4991:
4992:
4993: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
4994: -- commenting the following line as part of bug4369710 fix
4995: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4996:
4997: --Get the item key
4998: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4999: -- commenting the following line as part of bug4369710 fix

Line 4998: l_key := HZ_EVENT_PKG.item_key(l_event_name);

4994: -- commenting the following line as part of bug4369710 fix
4995: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
4996:
4997: --Get the item key
4998: l_key := HZ_EVENT_PKG.item_key(l_event_name);
4999: -- commenting the following line as part of bug4369710 fix
5000: /*
5001: IF l_yn = 'Y' THEN
5002: --Set Parameter

Line 5011: hz_event_pkg.AddParamEnvToList(l_list);

5007: -- initialization of object variables
5008: l_list := wf_parameter_list_t();
5009:
5010: -- Add Context values to the list
5011: hz_event_pkg.AddParamEnvToList(l_list);
5012: l_param := WF_PARAMETER_T( NULL, NULL );
5013:
5014: -- fill the parameters list
5015: l_list.extend;

Line 5021: hz_event_pkg.raise_event( p_event_name => l_event_name

5017: l_param.SetValue(P_WORK_CLASS_REC.WORK_CLASS_ID);
5018: l_list(l_list.last) := l_param;
5019:
5020: -- Raise Event
5021: hz_event_pkg.raise_event( p_event_name => l_event_name
5022: ,p_event_key => l_key
5023: ,p_parameters => l_list);
5024: l_list.DELETE;
5025:

Line 5057: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5053:
5054:
5055: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5056: -- commenting the following line as part of bug4369710 fix
5057: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5058:
5059: -- initialization of object variables
5060: l_list := wf_parameter_list_t();
5061:

Line 5063: hz_event_pkg.AddParamEnvToList(l_list);

5059: -- initialization of object variables
5060: l_list := wf_parameter_list_t();
5061:
5062: -- Add Context values to the list
5063: hz_event_pkg.AddParamEnvToList(l_list);
5064: l_param := WF_PARAMETER_T( NULL, NULL );
5065:
5066: -- fill the parameters list
5067: l_list.extend;

Line 5073: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5069: l_param.SetValue(P_CREDIT_RATINGS_REC.CREDIT_RATING_ID);
5070: l_list(l_list.last) := l_param;
5071:
5072: --Get the item key
5073: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5074: -- commenting the following line as part of bug4369710 fix
5075: /*
5076: IF l_yn = 'Y' THEN
5077: --Set Parameter

Line 5082: hz_event_pkg.raise_event( p_event_name => l_event_name

5078: hz_param_pkg.setparameter(l_key, p_credit_ratings_rec, 'NEW');
5079: END IF;
5080: */
5081: -- Raise Event
5082: hz_event_pkg.raise_event( p_event_name => l_event_name
5083: ,p_event_key => l_key
5084: ,p_parameters => l_list);
5085: l_list.DELETE;
5086:

Line 5116: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5112:
5113:
5114: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5115: -- commenting the following line as part of bug4369710 fix
5116: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5117:
5118: --Get the item key
5119: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5120:

Line 5119: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5115: -- commenting the following line as part of bug4369710 fix
5116: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5117:
5118: --Get the item key
5119: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5120:
5121: -- initialization of object variables
5122: l_list := wf_parameter_list_t();
5123:

Line 5125: hz_event_pkg.AddParamEnvToList(l_list);

5121: -- initialization of object variables
5122: l_list := wf_parameter_list_t();
5123:
5124: -- Add Context values to the list
5125: hz_event_pkg.AddParamEnvToList(l_list);
5126: l_param := WF_PARAMETER_T( NULL, NULL );
5127:
5128: -- fill the parameters list
5129: l_list.extend;

Line 5142: hz_event_pkg.raise_event( p_event_name => l_event_name

5138: hz_param_pkg.setparameter(l_key, p_old_credit_ratings_rec, 'OLD');
5139: END IF;
5140: */
5141: -- Raise Event
5142: hz_event_pkg.raise_event( p_event_name => l_event_name
5143: ,p_event_key => l_key
5144: ,p_parameters => l_list);
5145: l_list.DELETE;
5146:

Line 5175: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5171:
5172:
5173: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5174: -- commenting the following line as part of bug4369710 fix
5175: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5176:
5177: --Get the item key
5178: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5179:

Line 5178: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5174: -- commenting the following line as part of bug4369710 fix
5175: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5176:
5177: --Get the item key
5178: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5179:
5180: -- initialization of object variables
5181: l_list := wf_parameter_list_t();
5182:

Line 5184: hz_event_pkg.AddParamEnvToList(l_list);

5180: -- initialization of object variables
5181: l_list := wf_parameter_list_t();
5182:
5183: -- Add Context values to the list
5184: hz_event_pkg.AddParamEnvToList(l_list);
5185: l_param := WF_PARAMETER_T( NULL, NULL );
5186:
5187: -- fill the parameters list
5188: l_list.extend;

Line 5200: hz_event_pkg.raise_event( p_event_name => l_event_name

5196: hz_param_pkg.setparameter(l_key, p_financial_profile_rec, 'NEW');
5197: END IF;
5198: */
5199: -- Raise Event
5200: hz_event_pkg.raise_event( p_event_name => l_event_name
5201: ,p_event_key => l_key
5202: ,p_parameters => l_list);
5203: l_list.DELETE;
5204:

Line 5232: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5228:
5229:
5230: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5231: -- commenting the following line as part of bug4369710 fix
5232: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5233:
5234: --Get the item key
5235: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5236:

Line 5235: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5231: -- commenting the following line as part of bug4369710 fix
5232: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5233:
5234: --Get the item key
5235: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5236:
5237: -- initialization of object variables
5238: l_list := wf_parameter_list_t();
5239:

Line 5241: hz_event_pkg.AddParamEnvToList(l_list);

5237: -- initialization of object variables
5238: l_list := wf_parameter_list_t();
5239:
5240: -- Add Context values to the list
5241: hz_event_pkg.AddParamEnvToList(l_list);
5242: l_param := WF_PARAMETER_T( NULL, NULL );
5243:
5244: -- fill the parameters list
5245: l_list.extend;

Line 5257: hz_event_pkg.raise_event( p_event_name => l_event_name

5253: hz_param_pkg.setparameter(l_key, p_financial_profile_rec, 'NEW');
5254: END IF;
5255: */
5256: -- Raise Event
5257: hz_event_pkg.raise_event( p_event_name => l_event_name
5258: ,p_event_key => l_key
5259: ,p_parameters => l_list);
5260: l_list.DELETE;
5261:

Line 5289: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5285:
5286:
5287: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5288: -- commenting the following line as part of bug4369710 fix
5289: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5290:
5291: --Get the item key
5292: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5293:

Line 5292: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5288: -- commenting the following line as part of bug4369710 fix
5289: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5290:
5291: --Get the item key
5292: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5293:
5294: -- initialization of object variables
5295: l_list := wf_parameter_list_t();
5296:

Line 5298: hz_event_pkg.AddParamEnvToList(l_list);

5294: -- initialization of object variables
5295: l_list := wf_parameter_list_t();
5296:
5297: -- Add Context values to the list
5298: hz_event_pkg.AddParamEnvToList(l_list);
5299: l_param := WF_PARAMETER_T( NULL, NULL );
5300:
5301: -- fill the parameters list
5302: l_list.extend;

Line 5314: hz_event_pkg.raise_event( p_event_name => l_event_name

5310: hz_param_pkg.setparameter(l_key, p_orig_sys_reference_rec, 'NEW');
5311: END IF;
5312: */
5313: -- Raise Event
5314: hz_event_pkg.raise_event( p_event_name => l_event_name
5315: ,p_event_key => l_key
5316: ,p_parameters => l_list);
5317: l_list.DELETE;
5318:

Line 5349: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);

5345:
5346:
5347: IF G_EXECUTE_API_CALLOUT = 'Y' THEN
5348: -- commenting the following line as part of bug4369710 fix
5349: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5350:
5351: --Get the item key
5352: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5353: -- commenting the following line as part of bug4369710 fix

Line 5352: l_key := HZ_EVENT_PKG.item_key(l_event_name);

5348: -- commenting the following line as part of bug4369710 fix
5349: -- l_yn := hz_event_pkg.exist_subscription(l_event_name);
5350:
5351: --Get the item key
5352: l_key := HZ_EVENT_PKG.item_key(l_event_name);
5353: -- commenting the following line as part of bug4369710 fix
5354: /*
5355: IF l_yn = 'Y' THEN
5356: --Set Parameter

Line 5365: hz_event_pkg.AddParamEnvToList(l_list);

5361: -- initialization of object variables
5362: l_list := wf_parameter_list_t();
5363:
5364: -- Add Context values to the list
5365: hz_event_pkg.AddParamEnvToList(l_list);
5366: l_param := WF_PARAMETER_T( NULL, NULL );
5367:
5368: -- fill the parameters list
5369: l_list.extend;

Line 5375: hz_event_pkg.raise_event( p_event_name => l_event_name

5371: l_param.SetValue(P_ORIG_SYS_REFERENCE_REC.ORIG_SYSTEM_REF_ID);
5372: l_list(l_list.last) := l_param;
5373:
5374: -- Raise Event
5375: hz_event_pkg.raise_event( p_event_name => l_event_name
5376: ,p_event_key => l_key
5377: ,p_parameters => l_list);
5378: l_list.DELETE;
5379: