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) := 'ORG_ID';
22: g_pk3_name1 CONSTANT VARCHAR2(30) := 'RESOURCE_TYPE';

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) := 'ORG_ID';
22: g_pk3_name1 CONSTANT VARCHAR2(30) := 'RESOURCE_TYPE';
23:

Line 40: CSM_ACC_PKG.Insert_Acc

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

Line 80: l_access_id := CSM_ACC_PKG.Get_Acc_Id

76: BEGIN
77: CSM_UTIL_PKG.LOG('Entering CSP_SHIP_TO_ADDR_MDIRTY_U for location_id: ' || p_location_id,
78: 'CSM_PO_LOCATIONS_EVENT_PKG.CSP_SHIP_TO_ADDR_MDIRTY_U',FND_LOG.LEVEL_PROCEDURE);
79:
80: l_access_id := CSM_ACC_PKG.Get_Acc_Id
81: ( P_ACC_TABLE_NAME => g_acc_table_name1
82: ,P_PK1_NAME => g_pk1_name1
83: ,P_PK1_NUM_VALUE => p_location_id
84: ,P_PK2_NUM_VALUE => p_org_id

Line 90: CSM_ACC_PKG.Update_Acc

86: ,P_PK3_CHAR_VALUE => p_res_type
87: ,P_USER_ID => p_user_id
88: );
89:
90: CSM_ACC_PKG.Update_Acc
91: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
92: ,P_ACC_TABLE_NAME => g_acc_table_name1
93: ,P_ACCESS_ID => l_access_id
94: ,P_USER_ID => p_user_id

Line 178: CSM_ACC_PKG.Delete_Acc

174: csm_util_pkg.LOG(l_error_msg, 'CSM_PO_LOCATIONS_EVENT_PKG.SPAWN_CUST_ACCT_SITE_DEL', FND_LOG.LEVEL_ERROR);
175: END IF;
176:
177: -- process delete of csm_po_loc_ass_all
178: CSM_ACC_PKG.Delete_Acc
179: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
180: ,P_ACC_TABLE_NAME => g_acc_table_name1
181: ,P_PK1_NAME => g_pk1_name1
182: ,P_PK1_NUM_VALUE => r_cust_acc_site_upd_rec.location_id

Line 321: CSM_ACC_PKG.Delete_Acc

317: p_error_msg=>l_error_msg,
318: x_return_status=>l_return_status);
319:
320:
321: CSM_ACC_PKG.Delete_Acc
322: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
323: ,P_ACC_TABLE_NAME => g_acc_table_name1
324: ,P_PK1_NAME => g_pk1_name1
325: ,P_PK1_NUM_VALUE => r_cust_acc_site_upd_rec.location_id