DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_FIN_PLAN_TYPES_TL

Line 3298: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

3294: ,p_mark_as_original IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3295:
3296: --Parameters due to Fin Plan Model
3297: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3298: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3299: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3300:
3301: IS
3302:

Line 3485: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

3481: l_any_error_occurred_flag VARCHAR2(1);
3482: l_data VARCHAR2(2000);
3483: l_msg_index_out NUMBER;
3484: l_dummy VARCHAR2(1);
3485: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3486: l_result VARCHAR2(1);
3487: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3488: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3489: l_fc_version_created_flag VARCHAR2(1);

Line 3488: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

3484: l_dummy VARCHAR2(1);
3485: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3486: l_result VARCHAR2(1);
3487: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3488: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3489: l_fc_version_created_flag VARCHAR2(1);
3490: l_final_plan_prc_code VARCHAR2(10);
3491: l_targ_request_id pa_budget_versions.request_id%TYPE;
3492: BEGIN

Line 5180: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;

5176:
5177: l_project_id NUMBER := p_pa_project_id;
5178: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
5179: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5180: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5181: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5182: l_budget_version_id NUMBER;
5183: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5184: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

6235: l_version_type pa_budget_versions.version_type%TYPE;
6236: l_proj_fp_options_id NUMBER;
6237: l_result VARCHAR2(1);
6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6243: ll_version_type pa_budget_versions.version_type%TYPE;

Line 6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

6238: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6239: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6240: --Added by Xin Liu. 28-APR-03
6241: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6242: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6243: ll_version_type pa_budget_versions.version_type%TYPE;
6244: ll_version_number pa_budget_versions.version_number%TYPE;
6245:
6246: BEGIN

Line 8206: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;

8202:
8203: l_project_id NUMBER := p_pa_project_id;
8204: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
8205: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8206: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8207: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8208: l_budget_version_id NUMBER;
8209: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8210: l_resource_list_id NUMBER;

Line 9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;

9486: /*End of code for Bug 6417360*/
9487:
9488: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9489: l_fin_plan_type_id number;
9490: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9491: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9492: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9493: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9494: l_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;

9519: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9520: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9521: lx_version_type pa_budget_versions.version_type%TYPE := null;
9522: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9523: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9524: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9525: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9526: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9527: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 13259: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;

13255:
13256: l_project_id NUMBER := p_pa_project_id;
13257: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
13258: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13259: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13260: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13261: l_budget_version_id NUMBER;
13262: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13263: l_resource_list_id NUMBER;

Line 14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

14324: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14325: -- Bug 2863564 Parameters added for new Fin Plan Model
14326: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14327: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14328: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14329: ,p_version_type IN pa_budget_versions.version_type%TYPE
14330: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14331: ) IS
14332:

Line 14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

14476: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14477:
14478: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14479: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14480: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14481:
14482: l_version_type pa_budget_versions.version_type%TYPE;
14483: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14484: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

Line 14497: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

14493: l_result VARCHAR2(30);
14494:
14495:
14496: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14497: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14498: ll_version_type pa_budget_versions.version_type%TYPE;
14499: ll_version_number pa_budget_versions.version_number%TYPE;
14500: --needed to get the field values associated to a AMG message
14501:

Line 16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

16974: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16975: -- Bug 2863564 Parameters required for new Fin Plan Model
16976: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16977: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16978: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16979: ,p_version_type IN pa_budget_versions.version_type%TYPE
16980: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16981: ) IS
16982:

Line 19374: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

19370: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19371: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19372: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19373: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19374: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19375: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19376: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19377: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19378: ,p_distribute_amounts IN VARCHAR2 DEFAULT 'Y' -- Bug 9610380

Line 19403: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

19399:
19400: l_project_id NUMBER;
19401: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19402: l_fin_plan_type_id NUMBER;
19403: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19404: l_fin_plan_class_code varchar2(30);
19405: l_version_type pa_budget_versions.version_type%TYPE;
19406: l_budget_version_id NUMBER;
19407: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;