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

Line 128: FROM pa_resource_assignments

124: resource_list_member_id
125: BULK COLLECT
126: INTO l_da_ra_id_tab,
127: l_da_resource_list_members_tab
128: FROM pa_resource_assignments
129: WHERE budget_version_id = p_budget_version_id;
130:
131: IF l_da_resource_list_members_tab.count = 0 then
132: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

Line 276: -- UPDATE statement for pa_resource_assignments.

272:
273:
274: -- Bug 4143869: Added call to GET_PLAN_VERSION_DTLS to get the value of the
275: -- Retain Maually Added Lines flag. Also, added manual lines logic to the
276: -- UPDATE statement for pa_resource_assignments.
277:
278: IF P_PA_DEBUG_MODE = 'Y' THEN
279: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
280: P_CALLED_MODE => P_CALLED_MODE,

Line 314: UPDATE PA_RESOURCE_ASSIGNMENTS RA

310: -- process and is called by CREATE_RES_ASG in PAFPCAPB.pls.
311:
312: IF l_fp_cols_rec.X_GEN_RET_MANUAL_LINE_FLAG = 'N' THEN
313: FORALL i IN 1 .. l_da_ra_id_tab.count --l_da_resource_list_members_tab.count Bug 4895793
314: UPDATE PA_RESOURCE_ASSIGNMENTS RA
315: SET RESOURCE_CLASS_FLAG = l_da_resource_class_flag_tab(i),
316: RESOURCE_CLASS_CODE = l_da_resource_class_code_tab(i),
317: RES_TYPE_CODE = l_da_res_type_code_tab(i),
318: PERSON_ID = l_da_person_id_tab(i),

Line 362: UPDATE PA_RESOURCE_ASSIGNMENTS RA

358: l_etc_start_date :=
359: PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE(p_budget_version_id);
360: END IF;
361: FORALL i IN 1 .. l_da_ra_id_tab.count --l_da_resource_list_members_tab.count Bug 4895793.
362: UPDATE PA_RESOURCE_ASSIGNMENTS RA
363: SET RESOURCE_CLASS_FLAG = l_da_resource_class_flag_tab(i),
364: RESOURCE_CLASS_CODE = l_da_resource_class_code_tab(i),
365: RES_TYPE_CODE = l_da_res_type_code_tab(i),
366: PERSON_ID = l_da_person_id_tab(i),

Line 774: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

770: i_index NUMBER;
771: l_prev_i_index NUMBER;
772: l_actuals_exist_flag VARCHAR2(1);
773:
774: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
775:
776: /* Scalar variables for summing Plan amounts per ra_id */
777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

Line 835: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;

831: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
832:
833: /* Variables for Fixed Dates spread curve logic */
834: lc_fixed_date_code VARCHAR2(30) := 'FIXED_DATE';
835: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
836: l_fixed_date_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
837:
838: l_count NUMBER;
839: l_msg_count NUMBER;

Line 961: FROM pa_resource_assignments ra,

957: l_res_list_mem_id_tab,
958: l_rate_based_flag_tab,
959: l_planning_start_date_tab,
960: l_planning_end_date_tab
961: FROM pa_resource_assignments ra,
962: pa_res_list_map_tmp4 tmp4
963: WHERE ra.budget_version_id = p_budget_version_id
964: AND ra.task_id = tmp4.txn_task_id
965: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id

Line 982: FROM pa_resource_assignments ra,

978: l_res_list_mem_id_tab,
979: l_rate_based_flag_tab,
980: l_planning_start_date_tab,
981: l_planning_end_date_tab
982: FROM pa_resource_assignments ra,
983: pa_res_list_map_tmp4 tmp4
984: WHERE ra.budget_version_id = p_budget_version_id
985: AND ra.task_id = tmp4.txn_task_id
986: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id

Line 1371: FROM pa_resource_assignments ra,

1367: SELECT /*+ LEADING(tmp4) */
1368: ra.resource_assignment_id
1369: BULK COLLECT
1370: INTO l_fixed_date_ra_id_tab
1371: FROM pa_resource_assignments ra,
1372: pa_res_list_map_tmp4 tmp4
1373: WHERE ra.resource_assignment_id = tmp4.txn_resource_assignment_id
1374: AND ra.spread_curve_id = l_fixed_date_curve_id
1375: AND NOT ( ra.sp_fixed_date BETWEEN l_start_date AND l_end_date );

Line 1378: UPDATE pa_resource_assignments

