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 STANDARD

Line 2180: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

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 );
2182:
2183: UPDATE PO_HEADERS_ALL
2184: SET APPROVED_FLAG = 'N'

Line 2189: AND a.TYPE_LOOKUP_CODE = 'STANDARD'

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);
2191:
2192: EXCEPTION
2193: WHEN NO_DATA_FOUND

Line 2322: IF l_CC_TYPE = 'S' /* Year End processing for Standard Contracts */

2318:
2319: /* Perform Year End Processing on Contract Commitment */
2320:
2321:
2322: IF l_CC_TYPE = 'S' /* Year End processing for Standard Contracts */
2323:
2324: THEN
2325: l_RESULT_OF_YEAR_END_UPDATE := YEAR_END_UPDATE(V2.CC_HEADER_ID,
2326: p_YEAR,

Line 2375: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

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 );
2377:
2378: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2379: ( 1.0,

Line 2552: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

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 );
2554:
2555: IGC_CC_PO_INTERFACE_PKG.convert_cc_to_po
2556: ( 1.0,

Line 2791: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

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 );
2793:
2794: UPDATE PO_HEADERS_ALL
2795: SET APPROVED_FLAG = l_APPROVED_FLAG

Line 2800: AND a.TYPE_LOOKUP_CODE = 'STANDARD'

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);
2802: EXCEPTION
2803: WHEN NO_DATA_FOUND
2804: THEN