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 189: pa_resource_assignments ra,

185: NULL,
186: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
187: FROM pa_res_list_map_tmp4 tmp4,
188: pa_budget_lines sbl,
189: pa_resource_assignments ra,
190: pa_tasks ta /* Added for ER 4376722 */
191: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
192: and sbl.budget_version_id = l_source_id
193: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 217: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

213: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
214:
215: /* Added for bug #4938603 */
216: CURSOR fcst_bdgt_line_actual_qty
217: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
218: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
219: ) IS
220: SELECT sum(nvl(init_quantity,0))
221: FROM pa_budget_lines

Line 289: pa_resource_assignments ra,

285: NULL,
286: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
287: FROM pa_res_list_map_tmp4 tmp4,
288: pa_budget_lines sbl,
289: pa_resource_assignments ra,
290: pa_tasks ta /* Added for ER 4376722 */
291: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
292: and sbl.budget_version_id = l_source_id
293: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 360: pa_resource_assignments ra,

356: NULL,
357: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
358: FROM pa_res_list_map_tmp4 tmp4,
359: pa_budget_lines sbl,
360: pa_resource_assignments ra,
361: pa_tasks ta /* Added for ER 4376722 */
362: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
363: and sbl.budget_version_id = l_source_id
364: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 915: /populating tmp1 with PA_RESOURCE_ASSIGNMENTS/

911: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
912: END IF;
913: END IF;
914:
915: /*populating tmp1 with PA_RESOURCE_ASSIGNMENTS*/
916: IF l_fp_cols_rec_source.x_resource_list_id <>
917: l_fp_cols_rec_target.x_resource_list_id THEN
918: DELETE FROM PA_RES_LIST_MAP_TMP1;
919: DELETE from pa_res_list_map_tmp4;

Line 983: FROM PA_RESOURCE_ASSIGNMENTS ra

979: l_TXN_PLAN_END_DATE_tab,
980: l_RATE_BASED_FLAG_tab,
981: l_VENDOR_ID_tab,
982: l_CBS_ELEMENT_ID_tab --bug#16827157
983: FROM PA_RESOURCE_ASSIGNMENTS ra
984: WHERE ra.budget_version_id = l_source_id;
985: IF l_TXN_SOURCE_ID_tab.count = 0 THEN
986: IF P_PA_DEBUG_MODE = 'Y' THEN
987: PA_DEBUG.RESET_CURR_FUNCTION;

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

1113: --@@
1114:
1115: /*Calling CREATE_RES_ASG API to populate missing resouce assignments for target budget version*/
1116:
1117: -- select count(*) into l_count from pa_resource_assignments where
1118: -- budget_version_id = p_budget_version_id;
1119: -- dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
1120: ELSE
1121:

Line 1198: FROM PA_RESOURCE_ASSIGNMENTS ra

1194: RESOURCE_LIST_MEMBER_ID,
1195: RATE_BASED_FLAG,
1196: RESOURCE_LIST_MEMBER_ID,
1197: CBS_ELEMENT_ID--bug#16827157
1198: FROM PA_RESOURCE_ASSIGNMENTS ra
1199: WHERE ra.budget_version_id = l_source_id;
1200: IF sql%rowcount = 0 THEN
1201: IF P_PA_DEBUG_MODE = 'Y' THEN
1202: PA_DEBUG.RESET_CURR_FUNCTION;

Line 1248: from PA_RESOURCE_ASSIGNMENTS

