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