DBA Data[Home] [Help]

APPS.HZ_BUSINESS_EVENT_V2PVT dependencies on WF_PARAMETER_T

Line 18: l_param WF_PARAMETER_T;

14: p_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
15: ) IS
16:
17: l_list WF_PARAMETER_LIST_T;
18: l_param WF_PARAMETER_T;
19: l_key VARCHAR2(240);
20: l_exist VARCHAR2(1);
21: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Person.create';
22:

Line 51: l_param := WF_PARAMETER_T( NULL, NULL );

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
54: l_list.extend;
55: l_param.SetName( 'PARTY_ID' );

Line 84: l_param WF_PARAMETER_T;

80: p_old_person_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE
81: ) IS
82:
83: l_list WF_PARAMETER_LIST_T;
84: l_param WF_PARAMETER_T;
85: l_key VARCHAR2(240);
86: l_exist VARCHAR2(1);
87: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Person.update';
88:

Line 117: l_param := WF_PARAMETER_T( NULL, NULL );

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;
121: l_param.SetName( 'PARTY_ID' );

Line 148: l_param WF_PARAMETER_T;

144: p_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE
145: ) IS
146:
147: l_list WF_PARAMETER_LIST_T;
148: l_param WF_PARAMETER_T;
149: l_key VARCHAR2(240);
150: l_exist VARCHAR2(1);
151: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Group.create';
152:

Line 181: l_param := WF_PARAMETER_T( NULL, NULL );

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;
185: l_param.SetName( 'PARTY_ID' );

Line 213: l_param WF_PARAMETER_T;

209: p_old_group_rec IN HZ_PARTY_V2PUB.GROUP_REC_TYPE
210: ) IS
211:
212: l_list WF_PARAMETER_LIST_T;
213: l_param WF_PARAMETER_T;
214: l_key VARCHAR2(240);
215: l_exist VARCHAR2(1);
216: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Group.update';
217:

Line 246: l_param := WF_PARAMETER_T( NULL, NULL );

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;
250: l_param.SetName( 'PARTY_ID' );

Line 277: l_param WF_PARAMETER_T;

273: p_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
274: ) IS
275:
276: l_list WF_PARAMETER_LIST_T;
277: l_param WF_PARAMETER_T;
278: l_key VARCHAR2(240);
279: l_exist VARCHAR2(1);
280: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Organization.create';
281:

Line 308: l_param := WF_PARAMETER_T( NULL, NULL );

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
312: l_list.extend;

Line 341: l_param WF_PARAMETER_T;

337: p_old_organization_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE
338: ) IS
339:
340: l_list WF_PARAMETER_LIST_T;
341: l_param WF_PARAMETER_T;
342: l_key VARCHAR2(240);
343: l_exist VARCHAR2(1);
344: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Organization.update';
345:

Line 374: l_param := WF_PARAMETER_T( NULL, NULL );

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
378: l_list.extend;

Line 409: l_param WF_PARAMETER_T;

405: p_party_created IN VARCHAR2
406: ) IS
407:
408: l_list WF_PARAMETER_LIST_T;
409: l_param WF_PARAMETER_T;
410: l_key VARCHAR2(240);
411: l_exist VARCHAR2(1);
412: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Relationship.create';
413:

Line 442: l_param := WF_PARAMETER_T( NULL, NULL );

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
446: l_list.extend;

Line 480: l_param WF_PARAMETER_T;

476: p_old_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE
477: ) IS
478:
479: l_list WF_PARAMETER_LIST_T;
480: l_param WF_PARAMETER_T;
481: l_key VARCHAR2(240);
482: l_exist VARCHAR2(1);
483: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Relationship.update';
484:

Line 514: l_param := WF_PARAMETER_T( NULL, NULL );

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
518: l_list.extend;

Line 548: l_param WF_PARAMETER_T;

544: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
545: ) IS
546:
547: l_list WF_PARAMETER_LIST_T;
548: l_param WF_PARAMETER_T;
549: l_key VARCHAR2(240);
550: l_exist VARCHAR2(1);
551: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PartySite.create';
552:

Line 579: l_param := WF_PARAMETER_T( NULL, NULL );

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
583: l_list.extend;

Line 611: l_param WF_PARAMETER_T;

607: p_old_party_site_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE
608: ) IS
609:
610: l_list WF_PARAMETER_LIST_T;
611: l_param WF_PARAMETER_T;
612: l_key VARCHAR2(240);
613: l_exist VARCHAR2(1);
614: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PartySite.update';
615:

Line 645: l_param := WF_PARAMETER_T( NULL, NULL );

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
649: l_list.extend;

Line 677: l_param WF_PARAMETER_T;

673: p_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE
674: ) IS
675:
676: l_list WF_PARAMETER_LIST_T;
677: l_param WF_PARAMETER_T;
678: l_key VARCHAR2(240);
679: l_exist VARCHAR2(1);
680: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PartySiteUse.create';
681:

Line 709: l_param := WF_PARAMETER_T( NULL, NULL );

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
713: l_list.extend;

Line 742: l_param WF_PARAMETER_T;

738: p_old_party_site_use_rec IN HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE
739: ) IS
740:
741: l_list WF_PARAMETER_LIST_T;
742: l_param WF_PARAMETER_T;
743: l_key VARCHAR2(240);
744: l_exist VARCHAR2(1);
745: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PartySiteUse.update';
746:

