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 HZ_CUST_ACCOUNTS

Line 42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';

38: g_pk1_name5 CONSTANT VARCHAR2(30) := 'PARTY_ID';
39: g_publication_item_name5 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
40: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');*/
41:
42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

Line 43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';

39: g_publication_item_name5 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
40: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTIES');*/
41:
42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
47:

Line 46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

42: g_acc_table_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
43: g_acc_sequence_name6 CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S';
44: g_pk1_name6 CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
45: g_publication_item_name6 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
46: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');
47:
48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
50: g_pk1_name7 CONSTANT VARCHAR2(30) := 'COUNTER_ID';

Line 94: TYPE l_cust_acct_id_tbl_type IS TABLE OF csm_hz_cust_accounts_acc.cust_account_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;
98: TYPE l_counter_prp_id_tbl_type IS TABLE OF csm_counter_properties_acc.counter_property_id%TYPE INDEX BY BINARY_INTEGER;

Line 361: FROM hz_cust_accounts hca

357: CURSOR l_customer_accounts_ins_csr
358: IS
359: SELECT hca.cust_account_id
360: , tcpa.user_id
361: FROM hz_cust_accounts hca
362: , csm_party_assignment tcpa
363: WHERE hca.party_id = tcpa.party_id
364: AND tcpa.deleted_flag = 'N'
365: AND tcpa.party_site_id IN (-1,-2)

Line 367: FROM csm_hz_cust_accounts_acc chca

363: WHERE hca.party_id = tcpa.party_id
364: AND tcpa.deleted_flag = 'N'
365: AND tcpa.party_site_id IN (-1,-2)
366: AND NOT EXISTS ( SELECT 1
367: FROM csm_hz_cust_accounts_acc chca
368: WHERE chca.cust_account_id = hca.cust_account_id
369: AND chca.user_id = tcpa.user_id
370: );
371:

Line 566: FROM hz_cust_accounts hca

562: CURSOR l_customer_accounts_del_csr
563: IS
564: SELECT hca.cust_account_id
565: , tcpa.user_id
566: FROM hz_cust_accounts hca
567: , csm_party_assignment tcpa
568: WHERE hca.party_id = tcpa.party_id
569: AND tcpa.deleted_flag = 'Y'
570: AND tcpa.party_site_id IN (-1,-2)

Line 572: FROM csm_hz_cust_accounts_acc chca

568: WHERE hca.party_id = tcpa.party_id
569: AND tcpa.deleted_flag = 'Y'
570: AND tcpa.party_site_id IN (-1,-2)
571: AND EXISTS ( SELECT 1
572: FROM csm_hz_cust_accounts_acc chca
573: WHERE chca.cust_account_id = hca.cust_account_id
574: AND chca.user_id = tcpa.user_id
575: );
576:

Line 610: --call the CSM_ACC_PKG to delete the record from csm_hz_cust_accounts_acc table

606: IF l_cust_acct_id_tbl.COUNT > 0 THEN
607:
608: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
609:
610: --call the CSM_ACC_PKG to delete the record from csm_hz_cust_accounts_acc table
611:
612: CSM_ACC_PKG.Delete_Acc
613: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
614: ,P_ACC_TABLE_NAME => g_acc_table_name6

Line 1681: --call the CSM_ACC_PKG to insert the record into csm_hz_cust_accounts_acc table

1677: IF l_cust_acct_id_tbl.COUNT > 0 THEN
1678:
1679: FOR i IN l_cust_acct_id_tbl.FIRST..l_cust_acct_id_tbl.LAST LOOP
1680:
1681: --call the CSM_ACC_PKG to insert the record into csm_hz_cust_accounts_acc table
1682:
1683: CSM_ACC_PKG.Insert_Acc
1684: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name6
1685: ,P_ACC_TABLE_NAME => g_acc_table_name6