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.GMS_BUDGET_PUB dependencies on GMS_BUDGET_LINES

Line 552: gms_budget_lines gbl,

548: p_start_date in DATE) is
549:
550: select (nvl(gbal.actual_period_to_date,0) + nvl(gbal.encumb_period_to_date,0))
551: from gms_budget_versions gbv,
552: gms_budget_lines gbl,
553: gms_resource_assignments gra,
554: gms_balances gbal
555: where gbv.budget_version_id = gra.budget_version_id
556: and gra.resource_assignment_id = gbl.resource_assignment_id

Line 672: gms_budget_lines gbl_b,

668: gbl_b.period_name period_name,
669: gbv_b.budget_entry_method_code budget_entry_method_code,
670: gbv_b.resource_list_id resource_list_id
671: from gms_budget_versions gbv_b,
672: gms_budget_lines gbl_b,
673: gms_resource_assignments gra_b
674: where gbv_b.budget_version_id = gra_b.budget_version_id
675: and gra_b.resource_assignment_id = gbl_b.resource_assignment_id
676: and gbv_b.award_id = p_award_id

Line 690: gms_budget_lines gbl_d,

686: gbl_d.period_name period_name,
687: gbv_d.budget_entry_method_code budget_entry_method_code,
688: gbv_d.resource_list_id resource_list_id
689: from gms_budget_versions gbv_d,
690: gms_budget_lines gbl_d,
691: gms_resource_assignments gra_d
692: where gbv_d.budget_version_id = gra_d.budget_version_id
693: and gra_d.resource_assignment_id = gbl_d.resource_assignment_id
694: and gbv_d.award_id = p_award_id

Line 834: gms_budget_lines l

830: SYSDATE,
831: x_created_by,
832: x_last_update_login
833: from gms_resource_assignments a,
834: gms_budget_lines l
835: where a.budget_version_id = v.budget_version_id
836: and a.resource_assignment_id = l.resource_assignment_id
837: )
838: where budget_version_id = x_budget_version_id;

Line 938: gms_budget_lines gbl

934: sum(NVL(gbl.burdened_cost,0)) burdened_cost,
935: decode(sum(NVL(gbl.burdened_cost,0)), abs(sum(NVL(gbl.burdened_cost,0))), 1, 0) N
936: from gms_budget_versions gbv,
937: gms_resource_assignments gra,
938: gms_budget_lines gbl
939: where gbv.budget_version_id = gra.budget_version_id
940: and gra.resource_assignment_id = gbl.resource_assignment_id
941: and gbv.project_id = x_project_id
942: and gbv.award_id = x_award_id

Line 964: gms_budget_lines gbl

960: trunc(gbl.end_date) end_date,
961: sum(NVL(gbl.burdened_cost,0)) burdened_cost
962: from gms_budget_versions gbv,
963: gms_resource_assignments gra,
964: gms_budget_lines gbl
965: where gbv.budget_version_id = gra.budget_version_id
966: and gra.resource_assignment_id = gbl.resource_assignment_id
967: and gbv.project_id = x_project_id
968: and gbv.award_id = x_award_id

Line 1315: , gms_budget_lines gbl

1311: , gbl.start_date
1312: , gbl.end_date
1313: from gms_budget_versions gbv
1314: , gms_resource_assignments gra
1315: , gms_budget_lines gbl
1316: where gbv.budget_version_id = gra.budget_version_id
1317: and gra.resource_assignment_id = gbl.resource_assignment_id
1318: and gbv.project_id = p_project_id
1319: and gbv.award_id = p_award_id

Line 1334: , gms_budget_lines gbl

1330: , gbl.start_date
1331: , gbl.end_date
1332: from gms_budget_versions gbv
1333: , gms_resource_assignments gra
1334: , gms_budget_lines gbl
1335: where gbv.budget_version_id = gra.budget_version_id
1336: and gra.resource_assignment_id = gbl.resource_assignment_id
1337: and gbv.project_id = p_project_id
1338: and gbv.award_id <> p_award_id

Line 1650: , gms_budget_lines bl

1646: IS
1647: SELECT 'x'
1648: FROM gms_budget_versions bv
1649: , gms_resource_assignments ra
1650: , gms_budget_lines bl
1651: WHERE bv.budget_version_id = p_budget_version_id
1652: AND bv.budget_version_id = ra.budget_version_id (+)
1653: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
1654: FOR UPDATE OF bv.budget_version_id,ra.budget_version_id,bl.resource_assignment_id NOWAIT;

Line 4935: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before insert into gms_budget_lines');

