APPS.EGO_LIFECYCLE_USER_PUB dependencies on EGO_LCPHASE_ITEM_STATUS

Line 757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;

753: IS
754:
755: l_api_version NUMBER;
756: l_api_name VARCHAR2(30);
757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;

Line 758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;

754:
755: l_api_version NUMBER;
756: l_api_name VARCHAR2(30);
757: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
758: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
759: -- l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
760: l_revision MTL_ITEM_REVISIONS_B.REVISION%TYPE;
761: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
762:

Line 851: FROM EGO_LCPHASE_ITEM_STATUS status

847:
848: BEGIN
849: SELECT status.ITEM_STATUS_CODE
850: INTO l_status_code
851: FROM EGO_LCPHASE_ITEM_STATUS status
852: ,PA_EGO_PHASES_V phases
853: WHERE phases.PROJ_ELEMENT_ID = p_phase_id
854: AND status.PHASE_CODE = phases.PHASE_CODE
855: AND status.ITEM_STATUS_CODE = l_status_code;

Line 1005: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;

1001: IS
1002:
1003: l_api_version NUMBER;
1004: l_api_name VARCHAR2(30);
1005: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
1006: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
1007: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1008: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
1009:

Line 1006: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;

1002:
1003: l_api_version NUMBER;
1004: l_api_name VARCHAR2(30);
1005: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
1006: l_phase_code EGO_LCPHASE_ITEM_STATUS.PHASE_CODE%TYPE;
1007: l_revision_id MTL_ITEM_REVISIONS_B.REVISION_ID%TYPE;
1008: l_current_phase_id MTL_ITEM_REVISIONS_B.CURRENT_PHASE_ID%TYPE;
1009:
1010: l_revision_master_controlled VARCHAR2(1);

Line 1143: EGO_LCPHASE_ITEM_STATUS

1139: IF p_revision IS NULL
1140: THEN
1141: SELECT ITEM_STATUS_CODE INTO l_status_code
1142: FROM
1143: EGO_LCPHASE_ITEM_STATUS
1144: WHERE
1145: PHASE_CODE = l_phase_code
1146: AND DEFAULT_FLAG = 'Y';
1147: END IF;