eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_INV_LOC_ASS_EVENT_PKG dependencies on CSM_ACC_PKG

Line 20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_INV_LOC_ASS');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';
23:
24: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INVENTORIES';

Line 21: CSM_ACC_PKG.t_publication_item_list('CSM_INV_LOC_ASS');

17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENTS';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_INV_LOC_ASS_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_INV_LOC_ASS');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'CSP_INV_LOC_ASSIGNMENT_ID';
23:
24: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INVENTORIES';
25: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';

Line 28: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

24: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INVENTORIES';
25: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
26: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
27: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
28: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
29: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
30: g_pk1_name2 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
31: g_pk2_name2 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
32:

Line 29: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');

25: g_table_name2 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
26: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
27: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
28: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
29: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
30: g_pk1_name2 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
31: g_pk2_name2 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
32:
33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';

Line 37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

33: g_pub_item3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');
39: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
40: g_pk2_name3 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
41:

Line 38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');

34: g_table_name3 CONSTANT VARCHAR2(30) := 'MTL_ITEM_LOCATIONS';
35: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
36: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC_S';
37: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
38: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_LOCATIONS');
39: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
40: g_pk2_name3 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
41:
42: PROCEDURE INV_LOC_ASSIGNMENT_INS_INIT (p_csp_inv_loc_assignment_id IN NUMBER)

Line 124: CSM_ACC_PKG.Insert_Acc

120:
121: OPEN l_inv_loc_ass_csr(p_csp_inv_loc_assignment_id);
122: FETCH l_inv_loc_ass_csr INTO l_subinventory_code, l_organization_id;
123: IF l_inv_loc_ass_csr%FOUND THEN
124: CSM_ACC_PKG.Insert_Acc
125: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
126: ,P_ACC_TABLE_NAME => g_acc_table_name1
127: ,P_SEQ_NAME => g_acc_sequence_name1
128: ,P_PK1_NAME => g_pk1_name1

Line 134: CSM_ACC_PKG.Insert_Acc

130: ,P_USER_ID => p_user_id
131: );
132:
133: -- insert into csm_mtl_sec_inventories_acc
134: CSM_ACC_PKG.Insert_Acc
135: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
136: ,P_ACC_TABLE_NAME => g_acc_table_name2
137: ,P_SEQ_NAME => g_acc_sequence_name2
138: ,P_PK1_NAME => g_pk1_name2

Line 154: CSM_ACC_PKG.Insert_Acc

150: IF l_inv_location_csr%NOTFOUND THEN
151: EXIT;
152: END IF;
153: -- insert into csm_mtl_item_locations_acc
154: CSM_ACC_PKG.Insert_Acc
155: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
156: ,P_ACC_TABLE_NAME => g_acc_table_name3
157: ,P_SEQ_NAME => g_acc_sequence_name3
158: ,P_PK1_NAME => g_pk1_name3

Line 264: CSM_ACC_PKG.Delete_Acc

260: OPEN l_inv_loc_ass_csr(p_csp_inv_loc_assignment_id);
261: FETCH l_inv_loc_ass_csr INTO l_subinventory_code, l_organization_id;
262: IF l_inv_loc_ass_csr%FOUND THEN
263: -- delete from csm_inv_loc_ass_acc
264: CSM_ACC_PKG.Delete_Acc
265: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
266: ,P_ACC_TABLE_NAME => g_acc_table_name1
267: ,P_PK1_NAME => g_pk1_name1
268: ,P_PK1_NUM_VALUE => p_csp_inv_loc_assignment_id

Line 273: CSM_ACC_PKG.Delete_Acc

269: ,P_USER_ID => p_user_id
270: );
271:
272: -- delete from csm_mtl_sec_inventories_acc
273: CSM_ACC_PKG.Delete_Acc
274: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
275: ,P_ACC_TABLE_NAME => g_acc_table_name2
276: ,P_PK1_NAME => g_pk1_name2
277: ,P_PK1_CHAR_VALUE => l_subinventory_code

Line 294: CSM_ACC_PKG.Delete_Acc

290: EXIT;
291: END IF;
292:
293: -- delete from csm_mtl_item_locations_acc
294: CSM_ACC_PKG.Delete_Acc
295: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
296: ,P_ACC_TABLE_NAME => g_acc_table_name3
297: ,P_PK1_NAME => g_pk1_name3
298: ,P_PK1_NUM_VALUE => l_inv_location_id

Line 349: CSM_ACC_PKG.Update_Acc

345: OPEN l_invLocAsgn_csr(p_csp_inv_loc_assignment_id);
346: FETCH l_invLocAsgn_csr INTO l_invLocAsgn_rec;
347: IF l_invLocAsgn_csr%FOUND THEN
348: -- call the mark dirty for update
349: CSM_ACC_PKG.Update_Acc
350: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
351: ,P_ACC_TABLE_NAME => g_acc_table_name1
352: ,P_USER_ID => l_invLocAsgn_rec.user_id
353: ,P_ACCESS_ID => l_invLocAsgn_rec.access_id