DBA Data[Home] [Help]

APPS.PA_BUDGET_PUB dependencies on PA_FIN_PLAN_TYPES_TL

Line 3234: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

3230: ,p_mark_as_original IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3231:
3232: --Parameters due to Fin Plan Model
3233: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
3234: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
3235: ,p_version_type IN pa_budget_versions.version_type%TYPE)
3236:
3237: IS
3238:

Line 3413: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

3409: l_any_error_occurred_flag VARCHAR2(1);
3410: l_data VARCHAR2(2000);
3411: l_msg_index_out NUMBER;
3412: l_dummy VARCHAR2(1);
3413: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3414: l_result VARCHAR2(1);
3415: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3416: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3417: l_fc_version_created_flag VARCHAR2(1);

Line 3416: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

3412: l_dummy VARCHAR2(1);
3413: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3414: l_result VARCHAR2(1);
3415: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
3416: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
3417: l_fc_version_created_flag VARCHAR2(1);
3418: l_final_plan_prc_code VARCHAR2(10);
3419: l_targ_request_id pa_budget_versions.request_id%TYPE;
3420: BEGIN

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

5066:
5067: l_project_id NUMBER := p_pa_project_id;
5068: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
5069: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
5070: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
5071: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
5072: l_budget_version_id NUMBER;
5073: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
5074: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

6083: l_version_type pa_budget_versions.version_type%TYPE;
6084: l_proj_fp_options_id NUMBER;
6085: l_result VARCHAR2(1);
6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6091: ll_version_type pa_budget_versions.version_type%TYPE;

Line 6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

6086: l_record_version_number pa_budget_versions.record_version_number%TYPE;
6087: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6088: --Added by Xin Liu. 28-APR-03
6089: ll_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
6090: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
6091: ll_version_type pa_budget_versions.version_type%TYPE;
6092: ll_version_number pa_budget_versions.version_number%TYPE;
6093:
6094: BEGIN

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

8042:
8043: l_project_id NUMBER := p_pa_project_id;
8044: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
8045: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
8046: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
8047: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
8048: l_budget_version_id NUMBER;
8049: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
8050: l_resource_list_id NUMBER;

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

9303: /*End of code for Bug 6417360*/
9304:
9305: l_budget_version_name pa_budget_versions.version_name%TYPE := null;
9306: l_fin_plan_type_id number;
9307: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9308: l_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9309: l_budget_entry_code pa_budget_versions.budget_entry_method_code%TYPE :=null;
9310: -- l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9311: l_record_version_number pa_budget_versions.record_version_number%TYPE;

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

9336: lx_budget_version_name pa_budget_versions.version_name%TYPE := null;
9337: lx_budget_version_number pa_budget_versions.version_number%TYPE :=null;
9338: lx_version_type pa_budget_versions.version_type%TYPE := null;
9339: lx_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE :=null;
9340: lx_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE:=null;
9341: lx_set_current_working_flag pa_budget_versions.current_working_flag%TYPE :=null;
9342: lx_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
9343: lx_resource_list_id pa_budget_versions.resource_list_id%TYPE;
9344: lx_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

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

13032:
13033: l_project_id NUMBER := p_pa_project_id;
13034: l_budget_type_code pa_budget_types.budget_type_code%TYPE := p_budget_type_code;
13035: l_fin_plan_type_id NUMBER := p_fin_plan_type_id;
13036: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE := p_fin_plan_type_name;
13037: l_version_type pa_budget_versions.version_type%TYPE := p_version_type;
13038: l_budget_version_id NUMBER;
13039: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
13040: l_resource_list_id NUMBER;

Line 14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

14078: ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
14079: -- Bug 2863564 Parameters added for new Fin Plan Model
14080: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
14081: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
14082: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
14083: ,p_version_type IN pa_budget_versions.version_type%TYPE
14084: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
14085: ) IS
14086:

Line 14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

14230: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
14231:
14232: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14233: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
14234: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14235:
14236: l_version_type pa_budget_versions.version_type%TYPE;
14237: l_record_version_number pa_budget_versions.record_version_number%TYPE;
14238: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

Line 14251: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

14247: l_result VARCHAR2(30);
14248:
14249:
14250: ll_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
14251: ll_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
14252: ll_version_type pa_budget_versions.version_type%TYPE;
14253: ll_version_number pa_budget_versions.version_number%TYPE;
14254: --needed to get the field values associated to a AMG message
14255:

Line 16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE

16725: ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
16726: -- Bug 2863564 Parameters required for new Fin Plan Model
16727: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
16728: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
16729: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
16730: ,p_version_type IN pa_budget_versions.version_type%TYPE
16731: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE
16732: ) IS
16733:

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

19077: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19078: ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19079: ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19081: ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19082: ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
19083: ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
19084: ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
19085: ,x_msg_count OUT NOCOPY NUMBER

Line 19109: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;

19105:
19106: l_project_id NUMBER;
19107: l_budget_type_code pa_budget_types.budget_type_code%TYPE;
19108: l_fin_plan_type_id NUMBER;
19109: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
19110: l_fin_plan_class_code varchar2(30);
19111: l_version_type pa_budget_versions.version_type%TYPE;
19112: l_budget_version_id NUMBER;
19113: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;