Line 775: l_param := WF_PARAMETER_T( NULL, NULL );

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
779: l_list.extend;

Line 810: l_param WF_PARAMETER_T;

806:
807: ) IS
808:
809: l_list WF_PARAMETER_LIST_T;
810: l_param WF_PARAMETER_T;
811: l_key VARCHAR2(240);
812: l_exist VARCHAR2(1);
813: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContact.create';
814:

Line 840: l_param := WF_PARAMETER_T( NULL, NULL );

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
844: l_list.extend;

Line 873: l_param WF_PARAMETER_T;

869: p_old_org_contact_rec IN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE
870: ) IS
871:
872: l_list WF_PARAMETER_LIST_T;
873: l_param WF_PARAMETER_T;
874: l_key VARCHAR2(240);
875: l_exist VARCHAR2(1);
876: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContact.update';
877:

Line 907: l_param := WF_PARAMETER_T( NULL, NULL );

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
911: l_list.extend;

Line 939: l_param WF_PARAMETER_T;

935: p_org_contact_role_rec IN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE
936: ) IS
937:
938: l_list WF_PARAMETER_LIST_T;
939: l_param WF_PARAMETER_T;
940: l_key VARCHAR2(240);
941: l_exist VARCHAR2(1);
942: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContactRole.create';
943:

Line 970: l_param := WF_PARAMETER_T( NULL, NULL );

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
974: l_list.extend;

Line 1003: l_param WF_PARAMETER_T;

999: p_old_org_contact_role_rec IN HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE
1000: ) IS
1001:
1002: l_list WF_PARAMETER_LIST_T;
1003: l_param WF_PARAMETER_T;
1004: l_key VARCHAR2(240);
1005: l_exist VARCHAR2(1);
1006: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.OrgContactRole.update';
1007:

Line 1036: l_param := WF_PARAMETER_T( NULL, NULL );

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
1040: l_list.extend;

Line 1070: l_param WF_PARAMETER_T;

1066: p_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
1067: ) IS
1068:
1069: l_list WF_PARAMETER_LIST_T;
1070: l_param WF_PARAMETER_T;
1071: l_key VARCHAR2(240);
1072: l_exist VARCHAR2(1);
1073: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Location.create';
1074:

Line 1101: l_param := WF_PARAMETER_T( NULL, NULL );

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
1105: l_list.extend;

Line 1134: l_param WF_PARAMETER_T;

1130: p_old_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE
1131: ) IS
1132:
1133: l_list WF_PARAMETER_LIST_T;
1134: l_param WF_PARAMETER_T;
1135: l_key VARCHAR2(240);
1136: l_exist VARCHAR2(1);
1137: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.Location.update';
1138:

Line 1168: l_param := WF_PARAMETER_T( NULL, NULL );

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
1172: l_list.extend;

Line 1212: l_param WF_PARAMETER_T;

1208: p_web_rec IN hz_contact_point_v2pub.web_rec_type
1209: ) IS
1210:
1211: l_list WF_PARAMETER_LIST_T;
1212: l_param WF_PARAMETER_T;
1213: l_key VARCHAR2(240);
1214: l_exist VARCHAR2(1);
1215: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPoint.create';
1216:

Line 1250: l_param := WF_PARAMETER_T( NULL, NULL );

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
1254: l_list.extend;

Line 1299: l_param WF_PARAMETER_T;

1295: p_old_web_rec IN hz_contact_point_v2pub.web_rec_type
1296: ) IS
1297:
1298: l_list WF_PARAMETER_LIST_T;
1299: l_param WF_PARAMETER_T;
1300: l_key VARCHAR2(240);
1301: l_exist VARCHAR2(1);
1302: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPoint.update';
1303:

Line 1345: l_param := WF_PARAMETER_T( NULL, NULL );

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
1349: l_list.extend;

Line 1378: l_param WF_PARAMETER_T;

1374: p_contact_preference_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
1375: ) IS
1376:
1377: l_list WF_PARAMETER_LIST_T;
1378: l_param WF_PARAMETER_T;
1379: l_key VARCHAR2(240);
1380: l_exist VARCHAR2(1);
1381: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPreference.create';
1382:

Line 1409: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1413: l_param.SetName( 'CONTACT_PREFERENCE_ID' );

Line 1441: l_param WF_PARAMETER_T;

1437: p_old_contact_preference_rec IN HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE
1438: ) IS
1439:
1440: l_list WF_PARAMETER_LIST_T;
1441: l_param WF_PARAMETER_T;
1442: l_key VARCHAR2(240);
1443: l_exist VARCHAR2(1);
1444: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ContactPreference.update';
1445:

Line 1475: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1479: l_param.SetName( 'CONTACT_PREFERENCE_ID' );

Line 1511: l_param WF_PARAMETER_T;

1507: p_create_profile_amt IN VARCHAR2
1508: ) IS
1509:
1510: l_list WF_PARAMETER_LIST_T;
1511: l_param WF_PARAMETER_T;
1512: l_key VARCHAR2(240);
1513: l_exist VARCHAR2(1);
1514: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccount.create';
1515:

Line 1546: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1550: l_param.SetName( 'CUST_ACCOUNT_ID' );

Line 1595: l_param WF_PARAMETER_T;

1591: p_create_profile_amt IN VARCHAR2
1592: ) IS
1593:
1594: l_list WF_PARAMETER_LIST_T;
1595: l_param WF_PARAMETER_T;
1596: l_key VARCHAR2(240);
1597: l_exist VARCHAR2(1);
1598: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccount.create';
1599:

