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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 154: pa_resource_assignments ra,

150: NULL,
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
152: FROM pa_res_list_map_tmp4 tmp4,
153: pa_budget_lines sbl,
154: pa_resource_assignments ra,
155: pa_tasks ta /* Added for ER 4376722 */
156: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
157: and sbl.budget_version_id = l_source_id
158: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 182: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

178: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
179:
180: /* Added for bug #4938603 */
181: CURSOR fcst_bdgt_line_actual_qty
182: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
183: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
184: ) IS
185: SELECT sum(nvl(init_quantity,0))
186: FROM pa_budget_lines

Line 254: pa_resource_assignments ra,

250: NULL,
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
252: FROM pa_res_list_map_tmp4 tmp4,
253: pa_budget_lines sbl,
254: pa_resource_assignments ra,
255: pa_tasks ta /* Added for ER 4376722 */
256: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
257: and sbl.budget_version_id = l_source_id
258: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 325: pa_resource_assignments ra,

321: NULL,
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
323: FROM pa_res_list_map_tmp4 tmp4,
324: pa_budget_lines sbl,
325: pa_resource_assignments ra,
326: pa_tasks ta /* Added for ER 4376722 */
327: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
328: and sbl.budget_version_id = l_source_id
329: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 879: /populating tmp1 with PA_RESOURCE_ASSIGNMENTS/

875: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
876: END IF;
877: END IF;
878:
879: /*populating tmp1 with PA_RESOURCE_ASSIGNMENTS*/
880: IF l_fp_cols_rec_source.x_resource_list_id <>
881: l_fp_cols_rec_target.x_resource_list_id THEN
882: DELETE FROM PA_RES_LIST_MAP_TMP1;
883: DELETE from pa_res_list_map_tmp4;

Line 945: FROM PA_RESOURCE_ASSIGNMENTS ra

941: l_TXN_PLAN_START_DATE_tab,
942: l_TXN_PLAN_END_DATE_tab,
943: l_RATE_BASED_FLAG_tab,
944: l_VENDOR_ID_tab
945: FROM PA_RESOURCE_ASSIGNMENTS ra
946: WHERE ra.budget_version_id = l_source_id;
947: IF l_TXN_SOURCE_ID_tab.count = 0 THEN
948: IF P_PA_DEBUG_MODE = 'Y' THEN
949: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1078: -- select count(*) into l_count from pa_resource_assignments where

1074: --@@
1075:
1076: /*Calling CREATE_RES_ASG API to populate missing resouce assignments for target budget version*/
1077:
1078: -- select count(*) into l_count from pa_resource_assignments where
1079: -- budget_version_id = p_budget_version_id;
1080: -- dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
1081: ELSE
1082: DELETE from PA_RES_LIST_MAP_TMP4;

Line 1156: FROM PA_RESOURCE_ASSIGNMENTS ra

1152: SP_FIXED_DATE,
1153: RESOURCE_LIST_MEMBER_ID,
1154: RATE_BASED_FLAG,
1155: RESOURCE_LIST_MEMBER_ID
1156: FROM PA_RESOURCE_ASSIGNMENTS ra
1157: WHERE ra.budget_version_id = l_source_id;
1158: IF sql%rowcount = 0 THEN
1159: IF P_PA_DEBUG_MODE = 'Y' THEN
1160: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1206: from PA_RESOURCE_ASSIGNMENTS

