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_LATEST_PUBLISH_FP_WBS_ID IN NUMBER,
18: P_CALLING_CONTEXT IN VARCHAR2,
19: X_TXN_AMT_REC OUT NOCOPY PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP,
20: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

Line 163: l_txn_src_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;

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

Line 300: FROM pa_resource_assignments ra

296: ra.resource_class_flag,
297: ra.named_role,
298: ra.etc_method_code,
299: ra.task_id
300: FROM pa_resource_assignments ra
301: WHERE ra.budget_version_id = l_source_bv_id
302: AND NVL(ra.task_id,0) = p_task_id AND
303: EXISTS (SELECT 1 from pa_budget_lines bl WHERE
304: ra.resource_assignment_id =

Line 349: pa_resource_assignments ra

345: sum(bl.burdened_cost),
346: sum(bl.revenue),
347: l_txn_src_code
348: FROM pa_budget_lines bl,
349: pa_resource_assignments ra
350: WHERE ra.resource_assignment_id = bl.resource_assignment_id
351: and ra.budget_version_id = l_source_bv_id
352: and NVL(ra.task_id,0) = p_task_id
353: AND bl.COST_REJECTION_CODE IS NULL

Line 462: FROM pa_resource_assignments ra

458: ra.resource_class_flag,
459: ra.named_role,
460: ra.etc_method_code,
461: 0
462: FROM pa_resource_assignments ra
463: WHERE ra.budget_version_id = l_source_bv_id);
464:
465: --dbms_output.put_line('No. of rows inserted in tmp1 : '|| sql%rowcount);
466:

Line 503: pa_resource_assignments ra

499: sum(bl.burdened_cost),
500: sum(bl.revenue),
501: l_txn_src_code
502: FROM pa_budget_lines bl,
503: pa_resource_assignments ra
504: WHERE ra.budget_version_id = l_source_bv_id
505: AND ra.resource_assignment_id = bl.resource_assignment_id
506: AND bl.COST_REJECTION_CODE IS NULL
507: AND bl.REVENUE_REJECTION_CODE IS NULL

Line 613: FROM pa_resource_assignments ra,

609: ra.resource_class_flag,
610: ra.named_role,
611: ra.etc_method_code,
612: v.mapped_fin_task_id
613: FROM pa_resource_assignments ra,
614: pa_map_wp_to_fin_tasks_v v
615: WHERE
616: ra.budget_version_id = l_source_bv_id
617: AND v.mapped_fin_task_id = p_task_id

Line 660: pa_resource_assignments ra,

656: sum(bl.burdened_cost),
657: sum(bl.revenue),
658: l_txn_src_code
659: FROM pa_budget_lines bl,
660: pa_resource_assignments ra,
661: pa_map_wp_to_fin_tasks_v v
662: WHERE ra.resource_assignment_id = bl.resource_assignment_id
663: and ra.budget_version_id = l_source_bv_id
664: and v.parent_structure_version_id = p_fp_cols_rec_etc_wp.x_project_structure_version_id

Line 778: FROM pa_resource_assignments ra,

774: ra.resource_class_flag,
775: ra.named_role,
776: ra.etc_method_code,
777: v.mapped_fin_task_id
778: FROM pa_resource_assignments ra,
779: pa_map_wp_to_fin_tasks_v v
780: WHERE
781: ra.budget_version_id = l_source_bv_id
782: AND v.mapped_fin_task_id = p_task_id

Line 1332: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

1328: END UPDATE_TOTAL_PLAN_AMTS;
1329:
1330: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1331: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1332: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,

Line 1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

1329:
1330: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1331: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1332: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,
1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,

Line 1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1330: PROCEDURE GET_ACTUAL_TXN_AMOUNT
1331: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1332: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1333: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1334: P_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1335: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1336: P_CURRENCY_FLAG IN VARCHAR2,
1337: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1338: P_ACTUAL_FROM_DATE IN PA_PERIODS_ALL.START_DATE%TYPE,

Line 1346: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

1342: X_MSG_COUNT OUT NOCOPY NUMBER,
1343: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1344:
1345: L_MODULE_NAME VARCHAR2(200) := 'PA.PLSQL.PA_FP_GEN_FCST_AMT_PUB.GET_ACTUAL_TXN_AMOUNT';
1346: L_RES_ASG_ID PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1347:
1348: L_RATE_BASED_FLAG VARCHAR2(1);
1349: /*'TC' REPRESENTS TXN CURRENCY CODE
1350: 'PC' REPRESENTS PROJECT CURRENCY CODE*/

Line 1373: FROM pa_resource_assignments

1369: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE <> 'P' OR
1370: (P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND
1371: P_FP_COLS_REC.X_GEN_ETC_SRC_CODE = 'AVERAGE_ACTUALS') THEN
1372: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1373: FROM pa_resource_assignments
1374: WHERE resource_assignment_id = P_RES_ASG_ID;
1375: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1376: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1377: FROM pa_resource_assignments

Line 1377: FROM pa_resource_assignments

1373: FROM pa_resource_assignments
1374: WHERE resource_assignment_id = P_RES_ASG_ID;
1375: ELSIF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' THEN
1376: SELECT NVL(rate_based_flag,'N') INTO l_rate_based_flag
1377: FROM pa_resource_assignments
1378: WHERE budget_version_id = p_budget_version_id
1379: AND resource_list_member_id = p_res_list_member_id
1380: AND NVL(task_id, 0) = 0;
1381: END IF;

Line 1953: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

1949: END GET_ACTUAL_TXN_AMOUNT;
1950:
1951: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1952: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1953: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1956: P_CURRENCY_FLAG IN VARCHAR2,
1957: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,

Line 1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,

1950:
1951: PROCEDURE GEN_AVERAGE_OF_ACTUALS
1952: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1953: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1954: P_RES_LIST_MEMBER_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID%TYPE,
1955: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1956: P_CURRENCY_FLAG IN VARCHAR2,
1957: P_PLANNING_START_DATE IN PA_BUDGET_LINES.START_DATE%TYPE,
1958: P_PLANNING_END_DATE IN PA_BUDGET_LINES.END_DATE%TYPE,

Line 1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1961: P_ACTUAL_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1962: P_ACTUAL_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1963: P_ETC_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1964: P_ETC_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1965: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1966: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1967: X_MSG_COUNT OUT NOCOPY NUMBER,
1968: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1969:

Line 1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

1985:
1986: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pvt.gen_average_of_actuals';
1987: l_txn_amt_rec PA_FP_GEN_FCST_AMT_PUB.TXN_AMT_REC_TYP;
1988: l_future_no_of_period NUMBER;
1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
1991:
1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 2011: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;

2007: l_msg_count NUMBER;
2008: l_data VARCHAR2(2000);
2009: l_msg_data VARCHAR2(2000);
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:

Line 2035: FROM pa_resource_assignments ra,

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

Line 2048: FROM pa_resource_assignments ra,

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

Line 2392: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2388: --SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2389: -- DISTINCT target_res_asg_id
2390: --BULK COLLECT
2391: --INTO l_tgt_res_asg_tab
2392: --FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2393: --WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2394: -- AND ra.rate_based_flag = 'Y'
2395: -- AND tmp.rate_based_flag = 'N';
2396: l_bv_id := p_fp_cols_rec.x_budget_version_id;

Line 2407: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2403: SELECT /*+ LEADING(tmp) */
2404: DISTINCT target_res_asg_id
2405: BULK COLLECT
2406: INTO l_tgt_res_asg_tab
2407: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2408: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2409: AND ra.rate_based_flag = 'Y'
2410: AND tmp.rate_based_flag = 'N';
2411:

Line 2424: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2420: SELECT /*+ LEADING(tmp) */
2421: DISTINCT target_res_asg_id
2422: BULK COLLECT
2423: INTO l_tgt_res_asg_tab
2424: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2425: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2426: AND ra.rate_based_flag = 'Y'
2427: AND tmp.rate_based_flag = 'N'
2428: AND ( ra.transaction_source_code is not null

Line 2446: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra

2442: SELECT /*+ LEADING(tmp) */
2443: DISTINCT target_res_asg_id
2444: BULK COLLECT
2445: INTO l_tgt_res_asg_tab
2446: FROM pa_fp_calc_amt_tmp1 tmp, pa_resource_assignments ra
2447: WHERE tmp.target_res_asg_id = ra.resource_assignment_id
2448: AND ra.rate_based_flag = 'Y'
2449: AND tmp.rate_based_flag = 'N'
2450: AND ( ra.transaction_source_code is not null

Line 2472: UPDATE pa_resource_assignments

2468: RETURN;
2469: END IF;
2470:
2471: FORALL i IN 1..l_tgt_res_asg_tab.count
2472: UPDATE pa_resource_assignments
2473: SET rate_based_flag = 'N',
2474: unit_of_measure = 'DOLLARS'
2475: WHERE resource_assignment_id = l_tgt_res_asg_tab(i);
2476: