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_BILLING_AMOUNTS dependencies on PA_RES_LIST_MAP_TMP4

Line 428: SELECT /+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)/

424: c_multi_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
425: c_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
426: c_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE)
427: IS
428: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
429: P.RESOURCE_ASSIGNMENT_ID,
430: V.BILL_TRANS_CURRENCY_CODE,
431: PAP.PERIOD_NAME,
432: PAP.START_DATE,

Line 440: PA_RES_LIST_MAP_TMP4 TMP,

436: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
437: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
438: FROM PA_EVENTS_DELIVERABLE_V V,
439: PA_EVENT_TYPES ET,
440: PA_RES_LIST_MAP_TMP4 TMP,
441: PA_RESOURCE_ASSIGNMENTS P,
442: PA_PERIODS PAP
443: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID
444: AND V.EVENT_TYPE = ET.EVENT_TYPE

Line 457: SELECT /+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)/

453: PAP.PERIOD_NAME,
454: PAP.START_DATE,
455: PAP.END_DATE
456: UNION ALL
457: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
458: P.RESOURCE_ASSIGNMENT_ID,
459: V.BILL_TRANS_CURRENCY_CODE,
460: GLP.PERIOD_NAME,
461: GLP.START_DATE,

Line 469: PA_RES_LIST_MAP_TMP4 TMP,

465: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
466: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
467: FROM PA_EVENTS_DELIVERABLE_V V,
468: PA_EVENT_TYPES ET,
469: PA_RES_LIST_MAP_TMP4 TMP,
470: PA_RESOURCE_ASSIGNMENTS P,
471: GL_PERIOD_STATUSES GLP
472: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID
473: AND V.EVENT_TYPE = ET.EVENT_TYPE

Line 489: SELECT /+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)/

485: GLP.PERIOD_NAME,
486: GLP.START_DATE,
487: GLP.END_DATE
488: UNION ALL
489: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
490: P.RESOURCE_ASSIGNMENT_ID,
491: V.BILL_TRANS_CURRENCY_CODE,
492: TO_CHAR(NULL),
493: GET_EVENT_DATE(V.EVENT_DATE,c_etc_start_date,c_plan_class_code),

Line 501: PA_RES_LIST_MAP_TMP4 TMP,

497: 'REALIZED_LOSSES', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),
498: NVL(V.BILL_TRANS_REV_AMOUNT,0)))
499: FROM PA_EVENTS_DELIVERABLE_V V,
500: PA_EVENT_TYPES ET,
501: PA_RES_LIST_MAP_TMP4 TMP,
502: PA_RESOURCE_ASSIGNMENTS P
503: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID
504: AND V.EVENT_TYPE = ET.EVENT_TYPE
505: AND V.PROJECT_ID = P_PROJECT_ID

Line 637: DELETE FROM PA_RES_LIST_MAP_TMP4;

633: '||l_stru_sharing_code);*/
634:
635: /* Deleting all the records from the temporary table */
636: DELETE FROM PA_RES_LIST_MAP_TMP1;
637: DELETE FROM PA_RES_LIST_MAP_TMP4;
638:
639: -- hr_utility.trace_on(null,'GOD');
640: SELECT RESOURCE_CLASS_ID
641: INTO l_resource_class_id

Line 770: SELECT /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

766: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
767: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
768: END IF;
769:
770: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
771: count(*) INTO l_count1
772: FROM PA_RES_LIST_MAP_TMP4
773: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
774: IF l_count1 > 0 THEN

Line 772: FROM PA_RES_LIST_MAP_TMP4

768: END IF;
769:
770: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
771: count(*) INTO l_count1
772: FROM PA_RES_LIST_MAP_TMP4
773: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
774: IF l_count1 > 0 THEN
775: PA_UTILS.ADD_MESSAGE
776: (p_app_short_name => 'PA',

Line 783: --select count(*) into l_count from PA_RES_LIST_MAP_TMP4;

779: END IF;
780:
781: /*dbms_output.put_line('Status of mapping api:
782: '||X_RETURN_STATUS);*/
783: --select count(*) into l_count from PA_RES_LIST_MAP_TMP4;
784: -- hr_utility.trace('tmp4 count aft mapping api call '||l_count);
785: --dbms_output.put_line('tmp4 count :'||l_count);
786: /* Calling the API to get the resource_assignment_id */
787: IF p_pa_debug_mode = 'Y' THEN

Line 1559: SELECT /+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)/

