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_RES_ASG_CURRENCY_PUB dependencies on PA_RESOURCE_ASGN_CURR

Line 342: DELETE FROM pa_resource_asgn_curr_tmp

338:
339: IF p_version_level_flag = 'N' THEN
340:
341: -- 0.1. Remove records with delete_flag = 'Y' from temp table.
342: DELETE FROM pa_resource_asgn_curr_tmp
343: WHERE NVL(delete_flag,'N') = 'Y';
344:
345: IF p_copy_flag = 'Y' THEN
346: -- 0.2A. Validate that no records in the temp table share the same

Line 356: FROM pa_resource_asgn_curr_tmp

352: BULK COLLECT
353: INTO l_ra_id_tab,
354: l_txn_currency_code_tab,
355: l_duplicate_count_tab
356: FROM pa_resource_asgn_curr_tmp
357: GROUP BY resource_assignment_id
358: HAVING count(*) > 1;
359: ELSE
360: -- 0.2B. Validate that no records in the temp table share the same

Line 369: FROM pa_resource_asgn_curr_tmp

365: BULK COLLECT
366: INTO l_ra_id_tab,
367: l_txn_currency_code_tab,
368: l_duplicate_count_tab
369: FROM pa_resource_asgn_curr_tmp
370: GROUP BY resource_assignment_id, txn_currency_code
371: HAVING count(*) > 1;
372: END IF; -- IF p_copy_flag = 'Y' THEN
373:

Line 379: || 'PA_RESOURCE_ASGN_CURR_TMP '

375: IF l_ra_id_tab.count > 0 THEN
376: IF p_pa_debug_mode = 'Y' THEN
377: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
378: ( p_msg => 'Duplicate records found in '
379: || 'PA_RESOURCE_ASGN_CURR_TMP '
380: || '(count='||l_ra_id_tab.count||'):',
381: p_called_mode => p_called_mode,
382: p_module_name => l_module_name,
383: p_log_level => l_log_level );

Line 401: FROM pa_resource_asgn_curr_tmp

397:
398: -- 0.3. Raise an error if any records with null resource_assignment_id are found.
399: SELECT count(*)
400: INTO l_null_record_count
401: FROM pa_resource_asgn_curr_tmp
402: WHERE resource_assignment_id IS NULL;
403:
404: IF l_null_record_count > 0 THEN
405: IF p_pa_debug_mode = 'Y' THEN

Line 408: || 'PA_RESOURCE_ASGN_CURR_TMP '

404: IF l_null_record_count > 0 THEN
405: IF p_pa_debug_mode = 'Y' THEN
406: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
407: ( p_msg => 'Records with null resource_assignment_id found in '
408: || 'PA_RESOURCE_ASGN_CURR_TMP '
409: || '(count='||l_null_record_count||'):',
410: p_called_mode => p_called_mode,
411: p_module_name => l_module_name,
412: p_log_level => l_log_level );

Line 424: FROM pa_resource_asgn_curr_tmp

420: -- Raise an error if any records with null resource_assignment_id are found.
421: IF p_copy_flag <> 'Y' THEN
422: SELECT count(*)
423: INTO l_null_record_count
424: FROM pa_resource_asgn_curr_tmp
425: WHERE txn_currency_code IS NULL;
426:
427: IF l_null_record_count > 0 THEN
428: IF p_pa_debug_mode = 'Y' THEN

Line 431: || 'PA_RESOURCE_ASGN_CURR_TMP '

427: IF l_null_record_count > 0 THEN
428: IF p_pa_debug_mode = 'Y' THEN
429: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
430: ( p_msg => 'Records with null txn_currency_code found in '
431: || 'PA_RESOURCE_ASGN_CURR_TMP '
432: || '(count='||l_null_record_count||'):',
433: p_called_mode => p_called_mode,
434: p_module_name => l_module_name,
435: p_log_level => l_log_level );

Line 704: -- Print PA_RESOURCE_ASGN_CURR_TMP data