4931: end if;
4932:
4933: end if;
4934:
4935: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before insert into gms_budget_lines');
4936:
4937: insert into gms_budget_lines
4938: (resource_assignment_id,
4939: start_date,

Line 4937: insert into gms_budget_lines

4933: end if;
4934:
4935: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before insert into gms_budget_lines');
4936:
4937: insert into gms_budget_lines
4938: (resource_assignment_id,
4939: start_date,
4940: last_update_date,
4941: last_updated_by,

Line 5013: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_budget_lines');

5009: p_raw_cost_source,
5010: p_burdened_cost_source
5011: );
5012:
5013: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_budget_lines');
5014:
5015: end if;
5016:
5017: -------------------------------------------------------------------------------------------

Line 5168: , gms_budget_lines bl

5164: IS
5165: SELECT 'x'
5166: FROM gms_budget_versions bv
5167: , gms_resource_assignments ra
5168: , gms_budget_lines bl
5169: WHERE bv.budget_version_id = p_budget_version_id
5170: AND bv.budget_version_id = ra.budget_version_id (+)
5171: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
5172: FOR UPDATE OF bv.budget_version_id,ra.budget_version_id,bl.resource_assignment_id NOWAIT;

Line 5407: from gms_budget_lines

5403:
5404: -----------------------------------------------------------------------------
5405:
5406: /** for b1_rec in ( select rowid
5407: from gms_budget_lines
5408: where resource_assignment_id
5409: in
5410: (select resource_assignment_id
5411: from gms_resource_assignments

Line 5420: gms_budget_lines gbl

5416: gra.task_id,
5417: gbl.start_date,
5418: gbl.period_name
5419: from gms_resource_assignments gra,
5420: gms_budget_lines gbl
5421: where gbl.resource_assignment_id = gra.resource_assignment_id
5422: and gra.budget_version_id = l_budget_version_id )
5423:
5424: loop

Line 5559: FROM gms_budget_lines

5555: ( p_resource_assignment_id NUMBER
5556: , p_start_date DATE )
5557: IS
5558: SELECT rowidtochar(rowid)
5559: FROM gms_budget_lines
5560: WHERE resource_assignment_id = p_resource_assignment_id
5561: AND trunc(start_date) = nvl(trunc(p_start_date),trunc(start_date));
5562:
5563: CURSOR l_uncategorized_list_csr

Line 5610: FROM gms_budget_lines

5606: --needed to lock the budget line row
5607: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
5608: IS
5609: SELECT 'x'
5610: FROM gms_budget_lines
5611: WHERE rowid = p_budget_line_rowid
5612: FOR UPDATE NOWAIT;
5613:
5614: l_api_name CONSTANT VARCHAR2(30) := 'delete_budget_line';

Line 6037: gms_budget_lines l

6033: l_quantity,
6034: l_resource_assignment_id,
6035: l_track_as_labor_flag
6036: from gms_resource_assignments a,
6037: gms_budget_lines l
6038: where l.rowid = l_budget_line_rowid
6039: and l.resource_assignment_id = a.resource_assignment_id;
6040:
6041: delete from gms_budget_lines

Line 6041: delete from gms_budget_lines

6037: gms_budget_lines l
6038: where l.rowid = l_budget_line_rowid
6039: and l.resource_assignment_id = a.resource_assignment_id;
6040:
6041: delete from gms_budget_lines
6042: where rowid = l_budget_line_rowid;
6043:
6044: l_last_updated_by := fnd_global.user_id;
6045: l_last_update_login := fnd_global.login_id;

Line 6058: from gms_budget_lines

6054: delete gms_resource_assignments
6055: where resource_assignment_id = l_resource_assignment_id
6056: and not exists
6057: (select 1
6058: from gms_budget_lines
6059: where resource_assignment_id = l_resource_assignment_id);
6060:
6061: -- Update gms_budget_versions only if the denormalized totals are
6062: -- not being maintained in the form. Example the Copy Actual

Line 6258: FROM gms_budget_lines

6254: (p_resource_assignment_id NUMBER
6255: ,p_budget_start_date DATE )
6256: IS
6257: SELECT 'X'
6258: FROM gms_budget_lines
6259: WHERE resource_assignment_id = p_resource_assignment_id
6260: AND start_date = p_budget_start_date;
6261:
6262: --needed to get the current budget version data

Line 6344: , gms_budget_lines bl

6340: IS
6341: SELECT 'x'
6342: FROM gms_budget_versions bv
6343: , gms_resource_assignments ra
6344: , gms_budget_lines bl
6345: WHERE bv.budget_version_id = p_budget_version_id
6346: AND bv.budget_version_id = ra.budget_version_id (+)
6347: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
6348: FOR UPDATE OF bv.budget_version_id,ra.budget_version_id,bl.resource_assignment_id NOWAIT;

Line 7036: FROM gms_budget_lines

7032: (p_resource_assigment_id NUMBER
7033: ,p_budget_start_date DATE )
7034: IS
7035: SELECT rowidtochar(rowid)
7036: FROM gms_budget_lines
7037: WHERE resource_assignment_id = p_resource_assigment_id
7038: AND trunc(start_date) = nvl(trunc(p_budget_start_date),trunc(start_date));
7039:
7040: --needed to lock the budget line row

Line 7044: FROM gms_budget_lines

7040: --needed to lock the budget line row
7041: CURSOR l_lock_budget_line_csr( p_budget_line_rowid VARCHAR2)
7042: IS
7043: SELECT 'x'
7044: FROM gms_budget_lines
7045: WHERE rowid = p_budget_line_rowid
7046: FOR UPDATE NOWAIT;
7047: ---------------------------------------------------------------
7048: l_api_name CONSTANT VARCHAR2(30) := 'update_budget_line';

Line 7574: -- Once the above validations have passed update the GMS_BUDGET_LINES table

7570: END IF;
7571:
7572: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after checking existence of budget line');
7573:
7574: -- Once the above validations have passed update the GMS_BUDGET_LINES table
7575: -- with the appropriate values.
7576:
7577: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
7578:

Line 7579: UPDATE GMS_BUDGET_LINES

7575: -- with the appropriate values.
7576:
7577: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
7578:
7579: UPDATE GMS_BUDGET_LINES
7580: SET change_reason_code = decode(p_change_reason_code,
7581: GMS_BUDGET_PUB.G_MISS_CHAR,
7582: change_reason_code,
7583: p_change_reason_code),