1374: AND ra.spread_curve_id = l_fixed_date_curve_id
1375: AND NOT ( ra.sp_fixed_date BETWEEN l_start_date AND l_end_date );
1376:
1377: FORALL i IN 1..l_fixed_date_ra_id_tab.count
1378: UPDATE pa_resource_assignments
1379: SET spread_curve_id = NULL,
1380: sp_fixed_date = NULL,
1381: last_update_date = l_sysdate,
1382: last_updated_by = l_last_updated_by,

Line 1532: FROM pa_resource_assignments ra

1528: l_structure_version_id,ra.task_id)
1529: BULK COLLECT
1530: INTO l_task_id_tab,
1531: l_wbs_element_ver_id_tab
1532: FROM pa_resource_assignments ra
1533: WHERE ra.budget_version_id = p_budget_version_id
1534: AND nvl(ra.task_id,0) > 0;
1535:
1536: IF l_task_id_tab.count = 0 THEN

Line 1544: UPDATE pa_resource_assignments

1540: RETURN;
1541: END IF;
1542:
1543: FORALL i in 1..l_task_id_tab.count
1544: UPDATE pa_resource_assignments
1545: SET wbs_element_version_id = l_wbs_element_ver_id_tab(i)
1546: WHERE budget_version_id = p_budget_version_id
1547: AND task_id = l_task_id_tab(i);
1548:

Line 1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1572: copied over to the more granular period.
1573: */
1574: PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
1575: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,

Line 1675: from pa_resource_assignments ra,

1671: into l_org_id,
1672: l_source_ver_period_type,
1673: l_source_set_of_books_id,
1674: l_source_bv_id
1675: from pa_resource_assignments ra,
1676: pa_projects_all p,
1677: pa_proj_fp_options po,
1678: pa_implementations_all pia
1679: where ra.resource_assignment_id = p_src_res_asg_id_tab(1) and

Line 1781: * pa_resource_assignments table for all resource assignments belonging

1777:
1778:
1779: /**
1780: * This procedure updates the fixed date spread curve fields in the
1781: * pa_resource_assignments table for all resource assignments belonging
1782: * to the given budget version as necessary.
1783: * More specifically, for each resource assignment of interest, we null
1784: * out the spread_curve_id and sp_fixed_date pa_resource_assignments
1785: * table values if there exists a budget line for which the resource

Line 1784: * out the spread_curve_id and sp_fixed_date pa_resource_assignments

1780: * This procedure updates the fixed date spread curve fields in the
1781: * pa_resource_assignments table for all resource assignments belonging
1782: * to the given budget version as necessary.
1783: * More specifically, for each resource assignment of interest, we null
1784: * out the spread_curve_id and sp_fixed_date pa_resource_assignments
1785: * table values if there exists a budget line for which the resource
1786: * assignment's sp_fixed_date is not in the budget line's start and end
1787: * date range.
1788: * Additionally, for resources not having Fixed Date spread curves, we

Line 1791: * Note: This API currently updates the PA_RESOURCE_ASSIGNMENTS table

1787: * date range.
1788: * Additionally, for resources not having Fixed Date spread curves, we
1789: * ensure that sp_fixed_date is Nulled out to address Bug 4229963.
1790: *
1791: * Note: This API currently updates the PA_RESOURCE_ASSIGNMENTS table
1792: * multiple times. In the future, we revisit this as a Performance
1793: * issue and modify the logic so that we only update once.
1794: *
1795: * Note that the p_fp_col_rec parameter is currently not used.

Line 1814: FROM pa_resource_assignments ra,

1810: * having a fixed date spread curve and at least two budget lines for some
1811: * transaction currency code. */
1812: CURSOR multi_bl_fixed_date_ra_cur IS
1813: SELECT DISTINCT(bl.resource_assignment_id)
1814: FROM pa_resource_assignments ra,
1815: pa_spread_curves_b sp,
1816: pa_budget_lines bl
1817: WHERE ra.budget_version_id = p_budget_version_id
1818: AND sp.spread_curve_id = ra.spread_curve_id

Line 1833: FROM pa_resource_assignments ra,

1829: * the multi_bl_fixed_date_ra_cur cursor, we can reduce the amount of
1830: * processing required by this cursor. */
1831: CURSOR one_bl_fixed_date_ra_cur IS
1832: SELECT DISTINCT(bl.resource_assignment_id)
1833: FROM pa_resource_assignments ra,
1834: pa_spread_curves_b sp,
1835: pa_budget_lines bl
1836: WHERE ra.budget_version_id = p_budget_version_id
1837: AND sp.spread_curve_id = ra.spread_curve_id

Line 1886: * pa_resource_assignments table for the collected resource

1882: INTO l_res_asg_id_tab;
1883: CLOSE multi_bl_fixed_date_ra_cur;
1884:
1885: /* Null out the sp_fixed_date and spread_curve_id in the
1886: * pa_resource_assignments table for the collected resource
1887: * assignment id's */
1888: FORALL i in 1..l_res_asg_id_tab.count
1889: UPDATE pa_resource_assignments
1890: SET sp_fixed_date = NULL,

Line 1889: UPDATE pa_resource_assignments

1885: /* Null out the sp_fixed_date and spread_curve_id in the
1886: * pa_resource_assignments table for the collected resource
1887: * assignment id's */
1888: FORALL i in 1..l_res_asg_id_tab.count
1889: UPDATE pa_resource_assignments
1890: SET sp_fixed_date = NULL,
1891: spread_curve_id = NULL,
1892: last_update_date = l_sysdate,
1893: last_updated_by = l_last_updated_by,

Line 1910: * pa_resource_assignments table for the collected resource

1906: INTO l_res_asg_id_tab;
1907: CLOSE one_bl_fixed_date_ra_cur;
1908:
1909: /* Null out the sp_fixed_date and spread_curve_id in the
1910: * pa_resource_assignments table for the collected resource
1911: * assignment id's */
1912: FORALL i in 1..l_res_asg_id_tab.count
1913: UPDATE pa_resource_assignments
1914: SET sp_fixed_date = NULL,

Line 1913: UPDATE pa_resource_assignments

1909: /* Null out the sp_fixed_date and spread_curve_id in the
1910: * pa_resource_assignments table for the collected resource
1911: * assignment id's */
1912: FORALL i in 1..l_res_asg_id_tab.count
1913: UPDATE pa_resource_assignments
1914: SET sp_fixed_date = NULL,
1915: spread_curve_id = NULL,
1916: last_update_date = l_sysdate,
1917: last_updated_by = l_last_updated_by,

Line 1923: UPDATE pa_resource_assignments

1919: record_version_number = NVL(record_version_number,0) + 1
1920: WHERE resource_assignment_id = l_res_asg_id_tab(i);
1921:
1922: -- Bug 4229963: Ensure sp_fixed_date is NULL when spread is not Fixed Date.
1923: UPDATE pa_resource_assignments
1924: SET sp_fixed_date = NULL,
1925: last_update_date = l_sysdate,
1926: last_updated_by = l_last_updated_by,
1927: last_update_login = l_last_update_login,

Line 2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE

2054: -- IPM: Added table for copying source resource_rate_based_flag values.
2055: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2056:
2057: l_sysdate DATE;
2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2059: := FND_GLOBAL.user_id;
2060: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2061: := FND_GLOBAL.login_id;
2062:

Line 2060: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE

2056:
2057: l_sysdate DATE;
2058: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2059: := FND_GLOBAL.user_id;
2060: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2061: := FND_GLOBAL.login_id;
2062:
2063: l_count NUMBER;
2064: l_msg_count NUMBER;

Line 2208: FROM PA_RESOURCE_ASSIGNMENTS RA,

2204: l_rate_expenditure_type_tab,
2205: l_rate_func_curr_code_tab,
2206: l_org_id_tab,
2207: l_res_rate_based_flag_tab -- Added for IPM ER
2208: FROM PA_RESOURCE_ASSIGNMENTS RA,
2209: PA_RES_LIST_MAP_TMP1 tmp1,
2210: PA_FP_CALC_AMT_TMP1 map
2211: WHERE RA.budget_version_id = l_src_version_id
2212: AND RA.resource_assignment_id = map.resource_assignment_id

Line 2220: UPDATE PA_RESOURCE_ASSIGNMENTS

2216: --dbms_output.put_line('l_tgt_res_asg_id_tab.count = ' || l_tgt_res_asg_id_tab.count);
2217: l_sysdate := SYSDATE;
2218:
2219: FORALL j IN 1..l_tgt_res_asg_id_tab.count
2220: UPDATE PA_RESOURCE_ASSIGNMENTS
2221: SET RESOURCE_CLASS_FLAG = l_resource_class_flag_tab(j),
2222: RESOURCE_CLASS_CODE = l_resource_class_code_tab(j),
2223: RES_TYPE_CODE = l_res_type_code_tab(j),
2224: PERSON_ID = l_person_id_tab(j),