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.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_HZ_LOCATIONS_ACC

Line 18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';

14: g_pk2_name1 CONSTANT VARCHAR2(30) := 'PARTY_ID';
15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');

Line 19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';

15: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
17:
18: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
19: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:

Line 91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;

87:
88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_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;

Line 172: FROM csm_hz_locations_acc chla

168: WHERE cpsa.party_site_id = hps.party_site_id
169: AND cpsa.user_id = tcpa.user_id
170: )
171: AND NOT EXISTS ( SELECT 1
172: FROM csm_hz_locations_acc chla
173: WHERE chla.location_id = hps.location_id
174: AND chla.user_id = tcpa.user_id
175: );
176:

Line 411: FROM csm_hz_locations_acc chla

407: WHERE cpsa.party_site_id = hps.party_site_id
408: AND cpsa.user_id = tcpa.user_id
409: )
410: AND EXISTS ( SELECT 1
411: FROM csm_hz_locations_acc chla
412: WHERE chla.location_id = hps.location_id
413: AND chla.user_id = tcpa.user_id
414: );
415:

Line 1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table

1052: COMMIT;
1053:
1054: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1055:
1056: --call the CSM_ACC_PKG to delete the record from csm_hz_locations_acc table
1057:
1058: CSM_ACC_PKG.Delete_Acc
1059: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1060: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table

1236: COMMIT;
1237:
1238: FOR i IN l_location_id_tbl.FIRST..l_location_id_tbl.LAST LOOP
1239:
1240: --call the CSM_ACC_PKG to insert into csm_hz_locations_acc table
1241:
1242: CSM_ACC_PKG.Insert_Acc
1243: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
1244: ,P_ACC_TABLE_NAME => g_acc_table_name2