APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 448: select 1 INTO l_src_id from csm_mtl_system_items_acc acc

444: IF p_DML_t<>'D' AND l_found THEN
445: FOR I IN 1..l_tab_item_id.COUNT --delete will be handled by mtl sys item refresh conc prog
446: LOOP
447: BEGIN
448: select 1 INTO l_src_id from csm_mtl_system_items_acc acc
449: where acc.inventory_item_id=l_tab_item_id(I)
450: and acc.organization_id=l_tab_org_id(I)
451: and acc.user_id=l_tab_user_id(I);
452: l_found:=true;

Line 459: select csm_mtl_system_items_acc_s.NEXTVAL INTO l_access_id from dual;

455: l_found:=false;
456: END;
457:
458: If NOT l_found THEN
459: select csm_mtl_system_items_acc_s.NEXTVAL INTO l_access_id from dual;
460:
461: INSERT INTO csm_mtl_system_items_acc(access_id , user_id, inventory_item_id, organization_id, counter,
462: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
463: VALUES (l_access_id, l_tab_user_id(I),l_tab_item_id(I), l_tab_org_id(I), 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);

Line 461: INSERT INTO csm_mtl_system_items_acc(access_id , user_id, inventory_item_id, organization_id, counter,

457:
458: If NOT l_found THEN
459: select csm_mtl_system_items_acc_s.NEXTVAL INTO l_access_id from dual;
460:
461: INSERT INTO csm_mtl_system_items_acc(access_id , user_id, inventory_item_id, organization_id, counter,
462: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
463: VALUES (l_access_id, l_tab_user_id(I),l_tab_item_id(I), l_tab_org_id(I), 1,fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
464:
465: doMarkDirty('CSM_MTL_SYSTEM_ITEMS',l_access_id,l_tab_user_id(I),'I');