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

Line 47: -- p_pm_product_code - The PM vendor's product code stored in gms_budget_versions.

43: -- is requested.
44: -- p_award_id - Unique identifier for the award of the budget for which approval
45: -- is requested.
46: -- p_budget_type_code - Unique identifier for budget submitted for approval
47: -- p_pm_product_code - The PM vendor's product code stored in gms_budget_versions.
48: --
49: -- OUT NOCOPY Parameters
50: -- p_result - 'T' or 'F' (True/False)
51: -- p_err_code - Standard error code: 0, Success; x < 0, Unexpected Error;

Line 210: FROM gms_budget_versions

206: , p_award_id NUMBER
207: , p_budget_type_code VARCHAR2 )
208: IS
209: SELECT 'x'
210: FROM gms_budget_versions
211: WHERE project_id = p_project_id
212: AND award_id = p_award_id
213: AND budget_type_code = p_budget_type_code
214: AND budget_status_code = 'B';

Line 281: FROM gms_budget_versions

277: , revenue
278: , resource_list_id
279: , budget_version_id
280: , version_name
281: FROM gms_budget_versions
282: WHERE project_id = p_project_id
283: AND award_id = p_award_id
284: AND budget_type_code = p_budget_type_code
285: --AND budget_status_code = 'S'; -- Modified on 20-May-2000

Line 332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;

328: l_carrying_out_org_id NUMBER;
329: l_carrying_out_org_name hr_organization_units.name%TYPE;
330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
331:
332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;

Line 333: l_budget_description gms_budget_versions.description%TYPE;

329: l_carrying_out_org_name hr_organization_units.name%TYPE;
330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
331:
332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;

Line 334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;

330: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
331:
332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;

Line 335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;

331:
332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
339: l_version_name gms_budget_versions.version_name%TYPE;

Line 336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;

332: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
339: l_version_name gms_budget_versions.version_name%TYPE;
340:

Line 337: l_mark_as_original gms_budget_versions.original_flag%TYPE;

333: l_budget_description gms_budget_versions.description%TYPE;
334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
339: l_version_name gms_budget_versions.version_name%TYPE;
340:
341: l_total_labor_hours NUMBER;

Line 338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;

334: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
339: l_version_name gms_budget_versions.version_name%TYPE;
340:
341: l_total_labor_hours NUMBER;
342: l_total_raw_cost NUMBER;

Line 339: l_version_name gms_budget_versions.version_name%TYPE;

335: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
336: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
337: l_mark_as_original gms_budget_versions.original_flag%TYPE;
338: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
339: l_version_name gms_budget_versions.version_name%TYPE;
340:
341: l_total_labor_hours NUMBER;
342: l_total_raw_cost NUMBER;
343: l_total_burdened_cost NUMBER;

Line 948: FROM gms_budget_versions

944: , p_award_id NUMBER
945: , p_budget_type_code VARCHAR2 )
946: IS
947: SELECT 'x'
948: FROM gms_budget_versions
949: WHERE project_id = p_project_id
950: AND award_id = p_award_id
951: AND budget_type_code = p_budget_type_code
952: AND budget_status_code = 'B';

Line 1019: FROM gms_budget_versions

1015: , revenue
1016: , resource_list_id
1017: , budget_version_id
1018: , version_name
1019: FROM gms_budget_versions
1020: WHERE project_id = p_project_id
1021: AND award_id = p_award_id
1022: AND budget_type_code = p_budget_type_code
1023: --AND budget_status_code = 'S'; -- Modified on 20-May-2000

Line 1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;

1066: l_carrying_out_org_id NUMBER;
1067: l_carrying_out_org_name hr_organization_units.name%TYPE;
1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1069:
1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;

Line 1071: l_budget_description gms_budget_versions.description%TYPE;

1067: l_carrying_out_org_name hr_organization_units.name%TYPE;
1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1069:
1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;

Line 1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;

1068: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1069:
1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;

Line 1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;

1069:
1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
1077: l_version_name gms_budget_versions.version_name%TYPE;

Line 1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;

1070: l_pm_budget_reference gms_budget_versions.pm_budget_reference%TYPE;
1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
1077: l_version_name gms_budget_versions.version_name%TYPE;
1078:

Line 1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;

1071: l_budget_description gms_budget_versions.description%TYPE;
1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
1077: l_version_name gms_budget_versions.version_name%TYPE;
1078:
1079: l_total_labor_hours NUMBER;

Line 1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;

1072: l_budget_change_reason_code gms_budget_versions.change_reason_code%TYPE;
1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
1077: l_version_name gms_budget_versions.version_name%TYPE;
1078:
1079: l_total_labor_hours NUMBER;
1080: l_total_raw_cost NUMBER;

Line 1077: l_version_name gms_budget_versions.version_name%TYPE;

1073: l_budget_entry_method_code gms_budget_versions.budget_entry_method_code%TYPE;
1074: l_pm_budget_product_code gms_budget_versions.pm_product_code%TYPE;
1075: l_mark_as_original gms_budget_versions.original_flag%TYPE;
1076: l_budget_version_id gms_budget_versions.budget_version_id%TYPE;
1077: l_version_name gms_budget_versions.version_name%TYPE;
1078:
1079: l_total_labor_hours NUMBER;
1080: l_total_raw_cost NUMBER;
1081: l_total_burdened_cost NUMBER;