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 IGC_CC_PROCESS_DATA

Line 1289: UPDATE IGC_CC_PROCESS_DATA A

1285: p_REQUEST_ID);
1286:
1287: IF p_PROCESS_TYPE = 'Y'
1288: THEN
1289: UPDATE IGC_CC_PROCESS_DATA A
1290: SET VALIDATION_STATUS = 'F'
1291: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1292: AND A.REQUEST_ID = p_REQUEST_ID
1293: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1308: UPDATE IGC_CC_PROCESS_DATA A

1304: IF p_PROCESS_PHASE = 'F'
1305: THEN
1306: IF p_PROCESS_TYPE = 'Y'
1307: THEN
1308: UPDATE IGC_CC_PROCESS_DATA A
1309: SET VALIDATION_STATUS = 'P'
1310: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1311: AND A.REQUEST_ID = p_REQUEST_ID
1312: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1327: UPDATE IGC_CC_PROCESS_DATA A

1323: IF p_PROCESS_PHASE = 'P'
1324: THEN
1325: IF p_PROCESS_TYPE = 'Y'
1326: THEN
1327: UPDATE IGC_CC_PROCESS_DATA A
1328: SET VALIDATION_STATUS = 'P'
1329: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1330: AND A.REQUEST_ID = p_REQUEST_ID
1331: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1396: UPDATE IGC_CC_PROCESS_DATA A

1392:
1393:
1394: IF p_PROCESS_TYPE = 'Y'
1395: THEN
1396: UPDATE IGC_CC_PROCESS_DATA A
1397: SET VALIDATION_STATUS = 'F'
1398: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1399: AND A.REQUEST_ID = p_REQUEST_ID
1400: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1493: UPDATE IGC_CC_PROCESS_DATA A

1489: IF l_OVERBILLED_COUNTER > 0
1490: THEN
1491: IF p_PROCESS_TYPE = 'Y'
1492: THEN
1493: UPDATE IGC_CC_PROCESS_DATA A
1494: SET VALIDATION_STATUS = 'F'
1495: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1496: AND A.REQUEST_ID = p_REQUEST_ID
1497: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1506: UPDATE IGC_CC_PROCESS_DATA A

1502:
1503: IF p_PROCESS_PHASE = 'F' AND p_PROCESS_TYPE = 'Y'
1504: THEN
1505:
1506: UPDATE IGC_CC_PROCESS_DATA A
1507: SET VALIDATION_STATUS = 'P'
1508: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1509: AND A.REQUEST_ID = p_REQUEST_ID
1510: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1565: UPDATE IGC_CC_PROCESS_DATA A

1561: IF p_PROCESS_PHASE = 'P'
1562: THEN
1563: IF p_PROCESS_TYPE = 'Y'
1564: THEN
1565: UPDATE IGC_CC_PROCESS_DATA A
1566: SET VALIDATION_STATUS = 'P'
1567: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1568: AND A.REQUEST_ID = p_REQUEST_ID
1569: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1634: UPDATE IGC_CC_PROCESS_DATA A

1630: p_REQUEST_ID);
1631:
1632: IF p_PROCESS_TYPE = 'Y'
1633: THEN
1634: UPDATE IGC_CC_PROCESS_DATA A
1635: SET VALIDATION_STATUS = 'F'
1636: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1637: AND A.REQUEST_ID = p_REQUEST_ID
1638: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1729: UPDATE IGC_CC_PROCESS_DATA A

1725: IF l_OVERBILLED_COUNTER > 0
1726: THEN
1727: IF p_PROCESS_TYPE = 'Y'
1728: THEN
1729: UPDATE IGC_CC_PROCESS_DATA A
1730: SET VALIDATION_STATUS = 'F'
1731: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1732: AND A.REQUEST_ID = p_REQUEST_ID
1733: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1741: UPDATE IGC_CC_PROCESS_DATA A

1737: ELSE
1738: IF p_PROCESS_PHASE = 'F' AND p_PROCESS_TYPE = 'Y'
1739: THEN
1740:
1741: UPDATE IGC_CC_PROCESS_DATA A
1742: SET VALIDATION_STATUS = 'P'
1743: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1744: AND A.REQUEST_ID = p_REQUEST_ID
1745: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1797: UPDATE IGC_CC_PROCESS_DATA A

