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_BUDGETARY_CTRL_PKG dependencies on IGC_CC_HEADERS

Line 77: p_cc_header_rec IN igc_cc_headers%ROWTYPE,

73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: x_rowid IN OUT NOCOPY VARCHAR2,
76: p_action_flag IN VARCHAR2,
77: p_cc_header_rec IN igc_cc_headers%ROWTYPE,
78: p_update_flag IN OUT NOCOPY VARCHAR2
79: );
80:
81:

Line 376: p_cc_header_rec IN igc_cc_headers%ROWTYPE,

372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: x_rowid IN OUT NOCOPY VARCHAR2,
375: p_action_flag IN VARCHAR2,
376: p_cc_header_rec IN igc_cc_headers%ROWTYPE,
377: p_update_flag IN OUT NOCOPY VARCHAR2
378: ) IS
379:
380: l_api_name CONSTANT VARCHAR2(30) := 'Header_Wrapper';

Line 394: IGC_CC_HEADERS_PKG.Update_Row (

390: -- Make sure that the action requested to be performed is to UPDATE a row.
391: -- ---------------------------------------------------------------------------------
392: IF (p_action_flag = 'U') THEN
393:
394: IGC_CC_HEADERS_PKG.Update_Row (
395: p_api_version,
396: p_init_msg_list,
397: p_commit,
398: p_validation_level,

Line 510: l_cc_headers_rec igc_cc_headers%ROWTYPE;

506: IS
507: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Rel_Budgetary_Ctrl';
508: l_api_version CONSTANT NUMBER := 1.0;
509:
510: l_cc_headers_rec igc_cc_headers%ROWTYPE;
511: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
512: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
513:
514: l_transaction_date DATE;

Line 714: FROM igc_cc_headers

710: l_update_by := FND_GLOBAL.USER_ID;
711:
712: SELECT *
713: INTO l_cc_headers_rec
714: FROM igc_cc_headers
715: WHERE cc_header_id = p_cc_header_id;
716:
717: IF ( (l_cc_headers_rec.cc_state = 'PR') OR (l_cc_headers_rec.cc_state = 'CL') )
718: THEN

Line 1160: FROM igc_cc_headers

1156: END IF;
1157:
1158: SELECT rowid
1159: INTO l_row_id
1160: FROM igc_cc_headers
1161: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
1162:
1163: l_cc_headers_rec.cc_acct_date := p_accounting_date;
1164:

Line 1429: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,

1425:
1426:
1427: PROCEDURE Process_Interface_Row(
1428: p_currency_code IN VARCHAR2,
1429: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
1430: p_cc_acct_lines_rec IN igc_cc_acct_lines_v%ROWTYPE,
1431: p_cc_pmt_fcst_rec IN igc_cc_det_pf_v%ROWTYPE,
1432: p_mode IN VARCHAR2,
1433: p_type IN VARCHAR2,

Line 2091: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

2087: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2088: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2089: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2090:
2091: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2092: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;
2093: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2094: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2095: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;

Line 2121: l_cc_headers_rec igc_cc_headers%ROWTYPE;

2117: l_org_id NUMBER;
2118: l_sob_id NUMBER;
2119: l_cc_state VARCHAR2(2);
2120:
2121: l_cc_headers_rec igc_cc_headers%ROWTYPE;
2122: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
2123: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
2124: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2125:

Line 2131: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;

2127:
2128: l_currency_code gl_sets_of_books.currency_code%TYPE;
2129: l_error_message VARCHAR2(2000);
2130:
2131: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;
2132: l_encumbrance_status_old VARCHAR2(1);
2133: -- bug 2689651, start 1
2134: l_pa_mode VARCHAR2(1);
2135: l_unencumbered_amount NUMBER;

Line 2337: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)

2333: FROM igc_cc_det_pf
2334: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
2335:
2336: -- bug 2689651, start 2
2337: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)
2338: IS
2339: SELECT SUM(( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(cp_cc_header_id, NVL(cc_det_pf_entered_amt,0) ) -
2340: NVL(cc_det_pf_encmbrnc_amt,0) )) cc_det_pf_unencmbrd_amt
2341: FROM igc_cc_det_pf

Line 2395: FROM igc_cc_headers

2391:
2392: BEGIN
2393: SELECT *
2394: INTO l_cc_headers_rec
2395: FROM igc_cc_headers
2396: WHERE cc_header_id = p_cc_header_id;
2397:
2398: l_cc_apprvl_status_old := l_cc_headers_rec.cc_apprvl_status;
2399: l_encumbrance_status_old := l_cc_headers_rec.cc_encmbrnc_status;

Line 2422: FROM igc_cc_headers

2418: l_cc_headers_rec.last_updated_by := l_update_by;
2419:
2420: SELECT rowid
2421: INTO l_row_id
2422: FROM igc_cc_headers
2423: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
2424:
2425: Header_Wrapper (p_api_version => l_api_version,
2426: p_init_msg_list => FND_API.G_FALSE,

Line 2598: FROM igc_cc_headers

2594: /* begin fix for bug 1567120 */
2595: BEGIN
2596: SELECT *
2597: INTO l_cc_headers_rec
2598: FROM igc_cc_headers
2599: WHERE cc_header_id = p_cc_header_id;
2600: EXCEPTION
2601: WHEN OTHERS THEN
2602: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

Line 2619: FROM igc_cc_headers

2615: l_cc_headers_rec.last_updated_by := l_update_by;
2616:
2617: SELECT rowid
2618: INTO l_row_id
2619: FROM igc_cc_headers
2620: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
2621:
2622: Header_Wrapper (p_api_version => l_api_version,
2623: p_init_msg_list => FND_API.G_FALSE,

Line 3311: FROM igc_cc_headers

3307: END IF;
3308:
3309: SELECT rowid
3310: INTO l_row_id
3311: FROM igc_cc_headers
3312: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3313:
3314: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3315: IF (g_debug_mode = 'Y') THEN

Line 3607: FROM igc_cc_headers

3603: l_cc_headers_rec.last_updated_by := l_update_by;
3604:
3605: SELECT rowid
3606: INTO l_row_id
3607: FROM igc_cc_headers
3608: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3609:
3610: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3611: IF (g_debug_mode = 'Y') THEN

Line 3660: FROM igc_cc_headers

3656: l_cc_headers_rec.last_updated_by := l_update_by;
3657:
3658: SELECT rowid
3659: INTO l_row_id
3660: FROM igc_cc_headers
3661: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3662:
3663: Header_Wrapper (p_api_version => l_api_version,
3664: p_init_msg_list => FND_API.G_FALSE,

Line 3770: FROM igc_cc_headers

3766: l_cc_headers_rec.last_updated_by := l_update_by;
3767:
3768: SELECT rowid
3769: INTO l_row_id
3770: FROM igc_cc_headers
3771: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3772:
3773: Header_Wrapper (p_api_version => l_api_version,
3774: p_init_msg_list => FND_API.G_FALSE,

Line 3835: FROM igc_cc_headers

3831: l_cc_headers_rec.last_updated_by := l_update_by;
3832:
3833: SELECT rowid
3834: INTO l_row_id
3835: FROM igc_cc_headers
3836: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3837:
3838: Header_Wrapper (p_api_version => l_api_version,
3839: p_init_msg_list => FND_API.G_FALSE,

Line 3904: FROM igc_cc_headers

3900: l_cc_headers_rec.last_updated_by := l_update_by;
3901:
3902: SELECT rowid
3903: INTO l_row_id
3904: FROM igc_cc_headers
3905: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3906:
3907: Header_Wrapper (p_api_version => l_api_version,
3908: p_init_msg_list => FND_API.G_FALSE,

Line 3968: FROM igc_cc_headers

3964: l_cc_headers_rec.last_updated_by := l_update_by;
3965:
3966: SELECT rowid
3967: INTO l_row_id
3968: FROM igc_cc_headers
3969: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3970:
3971: Header_Wrapper (p_api_version => l_api_version,
3972: p_init_msg_list => FND_API.G_FALSE,

Line 4247: l_cc_headers_rec igc_cc_headers%ROWTYPE;

4243: IS
4244: l_api_name CONSTANT VARCHAR2(30) := 'Set_Encumbrance_Status';
4245: l_api_version CONSTANT NUMBER := 1.0;
4246:
4247: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4248: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4249: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4250:
4251: l_error_message VARCHAR2(2000);

Line 4271: l_header_rec igc_cc_headers%ROWTYPE;

4267: -- the table wrappers. These record definitions are NOT the same as the
4268: -- ones above when getting data from the views.
4269: -- -------------------------------------------------------------------------
4270: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
4271: l_header_rec igc_cc_headers%ROWTYPE;
4272: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
4273:
4274: e_cc_not_found EXCEPTION;
4275: e_invalid_status_code EXCEPTION;

Line 4461: FROM igc_cc_headers

4457: BEGIN
4458:
4459: SELECT *
4460: INTO l_cc_headers_rec
4461: FROM igc_cc_headers
4462: WHERE cc_header_id = p_cc_header_id;
4463:
4464: EXCEPTION
4465:

Line 4599: FROM igc_cc_headers

4595: l_cc_headers_rec.last_updated_by := l_update_by;
4596:
4597: SELECT rowid
4598: INTO l_row_id
4599: FROM igc_cc_headers
4600: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
4601:
4602: Header_Wrapper (p_api_version => l_api_version,
4603: p_init_msg_list => FND_API.G_FALSE,

Line 4736: l_cc_headers_rec igc_cc_headers%ROWTYPE;

4732: )
4733: IS
4734: l_api_name CONSTANT VARCHAR2(30) := 'Validate_CC';
4735: l_api_version CONSTANT NUMBER := 1.0;
4736: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4737: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4738: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4739: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4740: l_cc_acct_cnt NUMBER := 0;

Line 5120: FROM igc_cc_headers cch

5116: l_min_rel_start_date := NULL;
5117: BEGIN
5118: SELECT MIN(cch.cc_start_date)
5119: INTO l_min_rel_start_date
5120: FROM igc_cc_headers cch
5121: WHERE cch.parent_header_id = p_cc_header_id;
5122: EXCEPTION
5123: WHEN NO_DATA_FOUND THEN
5124: l_min_rel_start_date := NULL;

Line 5146: FROM igc_cc_headers cch

5142: l_cover_start_date := NULL;
5143: BEGIN
5144: SELECT cch.cc_start_date
5145: INTO l_cover_start_date
5146: FROM igc_cc_headers cch
5147: WHERE cch.cc_header_id = p_parent_cc_header_id;
5148: EXCEPTION
5149: WHEN NO_DATA_FOUND THEN
5150: l_cover_start_date := NULL;

Line 5199: FROM igc_cc_headers cch

5195: l_max_rel_end_date := NULL;
5196: BEGIN
5197: SELECT MAX(cch.cc_end_date)
5198: INTO l_max_rel_end_date
5199: FROM igc_cc_headers cch
5200: WHERE cch.parent_header_id = p_cc_header_id;
5201: EXCEPTION
5202: WHEN NO_DATA_FOUND THEN
5203: l_max_rel_end_date := NULL;

Line 5223: FROM igc_cc_headers cch

5219: l_cover_end_date := NULL;
5220: BEGIN
5221: SELECT cch.cc_end_date
5222: INTO l_cover_end_date
5223: FROM igc_cc_headers cch
5224: WHERE cch.cc_header_id = p_parent_cc_header_id;
5225: EXCEPTION
5226: WHEN NO_DATA_FOUND THEN
5227: l_cover_end_date := NULL;

Line 5764: FROM igc_cc_headers

5760: -- performed.
5761: BEGIN
5762: SELECT *
5763: INTO l_cc_headers_rec
5764: FROM igc_cc_headers
5765: WHERE cc_header_id = p_cc_header_id;
5766: EXCEPTION
5767: WHEN no_data_found THEN
5768: x_valid_cc := FND_API.G_FALSE;

Line 5888: FROM igc_cc_headers

5884: -- performed.
5885: BEGIN
5886: SELECT *
5887: INTO l_cc_headers_rec
5888: FROM igc_cc_headers
5889: WHERE cc_header_id = p_cc_header_id;
5890: EXCEPTION
5891: WHEN no_data_found THEN
5892: x_valid_cc := FND_API.G_FALSE;

Line 6235: FROM igc_cc_headers

6231:
6232: BEGIN
6233: SELECT *
6234: INTO l_cc_headers_rec
6235: FROM igc_cc_headers
6236: WHERE cc_header_id = p_cc_header_id;
6237: EXCEPTION
6238: WHEN no_data_found THEN
6239: x_valid_cc := FND_API.G_FALSE;