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.PSP_SUM_ADJ dependencies on FND_DATE

Line 89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Bug 6118274
89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
92: -- Bug 6118274
93:

Line 91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');

87:
88: -- Bug 6118274
89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for psp_enc_summary_lines');
90: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
91: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for psp_enc_summary_lines');
92: -- Bug 6118274
93:
94: -- Check the target system status and do the tieback
95: gms_tie_back(p_adj_sum_batch_name,

Line 761: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>

757: (NVL(l_attribute8, 'NULL') <> NVL(gl_sum_lines_rec.attribute8, 'NULL')) OR
758: (NVL(l_attribute9, 'NULL') <> NVL(gl_sum_lines_rec.attribute9, 'NULL')) OR
759: (NVL(l_attribute10, 'NULL') <> NVL(gl_sum_lines_rec.attribute10, 'NULL')) OR
760: --- added accounting_date condn for 3108109, 4734810
761: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>
762: nvl( gl_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR
763: nvl(l_exchange_rate_type,'-999') <>
764: nvl(gl_sum_lines_rec.exchange_rate_type,'-999') THEN
765:

Line 762: nvl( gl_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR

758: (NVL(l_attribute9, 'NULL') <> NVL(gl_sum_lines_rec.attribute9, 'NULL')) OR
759: (NVL(l_attribute10, 'NULL') <> NVL(gl_sum_lines_rec.attribute10, 'NULL')) OR
760: --- added accounting_date condn for 3108109, 4734810
761: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>
762: nvl( gl_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR
763: nvl(l_exchange_rate_type,'-999') <>
764: nvl(gl_sum_lines_rec.exchange_rate_type,'-999') THEN
765:
766: insert_into_summary_lines(

Line 2498: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>

2494: (NVL(l_attribute7, 'NULL') <> NVL(gms_sum_lines_rec.attribute7, 'NULL')) OR
2495: (NVL(l_attribute8, 'NULL') <> NVL(gms_sum_lines_rec.attribute8, 'NULL')) OR
2496: (NVL(l_attribute9, 'NULL') <> NVL(gms_sum_lines_rec.attribute9, 'NULL')) OR
2497: (NVL(l_attribute10, 'NULL') <> NVL(gms_sum_lines_rec.attribute10, 'NULL')) OR
2498: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>
2499: nvl( gms_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR
2500: nvl(l_exchange_rate_type,'-999') <> nvl(gms_sum_lines_rec.exchange_rate_type,'-999') THEN --3108109
2501:
2502: IF l_dr_cr_flag = 'C' THEN

Line 2499: nvl( gms_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR

2495: (NVL(l_attribute8, 'NULL') <> NVL(gms_sum_lines_rec.attribute8, 'NULL')) OR
2496: (NVL(l_attribute9, 'NULL') <> NVL(gms_sum_lines_rec.attribute9, 'NULL')) OR
2497: (NVL(l_attribute10, 'NULL') <> NVL(gms_sum_lines_rec.attribute10, 'NULL')) OR
2498: nvl(l_accounting_date, fnd_date.canonical_to_date('1800/01/31')) <>
2499: nvl( gms_sum_lines_rec.accounting_date, fnd_date.canonical_to_date('1800/01/31')) OR
2500: nvl(l_exchange_rate_type,'-999') <> nvl(gms_sum_lines_rec.exchange_rate_type,'-999') THEN --3108109
2501:
2502: IF l_dr_cr_flag = 'C' THEN
2503: l_summary_amount := 0 - l_summary_amount;

Line 3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');

3640:
3641: BEGIN
3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:

Line 3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');

3642:
3643: /*Bug 6118274*/
3644: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling gather_table_stats for pa_transaction_interface_all');
3645: fnd_stats.gather_table_stats('PA', 'PA_TRANSACTION_INTERFACE_ALL');
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed gather_table_stats for pa_transaction_interface_all');
3647: /*Bug 6118274*/
3648:
3649: open pc_batch_cur;
3650: loop