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

Line 788: l_approval_status igc_cc_process_data.old_approval_status%TYPE;

784: l_msg_count NUMBER;
785: l_msg_data VARCHAR2(2000);
786: G_FLAG VARCHAR2(1);
787:
788: l_approval_status igc_cc_process_data.old_approval_status%TYPE;
789:
790: l_Last_Updated_By NUMBER := FND_GLOBAL.USER_ID;
791: l_Last_Update_Login NUMBER := FND_GLOBAL.LOGIN_ID;
792: l_Created_By NUMBER := FND_GLOBAL.USER_ID;

Line 825: FROM igc_cc_process_data

821:
822:
823: SELECT old_approval_status
824: INTO l_approval_status
825: FROM igc_cc_process_data
826: WHERE cc_header_id = p_cc_header_id AND
827: request_id = p_request_id ;
828:
829: IF (p_validate_only = 'N')

Line 1538: UPDATE igc_cc_process_data

1534: RETURN 'F';
1535: END IF;
1536:
1537: /* Update validation status, in temporary table*/
1538: UPDATE igc_cc_process_data
1539: SET
1540: processed = 'Y'
1541: WHERE request_id = p_request_id AND
1542: cc_header_id = P_cc_header_id ;

Line 1564: UPDATE igc_cc_process_data a

1560: l_message igc_cc_process_exceptions.exception_reason%TYPE;
1561: BEGIN
1562: /* Update validation_status to 'F' in temporary table for releases */
1563:
1564: UPDATE igc_cc_process_data a
1565: SET a.validation_status = 'F'
1566: WHERE a.cc_header_id = p_cc_header_id AND
1567: request_id = p_request_id;
1568:

Line 1594: igc_cc_process_data a

1590: p_org_id,
1591: p_sob_id,
1592: p_request_id
1593: FROM igc_cc_headers b,
1594: igc_cc_process_data a
1595: WHERE
1596: b.parent_header_id = p_cc_header_id AND
1597: b.cc_header_id = a.cc_header_id AND
1598: a.request_id = p_request_id;

Line 1695: FROM igc_cc_process_data a ,

1691: /* Fetch the cover-relase both revalued data from temporary table */
1692: CURSOR c_cover_reval_data(p_request_id NUMBER)
1693: IS
1694: SELECT a.cc_header_id
1695: FROM igc_cc_process_data a ,
1696: igc_cc_headers b
1697: WHERE a.request_id = p_request_id AND
1698: a.cc_header_id = b.cc_header_id AND
1699: b.cc_type = 'C';

Line 1706: FROM igc_cc_process_data a ,

1702: /* Fetch the cover-standard data from temporary table */
1703: CURSOR c_reval_data(p_request_id NUMBER)
1704: IS
1705: SELECT a.cc_header_id
1706: FROM igc_cc_process_data a ,
1707: igc_cc_headers b
1708: WHERE a.request_id = p_request_id AND
1709: a.cc_header_id = b.cc_header_id AND
1710: (b.cc_type = 'C' OR b.cc_type = 'S');

Line 2183: INSERT INTO igc_cc_process_data

