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 IGC_CC_PROCESS_DATA

Line 147: FROM IGC_CC_PROCESS_DATA

143: gp.period_num = l_min_period_num;
144:
145: SELECT OLD_APPROVAL_STATUS
146: INTO l_APPROVAL_STATUS
147: FROM IGC_CC_PROCESS_DATA
148: WHERE CC_HEADER_ID = p_CC_HEADER_ID
149: AND REQUEST_ID = p_REQUEST_ID;
150:
151:

Line 982: FROM IGC_CC_PROCESS_DATA X

978:
979:
980: CURSOR C2 IS
981: SELECT *
982: FROM IGC_CC_PROCESS_DATA X
983: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
984: WHERE X.SET_OF_BOOKS_ID = l_sob_id
985: AND REQUEST_ID = l_REQUEST_ID1
986: AND X.ORG_ID = l_org_id

Line 1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA

1055: CURSOR C11(H_ID NUMBER) IS
1056: SELECT *
1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID

1057: FROM IGC_CC_HEADERS
1058: WHERE CC_HEADER_ID IN (SELECT IGC_CC_HEADERS.CC_HEADER_ID
1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);

Line 1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

1059: FROM IGC_CC_HEADERS,IGC_CC_PROCESS_DATA
1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);
1066:
1067:

Line 1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

1060: WHERE IGC_CC_HEADERS.PARENT_HEADER_ID = H_ID
1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);
1066:
1067:
1068: V1 C1%ROWTYPE;

Line 1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);

1061: AND IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_PROCESS_DATA.CC_HEADER_ID
1062: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1063: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
1064: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
1065: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id);
1066:
1067:
1068: V1 C1%ROWTYPE;
1069: V2 C2%ROWTYPE;

Line 1080: l_PROCESS_TYPE IGC_CC_PROCESS_DATA.PROCESS_TYPE%TYPE;

1076: l_STATUS_COUNTER NUMBER :=0;
1077: l_LOCK_CC_STATUS BOOLEAN;
1078: l_LOCK_PO_STATUS BOOLEAN;
1079: l_budg_status BOOLEAN;
1080: l_PROCESS_TYPE IGC_CC_PROCESS_DATA.PROCESS_TYPE%TYPE;
1081: l_RESULT_OF_VALIDATION IGC_CC_PROCESS_DATA.VALIDATION_STATUS%TYPE;
1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;
1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;

Line 1081: l_RESULT_OF_VALIDATION IGC_CC_PROCESS_DATA.VALIDATION_STATUS%TYPE;

1077: l_LOCK_CC_STATUS BOOLEAN;
1078: l_LOCK_PO_STATUS BOOLEAN;
1079: l_budg_status BOOLEAN;
1080: l_PROCESS_TYPE IGC_CC_PROCESS_DATA.PROCESS_TYPE%TYPE;
1081: l_RESULT_OF_VALIDATION IGC_CC_PROCESS_DATA.VALIDATION_STATUS%TYPE;
1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;
1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;
1085: l_PROCESSED_COUNTER NUMBER;

Line 1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;

1078: l_LOCK_PO_STATUS BOOLEAN;
1079: l_budg_status BOOLEAN;
1080: l_PROCESS_TYPE IGC_CC_PROCESS_DATA.PROCESS_TYPE%TYPE;
1081: l_RESULT_OF_VALIDATION IGC_CC_PROCESS_DATA.VALIDATION_STATUS%TYPE;
1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;
1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;
1085: l_PROCESSED_COUNTER NUMBER;
1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;

Line 1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;

1079: l_budg_status BOOLEAN;
1080: l_PROCESS_TYPE IGC_CC_PROCESS_DATA.PROCESS_TYPE%TYPE;
1081: l_RESULT_OF_VALIDATION IGC_CC_PROCESS_DATA.VALIDATION_STATUS%TYPE;
1082: l_RESULT_OF_RESERVATION IGC_CC_PROCESS_DATA.RESERVATION_STATUS%TYPE;
1083: l_RESULT_OF_YEAR_END_UPDATE IGC_CC_PROCESS_DATA.PROCESSED%TYPE;
1084: l_VALIDATION_COUNTER NUMBER;
1085: l_PROCESSED_COUNTER NUMBER;
1086: l_CC_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
1087: l_CC_TYPE IGC_CC_HEADERS.CC_TYPE%TYPE;

