DBA Data[Home] [Help]

APPS.CSM_CUSTOM_PKG dependencies on CSM_ACC_PKG

Line 17: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

13:
14: g_object_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOM_PKG'; -- package name
15: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
16: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
17: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
19:
20: PROCEDURE counter_values_del(p_counter_value_id IN number, x_return_status OUT NOCOPY varchar2)
21: IS

Line 18: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');

14: g_object_name CONSTANT VARCHAR2(30) := 'CSM_CUSTOM_PKG'; -- package name
15: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
16: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
17: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
19:
20: PROCEDURE counter_values_del(p_counter_value_id IN number, x_return_status OUT NOCOPY varchar2)
21: IS
22: l_err_msg varchar2(4000);

Line 32: CSM_ACC_PKG.Delete_Acc

28: WHERE counter_value_id = p_counter_value_id;
29:
30: BEGIN
31: FOR r_counter_values_csr IN l_counter_values_csr(p_counter_value_id) LOOP
32: CSM_ACC_PKG.Delete_Acc
33: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
34: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
35: ,P_PK1_NAME => g_counter_val_pk1_name
36: ,P_PK1_NUM_VALUE => r_counter_values_csr.counter_value_id