DBA Data[Home] [Help]

APPS.CSM_HZ_LOCATIONS_EVENT_PKG dependencies on CSM_ACC_PKG

Line 10: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

6: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC';
7: g_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'LOCATION_ID';
10: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
11: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
12:
13:
14:

Line 11: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');

7: g_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_LOCATIONS_ACC_S';
8: g_table_name CONSTANT VARCHAR2(30) := 'HZ_LOCATIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'LOCATION_ID';
10: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
11: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
12:
13:
14:
15: PROCEDURE INSERT_LOCATION( p_location_id IN NUMBER, p_user_id IN NUMBER)

Line 40: CSM_ACC_PKG.Insert_Acc

36: , 'Inserting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id
37: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
38: END IF;
39:
40: CSM_ACC_PKG.Insert_Acc
41: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name,
42: P_ACC_TABLE_NAME => g_acc_table_name,
43: P_SEQ_NAME => g_seq_name,
44: P_USER_ID => p_user_id,

Line 83: CSM_ACC_PKG.Delete_Acc

79: , 'Deleting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id
80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
81: END IF;
82:
83: CSM_ACC_PKG.Delete_Acc
84: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
85: ,P_ACC_TABLE_NAME => g_acc_table_name
86: ,P_PK1_NAME => g_pk1_name
87: ,P_PK1_NUM_VALUE => p_location_id