Line 1434: /* Fetching Rows from IGC_CC_HEADERS into IGC_CC_PROCESS_DATA depending upon Parameters */

1430:
1431: /******************* END ENCUMBRANCE CODE ************************/
1432:
1433:
1434: /* Fetching Rows from IGC_CC_HEADERS into IGC_CC_PROCESS_DATA depending upon Parameters */
1435:
1436: l_PROCESS_TYPE := 'Y';
1437:
1438: DELETE FROM IGC_CC_PROCESS_DATA A

Line 1438: DELETE FROM IGC_CC_PROCESS_DATA A

1434: /* Fetching Rows from IGC_CC_HEADERS into IGC_CC_PROCESS_DATA depending upon Parameters */
1435:
1436: l_PROCESS_TYPE := 'Y';
1437:
1438: DELETE FROM IGC_CC_PROCESS_DATA A
1439: WHERE A.PROCESS_TYPE = 'Y'
1440: AND A.PROCESS_PHASE = 'P'
1441: /* Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id */
1442: AND A.ORG_ID = l_org_id

Line 1460: -- in IGC_CC_PROCESS_DATA, they do not get picked up for subsequent runs.

1456: /* Bug 1866742, Year end not running for 2 consecutive years
1457: -- Commented the following out as it did not make sense.
1458:
1459: -- Because the records are left behind with status processed
1460: -- in IGC_CC_PROCESS_DATA, they do not get picked up for subsequent runs.
1461: -- Hence cleaning the table off like is being done for Preliminary mode
1462: -- Bidisha S, 24 July 2001
1463:
1464: DELETE FROM IGC_CC_PROCESS_DATA A

Line 1464: DELETE FROM IGC_CC_PROCESS_DATA A

1460: -- in IGC_CC_PROCESS_DATA, they do not get picked up for subsequent runs.
1461: -- Hence cleaning the table off like is being done for Preliminary mode
1462: -- Bidisha S, 24 July 2001
1463:
1464: DELETE FROM IGC_CC_PROCESS_DATA A
1465: WHERE A.PROCESS_TYPE = 'Y'
1466: AND A.PROCESS_PHASE IN ('F','P')
1467: AND ( A.PROCESSED <> 'Y' OR A.PROCESSED IS NULL)
1468: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 1472: UPDATE IGC_CC_PROCESS_DATA A

1468: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1469: AND A.ORG_ID = l_org_id
1470: AND A.SET_OF_BOOKS_ID = l_sob_id;
1471:
1472: UPDATE IGC_CC_PROCESS_DATA A
1473: SET REQUEST_ID = l_REQUEST_ID1
1474: WHERE A.PROCESS_TYPE = 'Y'
1475: AND A.PROCESS_PHASE = 'F'
1476: AND A.PROCESSED = 'Y'

Line 1486: DELETE FROM IGC_CC_PROCESS_DATA A

1482:
1483: -- Added for 1866742, Bidisha S, 24 July 2001
1484: -- Delete all records that have been processed
1485: -- Updation of request id has been moved below.
1486: DELETE FROM IGC_CC_PROCESS_DATA A
1487: WHERE A.PROCESS_TYPE = 'Y'
1488: AND A.PROCESS_PHASE = 'F'
1489: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1490: AND A.ORG_ID = l_org_id

Line 1549: FROM IGC_CC_PROCESS_DATA A

1545: THEN
1546: BEGIN
1547: SELECT CC_HEADER_ID
1548: INTO l_HEADER_ID
1549: FROM IGC_CC_PROCESS_DATA A
1550: WHERE A.CC_HEADER_ID = V1.CC_HEADER_ID
1551: AND A.PROCESS_PHASE = 'F'
1552: AND A.PROCESS_TYPE = 'Y';
1553: -- AND A.REQUEST_ID = l_REQUEST_ID1;

Line 1555: UPDATE IGC_CC_PROCESS_DATA A

1551: AND A.PROCESS_PHASE = 'F'
1552: AND A.PROCESS_TYPE = 'Y';
1553: -- AND A.REQUEST_ID = l_REQUEST_ID1;
1554:
1555: UPDATE IGC_CC_PROCESS_DATA A
1556: SET OLD_APPROVAL_STATUS = V1.CC_APPRVL_STATUS,
1557: REQUEST_ID = l_REQUEST_ID1
1558: WHERE A.CC_HEADER_ID = V1.CC_HEADER_ID
1559: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 1569: INSERT INTO IGC_CC_PROCESS_DATA

1565: EXCEPTION
1566: WHEN NO_DATA_FOUND
1567: THEN
1568:
1569: INSERT INTO IGC_CC_PROCESS_DATA
1570: (PROCESS_TYPE,
1571: PROCESS_PHASE,
1572: CC_HEADER_ID,
1573: VALIDATION_STATUS,

Line 1599: INSERT INTO IGC_CC_PROCESS_DATA

1595:
1596: IF p_PROCESS_PHASE = 'P'
1597: THEN
1598:
1599: INSERT INTO IGC_CC_PROCESS_DATA
1600: (PROCESS_TYPE,
1601: PROCESS_PHASE,
1602: CC_HEADER_ID,
1603: VALIDATION_STATUS,

Line 1664: UPDATE IGC_CC_PROCESS_DATA

1660: l_org_id,
1661: l_prov_enc_on,
1662: l_REQUEST_ID1);
1663:
1664: UPDATE IGC_CC_PROCESS_DATA
1665: SET VALIDATION_STATUS = l_RESULT_OF_VALIDATION
1666: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
1667: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1668: AND SET_OF_BOOKS_ID = l_sob_id

Line 1666: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID

1662: l_REQUEST_ID1);
1663:
1664: UPDATE IGC_CC_PROCESS_DATA
1665: SET VALIDATION_STATUS = l_RESULT_OF_VALIDATION
1666: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
1667: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1668: AND SET_OF_BOOKS_ID = l_sob_id
1669: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
1670: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE

Line 1669: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

1665: SET VALIDATION_STATUS = l_RESULT_OF_VALIDATION
1666: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
1667: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1668: AND SET_OF_BOOKS_ID = l_sob_id
1669: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
1670: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE
1671: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1;
1672:
1673: END IF;

Line 1670: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE

1666: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
1667: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1668: AND SET_OF_BOOKS_ID = l_sob_id
1669: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
1670: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE
1671: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1;
1672:
1673: END IF;
1674:

Line 1671: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1;

1667: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
1668: AND SET_OF_BOOKS_ID = l_sob_id
1669: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
1670: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE
1671: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1;
1672:
1673: END IF;
1674:
1675: END LOOP;

Line 2150: UPDATE IGC_CC_PROCESS_DATA A

2146: l_REQUEST_ID1);
2147:
2148: IF l_RESULT_OF_VALIDATION = 'P'
2149: THEN
2150: UPDATE IGC_CC_PROCESS_DATA A
2151: SET VALIDATION_STATUS = 'P'
2152: WHERE A.CC_HEADER_ID = V2.CC_HEADER_ID
2153: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2154: AND A.ORG_ID = l_org_id

Line 2203: UPDATE IGC_CC_PROCESS_DATA

2199: END IF;
2200:
2201: IF l_RESULT_OF_VALIDATION = 'F'
2202: THEN
2203: UPDATE IGC_CC_PROCESS_DATA
2204: SET VALIDATION_STATUS = 'F'
2205: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
2206: AND REQUEST_ID = l_REQUEST_ID1;
2207: END IF;

Line 2205: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID

2201: IF l_RESULT_OF_VALIDATION = 'F'
2202: THEN
2203: UPDATE IGC_CC_PROCESS_DATA
2204: SET VALIDATION_STATUS = 'F'
2205: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
2206: AND REQUEST_ID = l_REQUEST_ID1;
2207: END IF;
2208:
2209: END IF;

Line 2229: FROM IGC_CC_PROCESS_DATA

2225:
2226: -- check for all Contract Commitments get passed through Validation Phase
2227: SELECT COUNT(*)
2228: INTO l_VALIDATION_COUNTER
2229: FROM IGC_CC_PROCESS_DATA
2230: WHERE VALIDATION_STATUS = 'F'
2231: AND REQUEST_ID = l_REQUEST_ID1
2232: AND PROCESS_TYPE = 'Y'
2233: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 2254: FROM IGC_CC_PROCESS_DATA

2250: l_invalid_counter := 0;
2251:
2252: SELECT COUNT(*)
2253: INTO l_invalid_counter
2254: FROM IGC_CC_PROCESS_DATA
2255: WHERE validation_status = 'F'
2256: AND request_id = l_REQUEST_ID1
2257: AND process_type = 'Y'
2258: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 2307: UPDATE IGC_CC_PROCESS_DATA

2303: END IF;
2304:
2305: IF l_RESULT_OF_RESERVATION = 'P'
2306: THEN
2307: UPDATE IGC_CC_PROCESS_DATA
2308: SET RESERVATION_STATUS ='P'
2309: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
2310: AND REQUEST_ID = l_REQUEST_ID1;
2311:

Line 2309: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID

2305: IF l_RESULT_OF_RESERVATION = 'P'
2306: THEN
2307: UPDATE IGC_CC_PROCESS_DATA
2308: SET RESERVATION_STATUS ='P'
2309: WHERE IGC_CC_PROCESS_DATA.CC_HEADER_ID = V2.CC_HEADER_ID
2310: AND REQUEST_ID = l_REQUEST_ID1;
2311:
2312:
2313: SELECT CC_TYPE

Line 2342: UPDATE IGC_CC_PROCESS_DATA

2338:
2339:
2340: IF l_RESULT_OF_YEAR_END_UPDATE = 'Y'
2341: THEN
2342: UPDATE IGC_CC_PROCESS_DATA
2343: SET PROCESSED = 'Y'
2344: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2346: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id

Line 2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2341: THEN
2342: UPDATE IGC_CC_PROCESS_DATA
2343: SET PROCESSED = 'Y'
2344: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2346: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

Line 2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2343: SET PROCESSED = 'Y'
2344: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2346: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2350:
2351: UPDATE IGC_CC_HEADERS

Line 2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2344: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2346: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2350:
2351: UPDATE IGC_CC_HEADERS
2352: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS

Line 2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2345: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2346: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2347: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2348: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2349: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2350:
2351: UPDATE IGC_CC_HEADERS
2352: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2353: WHERE CC_HEADER_ID = V2.CC_HEADER_ID;

Line 2396: UPDATE IGC_CC_PROCESS_DATA

2392: END;
2393: END IF;
2394:
2395: ELSE
2396: UPDATE IGC_CC_PROCESS_DATA
2397: SET PROCESSED = 'N',
2398: VALIDATION_STATUS = 'F',
2399: RESERVATION_STATUS = 'F'
2400: WHERE CC_HEADER_ID = V2.CC_HEADER_ID

Line 2402: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2398: VALIDATION_STATUS = 'F',
2399: RESERVATION_STATUS = 'F'
2400: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2401: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2402: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2406:

Line 2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2399: RESERVATION_STATUS = 'F'
2400: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2401: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2402: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2406:
2407: UPDATE IGC_CC_HEADERS

Line 2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2400: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2401: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2402: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2406:
2407: UPDATE IGC_CC_HEADERS
2408: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS

Line 2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;

2401: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2402: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2403: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2404: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2405: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2406:
2407: UPDATE IGC_CC_HEADERS
2408: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS
2409: WHERE CC_HEADER_ID = V2.CC_HEADER_ID

Line 2435: UPDATE IGC_CC_PROCESS_DATA

2431:
2432:
2433: IF l_RESULT_OF_YEAR_END_UPDATE = 'Y'
2434: THEN
2435: UPDATE IGC_CC_PROCESS_DATA
2436: SET PROCESSED = 'Y'
2437: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2438: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2435: UPDATE IGC_CC_PROCESS_DATA
2436: SET PROCESSED = 'Y'
2437: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2438: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2440: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2441: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2442: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2443:

Line 2440: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2436: SET PROCESSED = 'Y'
2437: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2438: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2440: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2441: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2442: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2443:
2444: OPEN C11(V2.CC_HEADER_ID);

Line 2441: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2437: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2438: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2440: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2441: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2442: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2443:
2444: OPEN C11(V2.CC_HEADER_ID);
2445:

Line 2442: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2438: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2439: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2440: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2441: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2442: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2443:
2444: OPEN C11(V2.CC_HEADER_ID);
2445:
2446: RELEASE_YEAR_END_COUNTER := 0;

Line 2469: UPDATE IGC_CC_PROCESS_DATA

2465: THEN
2466: RELEASE_YEAR_END_COUNTER := RELEASE_YEAR_END_COUNTER +1;
2467: END IF;
2468:
2469: UPDATE IGC_CC_PROCESS_DATA
2470: SET PROCESSED = l_RESULT_OF_YEAR_END_UPDATE
2471: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2472: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2469: UPDATE IGC_CC_PROCESS_DATA
2470: SET PROCESSED = l_RESULT_OF_YEAR_END_UPDATE
2471: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2472: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2474: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2475: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2476: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2477:

Line 2474: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2470: SET PROCESSED = l_RESULT_OF_YEAR_END_UPDATE
2471: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2472: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2474: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2475: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2476: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2477:
2478: END LOOP;

Line 2475: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2471: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2472: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2474: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2475: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2476: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2477:
2478: END LOOP;
2479: CLOSE C11;

Line 2476: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2472: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2473: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2474: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2475: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2476: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2477:
2478: END LOOP;
2479: CLOSE C11;
2480:

Line 2483: UPDATE IGC_CC_PROCESS_DATA

2479: CLOSE C11;
2480:
2481: IF RELEASE_YEAR_END_COUNTER > 0
2482: THEN
2483: UPDATE IGC_CC_PROCESS_DATA
2484: SET PROCESSED = 'N'
2485: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2486: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2483: UPDATE IGC_CC_PROCESS_DATA
2484: SET PROCESSED = 'N'
2485: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2486: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2488: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2489: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2490: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2491:

Line 2488: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2484: SET PROCESSED = 'N'
2485: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2486: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2488: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2489: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2490: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2491:
2492: l_EXCEPTION := NULL;

Line 2489: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2485: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2486: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2488: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2489: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2490: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2491:
2492: l_EXCEPTION := NULL;
2493: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_COVER_REL_INSERT');

Line 2490: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2486: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2487: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2488: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2489: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2490: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2491:
2492: l_EXCEPTION := NULL;
2493: FND_MESSAGE.SET_NAME('IGC','IGC_CC_YEP_COVER_REL_INSERT');
2494: IF(g_excep_level >= g_debug_level) THEN

Line 2576: ELSE UPDATE IGC_CC_PROCESS_DATA

2572: CLOSE C11;
2573: END IF;
2574:
2575:
2576: ELSE UPDATE IGC_CC_PROCESS_DATA
2577: SET PROCESSED = 'N',
2578: VALIDATION_STATUS = 'F',
2579: RESERVATION_STATUS = 'F'
2580: WHERE CC_HEADER_ID = V2.CC_HEADER_ID

Line 2582: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2578: VALIDATION_STATUS = 'F',
2579: RESERVATION_STATUS = 'F'
2580: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2581: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2582: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2583: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2586:

Line 2583: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2579: RESERVATION_STATUS = 'F'
2580: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2581: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2582: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2583: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2586:
2587:

Line 2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2580: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2581: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2582: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2583: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2586:
2587:
2588: UPDATE IGC_CC_HEADERS

Line 2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2581: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2582: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2583: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2584: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2585: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2586:
2587:
2588: UPDATE IGC_CC_HEADERS
2589: SET CC_APPRVL_STATUS = V2.OLD_APPROVAL_STATUS

Line 2601: UPDATE IGC_CC_PROCESS_DATA

2597:
2598: FETCH C11 INTO V11;
2599: EXIT WHEN C11%NOTFOUND;
2600:
2601: UPDATE IGC_CC_PROCESS_DATA
2602: SET PROCESSED = 'N'
2603: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2604: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

Line 2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2601: UPDATE IGC_CC_PROCESS_DATA
2602: SET PROCESSED = 'N'
2603: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2604: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2606: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2607: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2608: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2609:

Line 2606: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2602: SET PROCESSED = 'N'
2603: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2604: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2606: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2607: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2608: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2609:
2610: END LOOP;

Line 2607: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2603: WHERE CC_HEADER_ID = V11.CC_HEADER_ID
2604: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2606: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2607: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2608: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2609:
2610: END LOOP;
2611: CLOSE C11;

Line 2608: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2604: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2605: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2606: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2607: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2608: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2609:
2610: END LOOP;
2611: CLOSE C11;
2612: END IF;

Line 2652: UPDATE IGC_CC_PROCESS_DATA

2648: l_sob_id,
2649: l_REQUEST_ID1);
2650:
2651:
2652: UPDATE IGC_CC_PROCESS_DATA
2653: SET VALIDATION_STATUS = 'F',
2654: PROCESSED = 'N',
2655: RESERVATION_STATUS = 'F'
2656: WHERE CC_HEADER_ID = V2.CC_HEADER_ID

Line 2658: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2654: PROCESSED = 'N',
2655: RESERVATION_STATUS = 'F'
2656: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2657: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2658: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2659: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2660: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2661: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2662:

Line 2659: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2655: RESERVATION_STATUS = 'F'
2656: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2657: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2658: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2659: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2660: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2661: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2662:
2663: END IF;

Line 2660: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2656: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2657: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2658: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2659: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2660: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2661: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2662:
2663: END IF;
2664:

Line 2661: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;

2657: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2658: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2659: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2660: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2661: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE;
2662:
2663: END IF;
2664:
2665: ELSE -- CC has not passed validation, Bug 1866713

Line 2667: UPDATE IGC_CC_PROCESS_DATA

2663: END IF;
2664:
2665: ELSE -- CC has not passed validation, Bug 1866713
2666:
2667: UPDATE IGC_CC_PROCESS_DATA
2668: SET PROCESSED = 'N',
2669: VALIDATION_STATUS = 'F',
2670: RESERVATION_STATUS = 'F'
2671: WHERE CC_HEADER_ID = V2.CC_HEADER_ID

Line 2673: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id

2669: VALIDATION_STATUS = 'F',
2670: RESERVATION_STATUS = 'F'
2671: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2672: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2673: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2674: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2675: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2676: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2677:

Line 2674: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1

2670: RESERVATION_STATUS = 'F'
2671: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2672: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2673: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2674: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2675: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2676: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2677:
2678: -- bug 2043221 ssmales - bug found during testing of topic 46 - approval status needs resetting

Line 2675: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id

2671: WHERE CC_HEADER_ID = V2.CC_HEADER_ID
2672: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2673: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2674: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2675: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2676: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2677:
2678: -- bug 2043221 ssmales - bug found during testing of topic 46 - approval status needs resetting
2679: -- update added below to process this

Line 2676: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;

2672: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2673: AND IGC_CC_PROCESS_DATA.SET_OF_BOOKS_ID = l_sob_id
2674: AND IGC_CC_PROCESS_DATA.REQUEST_ID = l_REQUEST_ID1
2675: AND IGC_CC_PROCESS_DATA.ORG_ID = l_org_id
2676: AND IGC_CC_PROCESS_DATA.PROCESS_TYPE = l_PROCESS_TYPE ;
2677:
2678: -- bug 2043221 ssmales - bug found during testing of topic 46 - approval status needs resetting
2679: -- update added below to process this
2680:

Line 2733: FROM IGC_CC_PROCESS_DATA

2729: l_PROCESSED_COUNTER := 0;
2730:
2731: SELECT COUNT(*)
2732: INTO l_PROCESSED_COUNTER
2733: FROM IGC_CC_PROCESS_DATA
2734: WHERE PROCESSED = 'N'
2735: AND PROCESS_TYPE = l_PROCESS_TYPE
2736: -- Bug No : 6341012. MOAC Uptake. p_sob_id,p_org_id are changed to l_sob_id,l_org_id
2737: AND ORG_ID = l_org_id