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_REP_YEP_PVT dependencies on STANDARD

Line 41: phh.type_lookup_code = 'STANDARD' AND

37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: pod.po_header_id = phh.po_header_id AND
40: phh.org_id = cch.org_id AND
41: phh.type_lookup_code = 'STANDARD' AND
42: phh.segment1 = cch.cc_num AND
43: cch.cc_header_id = p_cc_header_id;
44: BEGIN
45: l_count := 0;

Line 205: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

201: FROM IGC_CC_HEADERS B,
202: PO_HEADERS_ALL C
203: WHERE B.ORG_ID = C.ORG_ID AND
204: B.CC_NUM = C.SEGMENT1 AND
205: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
206: B.CC_HEADER_ID = P_CC_HEADER_ID);
207: CURSOR CC1(P_CC_HEADER_ID NUMBER) IS
208: SELECT 'Y'
209: FROM PO_HEADERS_ALL A

Line 216: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

212: FROM IGC_CC_HEADERS B,
213: PO_HEADERS_ALL C
214: WHERE B.ORG_ID = C.ORG_ID AND
215: B.CC_NUM = C.SEGMENT1 AND
216: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
217: B.CC_HEADER_ID = P_CC_HEADER_ID)
218: FOR UPDATE
219: NOWAIT;
220:

Line 337: / Preliminary Mode and Final Mode Validation For STANDARD CC/

333: LOOP
334: FETCH C3 INTO V3; /* Fetch Contracts based upon CC_HEADER_ID */
335: EXIT WHEN C3%NOTFOUND;
336:
337: /**** Preliminary Mode and Final Mode Validation For STANDARD CC****/
338:
339: IF p_PROCESS_TYPE IN ('Y','R','F') AND
340: (p_PROCESS_PHASE = 'P'OR p_PROCESS_PHASE = 'F') AND
341: V3.CC_TYPE = 'S'

Line 590: /* Over Billed Amount Validation for Standard CC in Cancelled State */

586: p_REQUEST_ID);
587: RETURN 'F';
588: END IF;
589:
590: /* Over Billed Amount Validation for Standard CC in Cancelled State */
591:
592: IF V3.CC_STATE = 'CL' AND V3.CC_APPRVL_STATUS <>'IP'
593: THEN
594: l_OVERBILLED_COUNTER := 0;

