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_GEN_FCST_AMT_PVT dependencies on PA_TASKS

Line 31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;

27:
28: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
29: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
30: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;
31: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;
32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */

Line 36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

32: l_pa_projects_all_rec PA_FP_GEN_AMOUNT_UTILS.PA_PROJECTS_ALL_REC;
33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

Line 37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;

33: l_proj_fp_options_rec PA_FP_GEN_AMOUNT_UTILS.PROJ_FP_OPTIONS_REC;
34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

Line 38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;

34: /* end */
35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

Line 39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;

35: /* Local variables for calling get_planning_rate api */
36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

Line 40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

36: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;
37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

Line 41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

37: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;
38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;

Line 42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

38: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;
39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;
46: --Bug 4108350: Fixed the type mismatch for l_lab_sch_type.

Line 43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

39: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;
40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;
46: --Bug 4108350: Fixed the type mismatch for l_lab_sch_type.
47: l_lab_sch_type pa_tasks.labor_sch_type%TYPE; --emp_bill_rate_schedule_id%TYPE;

Line 44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

40: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;
41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;
46: --Bug 4108350: Fixed the type mismatch for l_lab_sch_type.
47: l_lab_sch_type pa_tasks.labor_sch_type%TYPE; --emp_bill_rate_schedule_id%TYPE;
48: l_rate_task_id pa_resource_assignments.task_id%TYPE;

Line 45: l_top_task_id pa_tasks.top_task_id%TYPE;

41: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;
42: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;
43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;
46: --Bug 4108350: Fixed the type mismatch for l_lab_sch_type.
47: l_lab_sch_type pa_tasks.labor_sch_type%TYPE; --emp_bill_rate_schedule_id%TYPE;
48: l_rate_task_id pa_resource_assignments.task_id%TYPE;
49:

Line 47: l_lab_sch_type pa_tasks.labor_sch_type%TYPE; --emp_bill_rate_schedule_id%TYPE;

43: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;
44: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;
45: l_top_task_id pa_tasks.top_task_id%TYPE;
46: --Bug 4108350: Fixed the type mismatch for l_lab_sch_type.
47: l_lab_sch_type pa_tasks.labor_sch_type%TYPE; --emp_bill_rate_schedule_id%TYPE;
48: l_rate_task_id pa_resource_assignments.task_id%TYPE;
49:
50: l_txn_currency_code pa_fp_rollup_tmp.txn_currency_code%TYPE := NULL;
51: l_txn_plan_quantity pa_fp_rollup_tmp.quantity%TYPE := NULL;

Line 858: x_pa_tasks_rec => l_pa_tasks_rec,

854: p_resource_list_member_id => l_res_list_member_id_tab(i), /* Bug 4070849 */
855: p_txn_currency_code => l_txn_currency_code,
856: x_res_format_id => l_res_format_id,
857: x_resource_asn_rec => l_resource_asn_rec,
858: x_pa_tasks_rec => l_pa_tasks_rec,
859: x_pa_projects_all_rec => l_pa_projects_all_rec,
860: x_proj_fp_options_rec => l_proj_fp_options_rec,
861: x_return_status => x_return_status,
862: x_msg_count => x_msg_count,

Line 902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;

898: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;

Line 903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;

899: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;

Line 904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;

900: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;

Line 905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;

901: ELSE
902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;

Line 906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;

902: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;

Line 907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;

903: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;

Line 908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;

904: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
912: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;

Line 909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;

905: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
912: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
913: /* Task level attributes are found

Line 910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;

906: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
912: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
913: /* Task level attributes are found
914: the following atributes can be

Line 911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;

907: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
908: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
909: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
910: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
911: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
912: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
913: /* Task level attributes are found
914: the following atributes can be
915: taken from the task level */

Line 2014: l_billable_flag PA_TASKS.BILLABLE_FLAG%TYPE;

2010: l_msg_index_out NUMBER;
2011: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
2012:
2013: /* Variables Added for ER 4376722 */
2014: l_billable_flag PA_TASKS.BILLABLE_FLAG%TYPE;
2015:
2016: BEGIN
2017: --Setting initial values
2018: X_MSG_COUNT := 0;

Line 2036: pa_tasks ta /* Added for ER 4376722 */

2032: INTO l_res_asg_id,
2033: l_rate_based_flag,
2034: l_billable_flag /* Added for ER 4376722 */
2035: FROM pa_resource_assignments ra,
2036: pa_tasks ta /* Added for ER 4376722 */
2037: WHERE ra.budget_version_id = p_budget_version_id
2038: AND NVL(ra.task_id,0) = p_task_id
2039: AND ra.resource_list_member_id = p_res_list_member_id
2040: AND NVL(ra.task_id,0) = ta.task_id (+); /* Added for ER 4376722 */

Line 2049: pa_tasks ta /* Added for ER 4376722 */

2045: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
2046: INTO l_rate_based_flag,
2047: l_billable_flag /* Added for ER 4376722 */
2048: FROM pa_resource_assignments ra,
2049: pa_tasks ta /* Added for ER 4376722 */
2050: WHERE ra.resource_assignment_id = l_res_asg_id
2051: AND NVL(ra.task_id,0) = ta.task_id (+); /* Added for ER 4376722 */
2052: END IF;
2053: