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.

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJECTS_ALL

Line 239: l_project_name pa_projects_all.name%TYPE;

235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 259: FROM pa_projects_all ppa

255: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
256: SELECT ppa.name project_name
257: ,pt.name task_name
258: ,prl.alias resource_name
259: FROM pa_projects_all ppa
260: ,pa_proj_elements pt
261: ,pa_resource_list_members prl
262: ,pa_resource_assignments pra
263: WHERE pra.resource_assignment_id = p_resource_assignment_id

Line 754: FROM pa_projects_all ppa

750: ,prl.alias resource_name
751: INTO l_project_name
752: ,l_task_name
753: ,l_resource_name
754: FROM pa_projects_all ppa
755: ,pa_proj_elements pt
756: ,pa_resource_list_members prl
757: ,pa_resource_assignments pra
758: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)

Line 1276: ,p_project_id IN Pa_projects_all.project_id%TYPE

1272: ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for Bug 13419867
1273: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
1274: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1275: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1276: ,p_project_id IN Pa_projects_all.project_id%TYPE
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type

Line 1568: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

1564: l_ppl_index NUMBER;
1565: l_amount_exists VARCHAR2(1);
1566: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
1567:
1568: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
1569: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;
1570:
1571: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1572: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;

Line 1569: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;

1565: l_amount_exists VARCHAR2(1);
1566: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
1567:
1568: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
1569: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;
1570:
1571: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1572: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
1573: l_pji_rollup_required VARCHAR2(1);

Line 1588: FROM pa_projects_all

1584: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
1585:
1586: CURSOR get_pc_code IS
1587: SELECT project_currency_code, projfunc_currency_code
1588: FROM pa_projects_all
1589: WHERE project_id = p_project_id;
1590:
1591: --------------------------------------------------------------------------
1592: -- This cursor is to be used to retrieve the proj_element_id based on the

Line 1617: FROM pa_projects_all

1613: CURSOR check_cost_code_enabled(c_project_id NUMBER) IS
1614: select 'Y' from dual where
1615: EXISTS
1616: (SELECT *
1617: FROM pa_projects_all
1618: WHERE project_id = c_project_id
1619: AND CBS_VERSION_ID IS NOT NULL
1620: AND CBS_ENABLE_FLAG = 'Y');
1621:

Line 6083: l_project_id pa_projects_all.project_id%TYPE;

6079: l_loop_start NUMBER;
6080: l_loop_end NUMBER;
6081:
6082: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
6083: l_project_id pa_projects_all.project_id%TYPE;
6084: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
6085: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
6086:
6087: l_job_id_temp NUMBER; --bug#13566990

Line 8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE

8317: PROCEDURE copy_planning_transactions
8318: (
8319: p_context IN VARCHAR2
8320: ,p_copy_external_flag IN VARCHAR2
8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE

8318: (
8319: p_context IN VARCHAR2
8320: ,p_copy_external_flag IN VARCHAR2
8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8326: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 8370: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;

8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);
8370: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
8371: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8372: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8373:
8374: -- Declared for Bug 3615617

Line 8371: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;

8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);
8370: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
8371: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8372: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8373:
8374: -- Declared for Bug 3615617
8375: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 8389: l_pc pa_projects_all.project_currency_code%type;

8385:
8386: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%type;
8387: l_project_id pa_proj_fp_options.project_id%type;
8388: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%type;
8389: l_pc pa_projects_all.project_currency_code%type;
8390: l_pfc pa_projects_all.projfunc_currency_code%type;
8391: --Code addition for bug#4200168 ends here.
8392:
8393: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

Line 8390: l_pfc pa_projects_all.projfunc_currency_code%type;

8386: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%type;
8387: l_project_id pa_proj_fp_options.project_id%type;
8388: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%type;
8389: l_pc pa_projects_all.project_currency_code%type;
8390: l_pfc pa_projects_all.projfunc_currency_code%type;
8391: --Code addition for bug#4200168 ends here.
8392:
8393: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
8394: l_resource_class_code VARCHAR2(30);

Line 9051: from pa_projects_all

9047: WHERE fin_plan_version_id = l_targ_budget_version_id;
9048:
9049: select project_currency_code, projfunc_currency_code
9050: INTO l_pc, l_pfc
9051: from pa_projects_all
9052: WHERE project_id = l_project_id;
9053:
9054: FORALL j IN 1..l_txn_curr_code_tbl.count
9055: INSERT INTO PA_FP_TXN_CURRENCIES

Line 9415: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331

9411: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
9412: l_mode varchar2(12) := null; --Bug 4160258
9413:
9414:
9415: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331
9416: l_project_currency_code VARCHAR2(30);
9417: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
9418:
9419: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ; --bug#16688443

Line 10859: IN 1)p_src_project_id IN pa_projects_all.project_id%TYPE

10855: then it attaches it.
10856: This would be called when workplan is enabled for
10857: a project or template.
10858: Parameters:(Note that all the input parameters are mandatory)
10859: IN 1)p_src_project_id IN pa_projects_all.project_id%TYPE
10860: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
10861: =======================================================================*/
10862: PROCEDURE Add_wp_plan_type
10863: (

Line 10860: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE

10856: This would be called when workplan is enabled for
10857: a project or template.
10858: Parameters:(Note that all the input parameters are mandatory)
10859: IN 1)p_src_project_id IN pa_projects_all.project_id%TYPE
10860: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
10861: =======================================================================*/
10862: PROCEDURE Add_wp_plan_type
10863: (
10864: p_src_project_id IN pa_projects_all.project_id%TYPE

Line 10864: p_src_project_id IN pa_projects_all.project_id%TYPE

10860: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
10861: =======================================================================*/
10862: PROCEDURE Add_wp_plan_type
10863: (
10864: p_src_project_id IN pa_projects_all.project_id%TYPE
10865: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
10866: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10867: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10868: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 10865: ,p_targ_project_id IN pa_projects_all.project_id%TYPE

10861: =======================================================================*/
10862: PROCEDURE Add_wp_plan_type
10863: (
10864: p_src_project_id IN pa_projects_all.project_id%TYPE
10865: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
10866: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10867: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10868: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10869: ) AS

Line 10884: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;

10880:
10881: l_wp_type_id NUMBER :=0;
10882: l_proj_wp_type_exists NUMBER :=0;
10883: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10884: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10885: l_proj_currency_code pa_projects_all.project_currency_code%type;
10886: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10887:
10888: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 10885: l_proj_currency_code pa_projects_all.project_currency_code%type;

10881: l_wp_type_id NUMBER :=0;
10882: l_proj_wp_type_exists NUMBER :=0;
10883: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10884: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10885: l_proj_currency_code pa_projects_all.project_currency_code%type;
10886: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10887:
10888: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
10889: l_src_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 11132: p_project_id IN Pa_projects_all.project_id%TYPE

11128: p_planned_equip_effort_tbl IN parameter has also been removed as they were not being used/referred.
11129: ********************************************************************************************************/
11130: PROCEDURE check_and_create_task_rec_info
11131: (
11132: p_project_id IN Pa_projects_all.project_id%TYPE
11133: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
11134: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 12253: l_start_date pa_projects_all.start_date%TYPE;

12249: --l_proj_element_id_tbl element_versions_tbl1_type;
12250: --l_element_version_id_tbl element_versions_tbl2_type;
12251: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12252:
12253: l_start_date pa_projects_all.start_date%TYPE;
12254: l_completion_date pa_projects_all.completion_date%TYPE;
12255:
12256: l_res_list_is_uncategorized VARCHAR2(1);
12257: l_is_resource_list_grouped VARCHAR2(1);

Line 12254: l_completion_date pa_projects_all.completion_date%TYPE;

12250: --l_element_version_id_tbl element_versions_tbl2_type;
12251: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12252:
12253: l_start_date pa_projects_all.start_date%TYPE;
12254: l_completion_date pa_projects_all.completion_date%TYPE;
12255:
12256: l_res_list_is_uncategorized VARCHAR2(1);
12257: l_is_resource_list_grouped VARCHAR2(1);
12258: l_group_resource_type_id NUMBER;

Line 12331: FROM pa_projects_all

12327:
12328: BEGIN
12329: SELECT start_date,completion_date
12330: INTO l_start_date,l_completion_date
12331: FROM pa_projects_all
12332: WHERE project_id = version_info_rec.project_id;
12333: EXCEPTION
12334: WHEN OTHERS THEN
12335: IF l_debug_mode = 'Y' THEN

Line 13477: p_project_id IN pa_projects_all.project_id%TYPE

13473: Bug 3867302 Sep 21 2004 For ci versions reporting data is not maintained
13474: ==============================================================================*/
13475:
13476: PROCEDURE Refresh_rbs_for_versions(
13477: p_project_id IN pa_projects_all.project_id%TYPE
13478: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
13479: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
13480: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
13481: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 13817: ,p_project_id IN pa_projects_all.project_id%TYPE)

13813: FUNCTION DUP_EXISTS
13814: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
13815: ,p_task_id IN pa_tasks.task_id%TYPE
13816: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
13817: ,p_project_id IN pa_projects_all.project_id%TYPE)
13818: RETURN VARCHAR2
13819: IS
13820: l_dup_exists VARCHAR2(1);
13821: BEGIN