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_HEADERS

Line 288: l_cc_num igc_cc_headers.cc_num%TYPE;

284: IS
285: l_lock_cc BOOLEAN;
286: l_lock_po BOOLEAN;
287: l_message igc_cc_process_exceptions.exception_reason%TYPE;
288: l_cc_num igc_cc_headers.cc_num%TYPE;
289: BEGIN
290:
291: --GSCC Warnings Fixed
292:

Line 309: FROM igc_cc_headers

305: -- bug 3199488, end block
306:
307: SELECT cc_num
308: INTO l_cc_num
309: FROM igc_cc_headers
310: WHERE cc_header_id = p_cc_header_id;
311:
312: l_lock_cc := TRUE;
313: l_lock_po := TRUE;

Line 433: l_cc_headers_rec igc_cc_headers%ROWTYPE;

429: )
430: RETURN VARCHAR2
431: IS
432:
433: l_cc_headers_rec igc_cc_headers%ROWTYPE;
434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
437:

Line 434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;

430: RETURN VARCHAR2
431: IS
432:
433: l_cc_headers_rec igc_cc_headers%ROWTYPE;
434: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
435: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
436: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
437:
438: l_exception igc_cc_process_exceptions.exception_reason%TYPE;

Line 600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;

596: l_Last_Updated_By NUMBER;
597: l_Last_Update_Login NUMBER;
598: l_Created_By NUMBER;
599:
600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
601: l_conversion_date igc_cc_headers.conversion_date%TYPE;
602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;

Line 601: l_conversion_date igc_cc_headers.conversion_date%TYPE;

597: l_Last_Update_Login NUMBER;
598: l_Created_By NUMBER;
599:
600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
601: l_conversion_date igc_cc_headers.conversion_date%TYPE;
602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:

Line 602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;

598: l_Created_By NUMBER;
599:
600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
601: l_conversion_date igc_cc_headers.conversion_date%TYPE;
602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;

Line 603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;

599:
600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
601: l_conversion_date igc_cc_headers.conversion_date%TYPE;
602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;

Line 604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;

600: l_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
601: l_conversion_date igc_cc_headers.conversion_date%TYPE;
602: l_conversion_rate igc_cc_headers.conversion_rate%TYPE;
603: l_cc_version_num igc_cc_headers.cc_version_num%TYPE;
604: l_cc_apprvl_status igc_cc_headers.cc_apprvl_status%TYPE;
605:
606: l_cc_acct_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
607: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
608: l_cc_acct_encmbrnc_amt igc_cc_acct_lines.cc_acct_encmbrnc_amt%TYPE ;

Line 644: FROM igc_cc_headers

640: -- bug 3199488, end block
641:
642: SELECT *
643: INTO l_cc_headers_rec
644: FROM igc_cc_headers
645: WHERE cc_header_id = p_cc_header_id;
646:
647:
648: SELECT old_approval_status

Line 1217: FROM igc_cc_headers

1213: l_cc_apprvl_status := l_approval_status;
1214:
1215: SELECT rowid
1216: INTO l_hdr_row_id
1217: FROM igc_cc_headers
1218: WHERE CC_HEADER_ID = l_cc_headers_rec.cc_header_id;
1219:
1220: IGC_CC_HEADERS_PKG.Update_Row(
1221: l_api_version,

Line 1220: IGC_CC_HEADERS_PKG.Update_Row(

1216: INTO l_hdr_row_id
1217: FROM igc_cc_headers
1218: WHERE CC_HEADER_ID = l_cc_headers_rec.cc_header_id;
1219:
1220: IGC_CC_HEADERS_PKG.Update_Row(
1221: l_api_version,
1222: l_init_msg_list,
1223: l_commit,
1224: l_validation_level,

Line 1310: UPDATE igc_cc_headers

1306:
1307:
1308: ELSIF (p_validate_only = 'Y')
1309: THEN
1310: UPDATE igc_cc_headers
1311: SET cc_apprvl_status = l_approval_status
1312: WHERE cc_header_id = p_cc_header_id;
1313: END IF;
1314:

Line 1557: FROM igc_cc_headers b,

1553: l_message,
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

Line 1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;

1584: p_rate_date IN VARCHAR2,
1585: p_rate IN VARCHAR2,
1586: p_cc_header_id IN NUMBER)
1587: IS
1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

Line 1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;

1585: p_rate IN VARCHAR2,
1586: p_cc_header_id IN NUMBER)
1587: IS
1588: l_cc_headers_rec igc_cc_headers%ROWTYPE;
1589: l_rel_cc_headers_rec igc_cc_headers%ROWTYPE;
1590: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1591: l_rel_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
1592: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
1593: l_rel_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;

Line 1676: FROM igc_cc_headers a

1672: p_cc_header_id NUMBER)
1673: IS
1674:
1675: SELECT *
1676: FROM igc_cc_headers a
1677: WHERE
1678: ( (a.cc_state = 'PR') OR
1679: (a.cc_state = 'CM') OR
1680: ( (a.cc_state = 'CT') AND (a.cc_apprvl_status <> 'AP')) OR

Line 1697: FROM igc_cc_headers b

1693: ( (a.cc_type = 'C') OR
1694: (a.cc_type = 'S') OR
1695: ( (a.cc_type = 'R') AND
1696: EXISTS (SELECT 'x'
1697: FROM igc_cc_headers b
1698: WHERE b.cc_header_id = NVL(a.parent_header_id,0) AND
1699: b.currency_code = p_func_currency_code)
1700: )
1701: )

Line 1725: igc_cc_headers b

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 */
1729: a.validation_status = 'I' AND

Line 1739: igc_cc_headers b

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 */
1743: (a.validation_status = 'I' OR a.validation_status = 'P') AND

Line 1750: FROM igc_cc_headers

1746:
1747: CURSOR C_ALL_RELEASES1(p_cc_header_id NUMBER)
1748: IS
1749: SELECT *
1750: FROM igc_cc_headers
1751: WHERE NVL(parent_header_id,0) = p_cc_header_id;
1752:
1753: CURSOR C_ALL_RELEASES(p_cc_header_id NUMBER)
1754: IS

Line 1756: FROM igc_cc_headers a

1752:
1753: CURSOR C_ALL_RELEASES(p_cc_header_id NUMBER)
1754: IS
1755: SELECT a.cc_header_id
1756: FROM igc_cc_headers a
1757: WHERE NVL(a.parent_header_id,0) = p_cc_header_id;
1758:
1759: CURSOR C_RELEASES(p_cc_header_id NUMBER,
1760: p_currency_code VARCHAR2,

Line 1764: FROM igc_cc_headers a

1760: p_currency_code VARCHAR2,
1761: p_rate_type VARCHAR2)
1762: IS
1763: SELECT a.cc_header_id
1764: FROM igc_cc_headers a
1765: WHERE NVL(a.parent_header_id,0) = p_cc_header_id AND
1766: a.currency_code = p_currency_code AND
1767: a.conversion_type = p_rate_type ;
1768:

Line 1902: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

1898: AND ccdpf.cc_det_pf_entered_amt <> IGC_CC_COMP_AMT_PKG.COMPUTE_PF_BILLED_AMT(ccdpf.cc_det_pf_line_id,ccdpf.cc_det_pf_line_num,
1899: ccdpf.cc_acct_line_id); -- Bug 3856265
1900:
1901:
1902: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1903: l_rel_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1904: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
1905:
1906: insert_data EXCEPTION;

Line 1903: l_rel_cc_header_id igc_cc_headers.cc_header_id%TYPE;

1899: ccdpf.cc_acct_line_id); -- Bug 3856265
1900:
1901:
1902: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1903: l_rel_cc_header_id igc_cc_headers.cc_header_id%TYPE;
1904: l_cc_acct_line_id igc_cc_acct_lines.cc_acct_line_id%TYPE;
1905:
1906: insert_data EXCEPTION;
1907: BEGIN

Line 2765: FROM igc_cc_headers

2761:
2762: /* Get Contract Details */
2763: SELECT *
2764: INTO l_cc_headers_rec
2765: FROM igc_cc_headers
2766: WHERE cc_header_id = l_cc_header_id;
2767:
2768: l_lock_cc_po := TRUE;
2769:

Line 2951: FROM igc_cc_headers

2947: validation_status = 'F' ,
2948: processed = 'Y'
2949: WHERE request_id = l_request_id1 AND
2950: cc_header_id IN (SELECT cc_header_id
2951: FROM igc_cc_headers
2952: WHERE NVL(parent_header_id,0) = l_cc_header_id);
2953: /* bug 1622969 */
2954: END IF;
2955:

Line 3009: FROM igc_cc_headers

3005:
3006: /* Get Contract Details */
3007: SELECT *
3008: INTO l_cc_headers_rec
3009: FROM igc_cc_headers
3010: WHERE cc_header_id = l_cc_header_id;
3011:
3012: -- IF l_debug_mode = 'Y' THEN
3013: -- Output_Debug (' IGCCREPB -- Getting account lines ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

Line 3050: igc_cc_headers b

3046: BEGIN
3047: SELECT NVL(SUM(NVL(CC_ACCT_FUNC_AMT,0)),0)
3048: INTO l_non_reval_acct_amt_total
3049: FROM igc_cc_acct_lines a,
3050: igc_cc_headers b
3051: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3052: a.cc_header_id = b.cc_header_id AND
3053: NVL(b.parent_header_id,0) = l_cc_header_id AND
3054: b.cc_header_id <> p_cc_header_id;

Line 3085: igc_cc_headers b

3081: )
3082: INTO l_reval_acct_amt_total
3083: --FROM igc_cc_acct_lines_v a,
3084: FROM igc_cc_acct_lines a,
3085: igc_cc_headers b
3086: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3087: a.cc_header_id = b.cc_header_id AND
3088: b.cc_header_id = p_cc_header_id;
3089: EXCEPTION

Line 3135: igc_cc_headers b

3131: BEGIN
3132: SELECT NVL(SUM(NVL(CC_ACCT_FUNC_AMT,0)),0)
3133: INTO l_non_reval_acct_amt_total
3134: FROM igc_cc_acct_lines a,
3135: igc_cc_headers b
3136: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3137: a.cc_header_id = b.cc_header_id AND
3138: NVL(b.parent_header_id,0) = l_cc_header_id AND
3139: ( (b.currency_code = p_currency_code AND b.conversion_type <> p_rate_type) OR

Line 3171: igc_cc_headers b

3167: )
3168: INTO l_reval_acct_amt_total
3169: --FROM igc_cc_acct_lines_v a,
3170: FROM igc_cc_acct_lines a,
3171: igc_cc_headers b
3172: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3173: a.cc_header_id = b.cc_header_id AND
3174: NVL(b.parent_header_id,0) = l_cc_header_id AND
3175: ( (b.currency_code = p_currency_code) AND

Line 3216: igc_cc_headers b

3212: BEGIN
3213: SELECT SUM(NVL(CC_ACCT_FUNC_AMT,0))
3214: INTO l_non_reval_acct_amt_total
3215: FROM igc_cc_acct_lines a,
3216: igc_cc_headers b
3217: WHERE NVL(parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3218: NVL(b.parent_header_id,0) = l_cc_header_id AND
3219: a.cc_header_id = b.cc_header_id AND
3220: ( (b.currency_code = p_currency_code AND b.conversion_type <> p_rate_type) OR

Line 3252: igc_cc_headers b

3248: )
3249: INTO l_reval_acct_amt_total
3250: --FROM igc_cc_acct_lines_v a,
3251: FROM igc_cc_acct_lines a,
3252: igc_cc_headers b
3253: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3254: a.cc_header_id = b.cc_header_id AND
3255: ( (b.currency_code = p_currency_code) AND
3256: ( b.conversion_type = p_rate_type));

Line 3344: igc_cc_headers c

3340: SELECT NVL(SUM(NVL(CC_DET_PF_FUNC_AMT,0)),0)
3341: INTO l_non_reval_pf_amt_total
3342: FROM igc_cc_det_pf a,
3343: igc_cc_acct_lines b,
3344: igc_cc_headers c
3345: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3346: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3347: a.cc_acct_line_id = b.cc_acct_line_id AND
3348: b.cc_header_id = c.cc_header_id AND

Line 3385: igc_cc_headers c

3381: )
3382: INTO l_reval_pf_amt_total
3383: FROM igc_cc_det_pf a,
3384: igc_cc_acct_lines b,
3385: igc_cc_headers c
3386: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3387: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3388: a.cc_acct_line_id = b.cc_acct_line_id AND
3389: b.cc_header_id = c.cc_header_id AND

Line 3431: igc_cc_headers c

3427: SELECT SUM(NVL(CC_DET_PF_FUNC_AMT,0))
3428: INTO l_non_reval_pf_amt_total
3429: FROM igc_cc_det_pf a,
3430: igc_cc_acct_lines b,
3431: igc_cc_headers c
3432: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3433: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3434: NVL(c.parent_header_id,0) = l_cc_header_id AND
3435: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3473: igc_cc_headers c

3469: )
3470: INTO l_reval_pf_amt_total
3471: FROM igc_cc_det_pf a,
3472: igc_cc_acct_lines b,
3473: igc_cc_headers c
3474: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3475: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3476: NVL(c.parent_header_id,0) = l_cc_header_id AND
3477: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3524: igc_cc_headers c

3520: SELECT NVL(SUM(NVL(CC_DET_PF_FUNC_AMT,0)),0)
3521: INTO l_non_reval_pf_amt_total
3522: FROM igc_cc_det_pf a,
3523: igc_cc_acct_lines b,
3524: igc_cc_headers c
3525: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3526: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3527: NVL(c.parent_header_id,0) = l_cc_header_id AND
3528: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3566: igc_cc_headers c

3562: )
3563: INTO l_reval_pf_amt_total
3564: FROM igc_cc_det_pf a,
3565: igc_cc_acct_lines b,
3566: igc_cc_headers c
3567: WHERE NVL(a.parent_acct_line_id,0) = l_cc_acct_lines_rec.cc_acct_line_id AND
3568: NVL(a.parent_det_pf_line_id,0) = l_cc_pmt_fcst_rec.cc_det_pf_line_id AND
3569: NVL(c.parent_header_id,0) = l_cc_header_id AND
3570: a.cc_acct_line_id = b.cc_acct_line_id AND

Line 3682: FROM igc_cc_headers

3678:
3679: /* Get Contract Details */
3680: SELECT *
3681: INTO l_cc_headers_rec
3682: FROM igc_cc_headers
3683: WHERE cc_header_id = l_cc_header_id;
3684:
3685: l_validation_status := 'P';
3686:

Line 3797: FROM igc_cc_headers

3793: processed = 'Y'
3794: WHERE
3795: request_id = l_request_id1 AND
3796: cc_header_id IN (SELECT cc_header_id
3797: FROM igc_cc_headers
3798: WHERE NVL(parent_header_id,0) = l_cc_header_id);
3799:
3800: END IF;
3801:

Line 3896: UPDATE igc_cc_headers

3892: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg71',
3893: ' IGCCREPB -- Updating Headers table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3894: END IF;
3895: -- bug 3199488, end block
3896: UPDATE igc_cc_headers
3897: SET cc_apprvl_status = 'IP'
3898: WHERE cc_header_id = l_cc_header_id;
3899: END IF;
3900:

Line 4031: UPDATE igc_cc_headers

4027: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg79',' IGCCREPB -- Update Header data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4028: END IF;
4029: -- bug 3199488, end block
4030:
4031: UPDATE igc_cc_headers
4032: SET cc_apprvl_status = 'IP'
4033: WHERE cc_header_id = l_rel_cc_headers_rec.cc_header_id ;
4034:
4035: l_po_count := 0;

Line 4153: FROM igc_cc_headers

4149: validation_status = l_validation_Status ,
4150: processed = 'Y'
4151: WHERE request_id = l_request_id1 AND
4152: cc_header_id IN (SELECT cc_header_id
4153: FROM igc_cc_headers
4154: WHERE NVL(parent_header_id,0) = l_cc_header_id);
4155: END IF;
4156:
4157: END IF;

Line 4212: FROM igc_cc_headers

4208: EXIT WHEN c_reval_data%NOTFOUND;
4209:
4210: SELECT *
4211: INTO l_cc_headers_rec
4212: FROM igc_cc_headers
4213: WHERE cc_header_id = l_cc_header_id;
4214:
4215:
4216: SELECT validation_status

Line 4286: UPDATE igc_cc_headers

4282: END IF;
4283: -- bug 3199488, end block
4284:
4285: -- fix bug 2124590 start 1
4286: UPDATE igc_cc_headers
4287: SET cc_version_num = cc_version_num + 1
4288: WHERE cc_header_id = l_cc_header_id;
4289:
4290: COMMIT;

Line 4315: UPDATE igc_cc_headers

4311: p_rate => l_rate,
4312: p_revalue_fix_date => NULL );
4313:
4314: -- fix bug 2124590 start 2
4315: UPDATE igc_cc_headers
4316: SET cc_version_num = cc_version_num - 1
4317: WHERE cc_header_id = l_cc_header_id;
4318:
4319: COMMIT;

Line 4342: update igc_cc_headers

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
4343: set cc_apprvl_status = l_approval_status
4344: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
4345:
4346:

Line 4427: FROM igc_cc_headers

4423: reservation_status = l_reservation_Status
4424: WHERE
4425: request_id = l_request_id1 AND
4426: cc_header_id IN (SELECT cc_header_id
4427: FROM igc_cc_headers
4428: WHERE NVL(parent_header_id,0) = l_cc_header_id);
4429: END IF;
4430:
4431: COMMIT;