APPS.GMS_BUDGET_PUB dependencies on PA_BUDGET_TYPES

Line 1621: FROM pa_budget_types

1617: CURSOR l_budget_amount_code_csr
1618: ( p_budget_type_code VARCHAR2 )
1619: IS
1620: SELECT budget_amount_code
1621: FROM pa_budget_types
1622: WHERE budget_type_code = p_budget_type_code;
1623:
1624:
1625: CURSOR l_budget_change_reason_csr ( p_change_reason_code VARCHAR2 )

Line 1677: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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);
1681: l_attribute1 VARCHAR2(150);

Line 2621: FROM pa_budget_types

2617: CURSOR l_budget_types_csr
2618: ( p_budget_type_code VARCHAR2 )
2619: IS
2620: SELECT 1
2621: FROM pa_budget_types
2622: WHERE budget_type_code = p_budget_type_code;
2623:
2624: CURSOR l_resource_assignments_csr
2625: ( p_budget_version_id NUMBER )

Line 4190: FROM pa_budget_types

4186: CURSOR l_budget_amount_code_csr
4187: ( p_budget_type_code VARCHAR2 )
4188: IS
4189: SELECT budget_amount_code
4190: FROM pa_budget_types
4191: WHERE budget_type_code = p_budget_type_code;
4192:
4193: -----------------
4194:

Line 4235: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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;
4239: l_user_id NUMBER := 0;

Line 5159: FROM pa_budget_types

5155: CURSOR l_budget_type_csr
5156: ( p_budget_type_code VARCHAR2 )
5157: IS
5158: SELECT 1
5159: FROM pa_budget_types
5160: WHERE budget_type_code = p_budget_type_code;
5161:
5162:
5163: CURSOR l_lock_budget_csr( p_budget_version_id NUMBER )

Line 5540: FROM pa_budget_types

5536: CURSOR l_budget_type_csr
5537: ( p_budget_type_code VARCHAR2 )
5538: IS
5539: SELECT 1
5540: FROM pa_budget_types
5541: WHERE budget_type_code = p_budget_type_code;
5542:
5543: CURSOR l_resource_assignment_csr
5544: (p_budget_version_id NUMBER

Line 6248: FROM pa_budget_types

6244: CURSOR l_budget_type_csr
6245: (p_budget_type_code VARCHAR2 )
6246: IS
6247: SELECT budget_amount_code
6248: FROM pa_budget_types
6249: WHERE budget_type_code = p_budget_type_code;
6250:
6251: --needed to check whether budget line already exists
6252:

Line 6958: FROM pa_budget_types

6954: CURSOR l_budget_amount_code_csr
6955: ( p_budget_type_code VARCHAR2 )
6956: IS
6957: SELECT budget_amount_code
6958: FROM pa_budget_types
6959: WHERE budget_type_code = p_budget_type_code;
6960:
6961: -- Added for Bug:2830539
6962: -- needed to validate the change reason code for the Budget Line

Line 7072: l_budget_amount_code pa_budget_types.budget_amount_code%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);
7074: l_change_reason_code VARCHAR2(30); -- NUMBER; BUG 2739513, this should be varchar2 not number
7075: l_project_start_date DATE;
7076: l_project_end_date DATE;