1202: tmp_task_tab.delete;
1203: tmp_ra_tab.delete;
1204: select resource_list_member_id, task_id, resource_assignment_id
1205: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1206: from PA_RESOURCE_ASSIGNMENTS
1207: where budget_version_id = P_BUDGET_VERSION_ID;
1208: for i in 1..tmp_ra_tab.count loop
1209: pa_fp_gen_amount_utils.fp_debug
1210: (p_called_mode => p_called_mode,

Line 1220: -- select count(*) into l_count from pa_resource_assignments where

1216: end loop;
1217: END IF;
1218: */
1219:
1220: -- select count(*) into l_count from pa_resource_assignments where
1221: -- budget_version_id = p_budget_version_id;
1222: -- dbms_output.put_line('after calling cre res asg api: res_assign has: '||l_count);
1223: -- dbms_output.put_line('--------------');
1224:

Line 1225: -- select count(*) into l_count from pa_resource_assignments where

1221: -- budget_version_id = p_budget_version_id;
1222: -- dbms_output.put_line('after calling cre res asg api: res_assign has: '||l_count);
1223: -- dbms_output.put_line('--------------');
1224:
1225: -- select count(*) into l_count from pa_resource_assignments where
1226: -- budget_version_id = p_budget_version_id;
1227: -- dbms_output.put_line('before calling upd res asg api: res assign has: '||l_count);
1228:
1229: /*Calling UPDATE_RES_ASG API to update resource_assignment_id in tmp4 for target budget version*/

Line 1253: -- select count(*) into l_count from pa_resource_assignments where

1249: --select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4
1250: --where TXN_RESOURCE_ASSIGNMENT_ID is not null;
1251: --hr_utility.trace('aft call update_res_asg, tmp4 with not null txn_res_asg_id '||l_count1);
1252:
1253: -- select count(*) into l_count from pa_resource_assignments where
1254: -- budget_version_id = p_budget_version_id;
1255: -- dbms_output.put_line('after calling upd res asg api: res assign has: '||l_count);
1256: IF P_PA_DEBUG_MODE = 'Y' THEN
1257: pa_fp_gen_amount_utils.fp_debug

Line 1278: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra

1274: SELECT /*+ LEADING(tmp) */
1275: DISTINCT txn_resource_assignment_id
1276: BULK COLLECT
1277: INTO l_tgt_res_asg_id_tab
1278: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra
1279: WHERE tmp.txn_resource_assignment_id = ra.resource_assignment_id
1280: AND ra.rate_based_flag = 'Y'
1281: AND tmp.txn_rate_based_flag = 'N';
1282:

Line 1285: UPDATE pa_resource_assignments

1281: AND tmp.txn_rate_based_flag = 'N';
1282:
1283: IF l_tgt_res_asg_id_tab.count <> 0 THEN
1284: FORALL i IN 1..l_tgt_res_asg_id_tab.count
1285: UPDATE pa_resource_assignments
1286: SET rate_based_flag = 'N',
1287: unit_of_measure = 'DOLLARS'
1288: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
1289:

Line 1382: UPDATE pa_resource_assignments

1378: BULK COLLECT INTO l_res_asg_uom_update_tab
1379: FROM pa_res_list_map_tmp4;
1380:
1381: FORALL i IN 1..l_res_asg_uom_update_tab.count
1382: UPDATE pa_resource_assignments
1383: SET unit_of_measure = 'DOLLARS',
1384: rate_based_flag = 'N'
1385: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
1386: END IF;

Line 1460: pa_resource_assignments ra

1456: l_cost_rate_override_tab,
1457: l_b_cost_rate_override_tab,
1458: l_bill_rate_override_tab
1459: FROM pa_Budget_lines bl,
1460: pa_resource_assignments ra
1461: WHERE bl.budget_version_id = p_budget_version_id
1462: AND ra.budget_version_id = p_budget_version_id
1463: AND bl.resource_assignment_id = ra.resource_assignment_id
1464: AND EXISTS (SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/ 1

Line 1491: UPDATE PA_RESOURCE_ASSIGNMENTS

1487: IF (l_fp_cols_rec_source.X_resource_list_id <>
1488: l_fp_cols_rec_target.X_resource_list_id AND
1489: l_uncategorized_flag = 'Y') THEN
1490: FORALL i IN 1..l_tgt_res_asg_id_tab.count
1491: UPDATE PA_RESOURCE_ASSIGNMENTS
1492: SET SPREAD_CURVE_ID = NULL,
1493: SP_FIXED_DATE = NULL
1494: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
1495: END IF;

Line 2420: UPDATE pa_resource_assignments

2416: BULK COLLECT INTO l_res_asg_uom_update_tab
2417: FROM pa_res_list_map_tmp4;
2418:
2419: FORALL i IN 1..l_res_asg_uom_update_tab.count
2420: UPDATE pa_resource_assignments
2421: SET unit_of_measure = 'DOLLARS',
2422: rate_based_flag = 'N'
2423: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
2424: END IF;

Line 2822: pa_resource_assignments ra,

2818: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2819: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2820: FROM pa_res_list_map_tmp4 tmp4,
2821: pa_budget_lines sbl,
2822: pa_resource_assignments ra,
2823: pa_tasks ta /* Added for ER 4376722 */
2824: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2825: and sbl.budget_version_id = p_source_bv_id
2826: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 2911: pa_resource_assignments ra,

2907: NULL,
2908: NVL(ta.billable_flag,'Y')
2909: FROM pa_res_list_map_tmp4 tmp4,
2910: pa_budget_lines sbl,
2911: pa_resource_assignments ra,
2912: pa_tasks ta
2913: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2914: and sbl.budget_version_id = p_source_bv_id
2915: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3007: pa_resource_assignments ra,

3003: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3004: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3005: FROM pa_res_list_map_tmp4 tmp4,
3006: pa_budget_lines sbl,
3007: pa_resource_assignments ra,
3008: pa_tasks ta /* Added for ER 4376722 */
3009: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3010: and sbl.budget_version_id = p_source_bv_id
3011: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3104: pa_resource_assignments ra,

3100: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3101: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3102: FROM pa_res_list_map_tmp4 tmp4,
3103: pa_budget_lines sbl,
3104: pa_resource_assignments ra,
3105: pa_tasks ta /* Added for ER 4376722 */
3106: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3107: and sbl.budget_version_id = p_source_bv_id
3108: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3136: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

3132: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
3133:
3134: /* Added for bug #4938603 */
3135: CURSOR fcst_bdgt_line_actual_qty
3136: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3137: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3138: ) IS
3139: SELECT sum(nvl(init_quantity,0))
3140: FROM pa_budget_lines

Line 3235: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE

3231: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3232: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3233: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3234:
3235: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
3236: := FND_GLOBAL.user_id;
3237: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
3238: := FND_GLOBAL.login_id;
3239:

Line 3237: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE

3233: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3234:
3235: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
3236: := FND_GLOBAL.user_id;
3237: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
3238: := FND_GLOBAL.login_id;
3239:
3240: l_rev_gen_method VARCHAR2(3);
3241: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;

Line 3565: FROM PA_RESOURCE_ASSIGNMENTS RA,

3561: l_res_rate_based_flag_tab, -- Added for IPM ER
3562: l_rate_expenditure_type_tab,
3563: l_rate_func_curr_code_tab,
3564: l_org_id_tab
3565: FROM PA_RESOURCE_ASSIGNMENTS RA,
3566: PA_RES_LIST_MAP_TMP4 TMP
3567: WHERE RA.budget_version_id = p_source_bv_id
3568: AND RA.resource_assignment_id = TMP.txn_source_id;
3569:

Line 3583: UPDATE PA_RESOURCE_ASSIGNMENTS

3579: END LOOP;
3580: END IF;
3581:
3582: FORALL i IN 1..l_tgt_res_asg_id_tab.count
3583: UPDATE PA_RESOURCE_ASSIGNMENTS
3584: SET RESOURCE_CLASS_FLAG = l_resource_class_flag_tab(i),
3585: RESOURCE_CLASS_CODE = l_resource_class_code_tab(i),
3586: RES_TYPE_CODE = l_res_type_code_tab(i),
3587: PERSON_ID = l_person_id_tab(i),

Line 3738: pa_resource_assignments ra,

3734: WHERE rbc.budget_version_id = p_target_bv_id
3735: AND rbc.txn_bill_rate_override IS NOT NULL
3736: AND EXISTS ( SELECT null
3737: FROM pa_res_list_map_tmp4 tmp4,
3738: pa_resource_assignments ra,
3739: pa_tasks ta
3740: WHERE rbc.resource_assignment_id = tmp4.txn_resource_assignment_id
3741: AND tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3742: AND ra.task_id = ta.task_id

Line 3788: UPDATE pa_resource_assignments

3784: * may therefore contain ammounts aggregated from source amounts, in which
3785: * case the target spread curve will no longer reflect budget line amounts.
3786: * Hence, we NULL out the spread_curve_id for the target resources. */
3787:
3788: UPDATE pa_resource_assignments
3789: SET spread_curve_id = NULL,
3790: sp_fixed_date = NULL
3791: WHERE budget_version_id = p_target_bv_id
3792: AND EXISTS

Line 4921: UPDATE pa_resource_assignments

4917: BULK COLLECT INTO l_res_asg_uom_update_tab
4918: FROM pa_res_list_map_tmp4;
4919:
4920: FORALL i IN 1..l_res_asg_uom_update_tab.count
4921: UPDATE pa_resource_assignments
4922: SET unit_of_measure = 'DOLLARS',
4923: rate_based_flag = 'N'
4924: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
4925: END IF;

Line 5471: FROM pa_resource_assignments ra,

5467: bl.txn_currency_code,
5468: rbc.txn_raw_cost_rate_override,
5469: rbc.txn_burden_cost_rate_override,
5470: rbc.txn_bill_rate_override
5471: FROM pa_resource_assignments ra,
5472: pa_budget_lines bl,
5473: pa_resource_asgn_curr rbc,
5474: pa_res_list_map_tmp4 tmp4
5475: WHERE ra.budget_version_id = p_target_bv_id