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_CORE dependencies on GMS_BUDGET_VERSIONS

Line 397: -- to fnd_user while inserting record in gms_budget_versions

393: x_last_update_login := FND_GLOBAL.LOGIN_ID;
394:
395: -- This call is repeated in GMS_BUDGET_UTILS.Verify_Budget_Rules
396: -- as the APIs call that procedure. Using v_emp_id eliminates join
397: -- to fnd_user while inserting record in gms_budget_versions
398:
399: v_emp_id := PA_UTILS.GetEmpIdFromUser(x_created_by );
400:
401: if v_emp_id IS NULL then

Line 423: gms_budget_versions v,

419: x_project_type_class_code,x_time_phased_type_code,
420: x_entry_level_code
421: from pa_project_types t,
422: pa_projects p,
423: gms_budget_versions v,
424: pa_budget_entry_methods b
425: where v.budget_version_id = x_draft_version_id
426: and v.project_id = p.project_id
427: and b.budget_entry_method_code = v.budget_entry_method_code

Line 573: update gms_budget_versions

569:
570: if (x_mark_as_original = 'Y') then
571:
572: -- reset current budget version to non-current
573: update gms_budget_versions
574: set original_flag = 'Y',
575: current_original_flag = 'N',
576: last_update_date = SYSDATE,
577: last_updated_by = x_created_by,

Line 597: update gms_budget_versions

593: IF L_DEBUG = 'Y' THEN
594: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating current_flag to an intermediate status R','C');
595: END IF;
596:
597: update gms_budget_versions
598: set current_flag = 'R',
599: last_update_date = SYSDATE,
600: last_updated_by = x_created_by,
601: last_update_login = x_last_update_login

Line 613: from gms_budget_versions

609: || '><' || x_budget_type_code || '>';
610:
611: select nvl(max(version_number), 0)
612: into max_version
613: from gms_budget_versions
614: where project_id = x_project_id
615: and award_id = x_award_id
616: and budget_type_code = x_budget_type_code
617: and budget_status_code = 'B';

Line 620: select gms_budget_versions_s.nextval

616: and budget_type_code = x_budget_type_code
617: and budget_status_code = 'B';
618:
619: -- get the dest version id
620: select gms_budget_versions_s.nextval
621: into x_dest_version_id
622: from sys.dual;
623:
624: -- populate gms_budget_versions

Line 624: -- populate gms_budget_versions

620: select gms_budget_versions_s.nextval
621: into x_dest_version_id
622: from sys.dual;
623:
624: -- populate gms_budget_versions
625: x_err_stage := 'create baselined version <' || to_char(x_dest_version_id)
626: || '><' || to_char(max_version)
627: || '><' || to_char(x_created_by) || '>';
628:

Line 630: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Inserting records into gms_budget_versions','C');

