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_RESOURCE_ASSIGNMENTS

Line 553: gms_resource_assignments gra,

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
557: and gbal.award_id = gbv.award_id

Line 673: gms_resource_assignments gra_b

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
677: and gbv_b.project_id = p_project_id

Line 691: gms_resource_assignments gra_d

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
695: and gbv_d.project_id = p_project_id

Line 833: from gms_resource_assignments a,

829: pa_currency.round_currency_amt(sum(nvl(l.burdened_cost, 0))),
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: )

Line 937: gms_resource_assignments gra,

933: trunc(gbl.end_date) end_date,
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

Line 963: gms_resource_assignments gra,

959: select trunc(gbl.start_date) start_date,
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

Line 1313: , gms_resource_assignments gra

1309: select gbv.budget_version_id
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

Line 1332: , gms_resource_assignments gra

1328: select gbv.budget_version_id
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

Line 1648: , gms_resource_assignments ra

1644: CURSOR l_lock_old_budget_csr( p_budget_version_id NUMBER )
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 (+)

Line 2627: FROM gms_resource_assignments

2623: CURSOR l_resource_assignments_csr
2624: ( p_budget_version_id NUMBER )
2625: IS
2626: SELECT 1
2627: FROM gms_resource_assignments
2628: WHERE budget_version_id = p_budget_version_id;
2629:
2630: CURSOR l_budget_versions_csr
2631: ( p_project_id NUMBER

Line 3063: -- check for budget lines in gms_resource_assignments,

3059: END IF;
3060:
3061: CLOSE l_budget_versions_csr;
3062:
3063: -- check for budget lines in gms_resource_assignments,
3064: -- we only permit submit/baseline action when there are budget lines
3065:
3066: OPEN l_resource_assignments_csr(l_budget_version_id);
3067:

Line 4849: from gms_resource_assignments

4845:
4846: begin
4847: select resource_assignment_id
4848: into l_resource_assignment_id
4849: from gms_resource_assignments
4850: where budget_version_id = l_budget_version_id
4851: and project_id = l_project_id
4852: and NVL(task_id, 0) = NVL(l_task_id, 0) -- was p_pa_task_id
4853: and resource_list_member_id = p_resource_list_member_id;

Line 4864: select gms_resource_assignments_s.nextval

4860: || to_char(l_task_id) || '><'
4861: || to_char(p_resource_list_member_id)
4862: || '>';
4863:
4864: select gms_resource_assignments_s.nextval
4865: into l_resource_assignment_id
4866: from sys.dual;
4867:
4868: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after selecting from sequence');

Line 4871: insert into gms_resource_assignments

4867:
4868: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after selecting from sequence');
4869:
4870: -- create a new resource assignment
4871: insert into gms_resource_assignments
4872: (resource_assignment_id,
4873: budget_version_id,
4874: project_id,
4875: task_id,

Line 4910: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_resource_assignments');

4906:
4907: APP_EXCEPTION.RAISE_EXCEPTION;
4908: end ;
4909:
4910: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_resource_assignments');
4911:
4912: -- Copy raw cost into burdened cost if budrened cost is null.
4913: -- If the resource UOM is currency and raw cost is null then
4914: -- copy value of quantity amt into raw cost and also set quantity

Line 5166: , gms_resource_assignments ra

5162: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
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 (+)

Line 5410: from gms_resource_assignments

5406: from gms_budget_lines
5407: where resource_assignment_id
5408: in
5409: (select resource_assignment_id
5410: from gms_resource_assignments
5411: where budget_version_id = l_budget_version_id))
5412: **/
5413: for b1_rec in ( select gbl.rowid,
5414: gra.resource_list_member_id,

Line 5418: from gms_resource_assignments gra,

5414: gra.resource_list_member_id,
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:

Line 5548: FROM gms_resource_assignments

5544: ,p_task_id NUMBER
5545: ,p_member_id NUMBER )
5546: IS
5547: SELECT resource_assignment_id
5548: FROM gms_resource_assignments
5549: WHERE budget_version_id = p_budget_version_id
5550: AND task_id = p_task_id
5551: AND resource_list_member_id = p_member_id;
5552:

Line 6035: from gms_resource_assignments a,

6031: l_burdened_cost,
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:

Line 6048: from gms_resource_assignments

6044: l_last_update_login := fnd_global.login_id;
6045:
6046: select budget_version_id
6047: into l_budget_version_id
6048: from gms_resource_assignments
6049: where resource_assignment_id = l_resource_assignment_id;
6050:
6051: -- clean up gms_resource_assignments if necessary
6052:

Line 6051: -- clean up gms_resource_assignments if necessary

6047: into l_budget_version_id
6048: from gms_resource_assignments
6049: where resource_assignment_id = l_resource_assignment_id;
6050:
6051: -- clean up gms_resource_assignments if necessary
6052:
6053: delete gms_resource_assignments
6054: where resource_assignment_id = l_resource_assignment_id
6055: and not exists

Line 6053: delete gms_resource_assignments

6049: where resource_assignment_id = l_resource_assignment_id;
6050:
6051: -- clean up gms_resource_assignments if necessary
6052:
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

Line 6298: FROM gms_resource_assignments

6294: ,p_task_id NUMBER
6295: ,p_member_id NUMBER )
6296: IS
6297: SELECT resource_assignment_id
6298: FROM gms_resource_assignments
6299: WHERE budget_version_id = p_budget_version_id
6300: AND task_id = p_task_id
6301: AND resource_list_member_id = p_member_id;
6302:

Line 6342: , gms_resource_assignments ra

6338: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )
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 (+)

Line 7022: FROM gms_resource_assignments

7018: ,p_task_id NUMBER
7019: ,p_member_id NUMBER )
7020: IS
7021: SELECT resource_assignment_id
7022: FROM gms_resource_assignments
7023: WHERE budget_version_id = p_budget_version_id
7024: AND task_id = p_task_id
7025: AND resource_list_member_id = p_member_id;
7026:

Line 7067: l_resource_assignment_id gms_resource_assignments.resource_assignment_id%type;

7063: l_burdened_cost NUMBER;
7064: l_quantity NUMBER;
7065: l_unit_of_measure pa_resources.unit_of_measure%type;
7066: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%type;
7067: l_resource_assignment_id gms_resource_assignments.resource_assignment_id%type;
7068: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
7069: l_wbs_level NUMBER;
7070: l_return_status_task NUMBER;
7071: l_budget_amount_code pa_budget_types.budget_amount_code%type;