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_RESOURCE_ASSIGNMENTS

Line 16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

12: P_BV_ID_ETC_FP IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
13: P_FP_COLS_REC_ETC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14: P_FP_COLS_REC_ETC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
15: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
16: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
17: P_STRUCTURE_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE Default 'SHARE_FULL', -- Changes done for bug#10406949->FP Bug#12800007
18: P_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
19: P_CALLING_CONTEXT IN VARCHAR2,
20: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,

Line 49: l_rate_task_id pa_resource_assignments.task_id%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;
53: l_budget_lines_start_date pa_fp_rollup_tmp.start_date%TYPE := NULL;

Line 165: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

161: l_ins_pc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
162: l_ins_pc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
163:
164: l_source_bv_id number;
165: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
166: BEGIN
167: --Setting initial values
168: X_MSG_COUNT := 0;
169: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 305: FROM pa_resource_assignments ra

301: ra.resource_class_flag,
302: ra.named_role,
303: ra.etc_method_code,
304: ra.task_id
305: FROM pa_resource_assignments ra
306: WHERE ra.budget_version_id = l_source_bv_id
307: AND NVL(ra.task_id,0) = p_task_id AND
308: EXISTS (SELECT 1 from pa_budget_lines bl WHERE
309: ra.resource_assignment_id =

Line 354: pa_resource_assignments ra

350: sum(bl.burdened_cost),
351: sum(bl.revenue),
352: l_txn_src_code
353: FROM pa_budget_lines bl,
354: pa_resource_assignments ra
355: WHERE ra.resource_assignment_id = bl.resource_assignment_id
356: and ra.budget_version_id = l_source_bv_id
357: and NVL(ra.task_id,0) = p_task_id
358: AND bl.COST_REJECTION_CODE IS NULL

Line 469: FROM pa_resource_assignments ra

465: ra.resource_class_flag,
466: ra.named_role,
467: ra.etc_method_code,
468: 0
469: FROM pa_resource_assignments ra
470: WHERE ra.budget_version_id = l_source_bv_id);
471:
472: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
473:

Line 510: pa_resource_assignments ra

506: sum(bl.burdened_cost),
507: sum(bl.revenue),
508: l_txn_src_code
509: FROM pa_budget_lines bl,
510: pa_resource_assignments ra
511: WHERE ra.budget_version_id = l_source_bv_id
512: AND ra.resource_assignment_id = bl.resource_assignment_id
513: AND bl.COST_REJECTION_CODE IS NULL
514: AND bl.REVENUE_REJECTION_CODE IS NULL

Line 622: FROM pa_resource_assignments ra,

618: ra.resource_class_flag,
619: ra.named_role,
620: ra.etc_method_code,
621: v.mapped_fin_task_id
622: FROM pa_resource_assignments ra,
623: pa_map_wp_to_fin_tasks_tmp v -- changed pa_map_wp_to_fin_tasks_v for bug#10406949 ->FP Bug#12800007
624: WHERE
625: ra.budget_version_id = l_source_bv_id
626: AND v.mapped_fin_task_id = p_task_id

Line 669: pa_resource_assignments ra,

665: sum(bl.burdened_cost),
666: sum(bl.revenue),
667: l_txn_src_code
668: FROM pa_budget_lines bl,
669: pa_resource_assignments ra,
670: pa_map_wp_to_fin_tasks_tmp v -- changed pa_map_wp_to_fin_tasks_v for bug#10406949 ->FP Bug#12800007
671: WHERE ra.resource_assignment_id = bl.resource_assignment_id
672: and ra.budget_version_id = l_source_bv_id
673: and v.parent_structure_version_id = p_fp_cols_rec_etc_wp.x_project_structure_version_id

Line 789: FROM pa_resource_assignments ra,

785: ra.resource_class_flag,
786: ra.named_role,
787: ra.etc_method_code,
788: v.mapped_fin_task_id
789: FROM pa_resource_assignments ra,
790: pa_map_wp_to_fin_tasks_v v
791: WHERE
792: ra.budget_version_id = l_source_bv_id
793: AND v.mapped_fin_task_id = p_task_id

Line 1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

1341: END UPDATE_TOTAL_PLAN_AMTS;
1342:
1343: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1344: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

Line 1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

1342:
1343: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1344: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,

Line 1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711

1343: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1344: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,
1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1344: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1345: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1346: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1347: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1348: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1349: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1350: P_CURRENCY_FLAG IN VARCHAR2,
1351: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1352: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

Line 1360: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

1356: X_MSG_COUNT OUT NOCOPY NUMBER,
1357: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1358:
1359: L_MODULE_NAME VARCHAR2(200) := 'PA.PLSQL.PA_FP_GEN_FCST_AMT_PUB.GET_ACTUAL_TXN_AMOUNT';
1360: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1361:
1362: L_RATE_BASED_FLAG VARCHAR2(1);
1363: /*'TC' REPRESENTS TXN CURRENCY CODE
1364: 'PC' REPRESENTS PROJECT CURRENCY CODE*/

Line 1387: FROM pa_resource_assignments

1383: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE <> 'P' OR
1384: (P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND
1385: P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'AVERAGE_ACTUALS') THEN
1386: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1387: FROM pa_resource_assignments
1388: WHERE resource_assignment_id = P_RES_ASG_ID;
1389: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1390: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1391: FROM pa_resource_assignments

Line 1391: FROM pa_resource_assignments

1387: FROM pa_resource_assignments
1388: WHERE resource_assignment_id = P_RES_ASG_ID;
1389: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1390: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1391: FROM pa_resource_assignments
1392: WHERE budget_version_id = p_budget_version_id
1393: AND resource_list_member_id = p_res_list_member_id
1394: AND nvl(cbs_element_id,-1) = nvl(P_CBS_ELEMENT_ID,-1) --bug#16791711
1395: AND NVL(task_id, 0) = 0;

Line 1983: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

1979: END GET_ACTUAL_TXN_AMOUNT;
1980:
1981: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1982: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1983: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,

Line 1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

1980:
1981: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1982: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1983: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,
1988: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,

Line 1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711

1981: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1982: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1983: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1984: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1985: P_CBS_ELEMENT_ID IN PA_RESOURCE_ASSIGNMENTS.CBS_ELEMENT_ID%TYPE,--bug#16791711
1986: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1987: P_CURRENCY_FLAG IN VARCHAR2,
1988: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1989: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,

Line 1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1992: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1993: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1994: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1995: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1996: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1998: X_MSG_COUNT OUT NOCOPY NUMBER,
1999: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2000:

Line 2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

2016:
2017: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
2018: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
2019: l_future_no_of_period NUMBER;
2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
2022:
2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2042: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;

2038: l_msg_count NUMBER;
2039: l_data VARCHAR2(2000);
2040: l_msg_data VARCHAR2(2000);
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:

Line 2066: FROM pa_resource_assignments ra,

2062: NVL(ta.billable_flag,'Y') /* 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

Line 2080: FROM pa_resource_assignments ra,

2076: SELECT ra.rate_based_flag,
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;

Line 2425: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2421: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2422: -- DISTINCT target_res_asg_id
2423: --BULK COLLECT
2424: --INTO l_tgt_res_asg_tab
2425: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2426: --WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2427: -- AND ra.rate_based_flag = 'Y'
2428: -- AND tmp.rate_based_flag = 'N';
2429: l_bv_id := p_fp_cols_rec.x_budget_version_id;

Line 2440: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2436: SELECT /*+ LEADING(tmp) */
2437: DISTINCT target_res_asg_id
2438: BULK COLLECT
2439: INTO l_tgt_res_asg_tab
2440: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2441: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2442: AND ra.rate_based_flag = 'Y'
2443: AND tmp.rate_based_flag = 'N';
2444:

Line 2457: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2453: SELECT /*+ LEADING(tmp) */
2454: DISTINCT target_res_asg_id
2455: BULK COLLECT
2456: INTO l_tgt_res_asg_tab
2457: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2458: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2459: AND ra.rate_based_flag = 'Y'
2460: AND tmp.rate_based_flag = 'N'
2461: AND ( ra.transaction_source_code is not null

Line 2479: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2475: SELECT /*+ LEADING(tmp) */
2476: DISTINCT target_res_asg_id
2477: BULK COLLECT
2478: INTO l_tgt_res_asg_tab
2479: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2480: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2481: AND ra.rate_based_flag = 'Y'
2482: AND tmp.rate_based_flag = 'N'
2483: AND ( ra.transaction_source_code is not null

Line 2505: UPDATE pa_resource_assignments

2501: RETURN;
2502: END IF;
2503:
2504: FORALL i IN 1..l_tgt_res_asg_tab.count
2505: UPDATE pa_resource_assignments
2506: SET rate_based_flag = 'N',
2507: unit_of_measure = 'DOLLARS'
2508: WHERE resource_assignment_id = l_tgt_res_asg_tab(i);
2509: