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 183: l_project_name pa_projects_all.name%TYPE;

179: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
180: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
181: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
182: -- Added for Bug 3762278
183: l_project_name pa_projects_all.name%TYPE;
184: l_task_name pa_proj_elements.name%TYPE;
185: l_resource_name pa_resource_list_members.alias%TYPE;
186:
187: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 203: FROM pa_projects_all ppa

199: CURSOR get_line_info (p_resource_assignment_id IN NUMBER) IS
200: SELECT ppa.name project_name
201: ,pt.name task_name
202: ,prl.alias resource_name
203: FROM pa_projects_all ppa
204: ,pa_proj_elements pt
205: ,pa_resource_list_members prl
206: ,pa_resource_assignments pra
207: WHERE pra.resource_assignment_id = p_resource_assignment_id

Line 698: FROM pa_projects_all ppa

694: ,prl.alias resource_name
695: INTO l_project_name
696: ,l_task_name
697: ,l_resource_name
698: FROM pa_projects_all ppa
699: ,pa_proj_elements pt
700: ,pa_resource_list_members prl
701: ,pa_resource_assignments pra
702: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)

Line 1219: ,p_project_id IN Pa_projects_all.project_id%TYPE

1215: p_context IN VARCHAR2
1216: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
1217: ,p_one_to_one_mapping_flag IN VARCHAR2 DEFAULT 'N'
1218: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1219: ,p_project_id IN Pa_projects_all.project_id%TYPE
1220: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 1505: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;

1501: l_ppl_index NUMBER;
1502: l_amount_exists VARCHAR2(1);
1503: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
1504:
1505: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
1506: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;
1507:
1508: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1509: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;

Line 1506: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;

1502: l_amount_exists VARCHAR2(1);
1503: l_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;
1504:
1505: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
1506: l_proj_func_curr_code pa_projects_all.projfunc_currency_code%TYPE;
1507:
1508: -- Bug 3836358 -- ADDED for usage when p_skip_duplicates_flag is passed as Y
1509: l_task_id_temp PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
1510: l_pji_rollup_required VARCHAR2(1);

Line 1518: FROM pa_projects_all

1514:
1515:
1516: CURSOR get_pc_code IS
1517: SELECT project_currency_code, projfunc_currency_code
1518: FROM pa_projects_all
1519: WHERE project_id = p_project_id;
1520:
1521: --------------------------------------------------------------------------
1522: -- This cursor is to be used to retrieve the proj_element_id based on the

Line 5427: l_project_id pa_projects_all.project_id%TYPE;

5423: l_loop_start NUMBER;
5424: l_loop_end NUMBER;
5425:
5426: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5427: l_project_id pa_projects_all.project_id%TYPE;
5428: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
5429: l_pji_rollup_required VARCHAR2(1); --Bug 4200168
5430:
5431:

Line 7495: ,p_src_project_id IN pa_projects_all.project_id%TYPE

7491: PROCEDURE copy_planning_transactions
7492: (
7493: p_context IN VARCHAR2
7494: ,p_copy_external_flag IN VARCHAR2
7495: ,p_src_project_id IN pa_projects_all.project_id%TYPE
7496: ,p_target_project_id IN pa_projects_all.project_id%TYPE
7497: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7498: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7499: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 7496: ,p_target_project_id IN pa_projects_all.project_id%TYPE

7492: (
7493: p_context IN VARCHAR2
7494: ,p_copy_external_flag IN VARCHAR2
7495: ,p_src_project_id IN pa_projects_all.project_id%TYPE
7496: ,p_target_project_id IN pa_projects_all.project_id%TYPE
7497: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7498: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
7499: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
7500: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;

7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);
7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
7545: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
7546: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7547:
7548: -- Declared for Bug 3615617

Line 7545: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;

7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);
7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
7545: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
7546: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7547:
7548: -- Declared for Bug 3615617
7549: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 7563: l_pc pa_projects_all.project_currency_code%type;

7559:
7560: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%type;
7561: l_project_id pa_proj_fp_options.project_id%type;
7562: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%type;
7563: l_pc pa_projects_all.project_currency_code%type;
7564: l_pfc pa_projects_all.projfunc_currency_code%type;
7565: --Code addition for bug#4200168 ends here.
7566:
7567: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM

Line 7564: l_pfc pa_projects_all.projfunc_currency_code%type;

7560: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%type;
7561: l_project_id pa_proj_fp_options.project_id%type;
7562: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%type;
7563: l_pc pa_projects_all.project_currency_code%type;
7564: l_pfc pa_projects_all.projfunc_currency_code%type;
7565: --Code addition for bug#4200168 ends here.
7566:
7567: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
7568: l_resource_class_code VARCHAR2(30);

Line 8225: from pa_projects_all

8221: WHERE fin_plan_version_id = l_targ_budget_version_id;
8222:
8223: select project_currency_code, projfunc_currency_code
8224: INTO l_pc, l_pfc
8225: from pa_projects_all
8226: WHERE project_id = l_project_id;
8227:
8228: FORALL j IN 1..l_txn_curr_code_tbl.count
8229: INSERT INTO PA_FP_TXN_CURRENCIES

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

8585: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
8586: l_mode varchar2(12) := null; --Bug 4160258
8587:
8588:
8589: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331
8590: l_project_currency_code VARCHAR2(30);
8591: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
8592:
8593: BEGIN

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

9989: then it attaches it.
9990: This would be called when workplan is enabled for
9991: a project or template.
9992: Parameters:(Note that all the input parameters are mandatory)
9993: IN 1)p_src_project_id IN pa_projects_all.project_id%TYPE
9994: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
9995: =======================================================================*/
9996: PROCEDURE Add_wp_plan_type
9997: (

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

9990: This would be called when workplan is enabled for
9991: a project or template.
9992: Parameters:(Note that all the input parameters are mandatory)
9993: IN 1)p_src_project_id IN pa_projects_all.project_id%TYPE
9994: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
9995: =======================================================================*/
9996: PROCEDURE Add_wp_plan_type
9997: (
9998: p_src_project_id IN pa_projects_all.project_id%TYPE

Line 9998: p_src_project_id IN pa_projects_all.project_id%TYPE

9994: IN 2)p_targ_project_id IN pa_projects_all.project_id%TYPE
9995: =======================================================================*/
9996: PROCEDURE Add_wp_plan_type
9997: (
9998: p_src_project_id IN pa_projects_all.project_id%TYPE
9999: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
10000: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10001: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10002: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 9999: ,p_targ_project_id IN pa_projects_all.project_id%TYPE

9995: =======================================================================*/
9996: PROCEDURE Add_wp_plan_type
9997: (
9998: p_src_project_id IN pa_projects_all.project_id%TYPE
9999: ,p_targ_project_id IN pa_projects_all.project_id%TYPE
10000: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10001: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10002: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10003: ) AS

Line 10018: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;

10014:
10015: l_wp_type_id NUMBER :=0;
10016: l_proj_wp_type_exists NUMBER :=0;
10017: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10018: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10019: l_proj_currency_code pa_projects_all.project_currency_code%type;
10020: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10021:
10022: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 10019: l_proj_currency_code pa_projects_all.project_currency_code%type;

10015: l_wp_type_id NUMBER :=0;
10016: l_proj_wp_type_exists NUMBER :=0;
10017: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10018: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%type;
10019: l_proj_currency_code pa_projects_all.project_currency_code%type;
10020: l_appr_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag %TYPE;
10021:
10022: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
10023: l_src_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 10266: p_project_id IN Pa_projects_all.project_id%TYPE

10262: p_planned_equip_effort_tbl IN parameter has also been removed as they were not being used/referred.
10263: ********************************************************************************************************/
10264: PROCEDURE check_and_create_task_rec_info
10265: (
10266: p_project_id IN Pa_projects_all.project_id%TYPE
10267: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
10268: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10269: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10270: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 11379: l_start_date pa_projects_all.start_date%TYPE;

11375: --l_proj_element_id_tbl element_versions_tbl1_type;
11376: --l_element_version_id_tbl element_versions_tbl2_type;
11377: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11378:
11379: l_start_date pa_projects_all.start_date%TYPE;
11380: l_completion_date pa_projects_all.completion_date%TYPE;
11381:
11382: l_res_list_is_uncategorized VARCHAR2(1);
11383: l_is_resource_list_grouped VARCHAR2(1);

Line 11380: l_completion_date pa_projects_all.completion_date%TYPE;

11376: --l_element_version_id_tbl element_versions_tbl2_type;
11377: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11378:
11379: l_start_date pa_projects_all.start_date%TYPE;
11380: l_completion_date pa_projects_all.completion_date%TYPE;
11381:
11382: l_res_list_is_uncategorized VARCHAR2(1);
11383: l_is_resource_list_grouped VARCHAR2(1);
11384: l_group_resource_type_id NUMBER;

Line 11457: FROM pa_projects_all

11453:
11454: BEGIN
11455: SELECT start_date,completion_date
11456: INTO l_start_date,l_completion_date
11457: FROM pa_projects_all
11458: WHERE project_id = version_info_rec.project_id;
11459: EXCEPTION
11460: WHEN OTHERS THEN
11461: IF l_debug_mode = 'Y' THEN

Line 12576: p_project_id IN pa_projects_all.project_id%TYPE

12572: Bug 3867302 Sep 21 2004 For ci versions reporting data is not maintained
12573: ==============================================================================*/
12574:
12575: PROCEDURE Refresh_rbs_for_versions(
12576: p_project_id IN pa_projects_all.project_id%TYPE
12577: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
12578: ,p_calling_context IN VARCHAR2 -- Default 'ALL_CHILD_VERSIONS'
12579: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE -- Default null
12580: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

12912: FUNCTION DUP_EXISTS
12913: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12914: ,p_task_id IN pa_tasks.task_id%TYPE
12915: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
12916: ,p_project_id IN pa_projects_all.project_id%TYPE)
12917: RETURN VARCHAR2
12918: IS
12919: l_dup_exists VARCHAR2(1);
12920: BEGIN