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_RES_ASG_CURRENCY_PUB

Line 1: PACKAGE body PA_RES_ASG_CURRENCY_PUB as

1: PACKAGE body PA_RES_ASG_CURRENCY_PUB as
2: /* $Header: PAFPRBCB.pls 120.7.12020000.5 2013/05/17 10:17:13 bpottipa ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: -- Private P_CALLING_MODULE values

Line 140: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.MAINTAIN_DATA';

136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
138: X_MSG_DATA OUT NOCOPY VARCHAR2 )
139: IS
140: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.MAINTAIN_DATA';
141: l_log_level NUMBER := 5;
142:
143: l_msg_count NUMBER;
144: l_data VARCHAR2(2000);

Line 162: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS

158: ( p_function => 'MAINTAIN_DATA',
159: p_debug_mode => p_pa_debug_mode );
160: END IF;
161:
162: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS
163: ( P_CALLING_API => G_PVT_MAINTAIN,
164: P_FP_COLS_REC => p_fp_cols_rec,
165: P_CALLING_MODULE => p_calling_module,
166: P_DELETE_FLAG => p_delete_flag,

Line 288: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||

284: IF p_delete_flag = 'Y' THEN
285:
286: IF p_pa_debug_mode = 'Y' THEN
287: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
288: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
289: 'DELETE_TABLE_RECORDS',
290: P_CALLED_MODE => p_called_mode,
291: P_MODULE_NAME => l_module_name);
292: END IF;

Line 293: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS

289: 'DELETE_TABLE_RECORDS',
290: P_CALLED_MODE => p_called_mode,
291: P_MODULE_NAME => l_module_name);
292: END IF;
293: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS
294: ( P_FP_COLS_REC => p_fp_cols_rec,
295: P_CALLING_MODULE => p_calling_module,
296: P_VERSION_LEVEL_FLAG => p_version_level_flag,
297: P_CALLED_MODE => p_called_mode,

Line 303: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||

299: X_MSG_COUNT => x_msg_count,
300: X_MSG_DATA => x_msg_data );
301: IF p_pa_debug_mode = 'Y' THEN
302: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
303: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
304: 'DELETE_TABLE_RECORDS: '||x_return_status,
305: P_CALLED_MODE => p_called_mode,
306: P_MODULE_NAME => l_module_name);
307: END IF;

Line 450: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||

446: IF p_copy_flag = 'Y' THEN
447:
448: IF p_pa_debug_mode = 'Y' THEN
449: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
450: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
451: 'COPY_TABLE_RECORDS',
452: P_CALLED_MODE => p_called_mode,
453: P_MODULE_NAME => l_module_name);
454: END IF;

Line 455: PA_RES_ASG_CURRENCY_PUB.COPY_TABLE_RECORDS

451: 'COPY_TABLE_RECORDS',
452: P_CALLED_MODE => p_called_mode,
453: P_MODULE_NAME => l_module_name);
454: END IF;
455: PA_RES_ASG_CURRENCY_PUB.COPY_TABLE_RECORDS
456: ( P_FP_COLS_REC => p_fp_cols_rec,
457: P_SRC_VERSION_ID => p_src_version_id,
458: P_COPY_MODE => p_copy_mode,
459: P_CALLING_MODULE => p_calling_module,

Line 467: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||

463: X_MSG_COUNT => x_msg_count,
464: X_MSG_DATA => x_msg_data );
465: IF p_pa_debug_mode = 'Y' THEN
466: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
467: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
468: 'COPY_TABLE_RECORDS: '||x_return_status,
469: P_CALLED_MODE => p_called_mode,
470: P_MODULE_NAME => l_module_name);
471: END IF;

Line 490: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||

486: IF p_rollup_flag = 'N' THEN
487:
488: IF p_pa_debug_mode = 'Y' THEN
489: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
490: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
491: 'INSERT_TABLE_RECORDS',
492: P_CALLED_MODE => p_called_mode,
493: P_MODULE_NAME => l_module_name);
494: END IF;

Line 495: PA_RES_ASG_CURRENCY_PUB.INSERT_TABLE_RECORDS

491: 'INSERT_TABLE_RECORDS',
492: P_CALLED_MODE => p_called_mode,
493: P_MODULE_NAME => l_module_name);
494: END IF;
495: PA_RES_ASG_CURRENCY_PUB.INSERT_TABLE_RECORDS
496: ( P_FP_COLS_REC => p_fp_cols_rec,
497: P_CALLING_MODULE => p_calling_module,
498: P_VERSION_LEVEL_FLAG => p_version_level_flag,
499: P_CALLED_MODE => p_called_mode,

Line 505: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||

501: X_MSG_COUNT => x_msg_count,
502: X_MSG_DATA => x_msg_data );
503: IF p_pa_debug_mode = 'Y' THEN
504: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
505: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
506: 'INSERT_TABLE_RECORDS: '||x_return_status,
507: P_CALLED_MODE => p_called_mode,
508: P_MODULE_NAME => l_module_name);
509: END IF;

Line 519: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||

515: ELSIF p_rollup_flag = 'Y' THEN
516:
517: IF p_pa_debug_mode = 'Y' THEN
518: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
519: P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.' ||
520: 'ROLLUP_AMOUNTS',
521: P_CALLED_MODE => p_called_mode,
522: P_MODULE_NAME => l_module_name);
523: END IF;

Line 525: PA_RES_ASG_CURRENCY_PUB.ROLLUP_AMOUNTS

521: P_CALLED_MODE => p_called_mode,
522: P_MODULE_NAME => l_module_name);
523: END IF;
524:
525: PA_RES_ASG_CURRENCY_PUB.ROLLUP_AMOUNTS
526: ( P_FP_COLS_REC => p_fp_cols_rec,
527: P_CALLING_MODULE => p_calling_module,
528: P_VERSION_LEVEL_FLAG => p_version_level_flag,
529: P_CALLED_MODE => p_called_mode,

Line 535: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||

531: X_MSG_COUNT => x_msg_count,
532: X_MSG_DATA => x_msg_data );
533: IF p_pa_debug_mode = 'Y' THEN
534: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
535: P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.' ||
536: 'ROLLUP_AMOUNTS: '||x_return_status,
537: P_CALLED_MODE => p_called_mode,
538: P_MODULE_NAME => l_module_name);
539: END IF;

Line 591: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',

587: x_msg_count := 1;
588: x_msg_data := substr(sqlerrm,1,240);
589: -- dbms_output.put_line('error msg :'||x_msg_data);
590: FND_MSG_PUB.add_exc_msg
591: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
592: p_procedure_name => 'MAINTAIN_DATA',
593: p_error_text => substr(sqlerrm,1,240));
594: IF P_PA_DEBUG_MODE = 'Y' THEN
595: pa_fp_gen_amount_utils.fp_debug

Line 623: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS';

619: P_ROLLUP_FLAG IN VARCHAR2,
620: P_VERSION_LEVEL_FLAG IN VARCHAR2,
621: P_CALLED_MODE IN VARCHAR2 )
622: IS
623: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS';
624: l_log_level NUMBER := 5;
625: BEGIN
626: IF p_pa_debug_mode = 'N' THEN
627: RETURN;

Line 766: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS';

762: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
763: X_MSG_COUNT OUT NOCOPY NUMBER,
764: X_MSG_DATA OUT NOCOPY VARCHAR2)
765: IS
766: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS';
767: l_log_level NUMBER := 5;
768:
769: l_msg_count NUMBER;
770: l_data VARCHAR2(2000);

Line 781: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS

777: ( p_function => 'DELETE_TABLE_RECORDS',
778: p_debug_mode => p_pa_debug_mode );
779: END IF;
780:
781: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS
782: ( P_CALLING_API => G_PVT_DELETE,
783: P_FP_COLS_REC => p_fp_cols_rec,
784: P_CALLING_MODULE => p_calling_module,
785: P_VERSION_LEVEL_FLAG => p_version_level_flag,

Line 887: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',

883: x_msg_count := 1;
884: x_msg_data := substr(sqlerrm,1,240);
885: -- dbms_output.put_line('error msg :'||x_msg_data);
886: FND_MSG_PUB.add_exc_msg
887: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
888: p_procedure_name => 'DELETE_TABLE_RECORDS',
889: p_error_text => substr(sqlerrm,1,240));
890: IF P_PA_DEBUG_MODE = 'Y' THEN
891: pa_fp_gen_amount_utils.fp_debug

Line 914: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.COPY_TABLE_RECORDS';

910: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
911: X_MSG_COUNT OUT NOCOPY NUMBER,
912: X_MSG_DATA OUT NOCOPY VARCHAR2)
913: IS
914: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.COPY_TABLE_RECORDS';
915: l_log_level NUMBER := 5;
916:
917: l_msg_count NUMBER;
918: l_data VARCHAR2(2000);

Line 1077: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS

1073: ( p_function => 'COPY_TABLE_RECORDS',
1074: p_debug_mode => p_pa_debug_mode );
1075: END IF;
1076:
1077: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS
1078: ( P_CALLING_API => G_PVT_COPY,
1079: P_FP_COLS_REC => p_fp_cols_rec,
1080: P_CALLING_MODULE => p_calling_module,
1081: P_SRC_VERSION_ID => p_src_version_id,

Line 1300: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

1296: l_txn_currency_code_tab(i) );
1297:
1298: IF p_pa_debug_mode = 'Y' THEN
1299: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1300: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'
1301: || 'DELETE_TABLE_RECORDS',
1302: P_CALLED_MODE => p_called_mode,
1303: P_MODULE_NAME => l_module_name,
1304: P_LOG_LEVEL => l_log_level );

Line 1306: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS

1302: P_CALLED_MODE => p_called_mode,
1303: P_MODULE_NAME => l_module_name,
1304: P_LOG_LEVEL => l_log_level );
1305: END IF;
1306: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS
1307: ( P_FP_COLS_REC => p_fp_cols_rec,
1308: P_CALLING_MODULE => G_PVT_COPY,
1309: P_VERSION_LEVEL_FLAG => 'N',
1310: P_CALLED_MODE => p_called_mode,

Line 1316: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'

1312: X_MSG_COUNT => x_msg_count,
1313: X_MSG_DATA => x_msg_data );
1314: IF p_pa_debug_mode = 'Y' THEN
1315: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1316: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1317: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1318: P_CALLED_MODE => p_called_mode,
1319: P_MODULE_NAME => l_module_name,
1320: P_LOG_LEVEL => l_log_level );

Line 1488: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',

1484: x_msg_count := 1;
1485: x_msg_data := substr(sqlerrm,1,240);
1486: -- dbms_output.put_line('error msg :'||x_msg_data);
1487: FND_MSG_PUB.add_exc_msg
1488: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1489: p_procedure_name => 'COPY_TABLE_RECORDS',
1490: p_error_text => substr(sqlerrm,1,240));
1491: IF P_PA_DEBUG_MODE = 'Y' THEN
1492: pa_fp_gen_amount_utils.fp_debug

Line 1513: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.INSERT_TABLE_RECORDS';

1509: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1510: X_MSG_COUNT OUT NOCOPY NUMBER,
1511: X_MSG_DATA OUT NOCOPY VARCHAR2)
1512: IS
1513: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.INSERT_TABLE_RECORDS';
1514: l_log_level NUMBER := 5;
1515:
1516: l_msg_count NUMBER;
1517: l_data VARCHAR2(2000);

Line 1540: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS

1536: ( p_function => 'INSERT_TABLE_RECORDS',
1537: p_debug_mode => p_pa_debug_mode );
1538: END IF;
1539:
1540: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS
1541: ( P_CALLING_API => G_PVT_INSERT,
1542: P_FP_COLS_REC => p_fp_cols_rec,
1543: P_CALLING_MODULE => p_calling_module,
1544: P_VERSION_LEVEL_FLAG => p_version_level_flag,

Line 1610: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

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.'
1611: || 'DELETE_TABLE_RECORDS',
1612: P_CALLED_MODE => p_called_mode,
1613: P_MODULE_NAME => l_module_name,
1614: P_LOG_LEVEL => l_log_level );

Line 1616: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS

1612: P_CALLED_MODE => p_called_mode,
1613: P_MODULE_NAME => l_module_name,
1614: P_LOG_LEVEL => l_log_level );
1615: END IF;
1616: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS
1617: ( P_FP_COLS_REC => p_fp_cols_rec,
1618: P_CALLING_MODULE => G_PVT_INSERT,
1619: P_VERSION_LEVEL_FLAG => p_version_level_flag,
1620: P_CALLED_MODE => p_called_mode,

Line 1626: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'

1622: X_MSG_COUNT => x_msg_count,
1623: X_MSG_DATA => x_msg_data );
1624: IF p_pa_debug_mode = 'Y' THEN
1625: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1626: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
1627: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
1628: P_CALLED_MODE => p_called_mode,
1629: P_MODULE_NAME => l_module_name,
1630: P_LOG_LEVEL => l_log_level );

Line 1713: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',

1709: x_msg_count := 1;
1710: x_msg_data := substr(sqlerrm,1,240);
1711: -- dbms_output.put_line('error msg :'||x_msg_data);
1712: FND_MSG_PUB.add_exc_msg
1713: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
1714: p_procedure_name => 'INSERT_TABLE_RECORDS',
1715: p_error_text => substr(sqlerrm,1,240));
1716: IF P_PA_DEBUG_MODE = 'Y' THEN
1717: pa_fp_gen_amount_utils.fp_debug

Line 1738: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.ROLLUP_AMOUNTS';

1734: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1735: X_MSG_COUNT OUT NOCOPY NUMBER,
1736: X_MSG_DATA OUT NOCOPY VARCHAR2)
1737: IS
1738: l_module_name VARCHAR2(100) := 'pa.plsql.PA_RES_ASG_CURRENCY_PUB.ROLLUP_AMOUNTS';
1739: l_log_level NUMBER := 5;
1740:
1741: l_msg_count NUMBER;
1742: l_data VARCHAR2(2000);

Line 2092: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS

2088: ( p_function => 'ROLLUP_AMOUNTS',
2089: p_debug_mode => p_pa_debug_mode );
2090: END IF;
2091:
2092: PA_RES_ASG_CURRENCY_PUB.PRINT_INPUT_PARAMS
2093: ( P_CALLING_API => G_PVT_ROLLUP,
2094: P_FP_COLS_REC => p_fp_cols_rec,
2095: P_CALLING_MODULE => p_calling_module,
2096: P_VERSION_LEVEL_FLAG => p_version_level_flag,

Line 2282: ( P_MSG => 'Before calling PA_RES_ASG_CURRENCY_PUB.'

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.'
2283: || 'DELETE_TABLE_RECORDS',
2284: P_CALLED_MODE => p_called_mode,
2285: P_MODULE_NAME => l_module_name,
2286: P_LOG_LEVEL => l_log_level );

Line 2288: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS

2284: P_CALLED_MODE => p_called_mode,
2285: P_MODULE_NAME => l_module_name,
2286: P_LOG_LEVEL => l_log_level );
2287: END IF;
2288: PA_RES_ASG_CURRENCY_PUB.DELETE_TABLE_RECORDS
2289: ( P_FP_COLS_REC => p_fp_cols_rec,
2290: P_CALLING_MODULE => G_PVT_ROLLUP,
2291: P_VERSION_LEVEL_FLAG => p_version_level_flag,
2292: P_CALLED_MODE => p_called_mode,

Line 2298: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'

2294: X_MSG_COUNT => x_msg_count,
2295: X_MSG_DATA => x_msg_data );
2296: IF p_pa_debug_mode = 'Y' THEN
2297: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2298: ( P_MSG => 'After calling PA_RES_ASG_CURRENCY_PUB.'
2299: || 'DELETE_TABLE_RECORDS: ' || x_return_status,
2300: P_CALLED_MODE => p_called_mode,
2301: P_MODULE_NAME => l_module_name,
2302: P_LOG_LEVEL => l_log_level );

Line 2513: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',

2509: x_msg_count := 1;
2510: x_msg_data := substr(sqlerrm,1,240);
2511: -- dbms_output.put_line('error msg :'||x_msg_data);
2512: FND_MSG_PUB.add_exc_msg
2513: ( p_pkg_name => 'PA_RES_ASG_CURRENCY_PUB',
2514: p_procedure_name => 'ROLLUP_AMOUNTS',
2515: p_error_text => substr(sqlerrm,1,240));
2516: IF P_PA_DEBUG_MODE = 'Y' THEN
2517: pa_fp_gen_amount_utils.fp_debug

Line 2529: END PA_RES_ASG_CURRENCY_PUB;

2525:
2526: END ROLLUP_AMOUNTS;
2527:
2528:
2529: END PA_RES_ASG_CURRENCY_PUB;