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.MSD_PULL_FACT_DATA dependencies on MSD_COMMON_UTILITIES

Line 89: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;

85:
86: procedure pull_shipment_data(
87: errbuf OUT NOCOPY VARCHAR2,
88: retcode OUT NOCOPY VARCHAR2) IS
89: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;
90: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE ;
91: x_delete_flag VARCHAR2(1) := 'Y' ;
92: /******************************************************
93: Cursor to get distinct Instance, Max Data and Min Date

Line 90: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE ;

86: procedure pull_shipment_data(
87: errbuf OUT NOCOPY VARCHAR2,
88: retcode OUT NOCOPY VARCHAR2) IS
89: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_STAGING_TABLE ;
90: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SHIPMENT_FACT_TABLE ;
91: x_delete_flag VARCHAR2(1) := 'Y' ;
92: /******************************************************
93: Cursor to get distinct Instance, Max Data and Min Date
94: ******************************************************/

Line 131: p_date_column => MSD_COMMON_UTILITIES.SHIPMENT_DATE_USED,

127: Clean_Staging_Table(
128: errbuf => errbuf,
129: retcode => retcode,
130: p_table_name => x_source_table,
131: p_date_column => MSD_COMMON_UTILITIES.SHIPMENT_DATE_USED,
132: p_instance_id => Shipment_Rec.instance,
133: p_from_date => to_char(Shipment_Rec.min_ship_date, 'dd-mon-rrrr'),
134: p_to_date => to_char(Shipment_Rec.max_ship_date, 'dd-mon-rrrr'),
135: p_fcst_desg => null );

Line 164: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;

160: procedure pull_booking_data(
161: errbuf OUT NOCOPY VARCHAR2,
162: retcode OUT NOCOPY VARCHAR2) IS
163:
164: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;
165: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE ;
166: x_delete_flag VARCHAR2(1) := 'Y' ;
167: /******************************************************
168: Cursor to get distinct Instance, Max Data and Min Date

Line 165: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE ;

161: errbuf OUT NOCOPY VARCHAR2,
162: retcode OUT NOCOPY VARCHAR2) IS
163:
164: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_STAGING_TABLE ;
165: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.BOOKING_FACT_TABLE ;
166: x_delete_flag VARCHAR2(1) := 'Y' ;
167: /******************************************************
168: Cursor to get distinct Instance, Max Data and Min Date
169: ******************************************************/

Line 206: p_date_column => MSD_COMMON_UTILITIES.BOOKING_DATE_USED,

202: Clean_Staging_Table(
203: errbuf => errbuf,
204: retcode => retcode,
205: p_table_name => x_source_table,
206: p_date_column => MSD_COMMON_UTILITIES.BOOKING_DATE_USED,
207: p_instance_id => Booking_Rec.instance,
208: p_from_date => to_char(Booking_Rec.min_ship_date, 'dd-mon-rrrr'),
209: p_to_date => to_char(Booking_Rec.max_ship_date, 'dd-mon-rrrr'),
210: p_fcst_desg => null );

Line 242: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;

238:
239: procedure pull_uom_conversion(
240: errbuf OUT NOCOPY VARCHAR2,
241: retcode OUT NOCOPY VARCHAR2) IS
242: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;
243: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_FACT_TABLE ;
244:
245: /* DWK. Fix Bug 2220983. Do not include instance = '0' in the cursor */
246: Cursor UOM is

Line 243: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_FACT_TABLE ;

239: procedure pull_uom_conversion(
240: errbuf OUT NOCOPY VARCHAR2,
241: retcode OUT NOCOPY VARCHAR2) IS
242: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_STAGING_TABLE ;
243: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.UOM_FACT_TABLE ;
244:
245: /* DWK. Fix Bug 2220983. Do not include instance = '0' in the cursor */
246: Cursor UOM is
247: select instance

Line 313: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;

309:
310: procedure pull_currency_conversion(
311: errbuf OUT NOCOPY VARCHAR2,
312: retcode OUT NOCOPY VARCHAR2) IS
313: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;
314: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE ;
315: /******************************************************
316: Cursor to get Max Data and Min Date
317: ******************************************************/

Line 314: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE ;

310: procedure pull_currency_conversion(
311: errbuf OUT NOCOPY VARCHAR2,
312: retcode OUT NOCOPY VARCHAR2) IS
313: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_STAGING_TABLE ;
314: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.CURRENCY_FACT_TABLE ;
315: /******************************************************
316: Cursor to get Max Data and Min Date
317: ******************************************************/
318:

Line 354: p_date_column => MSD_COMMON_UTILITIES.CURRENCY_DATE_USED,