1555: -- Events in the total amount returned by this API. To this end, the join
1556: -- between pa_resource_assignments with pa_res_list_tmp4 has been commented
1557: -- out in the query below that gets Billing Event amounts.
1558:
1559: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
1560: V.EVENT_DATE,
1561: V.BILL_TRANS_CURRENCY_CODE,
1562: SUM(DECODE(ET.EVENT_TYPE_CLASSIFICATION,
1563: 'WRITE OFF', -1 * NVL(V.BILL_TRANS_REV_AMOUNT,0),

Line 1582: PA_RES_LIST_MAP_TMP4 TMP

1578: l_projfunc_rev_amt_tab,
1579: l_project_rev_amt_tab
1580: FROM PA_EVENTS_DELIVERABLE_V V,
1581: PA_EVENT_TYPES ET,
1582: PA_RES_LIST_MAP_TMP4 TMP
1583: --,PA_RESOURCE_ASSIGNMENTS RA
1584: WHERE V.PROJECT_ID = P_PROJECT_ID
1585: AND V.EVENT_DATE >= NVL(l_etc_start_date, V.EVENT_DATE)
1586: AND V.EVENT_TYPE = ET.EVENT_TYPE

Line 1793: DELETE FROM PA_RES_LIST_MAP_TMP4;

1789: END IF;
1790:
1791: /* Deleting all the records from the temporary table */
1792: DELETE FROM PA_RES_LIST_MAP_TMP1;
1793: DELETE FROM PA_RES_LIST_MAP_TMP4;
1794:
1795: SELECT PROJECT_ID,
1796: nvl(TASK_ID,0),
1797: EVENT_ID,

Line 1921: SELECT /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

1917: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1918: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1919: END IF;
1920:
1921: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
1922: count(*) INTO l_count1
1923: FROM PA_RES_LIST_MAP_TMP4
1924: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
1925: IF l_count1 > 0 THEN

Line 1923: FROM PA_RES_LIST_MAP_TMP4

1919: END IF;
1920:
1921: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
1922: count(*) INTO l_count1
1923: FROM PA_RES_LIST_MAP_TMP4
1924: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
1925: IF l_count1 > 0 THEN
1926: PA_UTILS.ADD_MESSAGE
1927: (p_app_short_name => 'PA',

Line 2038: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2034: IF P_FP_COLS_REC.X_FIN_PLAN_LEVEL_CODE = 'P' or
2035: P_GEN_SRC_CODE = 'RESOURCE_SCHEDULE' THEN
2036:
2037: /* Updating the TMP4 table with resource_assignment_id */
2038: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2039: distinct P.RESOURCE_ASSIGNMENT_ID,
2040: P.RESOURCE_LIST_MEMBER_ID
2041: BULK COLLECT
2042: INTO l_res_assgn_id_tab,

Line 2045: PA_RES_LIST_MAP_TMP4 T

2041: BULK COLLECT
2042: INTO l_res_assgn_id_tab,
2043: l_rlm_id_tab
2044: FROM PA_RESOURCE_ASSIGNMENTS P,
2045: PA_RES_LIST_MAP_TMP4 T
2046: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2047: AND NVL(P.TASK_ID,0) = 0
2048: AND P.PROJECT_ASSIGNMENT_ID = -1
2049: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;

Line 2052: UPDATE /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

2048: AND P.PROJECT_ASSIGNMENT_ID = -1
2049: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2050:
2051: FORALL i IN 1..l_res_assgn_id_tab.count
2052: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2053: PA_RES_LIST_MAP_TMP4
2054: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2055: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i);
2056: /* AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);

Line 2053: PA_RES_LIST_MAP_TMP4

2049: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2050:
2051: FORALL i IN 1..l_res_assgn_id_tab.count
2052: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2053: PA_RES_LIST_MAP_TMP4
2054: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2055: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i);
2056: /* AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);
2057: task id check is not required. commented for bug 3475017 */

Line 2067: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2063: l_stru_sharing_code = 'SHARE_FULL' OR
2064: P_GEN_SRC_CODE IN ( 'FINANCIAL_PLAN',
2065: 'OPEN_COMMITMENTS','BILLING_EVENTS' )) THEN
2066:
2067: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2068: P.RESOURCE_ASSIGNMENT_ID,
2069: P.RESOURCE_LIST_MEMBER_ID,
2070: NVL(T.TXN_TASK_ID,0)
2071: BULK COLLECT

Line 2076: PA_RES_LIST_MAP_TMP4 T

2072: INTO l_res_assgn_id_tab,
2073: l_rlm_id_tab,
2074: l_txn_task_id_tab
2075: FROM PA_RESOURCE_ASSIGNMENTS P,
2076: PA_RES_LIST_MAP_TMP4 T
2077: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2078: AND NVL(P.TASK_ID,0) = NVL(T.TXN_TASK_ID,0)
2079: AND P.PROJECT_ASSIGNMENT_ID = -1
2080: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;

Line 2083: UPDATE /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

2079: AND P.PROJECT_ASSIGNMENT_ID = -1
2080: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2081:
2082: FORALL i IN 1..l_res_assgn_id_tab.count
2083: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2084: PA_RES_LIST_MAP_TMP4
2085: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2086: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2087: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);

Line 2084: PA_RES_LIST_MAP_TMP4

2080: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2081:
2082: FORALL i IN 1..l_res_assgn_id_tab.count
2083: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2084: PA_RES_LIST_MAP_TMP4
2085: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2086: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2087: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);
2088:

Line 2097: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2093: l_stru_sharing_code = 'SHARE_FULL' OR
2094: P_GEN_SRC_CODE IN ( 'FINANCIAL_PLAN',
2095: 'OPEN_COMMITMENTS','BILLING_EVENTS' )) THEN
2096:
2097: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2098: P.RESOURCE_ASSIGNMENT_ID,
2099: P.RESOURCE_LIST_MEMBER_ID,
2100: NVL(P.TASK_ID,0),
2101: NVL(T.TXN_TASK_ID,0)

Line 2108: PA_RES_LIST_MAP_TMP4 T,

2104: l_rlm_id_tab,
2105: l_txn_top_task_id_tab,
2106: l_txn_sub_task_id_tab
2107: FROM PA_RESOURCE_ASSIGNMENTS P,
2108: PA_RES_LIST_MAP_TMP4 T,
2109: PA_TASKS TS
2110: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2111: AND TS.TASK_ID(+) = NVL(T.TXN_TASK_ID,0)
2112: AND NVL(P.TASK_ID,0) = NVL(TS.TOP_TASK_ID,0)

Line 2117: UPDATE /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

2113: AND P.PROJECT_ASSIGNMENT_ID = -1
2114: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2115:
2116: FORALL i IN 1..l_res_assgn_id_tab.count
2117: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2118: PA_RES_LIST_MAP_TMP4 tmp4
2119: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2120: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2121: AND NVL(TXN_TASK_ID,0) = l_txn_sub_task_id_tab(i);

Line 2118: PA_RES_LIST_MAP_TMP4 tmp4

2114: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID;
2115:
2116: FORALL i IN 1..l_res_assgn_id_tab.count
2117: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2118: PA_RES_LIST_MAP_TMP4 tmp4
2119: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2120: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2121: AND NVL(TXN_TASK_ID,0) = l_txn_sub_task_id_tab(i);
2122:

Line 2138: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2134: l_txn_task_id_tab,
2135: l_mapped_task_id_tab
2136: FROM
2137: (
2138: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2139: P.RESOURCE_ASSIGNMENT_ID resource_assignment_id,
2140: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2141: NVL(T.TXN_TASK_ID,0) txn_task_id ,
2142: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id

Line 2144: PA_RES_LIST_MAP_TMP4 T,

2140: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2141: NVL(T.TXN_TASK_ID,0) txn_task_id ,
2142: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
2143: FROM PA_RESOURCE_ASSIGNMENTS P,
2144: PA_RES_LIST_MAP_TMP4 T,
2145: PA_MAP_WP_TO_FIN_TASKS_V V
2146: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2147: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID
2148: AND NVL(T.TXN_TASK_ID,0) = NVL(V.PROJ_ELEMENT_ID,0)

Line 2154: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2150: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID
2151: AND NVL(P.TASK_ID,0) = NVL(V.MAPPED_FIN_TASK_ID,0)
2152: AND NVL(T.TXN_TASK_ID,0) > 0
2153: union
2154: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2155: P.RESOURCE_ASSIGNMENT_ID resource_assignment_id,
2156: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2157: 0 txn_task_id,
2158: 0 mapped_fin_task_id

Line 2160: PA_RES_LIST_MAP_TMP4 T

2156: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2157: 0 txn_task_id,
2158: 0 mapped_fin_task_id
2159: FROM PA_RESOURCE_ASSIGNMENTS P,
2160: PA_RES_LIST_MAP_TMP4 T
2161: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2162: AND P.PROJECT_ASSIGNMENT_ID = -1
2163: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID
2164: AND NVL(P.TASK_ID,0) = 0 );

Line 2194: --select count(*) into tmp_count from PA_RES_LIST_MAP_TMP4;

