APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on CSM_ACC_PKG

Line 18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';
22:

Line 19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');

15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';
22:
23: g_pub_item CONSTANT varchar(30) := 'CSM_PO_LOC_ASS_ALL';

Line 38: CSM_ACC_PKG.Insert_Acc

34: BEGIN
35: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_I for location_id: ' || p_location_id,
36: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
37:
38: CSM_ACC_PKG.Insert_Acc
39: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
40: ,P_ACC_TABLE_NAME => g_acc_table_name1
41: ,P_SEQ_NAME => g_acc_sequence_name1
42: ,P_PK1_NAME => g_pk1_name1

Line 75: l_access_id := CSM_ACC_PKG.Get_Acc_Id

71: BEGIN
72: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
73: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
74:
75: l_access_id := CSM_ACC_PKG.Get_Acc_Id
76: ( P_ACC_TABLE_NAME => g_acc_table_name1
77: ,P_PK1_NAME => g_pk1_name1
78: ,P_PK1_NUM_VALUE => p_location_id
79: ,P_PK2_NAME => g_pk2_name1

Line 84: CSM_ACC_PKG.Update_Acc

80: ,P_PK2_NUM_VALUE => p_site_use_id
81: ,P_USER_ID => p_user_id
82: );
83:
84: CSM_ACC_PKG.Update_Acc
85: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
86: ,P_ACC_TABLE_NAME => g_acc_table_name1
87: ,P_ACCESS_ID => l_access_id
88: ,P_USER_ID => p_user_id

Line 172: CSM_ACC_PKG.Delete_Acc

168: csm_util_pkg.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.SPAWN_CUST_ACCT_SITE_DEL', FND_LOG.LEVEL_ERROR);
169: END IF;
170:
171: -- process delete of csm_po_loc_ass_all
172: CSM_ACC_PKG.Delete_Acc
173: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
174: ,P_ACC_TABLE_NAME => g_acc_table_name1
175: ,P_PK1_NAME => g_pk1_name1
176: ,P_PK1_NUM_VALUE => r_cust_acc_site_upd_rec.location_id