Line 1630: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1634: l_param.SetName( 'CUST_ACCOUNT_ID' );

Line 1677: l_param WF_PARAMETER_T;

1673: p_old_cust_account_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE
1674: ) IS
1675:
1676: l_list WF_PARAMETER_LIST_T;
1677: l_param WF_PARAMETER_T;
1678: l_key VARCHAR2(240);
1679: l_exist VARCHAR2(1);
1680: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccount.update';
1681:

Line 1711: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1715: l_param.SetName( 'CUST_ACCOUNT_ID' );

Line 1742: l_param WF_PARAMETER_T;

1738: p_cust_acct_relate_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE
1739: ) IS
1740:
1741: l_list WF_PARAMETER_LIST_T;
1742: l_param WF_PARAMETER_T;
1743: l_key VARCHAR2(240);
1744: l_exist VARCHAR2(1);
1745: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctRelate.create';
1746:

Line 1775: l_param := WF_PARAMETER_T( NULL, NULL );

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
1778: l_list.extend;
1779: l_param.SetName( 'CUST_ACCOUNT_ID' );

Line 1812: l_param WF_PARAMETER_T;

1808: p_old_cust_acct_relate_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCT_RELATE_REC_TYPE
1809: ) IS
1810:
1811: l_list WF_PARAMETER_LIST_T;
1812: l_param WF_PARAMETER_T;
1813: l_key VARCHAR2(240);
1814: l_exist VARCHAR2(1);
1815: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctRelate.update';
1816:

Line 1848: l_param := WF_PARAMETER_T( NULL, NULL );

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
1851: l_list.extend;
1852: l_param.SetName( 'CUST_ACCOUNT_ID' );

Line 1887: l_param WF_PARAMETER_T;

1883: p_create_profile_amt IN VARCHAR2
1884: ) IS
1885:
1886: l_list WF_PARAMETER_LIST_T;
1887: l_param WF_PARAMETER_T;
1888: l_key VARCHAR2(240);
1889: l_exist VARCHAR2(1);
1890: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustomerProfile.create';
1891:

Line 1920: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1924: l_param.SetName( 'CUST_ACCOUNT_PROFILE_ID' );

Line 1957: l_param WF_PARAMETER_T;

1953: p_old_customer_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
1954: ) IS
1955:
1956: l_list WF_PARAMETER_LIST_T;
1957: l_param WF_PARAMETER_T;
1958: l_key VARCHAR2(240);
1959: l_exist VARCHAR2(1);
1960: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustomerProfile.update';
1961:

Line 1991: l_param := WF_PARAMETER_T( NULL, NULL );

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;
1995: l_param.SetName( 'CUST_ACCOUNT_PROFILE_ID' );

Line 2022: l_param WF_PARAMETER_T;

2018: p_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE
2019: ) IS
2020:
2021: l_list WF_PARAMETER_LIST_T;
2022: l_param WF_PARAMETER_T;
2023: l_key VARCHAR2(240);
2024: l_exist VARCHAR2(1);
2025: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustProfileAmt.create';
2026:

Line 2054: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2058: l_param.SetName( 'CUST_ACCT_PROFILE_AMT_ID' );

Line 2087: l_param WF_PARAMETER_T;

2083: p_old_cust_profile_amt_rec IN HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE
2084: ) IS
2085:
2086: l_list WF_PARAMETER_LIST_T;
2087: l_param WF_PARAMETER_T;
2088: l_key VARCHAR2(240);
2089: l_exist VARCHAR2(1);
2090: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustProfileAmt.update';
2091:

Line 2119: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2123: l_param.SetName( 'CUST_ACCT_PROFILE_AMT_ID' );

Line 2152: l_param WF_PARAMETER_T;

2148: p_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
2149: ) IS
2150:
2151: l_list WF_PARAMETER_LIST_T;
2152: l_param WF_PARAMETER_T;
2153: l_key VARCHAR2(240);
2154: l_exist VARCHAR2(1);
2155: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSite.create';
2156:

Line 2186: l_param := WF_PARAMETER_T( NULL, NULL );

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
2189: l_list.extend;
2190: l_param.SetName( 'CUST_ACCT_SITE_ID' );

Line 2218: l_param WF_PARAMETER_T;

2214: p_old_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE
2215: ) IS
2216:
2217: l_list WF_PARAMETER_LIST_T;
2218: l_param WF_PARAMETER_T;
2219: l_key VARCHAR2(240);
2220: l_exist VARCHAR2(1);
2221: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSite.update';
2222:

Line 2253: l_param := WF_PARAMETER_T( NULL, NULL );

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
2256: l_list.extend;
2257: l_param.SetName( 'CUST_ACCT_SITE_ID' );

Line 2287: l_param WF_PARAMETER_T;

2283: p_create_profile_amt IN VARCHAR2
2284: ) IS
2285:
2286: l_list WF_PARAMETER_LIST_T;
2287: l_param WF_PARAMETER_T;
2288: l_key VARCHAR2(240);
2289: l_exist VARCHAR2(1);
2290: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSiteUse.create';
2291:

Line 2324: l_param := WF_PARAMETER_T( NULL, NULL );

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
2327: l_list.extend;
2328: l_param.SetName( 'SITE_USE_ID' );