2190: --dbms_output.put_line('@@l_txn_task_id_tab(1):'||l_txn_task_id_tab(1));
2191: --dbms_output.put_line('@@l_txn_task_id_tab(2):'||l_txn_task_id_tab(2));
2192: --dbms_output.put_line('@@l_txn_task_id_tab(3):'||l_txn_task_id_tab(3));
2193: --dbms_output.put_line('@@l_txn_task_id_tab(4):'||l_txn_task_id_tab(4));
2194: --select count(*) into tmp_count from PA_RES_LIST_MAP_TMP4;
2195: --dbms_output.put_line('@@l_count of tmp4:'||tmp_count);
2196: --select txn_resource_assignment_id,resource_list_member_id, txn_task_id
2197: --bulk collect into tmp_ra_id_tab, tmp_rlm_id_tab, tmp_task_id_tab
2198: --from PA_RES_LIST_MAP_TMP4;

Line 2198: --from PA_RES_LIST_MAP_TMP4;

2194: --select count(*) into tmp_count from PA_RES_LIST_MAP_TMP4;
2195: --dbms_output.put_line('@@l_count of tmp4:'||tmp_count);
2196: --select txn_resource_assignment_id,resource_list_member_id, txn_task_id
2197: --bulk collect into tmp_ra_id_tab, tmp_rlm_id_tab, tmp_task_id_tab
2198: --from PA_RES_LIST_MAP_TMP4;
2199: --dbms_output.put_line('@@tmp_ra_id_tab.count'||tmp_ra_id_tab.count);
2200: --dbms_output.put_line('@@tmp_ra_id_tab(1):'||tmp_ra_id_tab(1));
2201: --dbms_output.put_line('@@tmp_ra_id_tab(2):'||tmp_ra_id_tab(2));
2202: --dbms_output.put_line('@@tmp_ra_id_tab(3):'||tmp_ra_id_tab(3));

Line 2211: UPDATE /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

2207: --dbms_output.put_line('@@tmp_task_id_tab(2):'||tmp_task_id_tab(2));
2208: --dbms_output.put_line('@@tmp_task_id_tab(3):'||tmp_task_id_tab(3));
2209:
2210: FORALL i IN 1..l_res_assgn_id_tab.count
2211: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2212: PA_RES_LIST_MAP_TMP4
2213: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2214: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2215: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);

Line 2212: PA_RES_LIST_MAP_TMP4

2208: --dbms_output.put_line('@@tmp_task_id_tab(3):'||tmp_task_id_tab(3));
2209:
2210: FORALL i IN 1..l_res_assgn_id_tab.count
2211: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2212: PA_RES_LIST_MAP_TMP4
2213: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2214: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2215: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);
2216:

Line 2230: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2226: l_txn_task_id_tab,
2227: l_mapped_task_id_tab
2228: FROM
2229: (
2230: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2231: P.RESOURCE_ASSIGNMENT_ID resource_assignment_id,
2232: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2233: NVL(T.TXN_TASK_ID,0) txn_task_id,
2234: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id

Line 2236: PA_RES_LIST_MAP_TMP4 T,

2232: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2233: NVL(T.TXN_TASK_ID,0) txn_task_id,
2234: NVL(V.MAPPED_FIN_TASK_ID,0) mapped_fin_task_id
2235: FROM PA_RESOURCE_ASSIGNMENTS P,
2236: PA_RES_LIST_MAP_TMP4 T,
2237: PA_MAP_WP_TO_FIN_TASKS_V V,
2238: PA_TASKS TS
2239: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2240: AND V.PARENT_STRUCTURE_VERSION_ID = P_WP_STRUCTURE_VER_ID

Line 2248: SELECT /+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)/

2244: AND P.PROJECT_ASSIGNMENT_ID = -1
2245: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID
2246: AND NVL(T.TXN_TASK_ID,0) > 0
2247: union
2248: SELECT /*+ INDEX(T,PA_RES_LIST_MAP_TMP4_N1)*/
2249: DISTINCT P.RESOURCE_ASSIGNMENT_ID resource_assignment_id,
2250: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2251: 0 txn_task_id,
2252: 0 mapped_fin_task_id

Line 2254: PA_RES_LIST_MAP_TMP4 T

2250: P.RESOURCE_LIST_MEMBER_ID resource_list_member_id,
2251: 0 txn_task_id,
2252: 0 mapped_fin_task_id
2253: FROM PA_RESOURCE_ASSIGNMENTS P,
2254: PA_RES_LIST_MAP_TMP4 T
2255: WHERE P.BUDGET_VERSION_ID = P_BUDGET_VERSION_ID
2256: AND P.PROJECT_ASSIGNMENT_ID = -1
2257: AND T.RESOURCE_LIST_MEMBER_ID = P.RESOURCE_LIST_MEMBER_ID
2258: AND NVL(P.TASK_ID,0) = 0

