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 2033: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

2029: l_purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE;
2030: -- l_cc_prov_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_prov_encmbrnc_enable_flag%TYPE;
2031: -- l_cc_conf_enc_enable_flag igc_cc_encmbrnc_ctrls.cc_conf_encmbrnc_enable_flag%TYPE;
2032:
2033: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
2034: l_cc_acct_line_id igc_cc_acct_lines_v.cc_acct_line_id%TYPE;
2035: l_cc_det_pf_line_id igc_cc_det_pf_v.cc_det_pf_line_id%TYPE;
2036: l_budget_dest_flag igc_cc_interface.budget_dest_flag%TYPE;
2037: l_cc_transaction_date igc_cc_interface.cc_transaction_date%TYPE;

Line 2063: l_cc_headers_rec igc_cc_headers%ROWTYPE;

2059: l_org_id NUMBER;
2060: l_sob_id NUMBER;
2061: l_cc_state VARCHAR2(2);
2062:
2063: l_cc_headers_rec igc_cc_headers%ROWTYPE;
2064: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
2065: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
2066: l_cc_interface_rec igc_cc_interface%ROWTYPE;
2067:

Line 2073: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;

2069:
2070: l_currency_code gl_sets_of_books.currency_code%TYPE;
2071: l_error_message VARCHAR2(2000);
2072:
2073: l_cc_apprvl_status_old igc_cc_headers.cc_apprvl_status%TYPE;
2074: l_encumbrance_status_old VARCHAR2(1);
2075: -- bug 2689651, start 1
2076: l_pa_mode VARCHAR2(1);
2077: l_unencumbered_amount NUMBER;

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

2275: FROM igc_cc_det_pf
2276: WHERE cc_det_pf_line_id = l_cc_pmt_fcst_rec.cc_det_pf_line_id;
2277:
2278: -- bug 2689651, start 2
2279: CURSOR c_unencumbered_amount(cp_cc_header_id igc_cc_headers.cc_header_id%TYPE)
2280: IS
2281: SELECT SUM(( IGC_CC_COMP_AMT_PKG.COMPUTE_FUNCTIONAL_AMT(cp_cc_header_id, NVL(cc_det_pf_entered_amt,0) ) -
2282: NVL(cc_det_pf_encmbrnc_amt,0) )) cc_det_pf_unencmbrd_amt
2283: FROM igc_cc_det_pf

Line 2337: FROM igc_cc_headers

2333:
2334: BEGIN
2335: SELECT *
2336: INTO l_cc_headers_rec
2337: FROM igc_cc_headers
2338: WHERE cc_header_id = p_cc_header_id;
2339:
2340: l_cc_apprvl_status_old := l_cc_headers_rec.cc_apprvl_status;
2341: l_encumbrance_status_old := l_cc_headers_rec.cc_encmbrnc_status;

Line 2364: FROM igc_cc_headers

2360: l_cc_headers_rec.last_updated_by := l_update_by;
2361:
2362: SELECT rowid
2363: INTO l_row_id
2364: FROM igc_cc_headers
2365: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
2366:
2367: Header_Wrapper (p_api_version => l_api_version,
2368: p_init_msg_list => FND_API.G_FALSE,

Line 2540: FROM igc_cc_headers

2536: /* begin fix for bug 1567120 */
2537: BEGIN
2538: SELECT *
2539: INTO l_cc_headers_rec
2540: FROM igc_cc_headers
2541: WHERE cc_header_id = p_cc_header_id;
2542: EXCEPTION
2543: WHEN OTHERS THEN
2544: fnd_message.set_name('IGC', 'IGC_CC_NOT_FOUND');

Line 2561: FROM igc_cc_headers

2557: l_cc_headers_rec.last_updated_by := l_update_by;
2558:
2559: SELECT rowid
2560: INTO l_row_id
2561: FROM igc_cc_headers
2562: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
2563:
2564: Header_Wrapper (p_api_version => l_api_version,
2565: p_init_msg_list => FND_API.G_FALSE,

Line 3253: FROM igc_cc_headers

3249: END IF;
3250:
3251: SELECT rowid
3252: INTO l_row_id
3253: FROM igc_cc_headers
3254: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3255:
3256: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3257: IF (g_debug_mode = 'Y') THEN

Line 3549: FROM igc_cc_headers

3545: l_cc_headers_rec.last_updated_by := l_update_by;
3546:
3547: SELECT rowid
3548: INTO l_row_id
3549: FROM igc_cc_headers
3550: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3551:
3552: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
3553: IF (g_debug_mode = 'Y') THEN

Line 3602: FROM igc_cc_headers

3598: l_cc_headers_rec.last_updated_by := l_update_by;
3599:
3600: SELECT rowid
3601: INTO l_row_id
3602: FROM igc_cc_headers
3603: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3604:
3605: Header_Wrapper (p_api_version => l_api_version,
3606: p_init_msg_list => FND_API.G_FALSE,

Line 3712: FROM igc_cc_headers

3708: l_cc_headers_rec.last_updated_by := l_update_by;
3709:
3710: SELECT rowid
3711: INTO l_row_id
3712: FROM igc_cc_headers
3713: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3714:
3715: Header_Wrapper (p_api_version => l_api_version,
3716: p_init_msg_list => FND_API.G_FALSE,

Line 3777: FROM igc_cc_headers

3773: l_cc_headers_rec.last_updated_by := l_update_by;
3774:
3775: SELECT rowid
3776: INTO l_row_id
3777: FROM igc_cc_headers
3778: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3779:
3780: Header_Wrapper (p_api_version => l_api_version,
3781: p_init_msg_list => FND_API.G_FALSE,

Line 3846: FROM igc_cc_headers

3842: l_cc_headers_rec.last_updated_by := l_update_by;
3843:
3844: SELECT rowid
3845: INTO l_row_id
3846: FROM igc_cc_headers
3847: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3848:
3849: Header_Wrapper (p_api_version => l_api_version,
3850: p_init_msg_list => FND_API.G_FALSE,

Line 3910: FROM igc_cc_headers

3906: l_cc_headers_rec.last_updated_by := l_update_by;
3907:
3908: SELECT rowid
3909: INTO l_row_id
3910: FROM igc_cc_headers
3911: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
3912:
3913: Header_Wrapper (p_api_version => l_api_version,
3914: p_init_msg_list => FND_API.G_FALSE,

Line 4189: l_cc_headers_rec igc_cc_headers%ROWTYPE;

4185: IS
4186: l_api_name CONSTANT VARCHAR2(30) := 'Set_Encumbrance_Status';
4187: l_api_version CONSTANT NUMBER := 1.0;
4188:
4189: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4190: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4191: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4192:
4193: l_error_message VARCHAR2(2000);

Line 4213: l_header_rec igc_cc_headers%ROWTYPE;

4209: -- the table wrappers. These record definitions are NOT the same as the
4210: -- ones above when getting data from the views.
4211: -- -------------------------------------------------------------------------
4212: l_det_pf_rec igc_cc_det_pf%ROWTYPE;
4213: l_header_rec igc_cc_headers%ROWTYPE;
4214: l_acct_line_rec igc_cc_acct_lines%ROWTYPE;
4215:
4216: e_cc_not_found EXCEPTION;
4217: e_invalid_status_code EXCEPTION;

Line 4403: FROM igc_cc_headers

4399: BEGIN
4400:
4401: SELECT *
4402: INTO l_cc_headers_rec
4403: FROM igc_cc_headers
4404: WHERE cc_header_id = p_cc_header_id;
4405:
4406: EXCEPTION
4407:

Line 4541: FROM igc_cc_headers

4537: l_cc_headers_rec.last_updated_by := l_update_by;
4538:
4539: SELECT rowid
4540: INTO l_row_id
4541: FROM igc_cc_headers
4542: WHERE cc_header_id = l_cc_headers_rec.cc_header_id;
4543:
4544: Header_Wrapper (p_api_version => l_api_version,
4545: p_init_msg_list => FND_API.G_FALSE,

Line 4678: l_cc_headers_rec igc_cc_headers%ROWTYPE;

4674: )
4675: IS
4676: l_api_name CONSTANT VARCHAR2(30) := 'Validate_CC';
4677: l_api_version CONSTANT NUMBER := 1.0;
4678: l_cc_headers_rec igc_cc_headers%ROWTYPE;
4679: l_cc_acct_lines_rec igc_cc_acct_lines_v%ROWTYPE;
4680: l_cc_det_pf_lines_rec igc_cc_det_pf_v%ROWTYPE;
4681: l_cc_pmt_fcst_rec igc_cc_det_pf_v%ROWTYPE;
4682: l_cc_acct_cnt NUMBER := 0;

Line 5062: FROM igc_cc_headers cch

5058: l_min_rel_start_date := NULL;
5059: BEGIN
5060: SELECT MIN(cch.cc_start_date)
5061: INTO l_min_rel_start_date
5062: FROM igc_cc_headers cch
5063: WHERE cch.parent_header_id = p_cc_header_id;
5064: EXCEPTION
5065: WHEN NO_DATA_FOUND THEN
5066: l_min_rel_start_date := NULL;

Line 5088: FROM igc_cc_headers cch

5084: l_cover_start_date := NULL;
5085: BEGIN
5086: SELECT cch.cc_start_date
5087: INTO l_cover_start_date
5088: FROM igc_cc_headers cch
5089: WHERE cch.cc_header_id = p_parent_cc_header_id;
5090: EXCEPTION
5091: WHEN NO_DATA_FOUND THEN
5092: l_cover_start_date := NULL;

Line 5141: FROM igc_cc_headers cch

5137: l_max_rel_end_date := NULL;
5138: BEGIN
5139: SELECT MAX(cch.cc_end_date)
5140: INTO l_max_rel_end_date
5141: FROM igc_cc_headers cch
5142: WHERE cch.parent_header_id = p_cc_header_id;
5143: EXCEPTION
5144: WHEN NO_DATA_FOUND THEN
5145: l_max_rel_end_date := NULL;

Line 5165: FROM igc_cc_headers cch

5161: l_cover_end_date := NULL;
5162: BEGIN
5163: SELECT cch.cc_end_date
5164: INTO l_cover_end_date
5165: FROM igc_cc_headers cch
5166: WHERE cch.cc_header_id = p_parent_cc_header_id;
5167: EXCEPTION
5168: WHEN NO_DATA_FOUND THEN
5169: l_cover_end_date := NULL;

Line 5706: FROM igc_cc_headers

5702: -- performed.
5703: BEGIN
5704: SELECT *
5705: INTO l_cc_headers_rec
5706: FROM igc_cc_headers
5707: WHERE cc_header_id = p_cc_header_id;
5708: EXCEPTION
5709: WHEN no_data_found THEN
5710: x_valid_cc := FND_API.G_FALSE;

Line 5830: FROM igc_cc_headers

5826: -- performed.
5827: BEGIN
5828: SELECT *
5829: INTO l_cc_headers_rec
5830: FROM igc_cc_headers
5831: WHERE cc_header_id = p_cc_header_id;
5832: EXCEPTION
5833: WHEN no_data_found THEN
5834: x_valid_cc := FND_API.G_FALSE;

Line 6175: FROM igc_cc_headers

6171:
6172: BEGIN
6173: SELECT *
6174: INTO l_cc_headers_rec
6175: FROM igc_cc_headers
6176: WHERE cc_header_id = p_cc_header_id;
6177: EXCEPTION
6178: WHEN no_data_found THEN
6179: x_valid_cc := FND_API.G_FALSE;