APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_SR_CONTACTS_ACC

Line 93: TYPE l_contacts_id_tbl_type IS TABLE OF csm_sr_contacts_acc.sr_contact_point_id%TYPE INDEX BY BINARY_INTEGER;

89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
90: TYPE l_party_site_id_tbl_type IS TABLE OF csm_party_sites_acc.party_site_id%TYPE INDEX BY BINARY_INTEGER;
91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;
92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
93: TYPE l_contacts_id_tbl_type IS TABLE OF csm_sr_contacts_acc.sr_contact_point_id%TYPE INDEX BY BINARY_INTEGER;
94: TYPE l_cust_acct_id_tbl_type IS TABLE OF csm_hz_cust_accounts_acc.cust_account_id%TYPE INDEX BY BINARY_INTEGER;
95: TYPE l_counter_id_tbl_type IS TABLE OF csm_counters_acc.counter_id%TYPE INDEX BY BINARY_INTEGER;
96: TYPE l_counter_value_id_tbl_type IS TABLE OF csm_counter_values_acc.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
97: TYPE l_counter_prop_val_tbl_type IS TABLE OF csm_counter_prop_values_acc.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;

Line 675: --call the CSM_ACC_PKG to delete the record from csm_sr_contacts_acc table

671: IF l_contacts_id_tbl.COUNT > 0 THEN
672:
673: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
674:
675: --call the CSM_ACC_PKG to delete the record from csm_sr_contacts_acc table
676:
677: CSM_ACC_PKG.Delete_Acc
678: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
679: ,P_ACC_TABLE_NAME => g_acc_table_name4

Line 1593: --call the CSM_ACC_PKG to insert into csm_sr_contacts_acc table

1589: IF l_contacts_id_tbl.COUNT > 0 THEN
1590:
1591: FOR i IN l_contacts_id_tbl.FIRST..l_contacts_id_tbl.LAST LOOP
1592:
1593: --call the CSM_ACC_PKG to insert into csm_sr_contacts_acc table
1594:
1595: CSM_ACC_PKG.Insert_Acc
1596: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
1597: ,P_ACC_TABLE_NAME => g_acc_table_name4