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 761: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

757: i_index NUMBER;
758: l_prev_i_index NUMBER;
759: l_actuals_exist_flag VARCHAR2(1);
760:
761: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
762:
763: /* Scalar variables for summing Plan amounts per ra_id */
764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

Line 822: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;

818: l_upd_burd_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
819:
820: /* Variables for Fixed Dates spread curve logic */
821: lc_fixed_date_code VARCHAR2(30) := 'FIXED_DATE';
822: l_fixed_date_curve_id PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID%TYPE;
823: l_fixed_date_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
824:
825: l_count NUMBER;
826: l_msg_count NUMBER;

Line 948: FROM pa_resource_assignments ra,

944: l_res_list_mem_id_tab,
945: l_rate_based_flag_tab,
946: l_planning_start_date_tab,
947: l_planning_end_date_tab
948: FROM pa_resource_assignments ra,
949: pa_res_list_map_tmp4 tmp4
950: WHERE ra.budget_version_id = p_budget_version_id
951: AND ra.task_id = tmp4.txn_task_id
952: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id

Line 969: FROM pa_resource_assignments ra,

965: l_res_list_mem_id_tab,
966: l_rate_based_flag_tab,
967: l_planning_start_date_tab,
968: l_planning_end_date_tab
969: FROM pa_resource_assignments ra,
970: pa_res_list_map_tmp4 tmp4
971: WHERE ra.budget_version_id = p_budget_version_id
972: AND ra.task_id = tmp4.txn_task_id
973: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id

Line 1358: FROM pa_resource_assignments ra,

1354: SELECT /*+ LEADING(tmp4) */
1355: ra.resource_assignment_id
1356: BULK COLLECT
1357: INTO l_fixed_date_ra_id_tab
1358: FROM pa_resource_assignments ra,
1359: pa_res_list_map_tmp4 tmp4
1360: WHERE ra.resource_assignment_id = tmp4.txn_resource_assignment_id
1361: AND ra.spread_curve_id = l_fixed_date_curve_id
1362: AND NOT ( ra.sp_fixed_date BETWEEN l_start_date AND l_end_date );

Line 1365: UPDATE pa_resource_assignments

1361: AND ra.spread_curve_id = l_fixed_date_curve_id
1362: AND NOT ( ra.sp_fixed_date BETWEEN l_start_date AND l_end_date );
1363:
1364: FORALL i IN 1..l_fixed_date_ra_id_tab.count
1365: UPDATE pa_resource_assignments
1366: SET spread_curve_id = NULL,
1367: sp_fixed_date = NULL,
1368: last_update_date = l_sysdate,
1369: last_updated_by = l_last_updated_by,

Line 1519: FROM pa_resource_assignments ra

1515: l_structure_version_id,ra.task_id)
1516: BULK COLLECT
1517: INTO l_task_id_tab,
1518: l_wbs_element_ver_id_tab
1519: FROM pa_resource_assignments ra
1520: WHERE ra.budget_version_id = p_budget_version_id
1521: AND nvl(ra.task_id,0) > 0;
1522:
1523: IF l_task_id_tab.count = 0 THEN

Line 1531: UPDATE pa_resource_assignments

1527: RETURN;
1528: END IF;
1529:
1530: FORALL i in 1..l_task_id_tab.count
1531: UPDATE pa_resource_assignments
1532: SET wbs_element_version_id = l_wbs_element_ver_id_tab(i)
1533: WHERE budget_version_id = p_budget_version_id
1534: AND task_id = l_task_id_tab(i);
1535:

Line 1563: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

1559: copied over to the more granular period.
1560: */
1561: PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
1562: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1563: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1564: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1565: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,

Line 1662: from pa_resource_assignments ra,

1658: into l_org_id,
1659: l_source_ver_period_type,
1660: l_source_set_of_books_id,
1661: l_source_bv_id
1662: from pa_resource_assignments ra,
1663: pa_projects_all p,
1664: pa_proj_fp_options po,
1665: pa_implementations_all pia
1666: where ra.resource_assignment_id = p_src_res_asg_id_tab(1) and

Line 1768: * pa_resource_assignments table for all resource assignments belonging

1764:
1765:
1766: /**
1767: * This procedure updates the fixed date spread curve fields in the
1768: * pa_resource_assignments table for all resource assignments belonging
1769: * to the given budget version as necessary.
1770: * More specifically, for each resource assignment of interest, we null
1771: * out the spread_curve_id and sp_fixed_date pa_resource_assignments
1772: * table values if there exists a budget line for which the resource

Line 1771: * out the spread_curve_id and sp_fixed_date pa_resource_assignments

1767: * This procedure updates the fixed date spread curve fields in the
1768: * pa_resource_assignments table for all resource assignments belonging
1769: * to the given budget version as necessary.
1770: * More specifically, for each resource assignment of interest, we null
1771: * out the spread_curve_id and sp_fixed_date pa_resource_assignments
1772: * table values if there exists a budget line for which the resource
1773: * assignment's sp_fixed_date is not in the budget line's start and end
1774: * date range.
1775: * Additionally, for resources not having Fixed Date spread curves, we

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

1774: * date range.
1775: * Additionally, for resources not having Fixed Date spread curves, we
1776: * ensure that sp_fixed_date is Nulled out to address Bug 4229963.
1777: *
1778: * Note: This API currently updates the PA_RESOURCE_ASSIGNMENTS table
1779: * multiple times. In the future, we revisit this as a Performance
1780: * issue and modify the logic so that we only update once.
1781: *
1782: * Note that the p_fp_col_rec parameter is currently not used.

Line 1801: FROM pa_resource_assignments ra,

1797: * having a fixed date spread curve and at least two budget lines for some
1798: * transaction currency code. */
1799: CURSOR multi_bl_fixed_date_ra_cur IS
1800: SELECT DISTINCT(bl.resource_assignment_id)
1801: FROM pa_resource_assignments ra,
1802: pa_spread_curves_b sp,
1803: pa_budget_lines bl
1804: WHERE ra.budget_version_id = p_budget_version_id
1805: AND sp.spread_curve_id = ra.spread_curve_id