Line 2371: l_param WF_PARAMETER_T;

2367: p_old_cust_site_use_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_SITE_USE_REC_TYPE
2368: ) IS
2369:
2370: l_list WF_PARAMETER_LIST_T;
2371: l_param WF_PARAMETER_T;
2372: l_key VARCHAR2(240);
2373: l_exist VARCHAR2(1);
2374: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAcctSiteUse.update';
2375:

Line 2406: l_param := WF_PARAMETER_T( NULL, NULL );

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
2409: l_list.extend;
2410: l_param.SetName( 'SITE_USE_ID' );

Line 2439: l_param WF_PARAMETER_T;

2435: p_cust_account_role_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE
2436: ) IS
2437:
2438: l_list WF_PARAMETER_LIST_T;
2439: l_param WF_PARAMETER_T;
2440: l_key VARCHAR2(240);
2441: l_exist VARCHAR2(1);
2442: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccountRole.create';
2443:

Line 2471: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2475: l_param.SetName( 'CUST_ACCOUNT_ROLE_ID' );

Line 2503: l_param WF_PARAMETER_T;

2499: p_old_cust_account_role_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.CUST_ACCOUNT_ROLE_REC_TYPE
2500: ) IS
2501:
2502: l_list WF_PARAMETER_LIST_T;
2503: l_param WF_PARAMETER_T;
2504: l_key VARCHAR2(240);
2505: l_exist VARCHAR2(1);
2506: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CustAccountRole.update';
2507:

Line 2537: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2541: l_param.SetName( 'CUST_ACCOUNT_ROLE_ID' );

Line 2568: l_param WF_PARAMETER_T;

2564: p_role_responsibility_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.ROLE_RESPONSIBILITY_REC_TYPE
2565: ) IS
2566:
2567: l_list WF_PARAMETER_LIST_T;
2568: l_param WF_PARAMETER_T;
2569: l_key VARCHAR2(240);
2570: l_exist VARCHAR2(1);
2571: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.RoleResponsibility.create';
2572:

Line 2600: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2604: l_param.SetName( 'RESPONSIBILITY_ID' );

Line 2632: l_param WF_PARAMETER_T;

2628: p_old_role_responsibility_rec IN HZ_CUST_ACCOUNT_ROLE_V2PUB.ROLE_RESPONSIBILITY_REC_TYPE
2629: ) IS
2630:
2631: l_list WF_PARAMETER_LIST_T;
2632: l_param WF_PARAMETER_T;
2633: l_key VARCHAR2(240);
2634: l_exist VARCHAR2(1);
2635: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.RoleResponsibility.update';
2636:

Line 2666: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2670: l_param.SetName( 'RESPONSIBILITY_ID' );

Line 2699: l_param WF_PARAMETER_T;

2695: p_class_category_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_REC_TYPE
2696: ) IS
2697:
2698: l_list WF_PARAMETER_LIST_T;
2699: l_param WF_PARAMETER_T;
2700: l_key VARCHAR2(240);
2701: l_exist VARCHAR2(1);
2702: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategory.create';
2703:

Line 2731: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2735: l_param.SetName( 'CLASS_CATEGORY' );

Line 2763: l_param WF_PARAMETER_T;

2759: p_old_class_category_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_REC_TYPE
2760: ) IS
2761:
2762: l_list WF_PARAMETER_LIST_T;
2763: l_param WF_PARAMETER_T;
2764: l_key VARCHAR2(240);
2765: l_exist VARCHAR2(1);
2766: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategory.update';
2767:

Line 2797: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2801: l_param.SetName( 'CLASS_CATEGORY' );

Line 2829: l_param WF_PARAMETER_T;

2825: p_class_code_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_REC_TYPE
2826: ) IS
2827:
2828: l_list WF_PARAMETER_LIST_T;
2829: l_param WF_PARAMETER_T;
2830: l_key VARCHAR2(240);
2831: l_exist VARCHAR2(1);
2832: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCode.create';
2833:

Line 2851: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2855: l_param.SetName( 'CLASS_CATEGORY' );

Line 2889: l_param WF_PARAMETER_T;

2885: p_old_class_code_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_REC_TYPE
2886: ) IS
2887:
2888: l_list WF_PARAMETER_LIST_T;
2889: l_param WF_PARAMETER_T;
2890: l_key VARCHAR2(240);
2891: l_exist VARCHAR2(1);
2892: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCode.update';
2893:

Line 2912: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2916: l_param.SetName( 'CLASS_CATEGORY' );

Line 2949: l_param WF_PARAMETER_T;

2945: p_class_code_relation_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_RELATION_REC_TYPE
2946: ) IS
2947:
2948: l_list WF_PARAMETER_LIST_T;
2949: l_param WF_PARAMETER_T;
2950: l_key VARCHAR2(240);
2951: l_exist VARCHAR2(1);
2952: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCodeRelation.create';
2953:

Line 2981: l_param := WF_PARAMETER_T( NULL, NULL );

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;
2985: l_param.SetName( 'CLASS_CATEGORY' );

Line 3023: l_param WF_PARAMETER_T;

3019: p_old_class_code_relation_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CODE_RELATION_REC_TYPE
3020: ) IS
3021:
3022: l_list WF_PARAMETER_LIST_T;
3023: l_param WF_PARAMETER_T;
3024: l_key VARCHAR2(240);
3025: l_exist VARCHAR2(1);
3026: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCodeRelation.update';
3027:

