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 PA_BUDGET_ENTRY_METHODS

Line 1059: pa_budget_entry_methods pbem

1055:
1056: select decode(entry_level_code, 'P','P','T')
1057: into x_entry_level_code
1058: from gms_budget_versions gbv,
1059: pa_budget_entry_methods pbem
1060: where gbv.budget_Version_id = x_budget_version_id
1061: and pbem.budget_entry_method_code = gbv.budget_entry_method_code;
1062:
1063: select decode (task_id, NULL, 'P','T')

Line 1091: from pa_budget_entry_methods pbem,

1087: where project_id = x_project_id;
1088:
1089: select time_phased_type_code, categorization_code
1090: into x_period_type, x_categorization_code
1091: from pa_budget_entry_methods pbem,
1092: gms_budget_versions gbv
1093: where gbv.budget_entry_method_code = pbem.budget_entry_method_code
1094: and gbv.budget_version_id = x_budget_version_id;
1095:

Line 1347: pa_budget_entry_methods pbem

1343: cursor time_phased_type_csr ( p_budget_version_id in NUMBER)
1344: is
1345: select time_phased_type_code
1346: from gms_budget_versions gbv,
1347: pa_budget_entry_methods pbem
1348: where gbv.budget_entry_method_code = pbem.budget_entry_method_code
1349: and gbv.budget_version_id = p_budget_version_id;
1350:
1351:

Line 1447: from pa_budget_entry_methods

1443:
1444: cursor entry_method_detail_csr(p_budget_entry_method_code IN VARCHAR2)
1445: IS
1446: select categorization_code
1447: from pa_budget_entry_methods
1448: where budget_entry_method_code = p_budget_entry_method_code;
1449:
1450: cursor resource_list_csr (p_project_id IN NUMBER,
1451: p_award_id IN NUMBER)

Line 1609: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

1605: )
1606: IS
1607:
1608: CURSOR l_budget_entry_method_csr
1609: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
1610: IS
1611: SELECT *
1612: FROM pa_budget_entry_methods
1613: WHERE budget_entry_method_code = p_budget_entry_method_code

Line 1612: FROM pa_budget_entry_methods

1608: CURSOR l_budget_entry_method_csr
1609: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
1610: IS
1611: SELECT *
1612: FROM pa_budget_entry_methods
1613: WHERE budget_entry_method_code = p_budget_entry_method_code
1614: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
1615:
1616:

Line 1676: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

1672: l_resource_list_id NUMBER;
1673: l_old_budget_version_id NUMBER;
1674: i NUMBER;
1675:
1676: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
1677: l_budget_amount_code pa_budget_types.budget_amount_code%type;
1678: l_description VARCHAR2(255);
1679: l_dummy VARCHAR2(1);
1680: l_attribute_category VARCHAR2(30);

Line 2695: pa_budget_entry_methods pbem

2691: CURSOR l_time_phased_type_csr(p_budget_version_id IN NUMBER)
2692: IS
2693: SELECT pbem.time_phased_type_code, pbem.entry_level_code
2694: FROM gms_budget_versions gbv,
2695: pa_budget_entry_methods pbem
2696: WHERE gbv.budget_version_id = p_budget_version_id
2697: AND gbv.budget_entry_method_code = pbem.budget_entry_method_code;
2698:
2699: -- Required to obtain Award and Project Numbers to be used in error messages

Line 2739: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;

2735: FOR UPDATE NOWAIT;
2736:
2737: ------------------------------------------------------------------------------
2738:
2739: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;
2740:
2741:
2742: l_api_name CONSTANT VARCHAR2(30) := 'baseline_budget';
2743: l_award_id NUMBER;

Line 3520: pa_budget_entry_methods bem

3516: bem.entry_level_code
3517: into l_prev_baselined_version_id,
3518: l_prev_entry_level_code
3519: from gms_budget_versions bv,
3520: pa_budget_entry_methods bem
3521: where bv.award_id = l_award_id
3522: and bv.project_id = l_project_id
3523: and bv.budget_type_code = p_budget_type_code
3524: and bv.budget_status_code = 'B'

Line 4164: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

4160:
4161: -- needed to get the fields associated to a budget entry method
4162:
4163: CURSOR l_budget_entry_method_csr
4164: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
4165: IS
4166: SELECT *
4167: FROM pa_budget_entry_methods
4168: WHERE budget_entry_method_code = p_budget_entry_method_code

Line 4167: FROM pa_budget_entry_methods

4163: CURSOR l_budget_entry_method_csr
4164: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
4165: IS
4166: SELECT *
4167: FROM pa_budget_entry_methods
4168: WHERE budget_entry_method_code = p_budget_entry_method_code
4169: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
4170:
4171: -- needed to get budget_type_code and award_id based on the budget_version_id

Line 4234: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

4230: l_attribute13 VARCHAR2(150);
4231: l_attribute14 VARCHAR2(150);
4232: l_attribute15 VARCHAR2(150);
4233: ---------------
4234: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;
4235: l_budget_amount_code pa_budget_types.budget_amount_code%type;
4236: l_resource_name pa_resource_list_members.alias%type; /*Changed for bug 4614242*/
4237: l_function_allowed VARCHAR2(1);
4238: l_resp_id NUMBER := 0;

Line 5581: FROM pa_budget_entry_methods

5577: CURSOR l_budget_entry_method_csr
5578: (p_budget_entry_method_code VARCHAR2)
5579: IS
5580: SELECT time_phased_type_code
5581: FROM pa_budget_entry_methods
5582: WHERE budget_entry_method_code = p_budget_entry_method_code;
5583:
5584: -- needed to get the budget_start_date of a period
5585:

Line 6288: FROM pa_budget_entry_methods

6284: IS
6285: SELECT time_phased_type_code
6286: , entry_level_code
6287: , categorization_code
6288: FROM pa_budget_entry_methods
6289: WHERE budget_entry_method_code = p_budget_entry_method_code;
6290:
6291: --needed to get the resource assignment for this budget_version / task / member combination
6292:

Line 6945: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

6941:
6942: -- needed to get the fields associated to a budget entry method
6943:
6944: CURSOR l_budget_entry_method_csr
6945: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
6946: IS
6947: SELECT *
6948: FROM pa_budget_entry_methods
6949: WHERE budget_entry_method_code = p_budget_entry_method_code

Line 6948: FROM pa_budget_entry_methods

6944: CURSOR l_budget_entry_method_csr
6945: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )
6946: IS
6947: SELECT *
6948: FROM pa_budget_entry_methods
6949: WHERE budget_entry_method_code = p_budget_entry_method_code
6950: AND trunc(sysdate) BETWEEN trunc(start_date_active) and trunc(nvl(end_date_active,sysdate));
6951:
6952: -- needed to do validation on mandatory fields for budget lines

Line 7069: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

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;
7073: l_description VARCHAR2(255);