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

Line 388: pa_resource_assignments ra

384: 'Y', pji_tmp.pou_revenue,
385: 'N', pji_tmp.prj_revenue,
386: 'A', pji_tmp.pou_revenue))
387: FROM pji_fm_xbs_accum_tmp1 pji_tmp,
388: pa_resource_assignments ra
389: WHERE c_version_type = 'ALL'
390: AND ( (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
391: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR
392: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR

Line 436: pa_resource_assignments ra

432: 'Y', pji_tmp.pou_revenue,
433: 'N', pji_tmp.prj_revenue,
434: 'A', pji_tmp.pou_revenue))
435: FROM pji_fm_xbs_accum_tmp1 pji_tmp,
436: pa_resource_assignments ra
437: WHERE c_version_type = 'COST'
438: AND (
439: (NVL(pji_tmp.txn_raw_cost, 0) <> 0) OR
440: (NVL(pji_tmp.txn_brdn_cost, 0) <> 0) OR

Line 484: pa_resource_assignments ra

480: 'Y', pji_tmp.pou_revenue,
481: 'N', pji_tmp.prj_revenue,
482: 'A', pji_tmp.pou_revenue))
483: FROM pji_fm_xbs_accum_tmp1 pji_tmp,
484: pa_resource_assignments ra
485: WHERE c_version_type = 'REVENUE'
486: AND (
487: (NVL(pji_tmp.txn_revenue, 0) <> 0) OR
488: (NVL(pji_tmp.quantity,0) <> 0)

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

734: ( SELECT DISTINCT PROJECT_ELEMENT_ID,
735: RES_LIST_MEMBER_ID,
736: NULL
737: FROM PJI_FM_XBS_ACCUM_TMP1);
738: -- select count(*) into l_count from pa_resource_assignments where
739: -- budget_version_id = p_budget_version_id;
740: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_fp_gen_amount_utils.fp_debug

Line 826: -- UPDATE pa_resource_assignments ra

822: FROM pji_fm_xbs_accum_tmp1;
823:
824: -- Bug 4170419: Start
825: -- FORALL k IN 1..l_res_asg_id_tmp_tab.count
826: -- UPDATE pa_resource_assignments ra
827: -- SET ra.unit_of_measure = 'DOLLARS',
828: -- ra.rate_based_flag = 'N'
829: -- WHERE ra.resource_assignment_id = l_res_asg_id_tmp_tab(k);
830:

Line 835: UPDATE pa_resource_assignments ra

831: If p_fp_cols_rec.x_time_phased_code IN ('P','G') then
832: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.get_etc_start_date(p_fp_cols_rec.x_budget_version_id);
833:
834: FORALL k IN 1..l_res_asg_id_tmp_tab.count
835: UPDATE pa_resource_assignments ra
836: SET ra.unit_of_measure = 'DOLLARS',
837: ra.rate_based_flag = 'N'
838: WHERE ra.resource_assignment_id = l_res_asg_id_tmp_tab(k)
839: AND ( ra.transaction_source_code is not null

Line 852: UPDATE pa_resource_assignments ra

848: );
849:
850: Else
851: FORALL k IN 1..l_res_asg_id_tmp_tab.count
852: UPDATE pa_resource_assignments ra
853: SET ra.unit_of_measure = 'DOLLARS',
854: ra.rate_based_flag = 'N'
855: WHERE ra.resource_assignment_id = l_res_asg_id_tmp_tab(k)
856: AND ( ra.transaction_source_code is not null

Line 953: FROM pa_resource_assignments

949: --dbms_output.put_line('Closing budget_line_cursor_np');
950: END IF;
951:
952: SELECT rate_based_flag into l_rate_based_flag
953: FROM pa_resource_assignments
954: WHERE resource_assignment_id = l_res_asg_id_tab(i);
955: --dbms_output.put_line('l_rate_based_flag: '||l_rate_based_flag);
956: IF l_rate_based_flag = 'N' THEN
957: IF P_FP_COLS_REC.x_version_type = 'REVENUE' THEN

Line 1038: /* the planning start date and end date in pa_resource assignments table

1034: END IF;
1035:
1036: END LOOP;
1037:
1038: /* the planning start date and end date in pa_resource assignments table
1039: * should be synched up with the budget lines after copying the actual
1040: * data for all the planning resources. */
1041: IF p_pa_debug_mode = 'Y' THEN
1042: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG

Line 1215: FROM pa_resource_assignments ra

1211: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1212: WHERE nvl(tmp1.task_id,0) = 0
1213: AND NOT EXISTS (
1214: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1215: FROM pa_resource_assignments ra
1216: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1217: AND NVL(ra.task_id,0) = 0
1218: AND ra.resource_list_member_id = tmp1.resource_list_member_id);
1219:

Line 1242: FROM pa_resource_assignments ra

1238: WHERE nvl(tmp1.task_id,0) > 0
1239: AND tmp1.task_id = task.task_id
1240: AND NOT EXISTS (
1241: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1242: FROM pa_resource_assignments ra
1243: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1244: AND nvl(ra.task_id,0) = nvl(tmp1.task_id,0)
1245: AND ra.resource_list_member_id = tmp1.resource_list_member_id)
1246: UNION

Line 1260: FROM pa_resource_assignments ra

1256: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1257: WHERE nvl(tmp1.task_id,0) = 0
1258: AND NOT EXISTS (
1259: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1260: FROM pa_resource_assignments ra
1261: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1262: AND NVL(ra.task_id,0) = 0
1263: AND ra.resource_list_member_id = tmp1.resource_list_member_id);
1264:

Line 1288: FROM pa_resource_assignments ra

1284: AND tmp1.task_id = task.task_id
1285: AND task.top_task_id = task_t.task_id
1286: AND NOT EXISTS (
1287: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1288: FROM pa_resource_assignments ra
1289: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1290: AND nvl(ra.task_id,0) = task_t.task_id
1291: AND ra.resource_list_member_id = tmp1.resource_list_member_id)
1292: GROUP BY task_t.task_id,

Line 1311: FROM pa_resource_assignments ra

1307: FROM PA_FP_PLANNING_RES_TMP1 tmp1
1308: WHERE nvl(tmp1.task_id,0) = 0
1309: AND NOT EXISTS (
1310: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1
1311: FROM pa_resource_assignments ra
1312: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1313: AND NVL(ra.task_id,0) = 0
1314: AND ra.resource_list_member_id = tmp1.resource_list_member_id)
1315: GROUP BY nvl(tmp1.task_id,0),

Line 1461: INSERT INTO PA_RESOURCE_ASSIGNMENTS (

1457: RETURN;
1458: END IF;
1459:
1460: FORALL i in l_task_id_tab.first .. l_task_id_tab.last
1461: INSERT INTO PA_RESOURCE_ASSIGNMENTS (
1462: RESOURCE_ASSIGNMENT_ID,
1463: BUDGET_VERSION_ID,
1464: PROJECT_ID,
1465: RESOURCE_LIST_MEMBER_ID,

Line 1479: pa_resource_assignments_s.nextval,

1475: RESOURCE_ASSIGNMENT_TYPE,
1476: RECORD_VERSION_NUMBER,
1477: TRANSACTION_SOURCE_CODE )
1478: VALUES (
1479: pa_resource_assignments_s.nextval,
1480: p_budget_version_id,
1481: p_project_id,
1482: l_rlm_id_tab(i),
1483: l_task_id_tab(i),

Line 1523: UPDATE PA_RESOURCE_ASSIGNMENTS

1519: INTO l_spread_curve_id
1520: FROM pa_spread_curves_b
1521: WHERE spread_curve_code = 'FIXED_DATE';
1522:
1523: UPDATE PA_RESOURCE_ASSIGNMENTS
1524: SET SP_FIXED_DATE = PLANNING_START_DATE
1525: WHERE SP_FIXED_DATE IS NULL
1526: AND SPREAD_CURVE_ID = l_spread_curve_id
1527: AND BUDGET_VERSION_ID = P_BUDGET_VERSION_ID;

Line 1632: FROM pa_resource_assignments ra

1628:
1629: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1630: SET resource_assignment_id =
1631: (SELECT resource_assignment_id
1632: FROM pa_resource_assignments ra
1633: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1634: AND ra.project_id = P_PROJECT_ID
1635: AND nvl(ra.task_id,0) = 0
1636: AND ra.resource_list_member_id = tmp1.resource_list_member_id);

Line 1643: FROM pa_resource_assignments ra

1639:
1640: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1641: SET resource_assignment_id =
1642: (SELECT resource_assignment_id
1643: FROM pa_resource_assignments ra
1644: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1645: AND ra.project_id = P_PROJECT_ID
1646: AND ra.task_id = tmp1.task_id
1647: AND ra.resource_list_member_id = tmp1.resource_list_member_id)

Line 1654: FROM pa_resource_assignments ra

1650:
1651: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1652: SET resource_assignment_id =
1653: (SELECT resource_assignment_id
1654: FROM pa_resource_assignments ra
1655: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1656: AND ra.project_id = P_PROJECT_ID
1657: AND nvl(ra.task_id,0) = 0
1658: AND ra.resource_list_member_id = tmp1.resource_list_member_id)

Line 1666: FROM pa_resource_assignments ra,

1662:
1663: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1664: SET resource_assignment_id =
1665: (SELECT resource_assignment_id
1666: FROM pa_resource_assignments ra,
1667: pa_tasks t
1668: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1669: AND ra.project_id = P_PROJECT_ID
1670: AND tmp1.task_id = t.task_id

Line 1679: FROM pa_resource_assignments ra

1675:
1676: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1677: SET resource_assignment_id =
1678: (SELECT resource_assignment_id
1679: FROM pa_resource_assignments ra
1680: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1681: AND ra.project_id = P_PROJECT_ID
1682: AND nvl(ra.task_id,0) = 0
1683: AND ra.resource_list_member_id = tmp1.resource_list_member_id)