Line 2262: UPDATE /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

2258: AND NVL(P.TASK_ID,0) = 0
2259: AND NVL(T.TXN_TASK_ID,0) = NVL(P.TASK_ID,0) );
2260:
2261: FORALL i IN 1..l_res_assgn_id_tab.count
2262: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2263: PA_RES_LIST_MAP_TMP4
2264: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2265: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2266: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);

Line 2263: PA_RES_LIST_MAP_TMP4

2259: AND NVL(T.TXN_TASK_ID,0) = NVL(P.TASK_ID,0) );
2260:
2261: FORALL i IN 1..l_res_assgn_id_tab.count
2262: UPDATE /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
2263: PA_RES_LIST_MAP_TMP4
2264: SET TXN_RESOURCE_ASSIGNMENT_ID = l_res_assgn_id_tab(i)
2265: WHERE RESOURCE_LIST_MEMBER_ID = l_rlm_id_tab(i)
2266: AND NVL(TXN_TASK_ID,0) = l_txn_task_id_tab(i);
2267:

Line 2271: * all rows in the PA_RES_LIST_MAP_TMP4 table with target resources that

2267:
2268: END IF;
2269:
2270: /* If the Retain Manually Added Plan Lines option is enabled, we remove
2271: * all rows in the PA_RES_LIST_MAP_TMP4 table with target resources that
2272: * have manually added plan lines. Thus, after this point, we can use the
2273: * mapping table without checking for the manually added lines condition. */
2274: IF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
2275: IF p_fp_cols_rec.x_plan_class_code = 'BUDGET' THEN

Line 2276: DELETE FROM pa_res_list_map_tmp4 tmp

2272: * have manually added plan lines. Thus, after this point, we can use the
2273: * mapping table without checking for the manually added lines condition. */
2274: IF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
2275: IF p_fp_cols_rec.x_plan_class_code = 'BUDGET' THEN
2276: DELETE FROM pa_res_list_map_tmp4 tmp
2277: WHERE EXISTS
2278: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2279: FROM pa_resource_assignments ra
2280: WHERE ra.budget_version_id = p_budget_version_id

Line 2278: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

2274: IF p_fp_cols_rec.x_gen_ret_manual_line_flag = 'Y' THEN
2275: IF p_fp_cols_rec.x_plan_class_code = 'BUDGET' THEN
2276: DELETE FROM pa_res_list_map_tmp4 tmp
2277: WHERE EXISTS
2278: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2279: FROM pa_resource_assignments ra
2280: WHERE ra.budget_version_id = p_budget_version_id
2281: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
2282: AND ra.transaction_source_code IS NULL

Line 2292: DELETE FROM pa_res_list_map_tmp4 tmp

2288: ELSIF p_fp_cols_rec.x_plan_class_code = 'FORECAST' THEN
2289: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
2290: ( p_budget_version_id );
2291: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
2292: DELETE FROM pa_res_list_map_tmp4 tmp
2293: WHERE EXISTS
2294: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2295: FROM pa_resource_assignments ra
2296: WHERE ra.budget_version_id = p_budget_version_id

Line 2294: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

2290: ( p_budget_version_id );
2291: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
2292: DELETE FROM pa_res_list_map_tmp4 tmp
2293: WHERE EXISTS
2294: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2295: FROM pa_resource_assignments ra
2296: WHERE ra.budget_version_id = p_budget_version_id
2297: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
2298: AND ra.transaction_source_code IS NULL

Line 2306: DELETE FROM pa_res_list_map_tmp4 tmp

2302: WHERE bl.resource_assignment_id = ra.resource_assignment_id
2303: AND bl.start_date >= l_etc_start_date
2304: AND rownum = 1 ));
2305: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
2306: DELETE FROM pa_res_list_map_tmp4 tmp
2307: WHERE EXISTS
2308: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2309: FROM pa_resource_assignments ra
2310: WHERE ra.budget_version_id = p_budget_version_id

Line 2308: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

2304: AND rownum = 1 ));
2305: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
2306: DELETE FROM pa_res_list_map_tmp4 tmp
2307: WHERE EXISTS
2308: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
2309: FROM pa_resource_assignments ra
2310: WHERE ra.budget_version_id = p_budget_version_id
2311: AND ra.resource_assignment_id = tmp.txn_resource_assignment_id
2312: AND ra.transaction_source_code IS NULL