1244: tmp_task_tab.delete;
1245: tmp_ra_tab.delete;
1246: select resource_list_member_id, task_id, resource_assignment_id
1247: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1248: from PA_RESOURCE_ASSIGNMENTS
1249: where budget_version_id = P_BUDGET_VERSION_ID;
1250: for i in 1..tmp_ra_tab.count loop
1251: pa_fp_gen_amount_utils.fp_debug
1252: (p_called_mode => p_called_mode,

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

1258: end loop;
1259: END IF;
1260: */
1261:
1262: -- select count(*) into l_count from pa_resource_assignments where
1263: -- budget_version_id = p_budget_version_id;
1264: -- dbms_output.put_line('after calling cre res asg api: res_assign has: '||l_count);
1265: -- dbms_output.put_line('--------------');
1266:

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

1263: -- budget_version_id = p_budget_version_id;
1264: -- dbms_output.put_line('after calling cre res asg api: res_assign has: '||l_count);
1265: -- dbms_output.put_line('--------------');
1266:
1267: -- select count(*) into l_count from pa_resource_assignments where
1268: -- budget_version_id = p_budget_version_id;
1269: -- dbms_output.put_line('before calling upd res asg api: res assign has: '||l_count);
1270:
1271: /*Calling UPDATE_RES_ASG API to update resource_assignment_id in tmp4 for target budget version*/

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

1291: --select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4
1292: --where TXN_RESOURCE_ASSIGNMENT_ID is not null;
1293: --hr_utility.trace('aft call update_res_asg, tmp4 with not null txn_res_asg_id '||l_count1);
1294:
1295: -- select count(*) into l_count from pa_resource_assignments where
1296: -- budget_version_id = p_budget_version_id;
1297: -- dbms_output.put_line('after calling upd res asg api: res assign has: '||l_count);
1298: IF P_PA_DEBUG_MODE = 'Y' THEN
1299: pa_fp_gen_amount_utils.fp_debug

Line 1320: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra

1316: SELECT /*+ LEADING(tmp) */
1317: DISTINCT txn_resource_assignment_id
1318: BULK COLLECT
1319: INTO l_tgt_res_asg_id_tab
1320: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra
1321: WHERE tmp.txn_resource_assignment_id = ra.resource_assignment_id
1322: AND ra.rate_based_flag = 'Y'
1323: AND tmp.txn_rate_based_flag = 'N';
1324:

Line 1327: UPDATE pa_resource_assignments

1323: AND tmp.txn_rate_based_flag = 'N';
1324:
1325: IF l_tgt_res_asg_id_tab.count <> 0 THEN
1326: FORALL i IN 1..l_tgt_res_asg_id_tab.count
1327: UPDATE pa_resource_assignments
1328: SET rate_based_flag = 'N',
1329: unit_of_measure = 'DOLLARS'
1330: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
1331:

Line 1424: UPDATE pa_resource_assignments

1420: BULK COLLECT INTO l_res_asg_uom_update_tab
1421: FROM pa_res_list_map_tmp4;
1422:
1423: FORALL i IN 1..l_res_asg_uom_update_tab.count
1424: UPDATE pa_resource_assignments
1425: SET unit_of_measure = 'DOLLARS',
1426: rate_based_flag = 'N'
1427: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
1428: END IF;

Line 1502: pa_resource_assignments ra

1498: l_cost_rate_override_tab,
1499: l_b_cost_rate_override_tab,
1500: l_bill_rate_override_tab
1501: FROM pa_Budget_lines bl,
1502: pa_resource_assignments ra
1503: WHERE bl.budget_version_id = p_budget_version_id
1504: AND ra.budget_version_id = p_budget_version_id
1505: AND bl.resource_assignment_id = ra.resource_assignment_id
1506: AND EXISTS (SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/ 1

Line 1533: UPDATE PA_RESOURCE_ASSIGNMENTS

1529: IF (l_fp_cols_rec_source.X_resource_list_id <>
1530: l_fp_cols_rec_target.X_resource_list_id AND
1531: l_uncategorized_flag = 'Y') THEN
1532: FORALL i IN 1..l_tgt_res_asg_id_tab.count
1533: UPDATE PA_RESOURCE_ASSIGNMENTS
1534: SET SPREAD_CURVE_ID = NULL,
1535: SP_FIXED_DATE = NULL
1536: WHERE resource_assignment_id = l_tgt_res_asg_id_tab(i);
1537: END IF;

Line 2462: UPDATE pa_resource_assignments

2458: BULK COLLECT INTO l_res_asg_uom_update_tab
2459: FROM pa_res_list_map_tmp4;
2460:
2461: FORALL i IN 1..l_res_asg_uom_update_tab.count
2462: UPDATE pa_resource_assignments
2463: SET unit_of_measure = 'DOLLARS',
2464: rate_based_flag = 'N'
2465: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
2466: END IF;

Line 2899: pa_resource_assignments ra,

2895: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2896: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2897: FROM pa_res_list_map_tmp4 tmp4,
2898: pa_budget_lines sbl,
2899: pa_resource_assignments ra,
2900: pa_tasks ta /* Added for ER 4376722 */
2901: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2902: and sbl.budget_version_id = p_source_bv_id
2903: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 2989: pa_resource_assignments ra,

2985: NVL(ta.billable_flag,'Y'),
2986: avg(sbl.txn_markup_percent) -- Bug #13552225
2987: FROM pa_res_list_map_tmp4 tmp4,
2988: pa_budget_lines sbl,
2989: pa_resource_assignments ra,
2990: pa_tasks ta
2991: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2992: and sbl.budget_version_id = p_source_bv_id
2993: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3085: pa_resource_assignments ra,

3081: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3082: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3083: FROM pa_res_list_map_tmp4 tmp4,
3084: pa_budget_lines sbl,
3085: pa_resource_assignments ra,
3086: pa_tasks ta /* Added for ER 4376722 */
3087: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3088: and sbl.budget_version_id = p_source_bv_id
3089: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3182: pa_resource_assignments ra,

3178: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3179: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3180: FROM pa_res_list_map_tmp4 tmp4,
3181: pa_budget_lines sbl,
3182: pa_resource_assignments ra,
3183: pa_tasks ta /* Added for ER 4376722 */
3184: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3185: and sbl.budget_version_id = p_source_bv_id
3186: and tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3214: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

3210: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
3211:
3212: /* Added for bug #4938603 */
3213: CURSOR fcst_bdgt_line_actual_qty
3214: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3215: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3216: ) IS
3217: SELECT sum(nvl(init_quantity,0))
3218: FROM pa_budget_lines

Line 3313: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE

3309: l_rate_expenditure_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3310: l_rate_func_curr_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
3311: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3312:
3313: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
3314: := FND_GLOBAL.user_id;
3315: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
3316: := FND_GLOBAL.login_id;
3317:

Line 3315: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE

3311: l_org_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
3312:
3313: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
3314: := FND_GLOBAL.user_id;
3315: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
3316: := FND_GLOBAL.login_id;
3317:
3318: l_rev_gen_method VARCHAR2(3);
3319: l_res_asg_uom_update_tab pa_plsql_datatypes.IdTabTyp;

Line 3643: FROM PA_RESOURCE_ASSIGNMENTS RA,

3639: l_res_rate_based_flag_tab, -- Added for IPM ER
3640: l_rate_expenditure_type_tab,
3641: l_rate_func_curr_code_tab,
3642: l_org_id_tab
3643: FROM PA_RESOURCE_ASSIGNMENTS RA,
3644: PA_RES_LIST_MAP_TMP4 TMP
3645: WHERE RA.budget_version_id = p_source_bv_id
3646: AND RA.resource_assignment_id = TMP.txn_source_id;
3647:

Line 3661: UPDATE PA_RESOURCE_ASSIGNMENTS

3657: END LOOP;
3658: END IF;
3659:
3660: FORALL i IN 1..l_tgt_res_asg_id_tab.count
3661: UPDATE PA_RESOURCE_ASSIGNMENTS
3662: SET RESOURCE_CLASS_FLAG = l_resource_class_flag_tab(i),
3663: RESOURCE_CLASS_CODE = l_resource_class_code_tab(i),
3664: RES_TYPE_CODE = l_res_type_code_tab(i),
3665: PERSON_ID = l_person_id_tab(i),

Line 3816: pa_resource_assignments ra,

3812: WHERE rbc.budget_version_id = p_target_bv_id
3813: AND rbc.txn_bill_rate_override IS NOT NULL
3814: AND EXISTS ( SELECT null
3815: FROM pa_res_list_map_tmp4 tmp4,
3816: pa_resource_assignments ra,
3817: pa_tasks ta
3818: WHERE rbc.resource_assignment_id = tmp4.txn_resource_assignment_id
3819: AND tmp4.txn_resource_assignment_id = ra.resource_assignment_id
3820: AND ra.task_id = ta.task_id

Line 3866: UPDATE pa_resource_assignments

3862: * may therefore contain ammounts aggregated from source amounts, in which
3863: * case the target spread curve will no longer reflect budget line amounts.
3864: * Hence, we NULL out the spread_curve_id for the target resources. */
3865:
3866: UPDATE pa_resource_assignments
3867: SET spread_curve_id = NULL,
3868: sp_fixed_date = NULL
3869: WHERE budget_version_id = p_target_bv_id
3870: AND EXISTS

Line 5000: UPDATE pa_resource_assignments

4996: BULK COLLECT INTO l_res_asg_uom_update_tab
4997: FROM pa_res_list_map_tmp4;
4998:
4999: FORALL i IN 1..l_res_asg_uom_update_tab.count
5000: UPDATE pa_resource_assignments
5001: SET unit_of_measure = 'DOLLARS',
5002: rate_based_flag = 'N'
5003: WHERE resource_assignment_id = l_res_asg_uom_update_tab(i);
5004: END IF;

Line 5550: FROM pa_resource_assignments ra,

5546: bl.txn_currency_code,
5547: rbc.txn_raw_cost_rate_override,
5548: rbc.txn_burden_cost_rate_override,
5549: rbc.txn_bill_rate_override
5550: FROM pa_resource_assignments ra,
5551: pa_budget_lines bl,
5552: pa_resource_asgn_curr rbc,
5553: pa_res_list_map_tmp4 tmp4
5554: WHERE ra.budget_version_id = p_target_bv_id