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_REVALUE_PROCESS_PKG dependencies on IGC_CC_PROCESS_DATA

Line 594: l_approval_status igc_cc_process_data.old_approval_status%TYPE;

590: l_msg_count NUMBER;
591: l_msg_data VARCHAR2(2000);
592: G_FLAG VARCHAR2(1);
593:
594: l_approval_status igc_cc_process_data.old_approval_status%TYPE;
595:
596: l_Last_Updated_By NUMBER;
597: l_Last_Update_Login NUMBER;
598: l_Created_By NUMBER;

Line 650: FROM igc_cc_process_data

646:
647:
648: SELECT old_approval_status
649: INTO l_approval_status
650: FROM igc_cc_process_data
651: WHERE cc_header_id = p_cc_header_id AND
652: request_id = p_request_id ;
653:
654:

Line 1410: UPDATE igc_cc_process_data

1406: RETURN 'F';
1407: END IF;
1408:
1409: /* Update validation status, in temporary table*/
1410: UPDATE igc_cc_process_data
1411: SET
1412: processed = 'Y'
1413: WHERE request_id = p_request_id AND
1414: cc_header_id = P_cc_header_id ;

Line 1528: UPDATE igc_cc_process_data a

1524: ' IGCCREPB -- Populate Error Begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1525: END IF;
1526: -- bug 3199488, end block
1527:
1528: UPDATE igc_cc_process_data a
1529: SET a.validation_status = 'F'
1530: WHERE a.cc_header_id = p_cc_header_id AND
1531: request_id = p_request_id;
1532:

Line 1558: igc_cc_process_data a

1554: p_org_id,
1555: p_sob_id,
1556: p_request_id
1557: FROM igc_cc_headers b,
1558: igc_cc_process_data a
1559: WHERE
1560: NVL(b.parent_header_id,0) = p_cc_header_id AND
1561: b.cc_header_id = a.cc_header_id AND
1562: b.currency_code = p_currency_code AND

Line 1724: FROM igc_cc_process_data a ,

1720: /* Fetch the cover-relase both revalued data from temporary table */
1721: CURSOR c_cover_reval_data(p_request_id NUMBER)
1722: IS
1723: SELECT a.cc_header_id
1724: FROM igc_cc_process_data a ,
1725: igc_cc_headers b
1726: WHERE a.request_id = p_request_id AND
1727: a.cc_header_id = b.cc_header_id AND
1728: /* bug 1622969 */

Line 1738: FROM igc_cc_process_data a ,

1734: /* Fetch the cover-standard data from temporary table */
1735: CURSOR c_reval_data(p_request_id NUMBER)
1736: IS
1737: SELECT a.cc_header_id
1738: FROM igc_cc_process_data a ,
1739: igc_cc_headers b
1740: WHERE a.request_id = p_request_id AND
1741: a.cc_header_id = b.cc_header_id AND
1742: /* bug 1622969 */

Line 2336: INSERT INTO igc_cc_process_data

2332: ' IGCCREPB -- Inserting CC type S record into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2333: END IF;
2334: -- bug 3199488, end block
2335:
2336: INSERT INTO igc_cc_process_data
2337: (
2338: process_type,
2339: process_phase,
2340: cc_header_id,

Line 2388: FROM igc_cc_process_data a

2384:
2385: BEGIN
2386: SELECT NVL(processed,'N')
2387: INTO l_processed
2388: FROM igc_cc_process_data a
2389: WHERE a.cc_header_id = NVL(l_cc_headers_rec.parent_header_id,0) AND
2390: a.request_id = l_request_id1;
2391: EXCEPTION
2392: WHEN NO_DATA_FOUND

Line 2421: INSERT INTO igc_cc_process_data

2417: ' IGCCREPB -- Inserting cover into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2418: END IF;
2419: -- bug 3199488, end block
2420:
2421: INSERT INTO igc_cc_process_data
2422: (
2423: process_type,
2424: process_phase,
2425: cc_header_id,

Line 2481: INSERT INTO igc_cc_process_data

2477:
2478: IF (l_cc_header_id = l_cc_headers_rec.cc_header_id)
2479: THEN
2480:
2481: INSERT INTO igc_cc_process_data
2482: (
2483: process_type,
2484: process_phase,
2485: cc_header_id,

Line 2507: INSERT INTO igc_cc_process_data

2503: l_sob_id,
2504: 'N',
2505: l_request_id1);
2506: ELSE
2507: INSERT INTO igc_cc_process_data
2508: (
2509: process_type,
2510: process_phase,
2511: cc_header_id,

Line 2560: UPDATE igc_cc_process_data a

2556: l_lock_cc_po := lock_cc_po(l_sob_id,l_org_id,l_cc_headers_rec.parent_header_id,l_request_id1);
2557:
2558: IF (l_lock_cc_po = TRUE)
2559: THEN
2560: UPDATE igc_cc_process_data a
2561: SET
2562: validate_only = 'N'
2563: WHERE a.request_id = l_request_id1 AND
2564: a.cc_header_id = l_cc_headers_rec.cc_header_id;

Line 2593: FROM igc_cc_process_data a

2589:
2590: BEGIN
2591: SELECT NVL(processed,'N')
2592: INTO l_processed
2593: FROM igc_cc_process_data a
2594: WHERE a.cc_header_id = l_cc_headers_rec.cc_header_id AND
2595: a.request_id = l_request_id1;
2596: EXCEPTION
2597: WHEN NO_DATA_FOUND

Line 2641: INSERT INTO igc_cc_process_data

2637: ' IGCCREPB -- Inserting into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2638: END IF;
2639: -- bug 3199488, end block
2640:
2641: INSERT INTO igc_cc_process_data
2642: (
2643: process_type,
2644: process_phase,
2645: cc_header_id,

Line 2683: INSERT INTO igc_cc_process_data

2679:
2680: END IF;
2681: -- bug 3199488, end block
2682:
2683: INSERT INTO igc_cc_process_data
2684: (
2685: process_type,
2686: process_phase,
2687: cc_header_id,

Line 2802: UPDATE igc_cc_process_data

2798: END IF;
2799: -- bug 3199488, end block
2800:
2801: /* bug 1622969 */
2802: UPDATE igc_cc_process_data
2803: SET validation_status = 'F',
2804: processed = 'Y'
2805: WHERE cc_header_id = l_cc_header_id AND
2806: request_id = l_request_id1;

Line 2873: /* Update releases status in igc_cc_process_data */

2869: -- bug 3199488, end block
2870:
2871: /* bug 1622969 */
2872:
2873: /* Update releases status in igc_cc_process_data */
2874: UPDATE igc_cc_process_data
2875: SET validation_status = 'F',
2876: processed = 'Y'
2877: WHERE cc_header_id = l_rel_cc_header_id AND

Line 2874: UPDATE igc_cc_process_data

2870:
2871: /* bug 1622969 */
2872:
2873: /* Update releases status in igc_cc_process_data */
2874: UPDATE igc_cc_process_data
2875: SET validation_status = 'F',
2876: processed = 'Y'
2877: WHERE cc_header_id = l_rel_cc_header_id AND
2878: request_id = l_request_id1;

Line 2880: /* Update cover status in igc_cc_process_data */

2876: processed = 'Y'
2877: WHERE cc_header_id = l_rel_cc_header_id AND
2878: request_id = l_request_id1;
2879:
2880: /* Update cover status in igc_cc_process_data */
2881: UPDATE igc_cc_process_data
2882: SET validation_status = 'F',
2883: processed = 'Y'
2884: WHERE cc_header_id = l_cc_header_id AND

Line 2881: UPDATE igc_cc_process_data

2877: WHERE cc_header_id = l_rel_cc_header_id AND
2878: request_id = l_request_id1;
2879:
2880: /* Update cover status in igc_cc_process_data */
2881: UPDATE igc_cc_process_data
2882: SET validation_status = 'F',
2883: processed = 'Y'
2884: WHERE cc_header_id = l_cc_header_id AND
2885: request_id = l_request_id1;

Line 2937: /* Update cover status in igc_cc_process_data */

2933: -- bug 3199488, end block
2934:
2935: /* bug 1622969 */
2936:
2937: /* Update cover status in igc_cc_process_data */
2938: UPDATE igc_cc_process_data
2939: SET validation_status = 'F',
2940: processed = 'Y'
2941: WHERE cc_header_id = l_cc_header_id AND

Line 2938: UPDATE igc_cc_process_data

2934:
2935: /* bug 1622969 */
2936:
2937: /* Update cover status in igc_cc_process_data */
2938: UPDATE igc_cc_process_data
2939: SET validation_status = 'F',
2940: processed = 'Y'
2941: WHERE cc_header_id = l_cc_header_id AND
2942: request_id = l_request_id1;

Line 2944: /* Update releases statuses in igc_cc_process_data */

2940: processed = 'Y'
2941: WHERE cc_header_id = l_cc_header_id AND
2942: request_id = l_request_id1;
2943:
2944: /* Update releases statuses in igc_cc_process_data */
2945: UPDATE igc_cc_process_data
2946: SET
2947: validation_status = 'F' ,
2948: processed = 'Y'

Line 2945: UPDATE igc_cc_process_data

2941: WHERE cc_header_id = l_cc_header_id AND
2942: request_id = l_request_id1;
2943:
2944: /* Update releases statuses in igc_cc_process_data */
2945: UPDATE igc_cc_process_data
2946: SET
2947: validation_status = 'F' ,
2948: processed = 'Y'
2949: WHERE request_id = l_request_id1 AND

Line 3111: FROM igc_cc_process_data

3107: l_validate_only := 'Y';
3108:
3109: SELECT validate_only
3110: INTO l_validate_only
3111: FROM igc_cc_process_data
3112: WHERE request_id = l_request_id1 AND
3113: cc_header_id = l_cc_headers_rec.cc_header_id;
3114:
3115: /* Release revaluation only */

Line 3693: FROM igc_cc_process_data

3689: IF (l_cc_headers_rec.cc_type = 'C')
3690: THEN
3691: SELECT validation_status
3692: INTO l_curr_validation_status
3693: FROM igc_cc_process_data
3694: WHERE cc_header_id = l_cc_header_id AND
3695: request_id = l_request_id1;
3696: END IF;
3697:

Line 3765: UPDATE igc_cc_process_data

3761: END IF;
3762: -- bug 3199488, end block
3763:
3764: BEGIN
3765: UPDATE igc_cc_process_data
3766: SET
3767: validation_status = l_validation_Status,
3768: processed = 'Y'
3769: WHERE

Line 3790: UPDATE igc_cc_process_data

3786: -- bug 3199488, end block
3787:
3788: IF (l_cc_headers_rec.cc_type = 'C')
3789: THEN
3790: UPDATE igc_cc_process_data
3791: SET
3792: validation_status = l_validation_Status,
3793: processed = 'Y'
3794: WHERE

Line 3870: UPDATE igc_cc_process_data

3866: END IF;
3867: -- bug 3199488, end block
3868:
3869: BEGIN
3870: UPDATE igc_cc_process_data
3871: SET
3872: validation_status = l_validation_Status,
3873: old_approval_status = l_cc_headers_rec.cc_apprvl_status
3874: WHERE

Line 4014: UPDATE igc_cc_process_data

4010: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg78',' IGCCREPB -- Update process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4011: END IF;
4012: -- bug 3199488, end block
4013:
4014: UPDATE igc_cc_process_data
4015: SET
4016: validation_status = l_validation_Status,
4017: old_approval_status = l_rel_cc_headers_rec.cc_apprvl_status
4018: WHERE request_id = l_request_id1 AND

Line 4126: UPDATE igc_cc_process_data

4122: ' IGCCREPB -- Updating cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4123: END IF;
4124: -- bug 3199488, end block
4125:
4126: UPDATE igc_cc_process_data
4127: SET
4128: validation_status = l_validation_Status ,
4129: processed = 'Y'
4130: WHERE request_id = l_request_id1 AND

Line 4147: UPDATE igc_cc_process_data

4143: ' IGCCREPB -- Updating Cover process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4144: END IF;
4145: -- bug 3199488, end block
4146:
4147: UPDATE igc_cc_process_data
4148: SET
4149: validation_status = l_validation_Status ,
4150: processed = 'Y'
4151: WHERE request_id = l_request_id1 AND

Line 4218: FROM igc_cc_process_data

4214:
4215:
4216: SELECT validation_status
4217: INTO l_validation_status
4218: FROM igc_cc_process_data
4219: WHERE request_id = l_request_id1 AND
4220: cc_header_id = l_cc_header_id ;
4221:
4222: IF (l_validation_status = 'P')

Line 4239: FROM igc_cc_process_data

4235: l_validate_only := 'Y';
4236:
4237: SELECT validate_only
4238: INTO l_validate_only
4239: FROM igc_cc_process_data
4240: WHERE request_id = l_request_id1 AND
4241: cc_header_id = l_cc_headers_rec.cc_header_id;
4242:
4243:

Line 4338: from igc_cc_process_data

4334: l_approval_status := NULL;
4335:
4336: select old_approval_status
4337: into l_approval_status
4338: from igc_cc_process_data
4339: where cc_header_id = l_cc_headers_rec.cc_header_id
4340: and request_id = l_request_id1;
4341:
4342: update igc_cc_headers

Line 4401: UPDATE igc_cc_process_data

4397: ' IGCCREPB -- Updating process data after encumber CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4398: END IF;
4399: -- bug 3199488, end block
4400:
4401: UPDATE igc_cc_process_data
4402: SET
4403: reservation_status = l_reservation_Status
4404: WHERE
4405: request_id = l_request_id1 AND

Line 4421: UPDATE igc_cc_process_data

4417: ' IGCCREPB -- Updating process data after encumber CC for Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4418: END IF;
4419: -- bug 3199488, end block
4420:
4421: UPDATE igc_cc_process_data
4422: SET
4423: reservation_status = l_reservation_Status
4424: WHERE
4425: request_id = l_request_id1 AND

Line 4462: FROM igc_cc_process_data

4458: l_validate_only := 'Y';
4459:
4460: SELECT validate_only
4461: INTO l_validate_only
4462: FROM igc_cc_process_data
4463: WHERE request_id = l_request_id1 AND
4464: cc_header_id = l_rel_cc_header_id;
4465:
4466: l_process_flag := 'P';

Line 4587: FROM igc_cc_process_data

4583: -- bug 3199488, end block
4584:
4585: SELECT validate_only
4586: INTO l_validate_only
4587: FROM igc_cc_process_data
4588: WHERE request_id = l_request_id1 AND
4589: cc_header_id = l_cc_headers_rec.cc_header_id;
4590:
4591: