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_TMP

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 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 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 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 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 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 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 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 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 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 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 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