626: || '><' || to_char(max_version)
627: || '><' || to_char(x_created_by) || '>';
628:
629: IF L_DEBUG = 'Y' THEN
630: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Inserting records into gms_budget_versions','C');
631: END IF;
632:
633: insert into gms_budget_versions(
634: budget_version_id,

Line 633: insert into gms_budget_versions(

629: IF L_DEBUG = 'Y' THEN
630: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Inserting records into gms_budget_versions','C');
631: END IF;
632:
633: insert into gms_budget_versions(
634: budget_version_id,
635: project_id,
636: award_id,
637: budget_type_code,

Line 730: from gms_budget_versions v

726: first_budget_period,
727: pm_product_code,
728: pm_budget_reference,
729: NULL
730: from gms_budget_versions v
731: where budget_version_id = x_draft_version_id;
732:
733: x_err_stage := 'create budget lines <' || to_char(x_draft_version_id)
734: || '><' || to_char(x_dest_version_id)

Line 939: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',

935: END IF;
936:
937: -- Copy attachments for every draft budget copied
938:
939: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',
940: x_draft_version_id,
941: null,null,null,null,
942: 'GMS_BUDGET_VERSIONS',
943: x_dest_version_id,

Line 942: 'GMS_BUDGET_VERSIONS',

938:
939: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',
940: x_draft_version_id,
941: null,null,null,null,
942: 'GMS_BUDGET_VERSIONS',
943: x_dest_version_id,
944: null,null,null,null,
945: FND_GLOBAL.USER_ID,
946: FND_GLOBAL.LOGIN_ID,

Line 1033: from pa_projects a, gms_budget_versions b

1029: || to_char(x_src_version_id) || '>';
1030:
1031: select start_date
1032: into g_project_start_date
1033: from pa_projects a, gms_budget_versions b
1034: where b.budget_version_id = x_src_version_id
1035: and a.project_id = b.project_id;
1036:
1037: savepoint before_copy;

Line 1044: from gms_budget_versions

1040: || to_char(x_src_version_id) || '>';
1041:
1042: select resource_list_id,first_budget_period
1043: into x_src_resource_list_id, x_first_budget_period
1044: from gms_budget_versions
1045: where budget_version_id = x_src_version_id;
1046:
1047: x_err_stage := 'get baselined budget <' || to_char(x_dest_project_id)
1048: || '><' || x_dest_budget_type_code || '>' ;

Line 1068: from gms_budget_versions

1064: -- resource list used in accumulation
1065:
1066: select resource_list_id
1067: into x_baselined_resource_list_id
1068: from gms_budget_versions
1069: where budget_version_id = x_baselined_version_id;
1070:
1071: if (x_src_resource_list_id <> x_baselined_resource_list_id) then
1072:

Line 1179: gms_budget_versions v

1175: m.entry_level_code
1176: into x_time_phased_type_code,
1177: x_entry_level_code
1178: from pa_budget_entry_methods m,
1179: gms_budget_versions v
1180: where v.budget_version_id = x_src_version_id
1181: and v.budget_entry_method_code = m.budget_entry_method_code;
1182:
1183: -- Shifting the First Budget Period

Line 1262: select gms_budget_versions_s.nextval

1258:
1259: x_err_stage := 'create budget version <' || to_char(x_dest_project_id)
1260: || '><' || x_dest_budget_type_code || '>' ;
1261:
1262: select gms_budget_versions_s.nextval
1263: into x_dest_version_id
1264: from sys.dual;
1265:
1266: insert into gms_budget_versions(

Line 1266: insert into gms_budget_versions(

1262: select gms_budget_versions_s.nextval
1263: into x_dest_version_id
1264: from sys.dual;
1265:
1266: insert into gms_budget_versions(
1267: budget_version_id,
1268: project_id,
1269: award_id,
1270: budget_type_code,

Line 1359: from gms_budget_versions v

1355: v.attribute14,
1356: v.attribute15,
1357: x_first_budget_period,
1358: NULL
1359: from gms_budget_versions v
1360: where v.budget_version_id = x_src_version_id;
1361:
1362: gms_budget_core.copy_lines(x_src_version_id,
1363: x_amount_change_pct,

Line 1381: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',

1377: end if;
1378:
1379: -- Copy attachments for every draft budget copied
1380:
1381: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',
1382: x_src_version_id,
1383: null,null,null,null,
1384: 'GMS_BUDGET_VERSIONS',
1385: x_dest_version_id,

Line 1384: 'GMS_BUDGET_VERSIONS',

1380:
1381: fnd_attached_documents2_pkg.copy_attachments('GMS_BUDGET_VERSIONS',
1382: x_src_version_id,
1383: null,null,null,null,
1384: 'GMS_BUDGET_VERSIONS',
1385: x_dest_version_id,
1386: null,null,null,null,
1387: FND_GLOBAL.USER_ID,
1388: FND_GLOBAL.LOGIN_ID,

Line 1486: gms_budget_versions v

1482: m.entry_level_code
1483: into x_time_phased_type_code,
1484: x_entry_level_code
1485: from pa_budget_entry_methods m,
1486: gms_budget_versions v
1487: where v.budget_version_id = x_src_version_id
1488: and v.budget_entry_method_code = m.budget_entry_method_code;
1489:
1490: x_err_stage := 'copy resource assignment <' || to_char(x_src_version_id)

Line 1524: gms_budget_versions dv

1520: from
1521: gms_resource_assignments sa,
1522: pa_tasks st,
1523: pa_tasks dt,
1524: gms_budget_versions dv
1525: where sa.budget_version_id = x_src_version_id
1526: and sa.project_id = st.project_id
1527: and sa.task_id = st.task_id
1528: and st.task_number = dt.task_number

Line 1561: gms_budget_versions dv

1557: sa.unit_of_measure,
1558: sa.track_as_labor_flag
1559: from
1560: gms_resource_assignments sa,
1561: gms_budget_versions dv
1562: where sa.budget_version_id = x_src_version_id
1563: and sa.task_id = 0
1564: and dv.budget_version_id = x_dest_version_id;
1565:

Line 1870: FROM gms_budget_versions gbv, pa_budget_entry_methods pbem

1866:
1867: CURSOR c_budget_details (p_budget_version NUMBER) IS
1868: SELECT gbv.budget_entry_method_code, resource_list_id,
1869: entry_level_code
1870: FROM gms_budget_versions gbv, pa_budget_entry_methods pbem
1871: WHERE gbv.budget_version_id = p_budget_version
1872: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
1873:
1874: CURSOR c_period_dates_draft IS

Line 2045: FROM gms_balances gb, gms_budget_versions gbv

2041: BEGIN
2042:
2043: SELECT MIN (start_date), MAX (end_date)
2044: INTO x_gbal_start_date, x_gbal_end_date
2045: FROM gms_balances gb, gms_budget_versions gbv
2046: WHERE gb.budget_version_id = gbv.budget_version_id
2047: AND gb.project_id = x_project_id
2048: AND gb.award_id = x_award_id
2049: AND gbv.award_id = gb.award_id

Line 2068: gms_budget_versions gbv,

2064:
2065: SELECT MIN (start_date), MAX (end_date)
2066: INTO x_pdb_start_date, x_pdb_end_date
2067: FROM gms_resource_assignments gra,
2068: gms_budget_versions gbv,
2069: gms_budget_lines gbl
2070: WHERE gbv.budget_version_id = gra.budget_version_id
2071: AND gbv.budget_version_id = x_version_id
2072: AND gra.resource_assignment_id = gbl.resource_assignment_id

Line 2228: FROM gms_budget_versions

2224: -- Added for bug 1831151
2225:
2226: CURSOR get_current_budget_version_id IS
2227: SELECT budget_version_id
2228: FROM gms_budget_versions
2229: WHERE award_id = x_award_id
2230: AND project_id = x_project_id
2231: AND current_flag = 'Y';
2232:

Line 2237: from gms_budget_versions b, pa_budget_types t

2233: -- end of modifications for bug 1831151
2234:
2235: cursor get_budget_amount_code is
2236: select budget_amount_code
2237: from gms_budget_versions b, pa_budget_types t
2238: where b.budget_version_id = x_version_id
2239: and b.budget_type_code = t.budget_type_code;
2240:
2241: -- required to fetch the budget line details reqd. to delete a budget line.