DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_COUNTER_PROP_VALUES_ACC

Line 62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';

58: g_publication_item_name8 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
59: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
60:
61:
62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
64: g_pk1_name9 CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
65: g_publication_item_name9 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
66: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');

Line 63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';

59: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
60:
61:
62: g_acc_table_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
63: g_acc_sequence_name9 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
64: g_pk1_name9 CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
65: g_publication_item_name9 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
66: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');
67:

Line 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;

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;
100: TYPE l_direct_flag_tbl_type IS TABLE OF HZ_RELATIONSHIPS.DIRECTIONAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
101: TYPE ver_lab_Tab IS TABLE OF csi_i_version_labels.version_label%TYPE INDEX BY BINARY_INTEGER;

Line 301: FROM csm_counter_prop_values_acc ccpva

297: FROM csm_party_assignment cpa
298: WHERE cpa.deleted_flag ='N'
299: )
300: AND NOT EXISTS ( SELECT 1
301: FROM csm_counter_prop_values_acc ccpva
302: WHERE ccpva.user_id = ccva.user_id
303: AND ccpva.counter_prop_value_id = ccpr.counter_prop_value_id
304: );
305:

Line 507: , csm_counter_prop_values_acc ccpva

503: IS
504: SELECT ccpr.counter_prop_value_id
505: , ccpva.user_id
506: FROM csi_ctr_property_readings ccpr
507: , csm_counter_prop_values_acc ccpva
508: WHERE ccpva.counter_prop_value_id = ccpr.counter_prop_value_id
509: AND NOT EXISTS (SELECT 1
510: FROM csm_counter_values_acc ccva
511: WHERE ccpr.counter_value_id = ccva.counter_value_id

Line 968: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROP_VALUES_ACC table

964: IF l_counter_prop_val_tbl.COUNT > 0 THEN
965:
966: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
967:
968: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROP_VALUES_ACC table
969:
970: CSM_ACC_PKG.Delete_Acc
971: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
972: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 1518: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROP_VALUES_ACC table

1514: IF l_counter_prop_val_tbl.COUNT > 0 THEN
1515:
1516: FOR i IN l_counter_prop_val_tbl.FIRST..l_counter_prop_val_tbl.LAST LOOP
1517:
1518: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROP_VALUES_ACC table
1519:
1520: CSM_ACC_PKG.Insert_Acc
1521: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1522: ,P_ACC_TABLE_NAME => g_acc_table_name9