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.

[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BALANCES

Line 3861: FROM gms_balances

3857: WHERE bv.budget_version_id = bc.budget_version_id
3858: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3859: AND bem.entry_level_code = 'M'
3860: AND t.task_id = (SELECT task_id
3861: FROM gms_balances
3862: WHERE budget_version_id = bc.budget_version_id
3863: AND project_id = bc.project_id
3864: AND award_id = bc.award_id
3865: AND task_id = bc.task_id

Line 3885: FROM gms_balances

3881: WHERE bv.budget_version_id = bc.budget_version_id
3882: AND bv.budget_entry_method_code = bem.budget_entry_method_code
3883: AND bem.entry_level_code = 'M'
3884: AND t.task_id = (SELECT task_id
3885: FROM gms_balances
3886: WHERE task_id = (SELECT top_task_id
3887: FROM pa_tasks
3888: WHERE task_id = bc.task_id)
3889: AND budget_version_id = bc.budget_version_id

Line 4155: FROM gms_balances gb

4151: if x_time_phased_type_code = 'R' then
4152:
4153: SELECT MIN (gb.start_date)
4154: INTO l_gb_start_date
4155: FROM gms_balances gb
4156: WHERE gb.budget_version_id = x_budget_version_id ;
4157:
4158: SELECT MAX (gb.END_date)
4159: INTO l_gb_end_date

Line 4160: FROM gms_balances gb

4156: WHERE gb.budget_version_id = x_budget_version_id ;
4157:
4158: SELECT MAX (gb.END_date)
4159: INTO l_gb_end_date
4160: FROM gms_balances gb
4161: WHERE gb.budget_version_id = x_budget_version_id ;
4162:
4163: --
4164: -- BUG 5529930 11I.GMS:QA:PJMRP3B4: FC FAILURE WHEN PROJECT START PRIOR TO BUDGET STAR

Line 4185: FROM gms_balances

4181: IF nvl(g_budget_version_id,0) <> x_budget_version_id THEN -- Bug 2092791
4182:
4183: SELECT MAX (end_date) --Bug Fix 1828613 From
4184: INTO gb_end_date
4185: FROM gms_balances
4186: WHERE budget_version_id = x_budget_version_id;
4187: SELECT MAX (expenditure_item_date)
4188: INTO exp_date
4189: FROM gms_bc_packets

Line 4237: FROM gms_balances

4233: EXCEPTION
4234: WHEN NO_DATA_FOUND THEN
4235: SELECT TRUNC (MAX (end_date))
4236: INTO gs_end_date
4237: FROM gms_balances
4238: WHERE budget_version_id = x_budget_version_id;
4239: END;
4240: IF gs_end_date > project_end_date THEN
4241: project_end_date := gs_end_date;

Line 4257: FROM gms_balances

4253: EXCEPTION
4254: WHEN NO_DATA_FOUND THEN
4255: SELECT TRUNC (MAX (end_date))
4256: INTO gs_end_date
4257: FROM gms_balances
4258: WHERE budget_version_id = x_budget_version_id;
4259: END;
4260: IF gs_end_date > project_end_date THEN
4261: project_end_date := gs_end_date;

Line 4316: FROM gms_balances

4312: SELECT TRUNC (MAX (start_date)),
4313: TRUNC (MIN (end_date))
4314: INTO dr_period_start_date,
4315: dr_period_end_date
4316: FROM gms_balances
4317: WHERE project_id = x_project_id
4318: AND budget_version_id = x_budget_version_id
4319: AND award_id = x_award_id
4320: AND balance_type <> 'BGT'

Line 4327: FROM gms_balances

4323: SELECT TRUNC (MAX (start_date)),
4324: TRUNC (MIN (end_date))
4325: INTO dr_period_start_date,
4326: dr_period_end_date
4327: FROM gms_balances
4328: WHERE project_id = x_project_id
4329: AND budget_version_id = x_budget_version_id
4330: AND award_id = x_award_id
4331: AND balance_type = 'BGT'

Line 4392: FROM gms_balances

4388: EXCEPTION
4389: WHEN NO_DATA_FOUND THEN
4390: SELECT TRUNC (MIN (start_date))
4391: INTO gs_start_date
4392: FROM gms_balances
4393: WHERE project_id = x_project_id
4394: AND award_id = x_award_id
4395: AND budget_version_id = x_budget_version_id
4396: AND balance_type = 'BGT';

Line 4412: FROM gms_balances

4408: EXCEPTION
4409: WHEN NO_DATA_FOUND THEN
4410: SELECT TRUNC (MIN (start_date))
4411: INTO gs_start_date
4412: FROM gms_balances
4413: WHERE project_id = x_project_id
4414: AND award_id = x_award_id
4415: AND budget_version_id = x_budget_version_id
4416: AND balance_type = 'BGT';

Line 4422: FROM gms_balances

4418: ELSIF x_time_phased_type_code = 'R' THEN
4419: g_error_stage := 'PJTD3';
4420: SELECT TRUNC (MIN (start_date))
4421: INTO gs_start_date
4422: FROM gms_balances
4423: WHERE project_id = x_project_id
4424: AND award_id = x_award_id
4425: AND budget_version_id = x_budget_version_id
4426: AND balance_type = 'BGT';

Line 5471: This procedure compares balances from gms_balances table and Records in gms_bc_packets

5467: END gms_setup;
5468:
5469: /* ------------------------------------------------------------------------------------------------------
5470: This Procedure is called in case of Budget Submit and Re-Baseline prcoess of Award Budget.
5471: This procedure compares balances from gms_balances table and Records in gms_bc_packets
5472: for that budget_version_id. If any Record fails, control comes out of the loop and goes
5473: to the exception part where all the values of variable are dumped into the o/p file
5474:
5475: Bug 3681963 : Modified the code of procedure budget_fundscheck consider the previous consumed

Line 5628: FROM gms_balances

5624: IF NVL(x_r_bc_tot,0) <> 0 THEN
5625:
5626: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5627: INTO l_balance_available
5628: FROM gms_balances
5629: WHERE budget_version_id = x_budget_version_id
5630: AND start_date >= x_budget_period_start_date
5631: AND end_date <= x_budget_period_end_date
5632: AND resource_list_member_id = x_res_list_member_id

Line 5682: FROM gms_balances

5678: IF NVL(x_rg_bc_tot,0) <> 0 THEN
5679:
5680: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5681: INTO l_balance_available
5682: FROM gms_balances
5683: WHERE budget_version_id = x_budget_version_id
5684: AND start_date >= x_budget_period_start_date
5685: AND end_date <= x_budget_period_end_date
5686: AND DECODE (

Line 5736: FROM gms_balances

5732: IF NVL(x_t_bc_tot,0) <> 0 THEN
5733:
5734: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5735: INTO l_balance_available
5736: FROM gms_balances
5737: WHERE budget_version_id = x_budget_version_id
5738: AND start_date >= x_budget_period_start_date
5739: AND end_date <= x_budget_period_end_date
5740: AND task_id = x_bud_task_id;

Line 5785: FROM gms_balances

5781: IF NVL(x_tt_bc_tot,0) <> 0 THEN
5782:
5783: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5784: INTO l_balance_available
5785: FROM gms_balances
5786: WHERE budget_version_id = x_budget_version_id
5787: AND start_date >= x_budget_period_start_date
5788: AND end_date <= x_budget_period_end_date
5789: AND DECODE (top_task_id, NULL, task_id, top_task_id) = x_top_task_id;

Line 5834: FROM gms_balances

5830: IF NVL(x_a_bc_tot,0) <> 0 THEN
5831:
5832: SELECT NVL(SUM (NVL (budget_period_to_date, 0)),0)
5833: INTO l_balance_available
5834: FROM gms_balances
5835: WHERE budget_version_id = x_budget_version_id
5836: AND start_date >= x_budget_period_start_date
5837: AND end_date <= x_budget_period_end_date;
5838:

Line 6143: FROM gms_balances gb

6139: SET (bp.res_budget_posted, bp.res_actual_posted, bp.res_enc_posted) =
6140: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6141: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6142: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6143: FROM gms_balances gb
6144: WHERE gb.budget_version_id = bp.budget_version_id
6145: AND gb.project_id = bp.project_id
6146: AND gb.award_id = bp.award_id
6147: AND (

Line 6436: FROM gms_balances gb

6432: SET (bp.res_grp_budget_posted, bp.res_grp_actual_posted, bp.res_grp_enc_posted) =
6433: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6434: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6435: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6436: FROM gms_balances gb
6437: WHERE gb.budget_version_id = bp.budget_version_id
6438: AND gb.project_id = bp.project_id
6439: AND gb.award_id = bp.award_id
6440: AND (

Line 6728: FROM gms_balances gb

6724: SET (bp.task_budget_posted, bp.task_actual_posted, bp.task_enc_posted) =
6725: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6726: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6727: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6728: FROM gms_balances gb
6729: WHERE gb.budget_version_id = bp.budget_version_id
6730: AND gb.project_id = bp.project_id
6731: AND gb.award_id = bp.award_id
6732: AND gb.task_id = bp.task_id

Line 6995: FROM gms_balances gb

6991: SET (bp.top_task_budget_posted, bp.top_task_actual_posted, bp.top_task_enc_posted) =
6992: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
6993: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
6994: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
6995: FROM gms_balances gb
6996: WHERE gb.budget_version_id = bp.budget_version_id
6997: AND gb.project_id = bp.project_id
6998: AND gb.award_id = bp.award_id
6999: AND gb.balance_type <> 'REV'

Line 7262: FROM gms_balances gb

7258: SET (bp.award_budget_posted, bp.award_actual_posted, bp.award_enc_posted) =
7259: (SELECT SUM (NVL (budget_period_to_date, 0) * DECODE (balance_type, 'BGT', 1, 0)),
7260: SUM (NVL (actual_period_to_date, 0) * DECODE (balance_type, 'EXP', 1, 0)),
7261: SUM (NVL (encumb_period_to_date, 0) * DECODE (balance_type, 'REQ', 1, 'PO', 1, 'AP', 1, 'ENC', 1, 0))
7262: FROM gms_balances gb
7263: WHERE gb.budget_version_id = bp.budget_version_id
7264: AND gb.project_id = bp.project_id
7265: AND gb.award_id = bp.award_id
7266: AND gb.start_date BETWEEN DECODE (