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 123: CSM_ACC_PKG.Insert_Acc

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

Line 133: CSM_ACC_PKG.Insert_Acc

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

Line 153: CSM_ACC_PKG.Insert_Acc

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

Line 262: CSM_ACC_PKG.Delete_Acc

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

Line 271: CSM_ACC_PKG.Delete_Acc

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

Line 292: CSM_ACC_PKG.Delete_Acc

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

Line 344: CSM_ACC_PKG.Update_Acc

340: OPEN l_invLocAsgn_csr(p_csp_inv_loc_assignment_id);
341: FETCH l_invLocAsgn_csr INTO l_invLocAsgn_rec;
342: IF l_invLocAsgn_csr%FOUND THEN
343: -- call the mark dirty for update
344: CSM_ACC_PKG.Update_Acc
345: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
346: ,P_ACC_TABLE_NAME => g_acc_table_name1
347: ,P_USER_ID => l_invLocAsgn_rec.user_id
348: ,P_ACCESS_ID => l_invLocAsgn_rec.access_id