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 341: DELETE FROM pa_resource_asgn_curr_tmp

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

Line 355: FROM pa_resource_asgn_curr_tmp

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

Line 368: FROM pa_resource_asgn_curr_tmp

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

Line 378: || 'PA_RESOURCE_ASGN_CURR_TMP '

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

Line 400: FROM pa_resource_asgn_curr_tmp

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

Line 407: || 'PA_RESOURCE_ASGN_CURR_TMP '

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

Line 423: FROM pa_resource_asgn_curr_tmp

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

Line 430: || 'PA_RESOURCE_ASGN_CURR_TMP '

426: IF l_null_record_count > 0 THEN
427: IF p_pa_debug_mode = 'Y' THEN
428: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
429: ( p_msg => 'Records with null txn_currency_code found in '
430: || 'PA_RESOURCE_ASGN_CURR_TMP '
431: || '(count='||l_null_record_count||'):',
432: p_called_mode => p_called_mode,
433: p_module_name => l_module_name,
434: 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: /* replaced the delete statement with the one below for bug 14040849
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: /* replaced the delete statement with the one below for bug 14040849
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: /* replaced the delete statement with the one below for bug 14040849
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: /* replaced the delete statement with the one below for bug 14040849
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 832: DELETE FROM PA_RESOURCE_ASGN_CURR RBC

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: */
832: DELETE FROM PA_RESOURCE_ASGN_CURR RBC
833: where rbc.rowid in (
834: select /*+ leading(tmp) cardinality(tmp,1) INDEX(RBC1 PA_RESOURCE_ASGN_CURR_U2) */ rbc1.rowid
835: from PA_RESOURCE_ASGN_CURR RBC1,
836: PA_RESOURCE_ASGN_CURR_TMP TMP

Line 834: select /+ leading(tmp) cardinality(tmp,1) INDEX(RBC1 PA_RESOURCE_ASGN_CURR_U2) / rbc1.rowid

830: NVL(tmp.txn_currency_code,rbc.txn_currency_code) );
831: */
832: DELETE FROM PA_RESOURCE_ASGN_CURR RBC
833: where rbc.rowid in (
834: select /*+ leading(tmp) cardinality(tmp,1) INDEX(RBC1 PA_RESOURCE_ASGN_CURR_U2) */ rbc1.rowid
835: from PA_RESOURCE_ASGN_CURR RBC1,
836: PA_RESOURCE_ASGN_CURR_TMP TMP
837: where RBC1.BUDGET_VERSION_ID = p_fp_cols_rec.x_budget_version_id
838: AND RBC1.RESOURCE_ASSIGNMENT_ID = TMP.RESOURCE_ASSIGNMENT_ID

Line 835: from PA_RESOURCE_ASGN_CURR RBC1,

831: */
832: DELETE FROM PA_RESOURCE_ASGN_CURR RBC
833: where rbc.rowid in (
834: select /*+ leading(tmp) cardinality(tmp,1) INDEX(RBC1 PA_RESOURCE_ASGN_CURR_U2) */ rbc1.rowid
835: from PA_RESOURCE_ASGN_CURR RBC1,
836: PA_RESOURCE_ASGN_CURR_TMP TMP
837: where RBC1.BUDGET_VERSION_ID = p_fp_cols_rec.x_budget_version_id
838: AND RBC1.RESOURCE_ASSIGNMENT_ID = TMP.RESOURCE_ASSIGNMENT_ID
839: AND RBC1.TXN_CURRENCY_CODE = NVL(TMP.TXN_CURRENCY_CODE,RBC1.TXN_CURRENCY_CODE));

Line 836: PA_RESOURCE_ASGN_CURR_TMP TMP

832: DELETE FROM PA_RESOURCE_ASGN_CURR RBC
833: where rbc.rowid in (
834: select /*+ leading(tmp) cardinality(tmp,1) INDEX(RBC1 PA_RESOURCE_ASGN_CURR_U2) */ rbc1.rowid
835: from PA_RESOURCE_ASGN_CURR RBC1,
836: PA_RESOURCE_ASGN_CURR_TMP TMP
837: where RBC1.BUDGET_VERSION_ID = p_fp_cols_rec.x_budget_version_id
838: AND RBC1.RESOURCE_ASSIGNMENT_ID = TMP.RESOURCE_ASSIGNMENT_ID
839: AND RBC1.TXN_CURRENCY_CODE = NVL(TMP.TXN_CURRENCY_CODE,RBC1.TXN_CURRENCY_CODE));
840: --end of 14040849

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

923: l_last_update_login NUMBER := FND_GLOBAL.login_id;
924: l_sysdate DATE := SYSDATE;
925: l_record_version_number NUMBER := 1;
926:
927: -- This cursor gets all the source pa_resource_asgn_curr records
928: -- for the entire version specified by c_src_version_id.
929: -- This cursor should be used when p_version_level_flag is 'Y'
930: -- and p_copy_mode is 'COPY_ALL'.
931:

Line 969: pa_resource_asgn_curr src_rbc

965: src_rbc.TOTAL_PROJFUNC_INIT_REVENUE,
966: src_rbc.TOTAL_DISPLAY_QUANTITY
967: FROM pa_resource_assignments tgt_ra,
968: pa_resource_assignments src_ra,
969: pa_resource_asgn_curr src_rbc
970: WHERE src_rbc.budget_version_id = c_src_version_id
971: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
972: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
973: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

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

973: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id
974: AND nvl(tgt_ra.cbs_element_id,-1) = nvl(src_ra.cbs_element_id,-1) --bug#16791711
975: AND tgt_ra.budget_version_id = c_tgt_version_id;
976:
977: -- This cursor gets overrides from the source pa_resource_asgn_curr
978: -- records for the entire version specified by c_src_version_id.
979: -- This cursor should be used when p_version_level_flag is 'Y'
980: -- and p_copy_mode is 'COPY_OVERRIDES'.
981:

Line 992: pa_resource_asgn_curr src_rbc

988: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
989: src_rbc.TXN_BILL_RATE_OVERRIDE
990: FROM pa_resource_assignments tgt_ra,
991: pa_resource_assignments src_ra,
992: pa_resource_asgn_curr src_rbc
993: WHERE src_rbc.budget_version_id = c_src_version_id
994: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
995: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
996: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

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

996: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id
997: AND nvl(tgt_ra.cbs_element_id,-1) = nvl(src_ra.cbs_element_id,-1) --bug#16791711
998: AND tgt_ra.budget_version_id = c_tgt_version_id;
999:
1000: -- This cursor gets overrides from the source pa_resource_asgn_curr
1001: -- records for the resources specified in pa_resource_asgn_curr_tmp
1002: -- for the version specified by c_src_version_id.
1003: -- This cursor should be used when p_version_level_flag is 'N'
1004: -- and p_copy_mode is 'COPY_OVERRIDES'.

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

997: AND nvl(tgt_ra.cbs_element_id,-1) = nvl(src_ra.cbs_element_id,-1) --bug#16791711
998: AND tgt_ra.budget_version_id = c_tgt_version_id;
999:
1000: -- This cursor gets overrides from the source pa_resource_asgn_curr
1001: -- records for the resources specified in pa_resource_asgn_curr_tmp
1002: -- for the version specified by c_src_version_id.
1003: -- This cursor should be used when p_version_level_flag is 'N'
1004: -- and p_copy_mode is 'COPY_OVERRIDES'.
1005: -- Note: Ordered hint has been added to avoid a Merge Join Cartesian

Line 1017: FROM pa_resource_asgn_curr src_rbc,

1013: src_rbc.TXN_CURRENCY_CODE,
1014: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
1015: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
1016: src_rbc.TXN_BILL_RATE_OVERRIDE
1017: FROM pa_resource_asgn_curr src_rbc,
1018: pa_resource_assignments src_ra,
1019: pa_resource_assignments tgt_ra,
1020: pa_resource_asgn_curr_tmp tmp
1021: WHERE tgt_ra.budget_version_id = c_tgt_version_id

Line 1020: pa_resource_asgn_curr_tmp tmp

1016: src_rbc.TXN_BILL_RATE_OVERRIDE
1017: FROM pa_resource_asgn_curr src_rbc,
1018: pa_resource_assignments src_ra,
1019: pa_resource_assignments tgt_ra,
1020: pa_resource_asgn_curr_tmp tmp
1021: WHERE tgt_ra.budget_version_id = c_tgt_version_id
1022: AND src_ra.budget_version_id = c_src_version_id
1023: AND tgt_ra.resource_assignment_id = tmp.resource_assignment_id
1024: AND nvl(src_ra.task_id,0) = nvl(tgt_ra.task_id,0)

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

1274: l_brdn_cost_rate_override_tab := l_null_NumTabTyp;
1275: END IF;
1276: END IF; -- p_copy_mode check
1277:
1278: -- Step 3: Delete target records from PA_RESOURCE_ASGN_CURR
1279: -- that are being copied over from source records.
1280:
1281: -- Populate PA_RESOURCE_ASGN_CURR_TMP with the target records.
1282: -- Note that the DELETE_TABLE_RECORDS API does not require the

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

1277:
1278: -- Step 3: Delete target records from PA_RESOURCE_ASGN_CURR
1279: -- that are being copied over from source records.
1280:
1281: -- Populate PA_RESOURCE_ASGN_CURR_TMP with the target records.
1282: -- Note that the DELETE_TABLE_RECORDS API does not require the
1283: -- DELETE_FLAG column be populated for internal p_calling_module
1284: -- values (though the flag is required for public p_calling_modules).
1285: -- See the is_public_calling_module() and is_private_calling_module()

Line 1288: DELETE PA_RESOURCE_ASGN_CURR_TMP;

1284: -- values (though the flag is required for public p_calling_modules).
1285: -- See the is_public_calling_module() and is_private_calling_module()
1286: -- functions for details on private/public calling modules.
1287:
1288: DELETE PA_RESOURCE_ASGN_CURR_TMP;
1289:
1290: FORALL i IN 1..l_ra_id_tab.count
1291: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (
1292: RESOURCE_ASSIGNMENT_ID,

Line 1291: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (

1287:
1288: DELETE PA_RESOURCE_ASGN_CURR_TMP;
1289:
1290: FORALL i IN 1..l_ra_id_tab.count
1291: INSERT INTO PA_RESOURCE_ASGN_CURR_TMP (
1292: RESOURCE_ASSIGNMENT_ID,
1293: TXN_CURRENCY_CODE )
1294: VALUES (
1295: l_ra_id_tab(i),

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

1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1324: END IF;
1325:
1326: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
1327:
1328: IF p_copy_mode = G_COPY_ALL THEN
1329: FORALL i IN 1..l_ra_id_tab.count
1330: INSERT INTO PA_RESOURCE_ASGN_CURR (

Line 1330: INSERT INTO PA_RESOURCE_ASGN_CURR (

1326: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
1327:
1328: IF p_copy_mode = G_COPY_ALL THEN
1329: FORALL i IN 1..l_ra_id_tab.count
1330: INSERT INTO PA_RESOURCE_ASGN_CURR (
1331: RA_TXN_ID,
1332: BUDGET_VERSION_ID,
1333: RESOURCE_ASSIGNMENT_ID,
1334: TXN_CURRENCY_CODE,

Line 1372: pa_resource_asgn_curr_s.nextval,

1368: LAST_UPDATED_BY,
1369: LAST_UPDATE_LOGIN,
1370: RECORD_VERSION_NUMBER )
1371: VALUES (
1372: pa_resource_asgn_curr_s.nextval,
1373: p_fp_cols_rec.x_budget_version_id,
1374: l_ra_id_tab(i),
1375: l_txn_currency_code_tab(i),
1376: l_total_quantity_tab(i),

Line 1414: INSERT INTO PA_RESOURCE_ASGN_CURR (

1410: l_last_update_login,
1411: l_record_version_number );
1412: ELSIF p_copy_mode = G_COPY_OVERRIDES THEN
1413: FORALL i IN 1..l_ra_id_tab.count
1414: INSERT INTO PA_RESOURCE_ASGN_CURR (
1415: RA_TXN_ID,
1416: BUDGET_VERSION_ID,
1417: RESOURCE_ASSIGNMENT_ID,
1418: TXN_CURRENCY_CODE,

Line 1429: pa_resource_asgn_curr_s.nextval,

1425: LAST_UPDATED_BY,
1426: LAST_UPDATE_LOGIN,
1427: RECORD_VERSION_NUMBER )
1428: VALUES (
1429: pa_resource_asgn_curr_s.nextval,
1430: p_fp_cols_rec.x_budget_version_id,
1431: l_ra_id_tab(i),
1432: l_txn_currency_code_tab(i),
1433: l_raw_cost_rate_override_tab(i),

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

1550:
1551: IF p_version_level_flag = 'Y' THEN
1552:
1553: -- VERSION LEVEL Mode:
1554: -- Insert records into PA_RESOURCE_ASGN_CURR for all planning
1555: -- resource + currency combinations for the given version that do
1556: -- not already exist in the table.
1557:
1558: SELECT DISTINCT

Line 1569: FROM pa_resource_asgn_curr rbc

1565: pa_resource_assignments ra
1566: WHERE ra.budget_version_id = p_fp_cols_rec.x_budget_version_id
1567: AND bl.resource_assignment_id = ra.resource_assignment_id
1568: AND NOT EXISTS (SELECT null
1569: FROM pa_resource_asgn_curr rbc
1570: WHERE rbc.resource_assignment_id = bl.resource_assignment_id
1571: AND rbc.txn_currency_code = bl.txn_currency_code);
1572:
1573: -- Insert records with values for the following columns:

Line 1579: INSERT INTO pa_resource_asgn_curr (

1575: -- All of the remaining columns, including the rate overrides,
1576: -- but excluding the who columns, will be Null in this case.
1577:
1578: FORALL i IN 1..l_ra_id_tab.count
1579: INSERT INTO pa_resource_asgn_curr (
1580: RA_TXN_ID,
1581: BUDGET_VERSION_ID,
1582: RESOURCE_ASSIGNMENT_ID,
1583: TXN_CURRENCY_CODE,

Line 1591: pa_resource_asgn_curr_s.nextval,

1587: LAST_UPDATED_BY,
1588: LAST_UPDATE_LOGIN,
1589: RECORD_VERSION_NUMBER )
1590: VALUES (
1591: pa_resource_asgn_curr_s.nextval,
1592: p_fp_cols_rec.x_budget_version_id,
1593: l_ra_id_tab(i),
1594: l_txn_currency_code_tab(i),
1595: l_sysdate,

Line 1606: -- into the PA_RESOURCE_ASGN_CURR table.

1602: ELSIF p_version_level_flag = 'N' THEN
1603:
1604: -- TEMP TABLE Mode:
1605: -- Delete and then Insert the records specified by the temp table
1606: -- into the PA_RESOURCE_ASGN_CURR table.
1607:
1608: IF p_pa_debug_mode = 'Y' THEN
1609: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1610: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

Line 1636: INSERT INTO pa_resource_asgn_curr

1632: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1633: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1634: END IF;
1635:
1636: INSERT INTO pa_resource_asgn_curr
1637: ( RA_TXN_ID,
1638: BUDGET_VERSION_ID,
1639: RESOURCE_ASSIGNMENT_ID,
1640: TXN_CURRENCY_CODE,

Line 1651: SELECT pa_resource_asgn_curr_s.nextval,

1647: LAST_UPDATED_BY,
1648: LAST_UPDATE_LOGIN,
1649: RECORD_VERSION_NUMBER,
1650: expenditure_type )--for EnC
1651: SELECT pa_resource_asgn_curr_s.nextval,
1652: p_fp_cols_rec.x_budget_version_id,
1653: tmp.resource_assignment_id,
1654: tmp.txn_currency_code,
1655: tmp.txn_raw_cost_rate_override,

Line 1665: FROM pa_resource_asgn_curr_tmp tmp;

1661: l_last_updated_by,
1662: l_last_update_login,
1663: l_record_version_number,
1664: expenditure_type --for EnC
1665: FROM pa_resource_asgn_curr_tmp tmp;
1666:
1667: END IF; -- p_version_level_flag check
1668:
1669: --dbms_output.put_line('Reached Insert Records');

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

1747: -- for the entire version specified by c_budget_version_id.
1748: -- This cursor should be used when p_version_level_flag is 'Y'.
1749: -- The cursor consists of two halves, connected by UNION ALL.
1750: -- The first half gets data for resources that have budget lines,
1751: -- but may or may not have records in PA_RESOURCE_ASGN_CURR.
1752: -- The second half gets data for resources that have records in
1753: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1754:
1755: CURSOR version_level_rollup_csr

Line 1753: -- PA_RESOURCE_ASGN_CURR but no budget lines.

1749: -- The cursor consists of two halves, connected by UNION ALL.
1750: -- The first half gets data for resources that have budget lines,
1751: -- but may or may not have records in PA_RESOURCE_ASGN_CURR.
1752: -- The second half gets data for resources that have records in
1753: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1754:
1755: CURSOR version_level_rollup_csr
1756: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1757: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

Line 1860: pa_resource_asgn_curr rbc

1856: 0,null,sum(nvl(bl.display_quantity,0))), --TOTAL_DISPLAY_QUANTITY
1857: rbc.expenditure_type --Expenditure type for Enc
1858: FROM pa_resource_assignments ra,
1859: pa_budget_lines bl,
1860: pa_resource_asgn_curr rbc
1861: WHERE bl.resource_assignment_id = rbc.resource_assignment_id (+)
1862: AND bl.txn_currency_code = rbc.txn_currency_code (+)
1863: AND ra.budget_version_id = c_budget_version_id
1864: AND ra.project_id = c_project_id

Line 1906: FROM pa_resource_asgn_curr rbc

1902: null, --TOTAL_PROJFUNC_INIT_BD_COST
1903: null, --TOTAL_PROJFUNC_INIT_REVENUE
1904: null, --TOTAL_DISPLAY_QUANTITY
1905: rbc.expenditure_type --Expenditure type for Enc
1906: FROM pa_resource_asgn_curr rbc
1907: WHERE rbc.budget_version_id = c_budget_version_id
1908: AND NOT EXISTS (SELECT null
1909: FROM pa_budget_lines bl
1910: WHERE bl.resource_assignment_id = rbc.resource_assignment_id

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

1911: AND bl.txn_currency_code = rbc.txn_currency_code );
1912:
1913:
1914: -- This cursor computes ETC rates, average rates, and amount totals
1915: -- for the resources specified in PA_RESOURCE_ASGN_CURR_TMP.
1916: -- This cursor should be used when p_version_level_flag is 'N'.
1917: -- The cursor gets data for resources that have records in
1918: -- PA_RESOURCE_ASGN_CURR but may or may not have budget lines.
1919: -- NOTE: the cursor parameters c_project_id and c_budget_version_id

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

1914: -- This cursor computes ETC rates, average rates, and amount totals
1915: -- for the resources specified in PA_RESOURCE_ASGN_CURR_TMP.
1916: -- This cursor should be used when p_version_level_flag is 'N'.
1917: -- The cursor gets data for resources that have records in
1918: -- PA_RESOURCE_ASGN_CURR but may or may not have budget lines.
1919: -- NOTE: the cursor parameters c_project_id and c_budget_version_id
1920: -- are not necessary here, but included in case of future use.
1921:
1922: CURSOR table_level_rollup_csr

Line 2026: pa_resource_asgn_curr_TMP rbc

2022: decode(sum(nvl(bl.display_quantity,0)),
2023: 0,null,sum(nvl(bl.display_quantity,0))), --TOTAL_DISPLAY_QUANTITY
2024: rbc.expenditure_type --Direct cost expenditure type for EnC
2025: FROM pa_budget_lines bl,
2026: pa_resource_asgn_curr_TMP rbc
2027: WHERE bl.resource_assignment_id (+) = rbc.resource_assignment_id
2028: AND bl.txn_currency_code (+) = rbc.txn_currency_code
2029: --Bug 6160759
2030: AND bl.budget_version_id(+)= p_fp_cols_rec.x_budget_version_id

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

2274: l_pfc_init_raw_cost_tab := l_null_NumTabTyp;
2275: l_pfc_init_burdened_cost_tab := l_null_NumTabTyp;
2276: END IF;
2277:
2278: -- Step 3: Delete records from the PA_RESOURCE_ASGN_CURR table.
2279:
2280: IF p_pa_debug_mode = 'Y' THEN
2281: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2282: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

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

2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2306: END IF;
2307:
2308: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
2309:
2310: FORALL i IN 1..l_ra_id_tab.count
2311: INSERT INTO PA_RESOURCE_ASGN_CURR (
2312: RA_TXN_ID,

Line 2311: INSERT INTO PA_RESOURCE_ASGN_CURR (

2307:
2308: -- Step 4: Insert records into the PA_RESOURCE_ASGN_CURR table.
2309:
2310: FORALL i IN 1..l_ra_id_tab.count
2311: INSERT INTO PA_RESOURCE_ASGN_CURR (
2312: RA_TXN_ID,
2313: BUDGET_VERSION_ID,
2314: RESOURCE_ASSIGNMENT_ID,
2315: TXN_CURRENCY_CODE,

Line 2354: pa_resource_asgn_curr_s.nextval,

2350: LAST_UPDATE_LOGIN,
2351: RECORD_VERSION_NUMBER,
2352: expenditure_type )
2353: VALUES (
2354: pa_resource_asgn_curr_s.nextval,
2355: p_fp_cols_rec.x_budget_version_id,
2356: l_ra_id_tab(i),
2357: l_txn_currency_code_tab(i),
2358: l_total_quantity_tab(i),

Line 2399: DELETE FROM pa_resource_asgn_curr prac

2395: );
2396:
2397: --bug#12865217
2398: FORALL j IN 1..l_ra_id_tab.count
2399: DELETE FROM pa_resource_asgn_curr prac
2400: WHERE EXISTS
2401: (SELECT 1
2402: FROM pa_resource_asgn_curr a
2403: where a.budget_version_id = p_fp_cols_rec.x_budget_version_id

Line 2402: FROM pa_resource_asgn_curr a

2398: FORALL j IN 1..l_ra_id_tab.count
2399: DELETE FROM pa_resource_asgn_curr prac
2400: WHERE EXISTS
2401: (SELECT 1
2402: FROM pa_resource_asgn_curr a
2403: where a.budget_version_id = p_fp_cols_rec.x_budget_version_id
2404: AND a.resource_assignment_id = l_ra_id_tab(j)
2405: AND prac.resource_assignment_id = a.resource_assignment_id
2406: AND ( a.total_quantity IS NOT NULL