APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_SYSTEM_ITEMS_ACC_S

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

199: l_sqlerrmsg varchar2(2000);
200:
201: CURSOR l_systemitems_ins_csr(p_new_organization_id IN number, p_user_id IN number)
202: IS
203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,

Line 364: SELECT CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

360:
361: -- insert
362: CURSOR l_systemitems_ins_csr
363: IS
364: SELECT CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
365: au.user_id,
366: msi.inventory_item_id,
367: msi.organization_id
368: FROM asg_user au,

Line 623: VALUES (CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL, l_user_id(i),

619: -- checking if the record exists before inserting into the _acc table
620: FORALL j in l_inv_id.FIRST..l_inv_id.LAST
621: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,
622: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
623: VALUES (CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL, l_user_id(i),
624: l_inv_id(j), l_org_id(j), 1, 1, l_current_run_date, 1,
625: l_current_run_date, 1)
626: RETURNING access_id, user_id BULK COLLECT INTO l_acc_id, l_curr_user_id;
627:

Line 1131: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

1127:
1128: -- Insert cursor
1129: CURSOR l_systemitems_ins_csr(p_organization_id IN NUMBER, p_user_id IN NUMBER)
1130: IS
1131: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
1132: au.user_id,
1133: msi.inventory_item_id,
1134: msi.organization_id
1135: FROM asg_user au,

Line 1234: VALUES (CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL, p_user_id , l_inv_id(i), l_organization_id, 1, 1, l_current_run_date,1,l_current_run_date,1);

1230: FORALL i IN l_inv_id.FIRST..l_inv_id.LAST
1231:
1232: INSERT INTO CSM_SYSTEM_ITEMS_ACC (ACCESS_ID, USER_ID, INVENTORY_ITEM_ID,ORGANIZATION_ID,
1233: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1234: VALUES (CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL, p_user_id , l_inv_id(i), l_organization_id, 1, 1, l_current_run_date,1,l_current_run_date,1);
1235: -- RETURNING access_id, user_id BULK COLLECT INTO l_acc_id_lst, l_user_id_lst;
1236:
1237: -- -- do bulk makedirty
1238: -- l_dummy := asg_download.mark_dirty(