APPS.GMS_BUDGET_PUB dependencies on PA_BUDGET_TYPES

Line 1620: FROM pa_budget_types

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

Line 1676: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

Line 2620: FROM pa_budget_types

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

Line 4189: FROM pa_budget_types

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

Line 4234: l_budget_amount_code pa_budget_types.budget_amount_code%type;

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

Line 5158: FROM pa_budget_types

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

Line 5539: FROM pa_budget_types

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

Line 6247: FROM pa_budget_types

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

Line 6957: FROM pa_budget_types

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

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