2179:
2180: /* Begin Standard Revaluation */
2181: IF (l_cc_headers_rec.cc_type = 'S')
2182: THEN
2183: INSERT INTO igc_cc_process_data
2184: (
2185: process_type,
2186: process_phase,
2187: cc_header_id,

Line 2227: INSERT INTO igc_cc_process_data

2223:
2224: /* Functional Currency Cover */
2225: IF (l_currency_code = l_cover_currency_code)
2226: THEN
2227: INSERT INTO igc_cc_process_data
2228: (
2229: process_type,
2230: process_phase,
2231: cc_header_id,

Line 2260: INSERT INTO igc_cc_process_data

2256:
2257: /* Non Functional Currency Cover */
2258: IF (l_currency_code <> l_cover_currency_code)
2259: THEN
2260: INSERT INTO igc_cc_process_data
2261: (
2262: process_type,
2263: process_phase,
2264: cc_header_id,

Line 2298: INSERT INTO igc_cc_process_data

2294:
2295: IF (l_cc_header_id = l_cc_headers_rec.cc_header_id)
2296: THEN
2297:
2298: INSERT INTO igc_cc_process_data
2299: (
2300: process_type,
2301: process_phase,
2302: cc_header_id,

Line 2325: INSERT INTO igc_cc_process_data

2321: l_sob_id,
2322: 'N',
2323: l_request_id1);
2324: ELSE
2325: INSERT INTO igc_cc_process_data
2326: (
2327: process_type,
2328: process_phase,
2329: cc_header_id,

Line 2650: FROM igc_cc_process_data

2646: IF (l_cc_headers_rec.cc_type = 'C')
2647: THEN
2648: SELECT validation_status
2649: INTO l_curr_validation_status
2650: FROM igc_cc_process_data
2651: WHERE cc_header_id = l_cc_header_id AND
2652: request_id = l_request_id1;
2653: END IF;
2654:

Line 2683: UPDATE igc_cc_process_data

2679: /* Update validation status in temporary table*/
2680:
2681:
2682: BEGIN
2683: UPDATE igc_cc_process_data
2684: SET
2685: validation_status = l_validation_Status,
2686: processed = 'Y'
2687: WHERE

Line 2698: UPDATE igc_cc_process_data

2694: END;
2695:
2696: IF (l_cc_headers_rec.cc_type = 'C')
2697: THEN
2698: UPDATE igc_cc_process_data
2699: SET
2700: validation_status = l_validation_Status,
2701: processed = 'Y'
2702: WHERE

Line 2727: UPDATE igc_cc_process_data

2723:
2724: IF (l_cc_headers_rec.cc_type = 'C') OR (l_cc_headers_rec.cc_type = 'S')
2725: THEN
2726: BEGIN
2727: UPDATE igc_cc_process_data
2728: SET
2729: validation_status = l_validation_Status,
2730: old_approval_status = l_cc_headers_rec.cc_apprvl_status
2731: WHERE

Line 2796: UPDATE igc_cc_process_data

2792: LOOP
2793: FETCH c_all_releases1 INTO l_rel_cc_headers_rec;
2794: EXIT WHEN c_all_releases1%NOTFOUND;
2795:
2796: UPDATE igc_cc_process_data
2797: SET
2798: validation_status = l_validation_Status,
2799: old_approval_status = l_rel_cc_headers_rec.cc_apprvl_status
2800: WHERE request_id = l_request_id1 AND

Line 2849: UPDATE igc_cc_process_data

2845: /* Update validation status, in temporary table*/
2846:
2847: IF (l_cc_headers_rec.cc_type = 'C') OR (l_cc_headers_rec.cc_type = 'S')
2848: THEN
2849: UPDATE igc_cc_process_data
2850: SET
2851: validation_status = l_validation_Status ,
2852: processed = 'Y'
2853: WHERE request_id = l_request_id1 AND

Line 2859: UPDATE igc_cc_process_data

2855: END IF;
2856:
2857: IF (l_cc_headers_rec.cc_type = 'C')
2858: THEN
2859: UPDATE igc_cc_process_data
2860: SET
2861: validation_status = l_validation_Status ,
2862: processed = 'Y'
2863: WHERE request_id = l_request_id1 AND

Line 2894: FROM igc_cc_process_data

2890:
2891:
2892: SELECT validation_status
2893: INTO l_validation_status
2894: FROM igc_cc_process_data
2895: WHERE request_id = l_request_id1 AND
2896: cc_header_id = p_cc_header_id ;
2897:
2898: IF (l_validation_status = 'P')

Line 2979: UPDATE igc_cc_process_data

2975: /* Update validation status, in temporary table*/
2976:
2977: IF (l_cc_headers_rec.cc_type = 'S')
2978: THEN
2979: UPDATE igc_cc_process_data
2980: SET
2981: reservation_status = l_reservation_Status
2982: WHERE
2983: request_id = l_request_id1 AND

Line 2990: UPDATE igc_cc_process_data

2986:
2987: IF (l_cc_headers_rec.cc_type = 'R')
2988: THEN
2989: /* Update Cover */
2990: UPDATE igc_cc_process_data
2991: SET
2992: reservation_status = l_reservation_Status
2993: WHERE
2994: request_id = l_request_id1 AND

Line 2998: UPDATE igc_cc_process_data

2994: request_id = l_request_id1 AND
2995: cc_header_id = l_cc_headers_rec.parent_header_id ;
2996:
2997: /* Update Relases */
2998: UPDATE igc_cc_process_data
2999: SET
3000: reservation_status = l_reservation_Status
3001: WHERE
3002: request_id = l_request_id1 AND

Line 3024: FROM igc_cc_process_data

3020: l_validate_only := 'Y';
3021:
3022: SELECT validate_only
3023: INTO l_validate_only
3024: FROM igc_cc_process_data
3025: WHERE request_id = l_request_id1 AND
3026: cc_header_id = l_cc_headers_rec.parent_header_id;
3027:
3028:

Line 3152: FROM igc_cc_process_data

3148: l_validate_only := 'Y';
3149:
3150: SELECT validate_only
3151: INTO l_validate_only
3152: FROM igc_cc_process_data
3153: WHERE request_id = l_request_id1 AND
3154: cc_header_id = l_rel_cc_header_id;
3155:
3156: