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 32: l_pa_tasks_rec PA_FP_GEN_AMOUNT_UTILS.PA_TASKS_REC;

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

Line 37: l_task_bill_rate_org_id pa_tasks.non_labor_bill_rate_org_id%TYPE;

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

Line 38: l_task_sch_discount pa_tasks.non_labor_schedule_discount%TYPE;

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

Line 39: l_task_sch_date pa_tasks.non_labor_schedule_fixed_date%TYPE;

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

Line 40: l_task_nl_std_bill_rt_sch_id pa_tasks.non_lab_std_bill_rt_sch_id%TYPE;

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

Line 41: l_task_emp_bill_rate_sch_id pa_tasks.emp_bill_rate_schedule_id%TYPE;

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

Line 42: l_task_job_bill_rate_sch_id pa_tasks.job_bill_rate_schedule_id%TYPE;

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

Line 43: l_task_lab_bill_rate_org_id pa_tasks.labor_bill_rate_org_id%TYPE;

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

Line 44: l_task_lab_sch_type pa_tasks.labor_sch_type%TYPE;

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

Line 45: l_task_non_labor_sch_type pa_tasks.non_labor_sch_type%TYPE;

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

Line 46: l_top_task_id pa_tasks.top_task_id%TYPE;

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

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

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

Line 871: x_pa_tasks_rec => l_pa_tasks_rec,

867: p_resource_list_member_id => l_res_list_member_id_tab(i), /* Bug 4070849 */
868: p_txn_currency_code => l_txn_currency_code,
869: x_res_format_id => l_res_format_id,
870: x_resource_asn_rec => l_resource_asn_rec,
871: x_pa_tasks_rec => l_pa_tasks_rec,
872: x_pa_projects_all_rec => l_pa_projects_all_rec,
873: x_proj_fp_options_rec => l_proj_fp_options_rec,
874: x_return_status => x_return_status,
875: x_msg_count => x_msg_count,

Line 915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;

911: l_lab_bill_rate_org_id := l_pa_projects_all_rec.x_labor_bill_rate_org_id;
912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;

Line 916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;

912: l_lab_sch_type := l_pa_projects_all_rec.x_labor_sch_type;
913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;

Line 917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;

913: l_non_labor_sch_type := l_pa_projects_all_rec.x_non_labor_sch_type;
914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;

Line 918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;

914: ELSE
915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;

Line 919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;

915: l_task_bill_rate_org_id := l_pa_tasks_rec.x_task_bill_rate_org_id;
916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;

Line 920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;

916: l_task_sch_discount := l_pa_tasks_rec.x_task_sch_discount;
917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;

Line 921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;

917: l_task_sch_date := l_pa_tasks_rec.x_task_sch_date;
918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
925: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;

Line 922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;

918: l_task_nl_std_bill_rt_sch_id := l_pa_tasks_rec.x_task_nl_std_bill_rt_sch_id;
919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
925: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
926: /* Task level attributes are found

Line 923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;

919: l_task_emp_bill_rate_sch_id := l_pa_tasks_rec.x_task_emp_bill_rate_sch_id;
920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
925: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
926: /* Task level attributes are found
927: the following atributes can be

Line 924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;

920: l_task_job_bill_rate_sch_id := l_pa_tasks_rec.x_task_job_bill_rate_sch_id;
921: l_task_lab_bill_rate_org_id := l_pa_tasks_rec.x_task_lab_bill_rate_org_id;
922: l_task_lab_sch_type := l_pa_tasks_rec.x_task_lab_sch_type;
923: l_task_non_labor_sch_type := l_pa_tasks_rec.x_task_non_labor_sch_type;
924: l_top_task_id := l_pa_tasks_rec.x_top_task_id;
925: l_rate_task_id := l_resource_asn_rec.x_rate_task_id;
926: /* Task level attributes are found
927: the following atributes can be
928: taken from the task level */

Line 2045: l_billable_flag PA_TASKS.BILLABLE_FLAG%TYPE;

2041: l_msg_index_out NUMBER;
2042: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
2043:
2044: /* Variables Added for ER 4376722 */
2045: l_billable_flag PA_TASKS.BILLABLE_FLAG%TYPE;
2046:
2047: BEGIN
2048: --Setting initial values
2049: X_MSG_COUNT := 0;

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

2063: INTO l_res_asg_id,
2064: l_rate_based_flag,
2065: l_billable_flag /* Added for ER 4376722 */
2066: FROM pa_resource_assignments ra,
2067: pa_tasks ta /* Added for ER 4376722 */
2068: WHERE ra.budget_version_id = p_budget_version_id
2069: AND NVL(ra.task_id,0) = p_task_id
2070: AND ra.resource_list_member_id = p_res_list_member_id
2071: AND nvl(ra.cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1)--bug#16791711

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

2077: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
2078: INTO l_rate_based_flag,
2079: l_billable_flag /* Added for ER 4376722 */
2080: FROM pa_resource_assignments ra,
2081: pa_tasks ta /* Added for ER 4376722 */
2082: WHERE ra.resource_assignment_id = l_res_asg_id
2083: AND NVL(ra.task_id,0) = ta.task_id (+); /* Added for ER 4376722 */
2084: END IF;
2085: