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_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 1314: , gms_resource_assignments gra

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

Line 1333: , gms_resource_assignments gra

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

Line 1649: , gms_resource_assignments ra

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

Line 2628: FROM gms_resource_assignments

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

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

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

Line 4850: from gms_resource_assignments

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

Line 4865: select gms_resource_assignments_s.nextval

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

Line 4872: insert into gms_resource_assignments

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

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

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

Line 5167: , gms_resource_assignments ra

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

Line 5411: from gms_resource_assignments

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

Line 5419: from gms_resource_assignments gra,

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

Line 5549: FROM gms_resource_assignments

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

Line 6036: from gms_resource_assignments a,

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

Line 6049: from gms_resource_assignments

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

Line 6052: -- clean up gms_resource_assignments if necessary

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

Line 6054: delete gms_resource_assignments

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

Line 6299: FROM gms_resource_assignments

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

Line 6343: , gms_resource_assignments ra

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

Line 7023: FROM gms_resource_assignments

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

Line 7068: l_resource_assignment_id gms_resource_assignments.resource_assignment_id%type;

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