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.IGC_CC_YEP_PROCESS_PKG dependencies on PO_HEADERS_ALL

Line 1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;

1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;
1088: l_CONTRACT_COUNTER NUMBER := 0;
1089: l_CC_CTRL_STATUS IGC_CC_HEADERS.CC_CTRL_STATUS%TYPE;
1090: l_APPROVED_FLAG PO_HEADERS_ALL.APPROVED_FLAG%TYPE;
1091: l_HEADER_ID IGC_CC_HEADERS.CC_HEADER_ID%TYPE;
1092: RELEASE_YEAR_END_COUNTER NUMBER;
1093: l_api_version CONSTANT NUMBER := 1.0;
1094: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

Line 2173: FROM PO_HEADERS_ALL A

2169:
2170: BEGIN
2171: SELECT 'Y'
2172: INTO l_DUMMY
2173: FROM PO_HEADERS_ALL A
2174: WHERE
2175: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2176: FROM IGC_CC_HEADERS B,
2177: PO_HEADERS_ALL C

Line 2177: PO_HEADERS_ALL C

2173: FROM PO_HEADERS_ALL A
2174: WHERE
2175: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2176: FROM IGC_CC_HEADERS B,
2177: PO_HEADERS_ALL C
2178: WHERE B.ORG_ID = C.ORG_ID AND
2179: B.CC_NUM = C.SEGMENT1 AND
2180: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2181: B.CC_HEADER_ID = V2.CC_HEADER_ID );

Line 2183: UPDATE PO_HEADERS_ALL

2179: B.CC_NUM = C.SEGMENT1 AND
2180: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2181: B.CC_HEADER_ID = V2.CC_HEADER_ID );
2182:
2183: UPDATE PO_HEADERS_ALL
2184: SET APPROVED_FLAG = 'N'
2185: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2186: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2187: WHERE a.SEGMENT1 = b.CC_NUM

Line 2186: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2182:
2183: UPDATE PO_HEADERS_ALL
2184: SET APPROVED_FLAG = 'N'
2185: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2186: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2187: WHERE a.SEGMENT1 = b.CC_NUM
2188: AND a.ORG_ID = b.ORG_ID
2189: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2190: AND b.CC_HEADER_ID = V2.CC_HEADER_ID);

Line 2368: FROM PO_HEADERS_ALL A

2364:
2365: BEGIN
2366: SELECT 'Y'
2367: INTO l_DUMMY
2368: FROM PO_HEADERS_ALL A
2369: WHERE
2370: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2371: FROM IGC_CC_HEADERS B,
2372: PO_HEADERS_ALL C

Line 2372: PO_HEADERS_ALL C

2368: FROM PO_HEADERS_ALL A
2369: WHERE
2370: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2371: FROM IGC_CC_HEADERS B,
2372: PO_HEADERS_ALL C
2373: WHERE B.ORG_ID = C.ORG_ID AND
2374: B.CC_NUM = C.SEGMENT1 AND
2375: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2376: B.CC_HEADER_ID = V2.CC_HEADER_ID );

Line 2544: FROM PO_HEADERS_ALL A

2540:
2541: BEGIN
2542: SELECT 'Y'
2543: INTO l_DUMMY
2544: FROM PO_HEADERS_ALL A
2545: WHERE
2546: A.PO_HEADER_ID =
2547: (SELECT C.PO_HEADER_ID
2548: FROM IGC_CC_HEADERS B,

Line 2549: PO_HEADERS_ALL C

2545: WHERE
2546: A.PO_HEADER_ID =
2547: (SELECT C.PO_HEADER_ID
2548: FROM IGC_CC_HEADERS B,
2549: PO_HEADERS_ALL C
2550: WHERE B.ORG_ID = C.ORG_ID AND
2551: B.CC_NUM = C.SEGMENT1 AND
2552: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2553: B.CC_HEADER_ID = V11.CC_HEADER_ID );

Line 2728: /* Reset the Values in IGC_CC_HEADERS AND PO_HEADERS_ALL When all Contracts are processed */

2724: l_REQUEST_ID1);
2725: END IF;
2726: */ -- 1866713 , End
2727:
2728: /* Reset the Values in IGC_CC_HEADERS AND PO_HEADERS_ALL When all Contracts are processed */
2729: l_PROCESSED_COUNTER := 0;
2730:
2731: SELECT COUNT(*)
2732: INTO l_PROCESSED_COUNTER

Line 2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */

2753: UPDATE IGC_CC_HEADERS
2754: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2755: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;
2756:
2757: /* Fetching value for PO_HEADERS_ALL => APPROVED_FLAG from IGC_CC_HEADERS => CC_CTRL_STATUS */
2758:
2759: SELECT CC_CTRL_STATUS
2760: INTO l_CC_CTRL_STATUS
2761: FROM IGC_CC_HEADERS

Line 2771: /* Restoring Original Values to PO_HEADERS_ALL */

2767: ELSE
2768: l_APPROVED_FLAG := 'N';
2769: END IF;
2770:
2771: /* Restoring Original Values to PO_HEADERS_ALL */
2772:
2773: SELECT CC_TYPE,CC_STATE,CC_APPRVL_STATUS
2774: INTO l_TYPE,l_STATE,l_PREVIOUS_APPRVL_STATUS
2775: FROM IGC_CC_HEADERS

Line 2784: FROM PO_HEADERS_ALL A

2780:
2781: BEGIN
2782: SELECT 'Y'
2783: INTO l_DUMMY
2784: FROM PO_HEADERS_ALL A
2785: WHERE
2786: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2787: FROM IGC_CC_HEADERS B,
2788: PO_HEADERS_ALL C

Line 2788: PO_HEADERS_ALL C

2784: FROM PO_HEADERS_ALL A
2785: WHERE
2786: A.PO_HEADER_ID = (SELECT C.PO_HEADER_ID
2787: FROM IGC_CC_HEADERS B,
2788: PO_HEADERS_ALL C
2789: WHERE B.ORG_ID = C.ORG_ID AND
2790: B.CC_NUM = C.SEGMENT1 AND
2791: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2792: B.CC_HEADER_ID = V2.CC_HEADER_ID );

Line 2794: UPDATE PO_HEADERS_ALL

2790: B.CC_NUM = C.SEGMENT1 AND
2791: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2792: B.CC_HEADER_ID = V2.CC_HEADER_ID );
2793:
2794: UPDATE PO_HEADERS_ALL
2795: SET APPROVED_FLAG = l_APPROVED_FLAG
2796: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2797: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2798: WHERE a.SEGMENT1 = b.CC_NUM

Line 2797: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b

2793:
2794: UPDATE PO_HEADERS_ALL
2795: SET APPROVED_FLAG = l_APPROVED_FLAG
2796: WHERE (SEGMENT1,ORG_ID,TYPE_LOOKUP_CODE) IN ( SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2797: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2798: WHERE a.SEGMENT1 = b.CC_NUM
2799: AND a.ORG_ID = b.ORG_ID
2800: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2801: AND b.CC_HEADER_ID = V2.CC_HEADER_ID);