DBA Data[Home] [Help]

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_COUNTER_PROPERTIES_ACC

Line 68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';

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:
68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');

Line 69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';

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:
68: g_acc_table_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC';
69: g_acc_sequence_name10 CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROPERTIES_ACC_S';
70: g_pk1_name10 CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
71: g_publication_item_name10 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
72: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROPERTIES');
73:

Line 98: TYPE l_counter_prp_id_tbl_type IS TABLE OF csm_counter_properties_acc.counter_property_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;
102:

Line 322: FROM csm_counter_properties_acc ccpa

318: FROM csm_party_assignment cpa
319: WHERE cpa.deleted_flag ='N'
320: )
321: AND NOT EXISTS ( SELECT 1
322: FROM csm_counter_properties_acc ccpa
323: WHERE ccpa.user_id = cca.user_id
324: AND ccpa.counter_property_id = ccpb.counter_property_id
325: );
326: /*

Line 523: , csm_counter_properties_acc ccpa

519: IS
520: SELECT ccpb.counter_property_id
521: , ccpa.user_id
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

Line 922: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROPERTIES_ACC table

918: IF l_counter_prp_id_tbl.COUNT > 0 THEN
919:
920: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
921:
922: --call the CSM_ACC_PKG to delete from CSM_COUNTER_PROPERTIES_ACC table
923:
924: CSM_ACC_PKG.Delete_Acc
925: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
926: ,P_ACC_TABLE_NAME => g_acc_table_name9

Line 1471: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROPERTIES_ACC table

1467: IF l_counter_prp_id_tbl.COUNT > 0 THEN
1468:
1469: FOR i IN l_counter_prp_id_tbl.FIRST..l_counter_prp_id_tbl.LAST LOOP
1470:
1471: --call the CSM_ACC_PKG to insert into CSM_COUNTER_PROPERTIES_ACC table
1472:
1473: CSM_ACC_PKG.Insert_Acc
1474: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name9
1475: ,P_ACC_TABLE_NAME => g_acc_table_name9