1793: END IF;
1794:
1795: IF p_PROCESS_PHASE = 'P' AND p_PROCESS_TYPE = 'Y'
1796: THEN
1797: UPDATE IGC_CC_PROCESS_DATA A
1798: SET VALIDATION_STATUS = 'P'
1799: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1800: AND A.REQUEST_ID = p_REQUEST_ID
1801: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1865: UPDATE IGC_CC_PROCESS_DATA A

1861: V3.SET_OF_BOOKS_ID,
1862: p_REQUEST_ID);
1863: IF (p_PROCESS_TYPE = 'Y')
1864: THEN
1865: UPDATE IGC_CC_PROCESS_DATA A
1866: SET VALIDATION_STATUS = 'F'
1867: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1868: AND A.REQUEST_ID = p_REQUEST_ID
1869: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1957: UPDATE IGC_CC_PROCESS_DATA A

1953: CLOSE C4;
1954:
1955: IF l_OVERBILLED_COUNTER > 0
1956: THEN
1957: UPDATE IGC_CC_PROCESS_DATA A
1958: SET VALIDATION_STATUS = 'F'
1959: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1960: AND A.REQUEST_ID = p_REQUEST_ID
1961: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 1968: UPDATE IGC_CC_PROCESS_DATA A

1964: ELSE
1965: IF p_PROCESS_PHASE = 'F' AND P_PROCESS_TYPE = 'Y'
1966: THEN
1967:
1968: UPDATE IGC_CC_PROCESS_DATA A
1969: SET VALIDATION_STATUS = 'P'
1970: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
1971: AND A.REQUEST_ID = p_REQUEST_ID
1972: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 2023: UPDATE IGC_CC_PROCESS_DATA A

2019:
2020: END IF;
2021: IF p_PROCESS_PHASE = 'P'
2022: THEN
2023: UPDATE IGC_CC_PROCESS_DATA A
2024: SET VALIDATION_STATUS = 'P'
2025: WHERE A.CC_HEADER_ID = V9.CC_HEADER_ID
2026: AND A.REQUEST_ID = p_REQUEST_ID
2027: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 2116: UPDATE IGC_CC_PROCESS_DATA A

2112: V3.SET_OF_BOOKS_ID,
2113: p_REQUEST_ID);
2114: IF (p_PROCESS_TYPE = 'Y')
2115: THEN
2116: UPDATE IGC_CC_PROCESS_DATA A
2117: SET VALIDATION_STATUS = 'F'
2118: WHERE A.CC_HEADER_ID = V3.CC_HEADER_ID
2119: AND A.REQUEST_ID = p_REQUEST_ID
2120: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 2159: UPDATE IGC_CC_PROCESS_DATA A

2155: V3.SET_OF_BOOKS_ID,
2156: p_REQUEST_ID);
2157: IF (p_PROCESS_TYPE = 'Y')
2158: THEN
2159: UPDATE IGC_CC_PROCESS_DATA A
2160: SET VALIDATION_STATUS = 'F'
2161: WHERE A.CC_HEADER_ID = V3.CC_HEADER_ID
2162: AND A.REQUEST_ID = p_REQUEST_ID
2163: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 2204: UPDATE IGC_CC_PROCESS_DATA A

2200:
2201:
2202: IF (p_PROCESS_TYPE = 'Y')
2203: THEN
2204: UPDATE IGC_CC_PROCESS_DATA A
2205: SET VALIDATION_STATUS = 'F'
2206: WHERE A.CC_HEADER_ID = V3.CC_HEADER_ID
2207: AND A.REQUEST_ID = p_REQUEST_ID
2208: AND A.PROCESS_TYPE = p_PROCESS_TYPE

Line 2248: UPDATE IGC_CC_PROCESS_DATA A

2244: p_REQUEST_ID);
2245:
2246: IF (p_PROCESS_TYPE = 'Y')
2247: THEN
2248: UPDATE IGC_CC_PROCESS_DATA A
2249: SET VALIDATION_STATUS = 'F'
2250: WHERE A.CC_HEADER_ID = V3.CC_HEADER_ID
2251: AND A.REQUEST_ID = p_REQUEST_ID
2252: AND A.PROCESS_TYPE = p_PROCESS_TYPE