Line 3057: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3061: l_param.SetName( 'CLASS_CATEGORY' );

Line 3098: l_param WF_PARAMETER_T;

3094: p_code_assignment_rec IN HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE
3095: ) IS
3096:
3097: l_list WF_PARAMETER_LIST_T;
3098: l_param WF_PARAMETER_T;
3099: l_key VARCHAR2(240);
3100: l_exist VARCHAR2(1);
3101: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CodeAssignment.create';
3102:

Line 3131: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3135: l_param.SetName( 'CODE_ASSIGNMENT_ID' );

Line 3163: l_param WF_PARAMETER_T;

3159: p_old_code_assignment_rec IN HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE
3160: ) IS
3161:
3162: l_list WF_PARAMETER_LIST_T;
3163: l_param WF_PARAMETER_T;
3164: l_key VARCHAR2(240);
3165: l_exist VARCHAR2(1);
3166: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.CodeAssignment.update';
3167:

Line 3198: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3202: l_param.SetName( 'CODE_ASSIGNMENT_ID' );

Line 3229: l_param WF_PARAMETER_T;

3225: p_class_category_use_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_USE_REC_TYPE
3226: ) IS
3227:
3228: l_list WF_PARAMETER_LIST_T;
3229: l_param WF_PARAMETER_T;
3230: l_key VARCHAR2(240);
3231: l_exist VARCHAR2(1);
3232: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategoryUse.create';
3233:

Line 3262: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3266: l_param.SetName( 'CLASS_CATEGORY' );

Line 3304: l_param WF_PARAMETER_T;

3300: p_old_class_category_use_rec IN HZ_CLASSIFICATION_V2PUB.CLASS_CATEGORY_USE_REC_TYPE
3301: ) IS
3302:
3303: l_list WF_PARAMETER_LIST_T;
3304: l_param WF_PARAMETER_T;
3305: l_key VARCHAR2(240);
3306: l_exist VARCHAR2(1);
3307: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.ClassCategoryUse.update';
3308:

Line 3338: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3342: l_param.SetName( 'CLASS_CATEGORY' );

Line 3381: l_param WF_PARAMETER_T;

3377: p_person_language_rec IN HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE
3378: ) IS
3379:
3380: l_list WF_PARAMETER_LIST_T;
3381: l_param WF_PARAMETER_T;
3382: l_key VARCHAR2(240);
3383: l_exist VARCHAR2(1);
3384: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PersonLanguage.create';
3385:

Line 3413: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3417: l_param.SetName( 'LANGUAGE_USE_REFERENCE_ID' );

Line 3445: l_param WF_PARAMETER_T;

3441: p_old_person_language_rec IN HZ_PERSON_INFO_V2PUB.PERSON_LANGUAGE_REC_TYPE
3442: ) IS
3443:
3444: l_list WF_PARAMETER_LIST_T;
3445: l_param WF_PARAMETER_T;
3446: l_key VARCHAR2(240);
3447: l_exist VARCHAR2(1);
3448: l_event_name VARCHAR2(240) := 'oracle.apps.ar.hz.PersonLanguage.update';
3449:

Line 3478: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3482: l_param.SetName( 'LANGUAGE_USE_REFERENCE_ID' );

Line 3512: l_param wf_parameter_t;

3508: PROCEDURE create_bill_pref_event
3509: ( p_billing_preferences_rec IN HZ_CUST_ACCT_INFO_PUB.BILLING_PREFERENCES_REC_TYPE)
3510: IS
3511: l_list wf_parameter_list_t;
3512: l_param wf_parameter_t;
3513: l_key varchar2(240);
3514: l_yn varchar2(1);
3515: l_event_name varchar2(240) := 'oracle.apps.ar.hz.BillingPreference.create';
3516: BEGIN

Line 3542: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3546: l_param.SetName('BILLING_PREFERENCES_ID');

Line 3571: l_param wf_parameter_t;

3567: PROCEDURE update_bill_pref_event
3568: ( p_billing_preferences_rec IN HZ_CUST_ACCT_INFO_PUB.BILLING_PREFERENCES_REC_TYPE)
3569: IS
3570: l_list wf_parameter_list_t;
3571: l_param wf_parameter_t;
3572: l_key varchar2(240);
3573: l_yn varchar2(1);
3574: l_event_name varchar2(240) := 'oracle.apps.ar.hz.BillingPreference.update';
3575: BEGIN

Line 3600: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3604: l_param.SetName('BILLING_PREFERENCES_ID');

Line 3628: l_param wf_parameter_t;

3624: PROCEDURE create_bank_acct_uses_event
3625: ( p_bank_acct_uses_rec IN HZ_CUST_ACCT_INFO_PUB.BANK_ACCT_USES_REC_TYPE )
3626: IS
3627: l_list wf_parameter_list_t;
3628: l_param wf_parameter_t;
3629: l_key varchar2(240);
3630: l_yn varchar2(1);
3631: l_event_name varchar2(240) := 'oracle.apps.ar.hz.BankAccountUse.create';
3632: BEGIN

Line 3657: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3661: l_param.SetName('BANK_ACCOUNT_USES_ID');

Line 3685: l_param wf_parameter_t;