Line 1820: FROM pa_resource_assignments ra,

1816: * the multi_bl_fixed_date_ra_cur cursor, we can reduce the amount of
1817: * processing required by this cursor. */
1818: CURSOR one_bl_fixed_date_ra_cur IS
1819: SELECT DISTINCT(bl.resource_assignment_id)
1820: FROM pa_resource_assignments ra,
1821: pa_spread_curves_b sp,
1822: pa_budget_lines bl
1823: WHERE ra.budget_version_id = p_budget_version_id
1824: AND sp.spread_curve_id = ra.spread_curve_id

Line 1873: * pa_resource_assignments table for the collected resource

1869: INTO l_res_asg_id_tab;
1870: CLOSE multi_bl_fixed_date_ra_cur;
1871:
1872: /* Null out the sp_fixed_date and spread_curve_id in the
1873: * pa_resource_assignments table for the collected resource
1874: * assignment id's */
1875: FORALL i in 1..l_res_asg_id_tab.count
1876: UPDATE pa_resource_assignments
1877: SET sp_fixed_date = NULL,

Line 1876: UPDATE pa_resource_assignments

1872: /* Null out the sp_fixed_date and spread_curve_id in the
1873: * pa_resource_assignments table for the collected resource
1874: * assignment id's */
1875: FORALL i in 1..l_res_asg_id_tab.count
1876: UPDATE pa_resource_assignments
1877: SET sp_fixed_date = NULL,
1878: spread_curve_id = NULL,
1879: last_update_date = l_sysdate,
1880: last_updated_by = l_last_updated_by,

Line 1897: * pa_resource_assignments table for the collected resource

1893: INTO l_res_asg_id_tab;
1894: CLOSE one_bl_fixed_date_ra_cur;
1895:
1896: /* Null out the sp_fixed_date and spread_curve_id in the
1897: * pa_resource_assignments table for the collected resource
1898: * assignment id's */
1899: FORALL i in 1..l_res_asg_id_tab.count
1900: UPDATE pa_resource_assignments
1901: SET sp_fixed_date = NULL,

Line 1900: UPDATE pa_resource_assignments

1896: /* Null out the sp_fixed_date and spread_curve_id in the
1897: * pa_resource_assignments table for the collected resource
1898: * assignment id's */
1899: FORALL i in 1..l_res_asg_id_tab.count
1900: UPDATE pa_resource_assignments
1901: SET sp_fixed_date = NULL,
1902: spread_curve_id = NULL,
1903: last_update_date = l_sysdate,
1904: last_updated_by = l_last_updated_by,

Line 1910: UPDATE pa_resource_assignments

1906: record_version_number = NVL(record_version_number,0) + 1
1907: WHERE resource_assignment_id = l_res_asg_id_tab(i);
1908:
1909: -- Bug 4229963: Ensure sp_fixed_date is NULL when spread is not Fixed Date.
1910: UPDATE pa_resource_assignments
1911: SET sp_fixed_date = NULL,
1912: last_update_date = l_sysdate,
1913: last_updated_by = l_last_updated_by,
1914: last_update_login = l_last_update_login,

Line 2045: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE

2041: -- IPM: Added table for copying source resource_rate_based_flag values.
2042: l_res_rate_based_flag_tab PA_PLSQL_DATATYPES.Char15TabTyp;
2043:
2044: l_sysdate DATE;
2045: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2046: := FND_GLOBAL.user_id;
2047: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2048: := FND_GLOBAL.login_id;
2049:

Line 2047: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE

2043:
2044: l_sysdate DATE;
2045: l_last_updated_by PA_RESOURCE_ASSIGNMENTS.LAST_UPDATED_BY%TYPE
2046: := FND_GLOBAL.user_id;
2047: l_last_update_login PA_RESOURCE_ASSIGNMENTS.LAST_UPDATE_LOGIN%TYPE
2048: := FND_GLOBAL.login_id;
2049:
2050: l_count NUMBER;
2051: l_msg_count NUMBER;

Line 2195: FROM PA_RESOURCE_ASSIGNMENTS RA,

2191: l_rate_expenditure_type_tab,
2192: l_rate_func_curr_code_tab,
2193: l_org_id_tab,
2194: l_res_rate_based_flag_tab -- Added for IPM ER
2195: FROM PA_RESOURCE_ASSIGNMENTS RA,
2196: PA_RES_LIST_MAP_TMP1 tmp1,
2197: PA_FP_CALC_AMT_TMP1 map
2198: WHERE RA.budget_version_id = l_src_version_id
2199: AND RA.resource_assignment_id = map.resource_assignment_id

Line 2207: UPDATE PA_RESOURCE_ASSIGNMENTS

2203: --dbms_output.put_line('l_tgt_res_asg_id_tab.count = ' || l_tgt_res_asg_id_tab.count);
2204: l_sysdate := SYSDATE;
2205:
2206: FORALL j IN 1..l_tgt_res_asg_id_tab.count
2207: UPDATE PA_RESOURCE_ASSIGNMENTS
2208: SET RESOURCE_CLASS_FLAG = l_resource_class_flag_tab(j),
2209: RESOURCE_CLASS_CODE = l_resource_class_code_tab(j),
2210: RES_TYPE_CODE = l_res_type_code_tab(j),
2211: PERSON_ID = l_person_id_tab(j),