350: errbuf => errbuf,
351: retcode => retcode,
352: p_table_name => x_source_table,
353: p_instance_id => null,
354: p_date_column => MSD_COMMON_UTILITIES.CURRENCY_DATE_USED,
355: p_from_date => to_char(Curr_Conv_Rec.min_ship_date, 'dd-mon-rrrr'),
356: p_to_date => to_char(Curr_Conv_Rec.max_ship_date, 'dd-mon-rrrr'),
357: p_fcst_desg => null );
358: END IF;

Line 383: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE ;

379:
380: /* procedure pull_opportunities_data(
381: errbuf OUT NOCOPY VARCHAR2,
382: retcode OUT NOCOPY VARCHAR2) IS
383: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE ;
384: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE ;*/
385: /******************************************************
386: Cursor to get distinct Instance, Max Data and Min Date
387: ******************************************************/

Line 384: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE ;*/

380: /* procedure pull_opportunities_data(
381: errbuf OUT NOCOPY VARCHAR2,
382: retcode OUT NOCOPY VARCHAR2) IS
383: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_STAGING_TABLE ;
384: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.OPPORTUNITY_FACT_TABLE ;*/
385: /******************************************************
386: Cursor to get distinct Instance, Max Data and Min Date
387: ******************************************************/
388: /* Cursor Opportunity is

Line 416: p_date_column => MSD_COMMON_UTILITIES.OPPORTUNITY_DATE_USED,

412: errbuf => errbuf,
413: retcode => retcode,
414: p_table_name => x_source_table,
415: p_instance_id => Opportunity_Rec.instance,
416: p_date_column => MSD_COMMON_UTILITIES.OPPORTUNITY_DATE_USED,
417: p_from_date => to_char(Opportunity_Rec.min_ship_date, 'dd-mon-rrrr'),
418: p_to_date => to_char(Opportunity_Rec.max_ship_date, 'dd-mon-rrrr'),
419: p_fcst_desg => null );
420:

Line 446: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE ;

442:
443: /*procedure pull_sales_forecast(
444: errbuf OUT NOCOPY VARCHAR2,
445: retcode OUT NOCOPY VARCHAR2) IS
446: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE ;
447: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE ;*/
448: /******************************************************
449: Cursor to get distinct Instance, Max Data and Min Date
450: ******************************************************/

Line 447: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE ;*/

443: /*procedure pull_sales_forecast(
444: errbuf OUT NOCOPY VARCHAR2,
445: retcode OUT NOCOPY VARCHAR2) IS
446: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_STAGING_TABLE ;
447: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.SALES_FCST_FACT_TABLE ;*/
448: /******************************************************
449: Cursor to get distinct Instance, Max Data and Min Date
450: ******************************************************/
451: /*

Line 513: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;

509:
510: procedure pull_mfg_forecast(
511: errbuf OUT NOCOPY VARCHAR2,
512: retcode OUT NOCOPY VARCHAR2) IS
513: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;
514: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE ;
515: x_delete_flag VARCHAR2(1) := 'Y' ;
516:
517: b_has_error BOOLEAN := FALSE;

Line 514: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE ;

510: procedure pull_mfg_forecast(
511: errbuf OUT NOCOPY VARCHAR2,
512: retcode OUT NOCOPY VARCHAR2) IS
513: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE ;
514: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.MFG_FCST_FACT_TABLE ;
515: x_delete_flag VARCHAR2(1) := 'Y' ;
516:
517: b_has_error BOOLEAN := FALSE;
518:

Line 571: MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE);

567: MSD_TRANSLATE_FACT_DATA.populate_calendar( errbuf,
568: retcode,
569: Mfg_Fcst_Rec.instance,
570: l_new_refresh_num,
571: MSD_COMMON_UTILITIES.MFG_FCST_STAGING_TABLE);
572: END IF;
573:
574: /* Proceed post-process */
575: MSD_TRANSLATE_FACT_DATA.mfg_post_process( errbuf,

Line 656: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;

652:
653: procedure pull_pricing_data(
654: errbuf OUT NOCOPY VARCHAR2,
655: retcode OUT NOCOPY VARCHAR2) IS
656: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;
657: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_FACT_TABLE ;
658:
659: /******************************************************
660: Cursor to get distinct Instance

Line 657: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_FACT_TABLE ;

653: procedure pull_pricing_data(
654: errbuf OUT NOCOPY VARCHAR2,
655: retcode OUT NOCOPY VARCHAR2) IS
656: x_source_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_STAGING_TABLE ;
657: x_dest_table VARCHAR2(50) := MSD_COMMON_UTILITIES.PRICING_FACT_TABLE ;
658:
659: /******************************************************
660: Cursor to get distinct Instance
661: ******************************************************/