3681: PROCEDURE update_bank_acct_uses_event
3682: ( p_bank_acct_uses_rec IN HZ_CUST_ACCT_INFO_PUB.BANK_ACCT_USES_REC_TYPE )
3683: IS
3684: l_list wf_parameter_list_t;
3685: l_param wf_parameter_t;
3686: l_key varchar2(240);
3687: l_yn varchar2(1);
3688: l_event_name varchar2(240) := 'oracle.apps.ar.hz.BankAccountUse.update';
3689: BEGIN

Line 3714: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3718: l_param.SetName('BANK_ACCOUNT_USES_ID');

Line 3742: l_param wf_parameter_t;

3738: PROCEDURE create_suspension_act_event
3739: ( p_suspension_activity_rec IN HZ_CUST_ACCT_INFO_PUB.SUSPENSION_ACTIVITY_REC_TYPE )
3740: IS
3741: l_list wf_parameter_list_t;
3742: l_param wf_parameter_t;
3743: l_key varchar2(240);
3744: l_yn varchar2(1);
3745: l_event_name varchar2(240) := 'oracle.apps.ar.hz.SuspensionActivity.create';
3746: BEGIN

Line 3771: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3775: l_param.SetName('SUSPENSION_ACTIVITY_ID');

Line 3799: l_param wf_parameter_t;

3795: PROCEDURE update_suspension_act_event
3796: ( p_suspension_activity_rec IN HZ_CUST_ACCT_INFO_PUB.SUSPENSION_ACTIVITY_REC_TYPE )
3797: IS
3798: l_list wf_parameter_list_t;
3799: l_param wf_parameter_t;
3800: l_key varchar2(240);
3801: l_yn varchar2(1);
3802: l_event_name varchar2(240) := 'oracle.apps.ar.hz.SuspensionActivity.update';
3803: BEGIN

Line 3827: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3831: l_param.SetName('SUSPENSION_ACTIVITY_ID');

Line 3858: l_param wf_parameter_t;

3854: PROCEDURE create_stock_markets_event
3855: ( p_stock_markets_rec IN HZ_ORG_INFO_PUB.STOCK_MARKETS_REC_TYPE )
3856: IS
3857: l_list wf_parameter_list_t;
3858: l_param wf_parameter_t;
3859: l_key varchar2(240);
3860: l_yn varchar2(1);
3861: l_event_name varchar2(240) := 'oracle.apps.ar.hz.StockMarket.create';
3862: BEGIN

Line 3888: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3892: l_param.SetName('STOCK_EXCHANGE_ID');

Line 3917: l_param wf_parameter_t;

3913: PROCEDURE update_stock_markets_event
3914: ( p_stock_markets_rec IN HZ_ORG_INFO_PUB.STOCK_MARKETS_REC_TYPE )
3915: IS
3916: l_list wf_parameter_list_t;
3917: l_param wf_parameter_t;
3918: l_key varchar2(240);
3919: l_yn varchar2(1);
3920: l_event_name varchar2(240) := 'oracle.apps.ar.hz.StockMarket.update';
3921: BEGIN

Line 3946: l_param := WF_PARAMETER_T( NULL, NULL );

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;
3950: l_param.SetName('STOCK_EXCHANGE_ID');

Line 3975: l_param wf_parameter_t;

3971: PROCEDURE create_sec_issued_event
3972: ( p_security_issued_rec IN HZ_ORG_INFO_PUB.SECURITY_ISSUED_REC_TYPE )
3973: IS
3974: l_list wf_parameter_list_t;
3975: l_param wf_parameter_t;
3976: l_key varchar2(240);
3977: l_yn varchar2(1);
3978: l_event_name varchar2(240) := 'oracle.apps.ar.hz.SecurityIssued.create';
3979: BEGIN

Line 4004: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4008: l_param.SetName('SECURITY_ISSUED_ID');

Line 4033: l_param wf_parameter_t;

4029: PROCEDURE update_sec_issued_event
4030: ( p_security_issued_rec IN HZ_ORG_INFO_PUB.SECURITY_ISSUED_REC_TYPE )
4031: IS
4032: l_list wf_parameter_list_t;
4033: l_param wf_parameter_t;
4034: l_key varchar2(240);
4035: l_yn varchar2(1);
4036: l_event_name varchar2(240) := 'oracle.apps.ar.hz.SecurityIssued.update';
4037: BEGIN

Line 4062: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4066: l_param.SetName('SECURITY_ISSUED_ID');

Line 4090: l_param wf_parameter_t;

4086: PROCEDURE create_fin_reports_event
4087: ( p_financial_reports_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE )
4088: IS
4089: l_list wf_parameter_list_t;
4090: l_param wf_parameter_t;
4091: l_key varchar2(240);
4092: l_yn varchar2(1);
4093: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialReport.create';
4094: BEGIN

Line 4120: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4124: l_param.SetName('FINANCIAL_REPORT_ID');

Line 4150: l_param wf_parameter_t;

4146: ( p_financial_reports_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE,
4147: p_old_financial_reports_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_REPORT_REC_TYPE )
4148: IS
4149: l_list wf_parameter_list_t;
4150: l_param wf_parameter_t;
4151: l_key varchar2(240);
4152: l_yn varchar2(1);
4153: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialReport.update';
4154: BEGIN

Line 4180: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4184: l_param.SetName('FINANCIAL_REPORT_ID');

Line 4209: l_param wf_parameter_t;

4205: PROCEDURE create_fin_numbers_event
4206: ( p_financial_numbers_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE )
4207: IS
4208: l_list wf_parameter_list_t;
4209: l_param wf_parameter_t;
4210: l_key varchar2(240);
4211: l_yn varchar2(1);
4212: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialNumber.create';
4213: BEGIN

Line 4238: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4242: l_param.SetName('FINANCIAL_NUMBER_ID');

Line 4268: l_param wf_parameter_t;

4264: ( p_financial_numbers_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE ,
4265: p_old_financial_numbers_rec IN HZ_ORGANIZATION_INFO_V2PUB.FINANCIAL_NUMBER_REC_TYPE )
4266: IS
4267: l_list wf_parameter_list_t;
4268: l_param wf_parameter_t;
4269: l_key varchar2(240);
4270: l_yn varchar2(1);
4271: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialNumber.update';
4272: BEGIN

Line 4298: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4302: l_param.SetName('FINANCIAL_NUMBER_ID');

Line 4326: l_param wf_parameter_t;

4322: PROCEDURE create_certifications_event
4323: ( p_certifications_rec IN HZ_ORG_INFO_PUB.CERTIFICATIONS_REC_TYPE )
4324: IS
4325: l_list wf_parameter_list_t;
4326: l_param wf_parameter_t;
4327: l_key varchar2(240);
4328: l_yn varchar2(1);
4329: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Certification.create';
4330: BEGIN

Line 4356: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4360: l_param.SetName('CERTIFICATION_ID');

Line 4384: l_param wf_parameter_t;

4380: PROCEDURE update_certifications_event
4381: ( p_certifications_rec IN HZ_ORG_INFO_PUB.CERTIFICATIONS_REC_TYPE )
4382: IS
4383: l_list wf_parameter_list_t;
4384: l_param wf_parameter_t;
4385: l_key varchar2(240);
4386: l_yn varchar2(1);
4387: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Certification.update';
4388: BEGIN

Line 4414: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4418: l_param.SetName('CERTIFICATION_ID');

Line 4443: l_param wf_parameter_t;

4439: PROCEDURE create_person_interest_event
4440: (p_per_interest_rec IN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE)
4441: IS
4442: l_list wf_parameter_list_t;
4443: l_param wf_parameter_t;
4444: l_key varchar2(240);
4445: l_yn varchar2(1);
4446: l_event_name varchar2(240) := 'oracle.apps.ar.hz.PersonInterest.create';
4447: BEGIN

Line 4472: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4476: l_param.SetName('PERSON_INTEREST_ID');

Line 4503: l_param wf_parameter_t;

4499: p_old_per_interest_rec IN HZ_PERSON_INFO_V2PUB.PERSON_INTEREST_REC_TYPE
4500: )
4501: IS
4502: l_list wf_parameter_list_t;
4503: l_param wf_parameter_t;
4504: l_key varchar2(240);
4505: l_yn varchar2(1);
4506: l_event_name varchar2(240) := 'oracle.apps.ar.hz.PersonInterest.update';
4507: BEGIN

Line 4533: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4537: l_param.SetName('PERSON_INTEREST_ID');

Line 4562: l_param wf_parameter_t;

4558: PROCEDURE create_citizenship_event
4559: (p_citizenship_rec IN HZ_PERSON_INFO_V2PUB.CITIZENSHIP_REC_TYPE)
4560: IS
4561: l_list wf_parameter_list_t;
4562: l_param wf_parameter_t;
4563: l_key varchar2(240);
4564: l_yn varchar2(1);
4565: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Citizenship.create';
4566: BEGIN

Line 4591: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4595: l_param.SetName('CITIZENSHIP_ID');

Line 4623: l_param wf_parameter_t;

4619: p_old_citizenship_rec IN HZ_PERSON_INFO_V2PUB.CITIZENSHIP_REC_TYPE
4620: )
4621: IS
4622: l_list wf_parameter_list_t;
4623: l_param wf_parameter_t;
4624: l_key varchar2(240);
4625: l_yn varchar2(1);
4626: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Citizenship.update';
4627: BEGIN

Line 4653: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4657: l_param.SetName('CITIZENSHIP_ID');

Line 4683: l_param wf_parameter_t;

4679: PROCEDURE create_education_event
4680: (p_education_rec IN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE)
4681: IS
4682: l_list wf_parameter_list_t;
4683: l_param wf_parameter_t;
4684: l_key varchar2(240);
4685: l_yn varchar2(1);
4686: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Education.create';
4687: BEGIN

Line 4712: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4716: l_param.SetName('EDUCATION_ID');

Line 4744: l_param wf_parameter_t;

4740: p_old_education_rec IN HZ_PERSON_INFO_V2PUB.EDUCATION_REC_TYPE
4741: )
4742: IS
4743: l_list wf_parameter_list_t;
4744: l_param wf_parameter_t;
4745: l_key varchar2(240);
4746: l_yn varchar2(1);
4747: l_event_name varchar2(240) := 'oracle.apps.ar.hz.Education.update';
4748: BEGIN

Line 4774: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4778: l_param.SetName('EDUCATION_ID');

Line 4806: l_param wf_parameter_t;

4802: p_old_emp_history_rec IN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE
4803: )
4804: IS
4805: l_list wf_parameter_list_t;
4806: l_param wf_parameter_t;
4807: l_key varchar2(240);
4808: l_yn varchar2(1);
4809: l_event_name varchar2(240) := 'oracle.apps.ar.hz.EmploymentHistory.update';
4810: BEGIN