Line 682: OPEN C4(V3.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */

678:
679: IF V3.CC_STATE = 'CM' AND V3.CC_APPRVL_STATUS <> 'IP'
680: THEN
681: l_OVERBILLED_COUNTER := 0;
682: OPEN C4(V3.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */
683: /* Fetching Records based upon CC_HEADER_ID in CC_ACCT_LINES */
684: LOOP
685: FETCH C4 INTO V4;
686: EXIT WHEN C4%NOTFOUND;

Line 772: OPEN C4(V3.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */

768:
769: IF V3.CC_STATE = 'CT' AND V3.CC_APPRVL_STATUS <> 'IP'
770: THEN
771: l_OVERBILLED_COUNTER := 0;
772: OPEN C4(V3.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */
773: /* Fetching Records based upon CC_HEADER_ID in CC_ACCT_LINES */
774: LOOP
775: FETCH C4 INTO V4;
776: EXIT WHEN C4%NOTFOUND;

Line 1412: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */

1408:
1409: IF V9.CC_STATE = 'CL' AND V9.CC_APPRVL_STATUS <>'IP'
1410: THEN
1411: l_OVERBILLED_COUNTER := 0;
1412: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */
1413:
1414: /* Fetching Records based upon CC_HEADER_ID in CC_ACCT_LINES */
1415: LOOP
1416: FETCH C4 INTO V4;

Line 1538: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

1534: FROM IGC_CC_HEADERS B,
1535: PO_HEADERS_ALL C
1536: WHERE B.ORG_ID = C.ORG_ID AND
1537: B.CC_NUM = C.SEGMENT1 AND
1538: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1539: B.CC_HEADER_ID = V9.CC_HEADER_ID );
1540:
1541:
1542: UPDATE PO_HEADERS_ALL

Line 1549: AND a.TYPE_LOOKUP_CODE = 'STANDARD'

1545: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1546: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1547: WHERE a.SEGMENT1 = b.CC_NUM
1548: AND a.ORG_ID = b.ORG_ID
1549: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1550: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);
1551:
1552: EXCEPTION
1553: WHEN NO_DATA_FOUND

Line 1650: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */

1646:
1647: IF V9.CC_STATE = 'CM' AND V9.CC_APPRVL_STATUS <> 'IP'
1648: THEN
1649: l_OVERBILLED_COUNTER := 0;
1650: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */
1651: /* Fetching Records based upon CC_HEADER_ID in CC_ACCT_LINES */
1652: LOOP
1653: FETCH C4 INTO V4;
1654: EXIT WHEN C4%NOTFOUND;

Line 1772: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

1768: FROM IGC_CC_HEADERS B,
1769: PO_HEADERS_ALL C
1770: WHERE B.ORG_ID = C.ORG_ID AND
1771: B.CC_NUM = C.SEGMENT1 AND
1772: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
1773: B.CC_HEADER_ID = V9.CC_HEADER_ID );
1774:
1775:
1776: UPDATE PO_HEADERS_ALL

Line 1783: AND a.TYPE_LOOKUP_CODE = 'STANDARD'

1779: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
1780: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
1781: WHERE a.SEGMENT1 = b.CC_NUM
1782: AND a.ORG_ID = b.ORG_ID
1783: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
1784: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);
1785:
1786: EXCEPTION
1787: WHEN NO_DATA_FOUND

Line 1881: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */

1877:
1878: IF V9.CC_STATE = 'CT' AND V9.CC_APPRVL_STATUS <> 'IP'
1879: THEN
1880: l_OVERBILLED_COUNTER := 0;
1881: OPEN C4(V9.CC_HEADER_ID); /* Over Billed Amount Validation for Standard CC */
1882: /* Fetching Records based upon CC_HEADER_ID in CC_ACCT_LINES */
1883: LOOP
1884: FETCH C4 INTO V4;
1885: EXIT WHEN C4%NOTFOUND;

Line 1999: C.TYPE_LOOKUP_CODE = 'STANDARD' AND

1995: FROM IGC_CC_HEADERS B,
1996: PO_HEADERS_ALL C
1997: WHERE B.ORG_ID = C.ORG_ID AND
1998: B.CC_NUM = C.SEGMENT1 AND
1999: C.TYPE_LOOKUP_CODE = 'STANDARD' AND
2000: B.CC_HEADER_ID = V9.CC_HEADER_ID );
2001:
2002:
2003: UPDATE PO_HEADERS_ALL

Line 2010: AND a.TYPE_LOOKUP_CODE = 'STANDARD'

2006: (SELECT SEGMENT1,a.ORG_ID,TYPE_LOOKUP_CODE
2007: FROM PO_HEADERS_ALL a, IGC_CC_HEADERS b
2008: WHERE a.SEGMENT1 = b.CC_NUM
2009: AND a.ORG_ID = b.ORG_ID
2010: AND a.TYPE_LOOKUP_CODE = 'STANDARD'
2011: AND b.CC_HEADER_ID = V9.CC_HEADER_ID);
2012:
2013: EXCEPTION
2014: WHEN NO_DATA_FOUND

Line 2317: phh.type_lookup_code = 'STANDARD' AND

2313: igc_cc_headers cch
2314: WHERE
2315: pod.po_header_id = phh.po_header_id AND
2316: phh.org_id = cch.org_id AND
2317: phh.type_lookup_code = 'STANDARD' AND
2318: phh.segment1 = cch.cc_num AND
2319: cch.cc_header_id = p_cc_header_id;
2320:
2321: CURSOR c_invoices(p_po_distribution_id NUMBER)