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 1314: , gms_budget_lines gbl

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

Line 1333: , gms_budget_lines gbl

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

Line 1649: , gms_budget_lines bl

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

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

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

Line 4936: insert into gms_budget_lines

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

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

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

Line 5167: , gms_budget_lines bl

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

Line 5406: from gms_budget_lines

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

Line 5419: gms_budget_lines gbl

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

Line 5558: FROM gms_budget_lines

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

Line 5609: FROM gms_budget_lines

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

Line 6036: gms_budget_lines l

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

Line 6040: delete from gms_budget_lines

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

Line 6057: from gms_budget_lines

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

Line 6257: FROM gms_budget_lines

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

Line 6343: , gms_budget_lines bl

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

Line 7035: FROM gms_budget_lines

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

Line 7043: FROM gms_budget_lines

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

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

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

Line 7578: UPDATE GMS_BUDGET_LINES

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