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.

[Home] [Help]

APPS.CSD_RETURNS_BI_PVT dependencies on CSD_FACT_DETAILS

Line 16: FROM csd_fact_details

12: BEGIN
13:
14: SELECT last_run_date
15: INTO l_last_run_date
16: FROM csd_fact_details
17: WHERE fact_name = p_fact_name;
18:
19: RETURN l_last_run_date;
20:

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');

140: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
141:
142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;

142: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Receiving Transactions fact ...');
143:
144: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_RCV_TXNS_F name ...');
145:
146: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_RCV_TXNS_F;
147:
148: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
149:
150: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_RCV_TXNS_F ...');

Line 280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

276: ;
277:
278: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
281:
282: INSERT INTO CSD_FACT_DETAILS
283: (fact_name,
284: last_run_date,

Line 282: INSERT INTO CSD_FACT_DETAILS

278: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
281:
282: INSERT INTO CSD_FACT_DETAILS
283: (fact_name,
284: last_run_date,
285: created_by,
286: creation_date,

Line 358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');

354: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
355:
356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;

356: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Shipping Transactions fact ...');
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_SHP_TXNS_F name ...');
359:
360: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_SHP_TXNS_F;
361:
362: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
363:
364: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_SHP_TXNS_F ...');

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

457:
458:
459: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
460:
461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
462:
463: INSERT INTO CSD_FACT_DETAILS
464: (fact_name,
465: last_run_date,

Line 463: INSERT INTO CSD_FACT_DETAILS

459: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
460:
461: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
462:
463: INSERT INTO CSD_FACT_DETAILS
464: (fact_name,
465: last_run_date,
466: created_by,
467: creation_date,

Line 538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');

534: l_request_id := NVL(fnd_global.CONC_REQUEST_ID, -1);
535:
536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');

Line 540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;

536: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Entering the initial refresh process for Material Transactions fact ...');
537:
538: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Deleting record from CSD_FACT_DETAILS for CSD_RETURNS_BI_MTL_TXNS_F name ...');
539:
540: DELETE FROM CSD_FACT_DETAILS where fact_name = C_CSD_RETURNS_BI_MTL_TXNS_F;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Delete successful.');
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Truncating table CSD_RETURNS_BI_MTL_TXNS_F ...');

Line 709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');

705: -- swai: 12.2 end
706:
707: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
708:
709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
710:
711: INSERT INTO CSD_FACT_DETAILS
712: (fact_name,
713: last_run_date,

Line 711: INSERT INTO CSD_FACT_DETAILS

707: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Insert successful.');
708:
709: FND_FILE.PUT_LINE(FND_FILE.LOG, lc_proc_name || ': ' || 'Inserting a record into CSD_FACT_DETAILS ...');
710:
711: INSERT INTO CSD_FACT_DETAILS
712: (fact_name,
713: last_run_date,
714: created_by,
715: creation_date,