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_COUNTERS_ACC

Line 48: g_acc_table_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';

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';
51: g_publication_item_name7 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
52: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');

Line 49: g_acc_sequence_name7 CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';

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';
51: g_publication_item_name7 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
52: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
53:

Line 95: TYPE l_counter_id_tbl_type IS TABLE OF csm_counters_acc.counter_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;
99: TYPE l_relationship_id_tbl_type IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE INDEX BY BINARY_INTEGER;

Line 258: FROM csm_counters_acc ccsa

254: FROM csm_party_assignment cpa
255: WHERE cpa.deleted_flag = 'N'
256: )
257: AND NOT EXISTS (SELECT 1
258: FROM csm_counters_acc ccsa
259: WHERE ccsa.user_id = ciia.user_id
260: AND ccsa.counter_id = ccb.counter_id
261: );
262:

Line 273: , csm_counters_acc cca

269: SELECT ccr.counter_value_id
270: , ccr.counter_id
271: , cca.user_id
272: FROM csi_counter_readings ccr
273: , csm_counters_acc cca
274: WHERE ccr.counter_id = cca.counter_id
275: AND cca.user_id IN ( SELECT cpa.user_id
276: FROM csm_party_assignment cpa
277: WHERE cpa.deleted_flag ='N'

Line 315: , csm_counters_acc cca

311: IS
312: SELECT ccpb.counter_property_id
313: , cca.user_id
314: FROM csi_counter_properties_b ccpb
315: , csm_counters_acc cca
316: WHERE ccpb.counter_id = cca.counter_id
317: AND cca.user_id IN ( SELECT cpa.user_id
318: FROM csm_party_assignment cpa
319: WHERE cpa.deleted_flag ='N'

Line 469: ,csm_counters_acc ccsa

465: SELECT ccb.counter_id
466: , ccsa.user_id
467: FROM csi_counters_b ccb
468: , csi_counter_associations cca
469: ,csm_counters_acc ccsa
470: WHERE ccb.counter_id = cca.counter_id
471: AND ccb.counter_type = 'REGULAR'
472: AND cca.source_object_code = 'CP'
473: AND ccsa.counter_id = ccb.counter_id

Line 493: FROM csm_counters_acc cca

489: FROM csi_counter_readings ccr
490: ,csm_counter_values_acc ccva
491: WHERE ccva.counter_value_id = ccr.counter_value_id
492: AND NOT EXISTS ( SELECT 1
493: FROM csm_counters_acc cca
494: WHERE cca.user_id = ccva.user_id
495: AND ccr.counter_id = cca.counter_id
496: );
497:

Line 526: FROM csm_counters_acc cca

522: FROM csi_counter_properties_b ccpb
523: , csm_counter_properties_acc ccpa
524: WHERE ccpa.counter_property_id = ccpb.counter_property_id
525: AND NOT EXISTS(SELECT 1
526: FROM csm_counters_acc cca
527: WHERE ccpb.counter_id = cca.counter_id
528: AND cca.user_id = ccpa.user_id
529: );
530:

Line 824: --call the CSM_ACC_PKG to delete from csm_counters_acc table

820: IF l_counter_id_tbl.COUNT > 0 THEN
821:
822: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
823:
824: --call the CSM_ACC_PKG to delete from csm_counters_acc table
825:
826: CSM_ACC_PKG.Delete_Acc
827: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
828: ,P_ACC_TABLE_NAME => g_acc_table_name7

Line 1369: --call the CSM_ACC_PKG to insert into csm_counters_acc table

1365: IF l_counter_id_tbl.COUNT > 0 THEN
1366:
1367: FOR i IN l_counter_id_tbl.FIRST..l_counter_id_tbl.LAST LOOP
1368:
1369: --call the CSM_ACC_PKG to insert into csm_counters_acc table
1370:
1371: CSM_ACC_PKG.Insert_Acc
1372: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name7
1373: ,P_ACC_TABLE_NAME => g_acc_table_name7