APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on MTL_PENDING_ITEM_STATUS

Line 482: --If there is a phase change, then insert a record into mtl_pending_item_status

478: ) THEN
479: --
480: -- user is changing lifecycle OR lifecycle phase
481: --
482: --If there is a phase change, then insert a record into mtl_pending_item_status
483: code_debug(l_api_name||': changing the lifecycle now ');
484: l_phase_rec := TRUE;
485: l_pending_flag := 'N';
486: l_implemented_date := l_sysdate;

Line 528: INSERT INTO mtl_pending_item_status(

524:
525: IF (l_status_rec OR l_phase_rec) THEN
526: code_debug(l_api_name||': creating a pending item status ');
527: l_phase_rec := FALSE;
528: INSERT INTO mtl_pending_item_status(
529: inventory_item_id,
530: organization_id,
531: effective_date,
532: implemented_date,

Line 1339: FROM mtl_pending_item_status mpis

1335: ,cp_org_id IN NUMBER
1336: ,cp_rev_id IN NUMBER
1337: ) IS
1338: SELECT organization_id
1339: FROM mtl_pending_item_status mpis
1340: WHERE inventory_item_id = cp_item_id
1341: AND EXISTS
1342: (SELECT P2.ORGANIZATION_ID
1343: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1602: INSERT INTO mtl_pending_item_status(

1598: END IF;
1599:
1600: l_user_id := FND_GLOBAL.User_Id;
1601: l_sysdate := SYSDATE;
1602: INSERT INTO mtl_pending_item_status(
1603: inventory_item_id,
1604: organization_id,
1605: status_code,
1606: revision_id,