Line 4836: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4840: l_param.SetName('EMPLOYMENT_HISTORY_ID');

Line 4865: l_param wf_parameter_t;

4861: PROCEDURE create_emp_history_event
4862: (p_emp_history_rec IN HZ_PERSON_INFO_V2PUB.EMPLOYMENT_HISTORY_REC_TYPE)
4863: IS
4864: l_list wf_parameter_list_t;
4865: l_param wf_parameter_t;
4866: l_key varchar2(240);
4867: l_yn varchar2(1);
4868: l_event_name varchar2(240) := 'oracle.apps.ar.hz.EmploymentHistory.create';
4869: BEGIN

Line 4894: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4898: l_param.SetName('EMPLOYMENT_HISTORY_ID');

Line 4923: l_param wf_parameter_t;

4919: PROCEDURE create_work_class_event
4920: (p_work_class_rec IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE)
4921: IS
4922: l_list wf_parameter_list_t;
4923: l_param wf_parameter_t;
4924: l_key varchar2(240);
4925: l_yn varchar2(1);
4926: l_event_name varchar2(240) := 'oracle.apps.ar.hz.WorkClass.create';
4927: BEGIN

Line 4952: l_param := WF_PARAMETER_T( NULL, NULL );

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;
4956: l_param.SetName('WORK_CLASS_ID');

Line 4982: l_param wf_parameter_t;

4978: (p_work_class_rec IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE,
4979: p_old_work_class_rec IN HZ_PERSON_INFO_V2PUB.WORK_CLASS_REC_TYPE)
4980: IS
4981: l_list wf_parameter_list_t;
4982: l_param wf_parameter_t;
4983: l_key varchar2(240);
4984: l_yn varchar2(1);
4985: l_event_name varchar2(240) := 'oracle.apps.ar.hz.WorkClass.update';
4986: BEGIN

Line 5012: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5016: l_param.SetName('WORK_CLASS_ID');

Line 5044: l_param wf_parameter_t;

5040: PROCEDURE create_credit_ratings_event
5041: (p_credit_ratings_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE)
5042: IS
5043: l_list wf_parameter_list_t;
5044: l_param wf_parameter_t;
5045: l_key varchar2(240);
5046: l_yn varchar2(1);
5047: l_event_name varchar2(240) := 'oracle.apps.ar.hz.CreditRating.create';
5048: BEGIN

Line 5064: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5068: l_param.SetName('CREDIT_RATING_ID');

Line 5103: l_param wf_parameter_t;

5099: (p_credit_ratings_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE,
5100: p_old_credit_ratings_rec IN HZ_PARTY_INFO_V2PUB.CREDIT_RATING_REC_TYPE)
5101: IS
5102: l_list wf_parameter_list_t;
5103: l_param wf_parameter_t;
5104: l_key varchar2(240);
5105: l_yn varchar2(1);
5106: l_event_name varchar2(240) := 'oracle.apps.ar.hz.CreditRating.update';
5107: BEGIN

Line 5126: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5130: l_param.SetName('CREDIT_RATING_ID');

Line 5162: l_param wf_parameter_t;

5158: PROCEDURE create_fin_profile_event
5159: (p_financial_profile_rec IN HZ_PARTY_INFO_PUB.FINANCIAL_PROFILE_REC_TYPE)
5160: IS
5161: l_list wf_parameter_list_t;
5162: l_param wf_parameter_t;
5163: l_key varchar2(240);
5164: l_yn varchar2(1);
5165: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialProfile.create';
5166: BEGIN

Line 5185: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5189: l_param.SetName('FINANCIAL_PROFILE_ID');

Line 5220: l_param wf_parameter_t;

5216: PROCEDURE update_fin_profile_event
5217: (p_financial_profile_rec IN HZ_PARTY_INFO_PUB.FINANCIAL_PROFILE_REC_TYPE)
5218: IS
5219: l_list wf_parameter_list_t;
5220: l_param wf_parameter_t;
5221: l_key varchar2(240);
5222: l_yn varchar2(1);
5223: l_event_name varchar2(240) := 'oracle.apps.ar.hz.FinancialProfile.update';
5224: BEGIN

Line 5242: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5246: l_param.SetName('FINANCIAL_PROFILE_ID');

Line 5276: l_param wf_parameter_t;

5272: PROCEDURE create_orig_system_ref_event (
5273: p_orig_sys_reference_rec IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
5274: ) is
5275: l_list wf_parameter_list_t;
5276: l_param wf_parameter_t;
5277: l_key varchar2(240);
5278: l_yn varchar2(1);
5279: l_event_name varchar2(240) := 'oracle.apps.ar.hz.origSystemRef.create';
5280: BEGIN

Line 5299: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5303: l_param.SetName('ORIG_SYSTEM_REF_ID');

Line 5335: l_param wf_parameter_t;

5331: p_old_orig_sys_reference_re IN HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE
5332: )
5333: IS
5334: l_list wf_parameter_list_t;
5335: l_param wf_parameter_t;
5336: l_key varchar2(240);
5337: l_yn varchar2(1);
5338: l_event_name varchar2(240) := 'oracle.apps.ar.hz.origSystemRef.update';
5339: BEGIN

Line 5366: l_param := WF_PARAMETER_T( NULL, NULL );

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;
5370: l_param.SetName('ORIG_SYSTEM_REF_ID');