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 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 1346: pa_budget_entry_methods pbem

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

Line 1446: from pa_budget_entry_methods

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

Line 1608: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

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

Line 1611: FROM pa_budget_entry_methods

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

Line 1675: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

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

Line 2694: pa_budget_entry_methods pbem

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

Line 2738: l_prev_entry_level_code pa_budget_entry_methods.entry_level_code%type;

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

Line 3519: pa_budget_entry_methods bem

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

Line 4163: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

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

Line 4166: FROM pa_budget_entry_methods

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

Line 4233: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

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

Line 5580: FROM pa_budget_entry_methods

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

Line 6287: FROM pa_budget_entry_methods

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

Line 6944: (p_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%type )

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

Line 6947: FROM pa_budget_entry_methods

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

Line 7068: l_budget_entry_method_rec pa_budget_entry_methods%rowtype;

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