700: p_module_name => l_module_name,
701: p_log_level => l_log_level );
702:
703:
704: -- Print PA_RESOURCE_ASGN_CURR_TMP data
705: IF p_version_level_flag = 'N' THEN
706: -- Print values of PA_RESOURCE_ASGN_CURR_TMP data
707: DECLARE
708: l_dbg_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 706: -- Print values of PA_RESOURCE_ASGN_CURR_TMP data

702:
703:
704: -- Print PA_RESOURCE_ASGN_CURR_TMP data
705: IF p_version_level_flag = 'N' THEN
706: -- Print values of PA_RESOURCE_ASGN_CURR_TMP data
707: DECLARE
708: l_dbg_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
709: l_dbg_txn_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;
710: l_dbg_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 728: FROM pa_resource_asgn_curr_tmp

724: l_dbg_rc_rate_override_tab,
725: l_dbg_bc_rate_override_tab,
726: l_dbg_bill_rate_override_tab,
727: l_dbg_delete_flag_tab
728: FROM pa_resource_asgn_curr_tmp
729: ORDER BY resource_assignment_id, txn_currency_code;
730:
731: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
732: ( p_msg => 'Printing PA_RESOURCE_ASGN_CURR_TMP table data '

Line 732: ( p_msg => 'Printing PA_RESOURCE_ASGN_CURR_TMP table data '

728: FROM pa_resource_asgn_curr_tmp
729: ORDER BY resource_assignment_id, txn_currency_code;
730:
731: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
732: ( p_msg => 'Printing PA_RESOURCE_ASGN_CURR_TMP table data '
733: || '(count='||l_dbg_ra_id_tab.count||'):',
734: p_called_mode => p_called_mode,
735: p_module_name => l_module_name,
736: p_log_level => l_log_level );

Line 794: -- Delete records from pa_resource_asgn_curr for the version.

790:
791: IF p_version_level_flag = 'Y' THEN
792:
793: -- VERSION LEVEL Mode:
794: -- Delete records from pa_resource_asgn_curr for the version.
795:
796: DELETE FROM pa_resource_asgn_curr rbc
797: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id;
798:

Line 796: DELETE FROM pa_resource_asgn_curr rbc

792:
793: -- VERSION LEVEL Mode:
794: -- Delete records from pa_resource_asgn_curr for the version.
795:
796: DELETE FROM pa_resource_asgn_curr rbc
797: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id;
798:
799: ELSIF p_version_level_flag = 'N' THEN
800:

Line 804: -- Delete records from pa_resource_asgn_curr for all the

800:
801: IF is_public_calling_module(p_calling_module) THEN
802:
803: -- TEMP TABLE Mode:
804: -- Delete records from pa_resource_asgn_curr for all the
805: -- planning resource + currency combinations specified in
806: -- pa_resource_asgn_curr_tmp with delete_flag = 'Y'.
807:
808: DELETE FROM pa_resource_asgn_curr rbc

Line 806: -- pa_resource_asgn_curr_tmp with delete_flag = 'Y'.

802:
803: -- TEMP TABLE Mode:
804: -- Delete records from pa_resource_asgn_curr for all the
805: -- planning resource + currency combinations specified in
806: -- pa_resource_asgn_curr_tmp with delete_flag = 'Y'.
807:
808: DELETE FROM pa_resource_asgn_curr rbc
809: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
810: AND EXISTS ( SELECT null

Line 808: DELETE FROM pa_resource_asgn_curr rbc

804: -- Delete records from pa_resource_asgn_curr for all the
805: -- planning resource + currency combinations specified in
806: -- pa_resource_asgn_curr_tmp with delete_flag = 'Y'.
807:
808: DELETE FROM pa_resource_asgn_curr rbc
809: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
810: AND EXISTS ( SELECT null
811: FROM pa_resource_asgn_curr_tmp tmp
812: WHERE NVL(tmp.delete_flag,'N') = 'Y'

Line 811: FROM pa_resource_asgn_curr_tmp tmp

807:
808: DELETE FROM pa_resource_asgn_curr rbc
809: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
810: AND EXISTS ( SELECT null
811: FROM pa_resource_asgn_curr_tmp tmp
812: WHERE NVL(tmp.delete_flag,'N') = 'Y'
813: AND rbc.resource_assignment_id = tmp.resource_assignment_id
814: AND rbc.txn_currency_code =
815: NVL(tmp.txn_currency_code,rbc.txn_currency_code) );

Line 820: -- Delete records from pa_resource_asgn_curr for all the

816:
817: ELSIF is_private_calling_module(p_calling_module) THEN
818:
819: -- TEMP TABLE Mode:
820: -- Delete records from pa_resource_asgn_curr for all the
821: -- planning resource + currency combinations specified in
822: -- pa_resource_asgn_curr_tmp without checking delete_flag.
823:
824: DELETE FROM pa_resource_asgn_curr rbc

Line 822: -- pa_resource_asgn_curr_tmp without checking delete_flag.

818:
819: -- TEMP TABLE Mode:
820: -- Delete records from pa_resource_asgn_curr for all the
821: -- planning resource + currency combinations specified in
822: -- pa_resource_asgn_curr_tmp without checking delete_flag.
823:
824: DELETE FROM pa_resource_asgn_curr rbc
825: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
826: AND EXISTS ( SELECT null

Line 824: DELETE FROM pa_resource_asgn_curr rbc

820: -- Delete records from pa_resource_asgn_curr for all the
821: -- planning resource + currency combinations specified in
822: -- pa_resource_asgn_curr_tmp without checking delete_flag.
823:
824: DELETE FROM pa_resource_asgn_curr rbc
825: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
826: AND EXISTS ( SELECT null
827: FROM pa_resource_asgn_curr_tmp tmp
828: WHERE rbc.resource_assignment_id = tmp.resource_assignment_id

Line 827: FROM pa_resource_asgn_curr_tmp tmp

823:
824: DELETE FROM pa_resource_asgn_curr rbc
825: WHERE rbc.budget_version_id = p_fp_cols_rec.x_budget_version_id
826: AND EXISTS ( SELECT null
827: FROM pa_resource_asgn_curr_tmp tmp
828: WHERE rbc.resource_assignment_id = tmp.resource_assignment_id
829: AND rbc.txn_currency_code =
830: NVL(tmp.txn_currency_code,rbc.txn_currency_code) );
831:

Line 918: -- This cursor gets all the source pa_resource_asgn_curr records

914: l_last_update_login NUMBER := FND_GLOBAL.login_id;
915: l_sysdate DATE := SYSDATE;
916: l_record_version_number NUMBER := 1;
917:
918: -- This cursor gets all the source pa_resource_asgn_curr records
919: -- for the entire version specified by c_src_version_id.
920: -- This cursor should be used when p_version_level_flag is 'Y'
921: -- and p_copy_mode is 'COPY_ALL'.
922:

Line 960: pa_resource_asgn_curr src_rbc

956: src_rbc.TOTAL_PROJFUNC_INIT_REVENUE,
957: src_rbc.TOTAL_DISPLAY_QUANTITY
958: FROM pa_resource_assignments tgt_ra,
959: pa_resource_assignments src_ra,
960: pa_resource_asgn_curr src_rbc
961: WHERE src_rbc.budget_version_id = c_src_version_id
962: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
963: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
964: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 967: -- This cursor gets overrides from the source pa_resource_asgn_curr

963: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
964: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id
965: AND tgt_ra.budget_version_id = c_tgt_version_id;
966:
967: -- This cursor gets overrides from the source pa_resource_asgn_curr
968: -- records for the entire version specified by c_src_version_id.
969: -- This cursor should be used when p_version_level_flag is 'Y'
970: -- and p_copy_mode is 'COPY_OVERRIDES'.
971:

Line 982: pa_resource_asgn_curr src_rbc

978: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
979: src_rbc.TXN_BILL_RATE_OVERRIDE
980: FROM pa_resource_assignments tgt_ra,
981: pa_resource_assignments src_ra,
982: pa_resource_asgn_curr src_rbc
983: WHERE src_rbc.budget_version_id = c_src_version_id
984: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
985: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
986: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 989: -- This cursor gets overrides from the source pa_resource_asgn_curr

985: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
986: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id
987: AND tgt_ra.budget_version_id = c_tgt_version_id;
988:
989: -- This cursor gets overrides from the source pa_resource_asgn_curr
990: -- records for the resources specified in pa_resource_asgn_curr_tmp
991: -- for the version specified by c_src_version_id.
992: -- This cursor should be used when p_version_level_flag is 'N'
993: -- and p_copy_mode is 'COPY_OVERRIDES'.

Line 990: -- records for the resources specified in pa_resource_asgn_curr_tmp

986: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id
987: AND tgt_ra.budget_version_id = c_tgt_version_id;
988:
989: -- This cursor gets overrides from the source pa_resource_asgn_curr
990: -- records for the resources specified in pa_resource_asgn_curr_tmp
991: -- for the version specified by c_src_version_id.
992: -- This cursor should be used when p_version_level_flag is 'N'
993: -- and p_copy_mode is 'COPY_OVERRIDES'.
994: -- Note: Ordered hint has been added to avoid a Merge Join Cartesian

Line 1006: FROM pa_resource_asgn_curr src_rbc,

1002: src_rbc.TXN_CURRENCY_CODE,
1003: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
1004: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
1005: src_rbc.TXN_BILL_RATE_OVERRIDE
1006: FROM pa_resource_asgn_curr src_rbc,
1007: pa_resource_assignments src_ra,
1008: pa_resource_assignments tgt_ra,
1009: pa_resource_asgn_curr_tmp tmp
1010: WHERE tgt_ra.budget_version_id = c_tgt_version_id

Line 1009: pa_resource_asgn_curr_tmp tmp

1005: src_rbc.TXN_BILL_RATE_OVERRIDE
1006: FROM pa_resource_asgn_curr src_rbc,
1007: pa_resource_assignments src_ra,
1008: pa_resource_assignments tgt_ra,
1009: pa_resource_asgn_curr_tmp tmp
1010: WHERE tgt_ra.budget_version_id = c_tgt_version_id
1011: AND src_ra.budget_version_id = c_src_version_id
1012: AND tgt_ra.resource_assignment_id = tmp.resource_assignment_id
1013: AND nvl(src_ra.task_id,0) = nvl(tgt_ra.task_id,0)

Line 1266: -- Step 3: Delete target records from PA_RESOURCE_ASGN_CURR

1262: l_brdn_cost_rate_override_tab := l_null_NumTabTyp;
1263: END IF;
1264: END IF; -- p_copy_mode check
1265:
1266: -- Step 3: Delete target records from PA_RESOURCE_ASGN_CURR
1267: -- that are being copied over from source records.
1268:
1269: -- Populate PA_RESOURCE_ASGN_CURR_TMP with the target records.
1270: -- Note that the DELETE_TABLE_RECORDS API does not require the

Line 1269: -- Populate PA_RESOURCE_ASGN_CURR_TMP with the target records.

1265:
1266: -- Step 3: Delete target records from PA_RESOURCE_ASGN_CURR
1267: -- that are being copied over from source records.
1268:
1269: -- Populate PA_RESOURCE_ASGN_CURR_TMP with the target records.
1270: -- Note that the DELETE_TABLE_RECORDS API does not require the
1271: -- DELETE_FLAG column be populated for internal p_calling_module
1272: -- values (though the flag is required for public p_calling_modules).
1273: -- See the is_public_calling_module() and is_private_calling_module()

Line 1276: DELETE PA_RESOURCE_ASGN_CURR_TMP;

1272: -- values (though the flag is required for public p_calling_modules).
1273: -- See the is_public_calling_module() and is_private_calling_module()
1274: -- functions for details on private/public calling modules.
1275:
1276: DELETE PA_RESOURCE_ASGN_CURR_TMP;
1277:
1278: FORALL i IN 1..l_ra_id_tab.count
1279: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (
1280: RESOURCE_ASSIGNMENT_ID,

Line 1279: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (

1275:
1276: DELETE PA_RESOURCE_ASGN_CURR_TMP;
1277:
1278: FORALL i IN 1..l_ra_id_tab.count
1279: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (
1280: RESOURCE_ASSIGNMENT_ID,
1281: TXN_CURRENCY_CODE )
1282: VALUES (
1283: l_ra_id_tab(i),

Line 1314: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

1310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1311: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1312: END IF;
1313:
1314: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
1315:
1316: IF p_copy_mode = G_COPY_ALL THEN
1317: FORALL i IN 1..l_ra_id_tab.count
1318: INSERT INTO PA_RESOURCE_ASGN_CURR (

Line 1318: INSERT INTO PA_RESOURCE_ASGN_CURR (

1314: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
1315:
1316: IF p_copy_mode = G_COPY_ALL THEN
1317: FORALL i IN 1..l_ra_id_tab.count
1318: INSERT INTO PA_RESOURCE_ASGN_CURR (
1319: RA_TXN_ID,
1320: BUDGET_VERSION_ID,
1321: RESOURCE_ASSIGNMENT_ID,
1322: TXN_CURRENCY_CODE,

Line 1360: pa_resource_asgn_curr_s.nextval,

1356: LAST_UPDATED_BY,
1357: LAST_UPDATE_LOGIN,
1358: RECORD_VERSION_NUMBER )
1359: VALUES (
1360: pa_resource_asgn_curr_s.nextval,
1361: p_fp_cols_rec.x_budget_version_id,
1362: l_ra_id_tab(i),
1363: l_txn_currency_code_tab(i),
1364: l_total_quantity_tab(i),

Line 1402: INSERT INTO PA_RESOURCE_ASGN_CURR (

1398: l_last_update_login,
1399: l_record_version_number );
1400: ELSIF p_copy_mode = G_COPY_OVERRIDES THEN
1401: FORALL i IN 1..l_ra_id_tab.count
1402: INSERT INTO PA_RESOURCE_ASGN_CURR (
1403: RA_TXN_ID,
1404: BUDGET_VERSION_ID,
1405: RESOURCE_ASSIGNMENT_ID,
1406: TXN_CURRENCY_CODE,

Line 1417: pa_resource_asgn_curr_s.nextval,

1413: LAST_UPDATED_BY,
1414: LAST_UPDATE_LOGIN,
1415: RECORD_VERSION_NUMBER )
1416: VALUES (
1417: pa_resource_asgn_curr_s.nextval,
1418: p_fp_cols_rec.x_budget_version_id,
1419: l_ra_id_tab(i),
1420: l_txn_currency_code_tab(i),
1421: l_raw_cost_rate_override_tab(i),

Line 1542: -- Insert records into PA_RESOURCE_ASGN_CURR for all planning

1538:
1539: IF p_version_level_flag = 'Y' THEN
1540:
1541: -- VERSION LEVEL Mode:
1542: -- Insert records into PA_RESOURCE_ASGN_CURR for all planning
1543: -- resource + currency combinations for the given version that do
1544: -- not already exist in the table.
1545:
1546: SELECT DISTINCT

Line 1557: FROM pa_resource_asgn_curr rbc

1553: pa_resource_assignments ra
1554: WHERE ra.budget_version_id = p_fp_cols_rec.x_budget_version_id
1555: AND bl.resource_assignment_id = ra.resource_assignment_id
1556: AND NOT EXISTS (SELECT null
1557: FROM pa_resource_asgn_curr rbc
1558: WHERE rbc.resource_assignment_id = bl.resource_assignment_id
1559: AND rbc.txn_currency_code = bl.txn_currency_code);
1560:
1561: -- Insert records with values for the following columns:

Line 1567: INSERT INTO pa_resource_asgn_curr (

1563: -- All of the remaining columns, including the rate overrides,
1564: -- but excluding the who columns, will be Null in this case.
1565:
1566: FORALL i IN 1..l_ra_id_tab.count
1567: INSERT INTO pa_resource_asgn_curr (
1568: RA_TXN_ID,
1569: BUDGET_VERSION_ID,
1570: RESOURCE_ASSIGNMENT_ID,
1571: TXN_CURRENCY_CODE,

Line 1579: pa_resource_asgn_curr_s.nextval,

1575: LAST_UPDATED_BY,
1576: LAST_UPDATE_LOGIN,
1577: RECORD_VERSION_NUMBER )
1578: VALUES (
1579: pa_resource_asgn_curr_s.nextval,
1580: p_fp_cols_rec.x_budget_version_id,
1581: l_ra_id_tab(i),
1582: l_txn_currency_code_tab(i),
1583: l_sysdate,

Line 1594: -- into the PA_RESOURCE_ASGN_CURR table.

1590: ELSIF p_version_level_flag = 'N' THEN
1591:
1592: -- TEMP TABLE Mode:
1593: -- Delete and then Insert the records specified by the temp table
1594: -- into the PA_RESOURCE_ASGN_CURR table.
1595:
1596: IF p_pa_debug_mode = 'Y' THEN
1597: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1598: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

Line 1624: INSERT INTO pa_resource_asgn_curr

1620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1621: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1622: END IF;
1623:
1624: INSERT INTO pa_resource_asgn_curr
1625: ( RA_TXN_ID,
1626: BUDGET_VERSION_ID,
1627: RESOURCE_ASSIGNMENT_ID,
1628: TXN_CURRENCY_CODE,

Line 1638: SELECT pa_resource_asgn_curr_s.nextval,

1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY,
1636: LAST_UPDATE_LOGIN,
1637: RECORD_VERSION_NUMBER )
1638: SELECT pa_resource_asgn_curr_s.nextval,
1639: p_fp_cols_rec.x_budget_version_id,
1640: tmp.resource_assignment_id,
1641: tmp.txn_currency_code,
1642: tmp.txn_raw_cost_rate_override,

Line 1651: FROM pa_resource_asgn_curr_tmp tmp;

1647: l_sysdate,
1648: l_last_updated_by,
1649: l_last_update_login,
1650: l_record_version_number
1651: FROM pa_resource_asgn_curr_tmp tmp;
1652:
1653: END IF; -- p_version_level_flag check
1654:
1655: --dbms_output.put_line('Reached Insert Records');

Line 1737: -- but may or may not have records in PA_RESOURCE_ASGN_CURR.

1733: -- for the entire version specified by c_budget_version_id.
1734: -- This cursor should be used when p_version_level_flag is 'Y'.
1735: -- The cursor consists of two halves, connected by UNION ALL.
1736: -- The first half gets data for resources that have budget lines,
1737: -- but may or may not have records in PA_RESOURCE_ASGN_CURR.
1738: -- The second half gets data for resources that have records in
1739: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1740:
1741: CURSOR version_level_rollup_csr

Line 1739: -- PA_RESOURCE_ASGN_CURR but no budget lines.

1735: -- The cursor consists of two halves, connected by UNION ALL.
1736: -- The first half gets data for resources that have budget lines,
1737: -- but may or may not have records in PA_RESOURCE_ASGN_CURR.
1738: -- The second half gets data for resources that have records in
1739: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1740:
1741: CURSOR version_level_rollup_csr
1742: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1743: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

Line 1845: pa_resource_asgn_curr rbc

1841: decode(sum(nvl(bl.display_quantity,0)),
1842: 0,null,sum(nvl(bl.display_quantity,0))) --TOTAL_DISPLAY_QUANTITY
1843: FROM pa_resource_assignments ra,
1844: pa_budget_lines bl,
1845: pa_resource_asgn_curr rbc
1846: WHERE bl.resource_assignment_id = rbc.resource_assignment_id (+)
1847: AND bl.txn_currency_code = rbc.txn_currency_code (+)
1848: AND ra.budget_version_id = c_budget_version_id
1849: AND ra.project_id = c_project_id

Line 1889: FROM pa_resource_asgn_curr rbc

1885: null, --TOTAL_PROJFUNC_INIT_RAW_COST
1886: null, --TOTAL_PROJFUNC_INIT_BD_COST
1887: null, --TOTAL_PROJFUNC_INIT_REVENUE
1888: null --TOTAL_DISPLAY_QUANTITY
1889: FROM pa_resource_asgn_curr rbc
1890: WHERE rbc.budget_version_id = c_budget_version_id
1891: AND NOT EXISTS (SELECT null
1892: FROM pa_budget_lines bl
1893: WHERE bl.resource_assignment_id = rbc.resource_assignment_id

Line 1898: -- for the resources specified in PA_RESOURCE_ASGN_CURR_TMP.

1894: AND bl.txn_currency_code = rbc.txn_currency_code );
1895:
1896:
1897: -- This cursor computes ETC rates, average rates, and amount totals
1898: -- for the resources specified in PA_RESOURCE_ASGN_CURR_TMP.
1899: -- This cursor should be used when p_version_level_flag is 'N'.
1900: -- The cursor gets data for resources that have records in
1901: -- PA_RESOURCE_ASGN_CURR but may or may not have budget lines.
1902: -- NOTE: the cursor parameters c_project_id and c_budget_version_id

Line 1901: -- PA_RESOURCE_ASGN_CURR but may or may not have budget lines.

1897: -- This cursor computes ETC rates, average rates, and amount totals
1898: -- for the resources specified in PA_RESOURCE_ASGN_CURR_TMP.
1899: -- This cursor should be used when p_version_level_flag is 'N'.
1900: -- The cursor gets data for resources that have records in
1901: -- PA_RESOURCE_ASGN_CURR but may or may not have budget lines.
1902: -- NOTE: the cursor parameters c_project_id and c_budget_version_id
1903: -- are not necessary here, but included in case of future use.
1904:
1905: CURSOR table_level_rollup_csr

Line 2006: pa_resource_asgn_curr_TMP rbc

2002: 0,null,sum(nvl(bl.init_revenue,0))), --TOTAL_PROJFUNC_INIT_REVENUE
2003: decode(sum(nvl(bl.display_quantity,0)),
2004: 0,null,sum(nvl(bl.display_quantity,0))) --TOTAL_DISPLAY_QUANTITY
2005: FROM pa_budget_lines bl,
2006: pa_resource_asgn_curr_TMP rbc
2007: WHERE bl.resource_assignment_id (+) = rbc.resource_assignment_id
2008: AND bl.txn_currency_code (+) = rbc.txn_currency_code
2009: GROUP BY rbc.resource_assignment_id,
2010: rbc.txn_currency_code,

Line 2251: -- Step 3: Delete records from the PA_RESOURCE_ASGN_CURR table.

2247: l_pfc_init_raw_cost_tab := l_null_NumTabTyp;
2248: l_pfc_init_burdened_cost_tab := l_null_NumTabTyp;
2249: END IF;
2250:
2251: -- Step 3: Delete records from the PA_RESOURCE_ASGN_CURR table.
2252:
2253: IF p_pa_debug_mode = 'Y' THEN
2254: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2255: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

Line 2281: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.

2277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2278: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2279: END IF;
2280:
2281: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
2282:
2283: FORALL i IN 1..l_ra_id_tab.count
2284: INSERT INTO PA_RESOURCE_ASGN_CURR (
2285: RA_TXN_ID,

Line 2284: INSERT INTO PA_RESOURCE_ASGN_CURR (

2280:
2281: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
2282:
2283: FORALL i IN 1..l_ra_id_tab.count
2284: INSERT INTO PA_RESOURCE_ASGN_CURR (
2285: RA_TXN_ID,
2286: BUDGET_VERSION_ID,
2287: RESOURCE_ASSIGNMENT_ID,
2288: TXN_CURRENCY_CODE,

Line 2326: pa_resource_asgn_curr_s.nextval,

2322: LAST_UPDATED_BY,
2323: LAST_UPDATE_LOGIN,
2324: RECORD_VERSION_NUMBER )
2325: VALUES (
2326: pa_resource_asgn_curr_s.nextval,
2327: p_fp_cols_rec.x_budget_version_id,
2328: l_ra_id_tab(i),
2329: l_txn_currency_code_tab(i),
2330: l_total_quantity_tab(i),