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.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on STANDARD

Line 18: -- Package level variables for the standard who columns

14:
15: -- DBI Global start date
16: s_global_start_date DATE;
17:
18: -- Package level variables for the standard who columns
19: s_user_id NUMBER;
20: s_login_id NUMBER;
21: s_program_id NUMBER;
22: s_program_login_id NUMBER;

Line 46: -- Generate the standard intra-class conversion rates

42: -- Print stage done message
43: PROCEDURE print_stage_done_mesg (p_proc_name IN VARCHAR2,
44: p_stmt_id IN NUMBER);
45:
46: -- Generate the standard intra-class conversion rates
47: PROCEDURE compute_std_intra_class_conv;
48:
49: -- Generate the standard inter-class conversion rates
50: PROCEDURE compute_std_inter_class_conv;

Line 49: -- Generate the standard inter-class conversion rates

45:
46: -- Generate the standard intra-class conversion rates
47: PROCEDURE compute_std_intra_class_conv;
48:
49: -- Generate the standard inter-class conversion rates
50: PROCEDURE compute_std_inter_class_conv;
51:
52: -- Update the log table.
53: PROCEDURE update_log (p_run_date IN DATE);

Line 63: -- Insert the new standard rates (i.e. new combinations not in fact table)

59: **************************************************/
60: -- Clean/Setup up tables for the initial load
61: PROCEDURE setup_tables_init;
62:
63: -- Insert the new standard rates (i.e. new combinations not in fact table)
64: -- into the fact table.
65: PROCEDURE insert_std_rates_init (p_run_date IN DATE);
66:
67: /**************************************************

Line 280: Compute the standard intra-class conversion rates.

276:
277:
278: /* compute_std_intra_class_conv
279:
280: Compute the standard intra-class conversion rates.
281:
282: Rates will be computed for all UOMs belonging to the
283: class(es) of the reporting UOM(s) of the the measure(s) specified
284: in the p_measure_tbl input parameter.

Line 312: -- since the last run, then all intra class standard rates will

308: -- last run (in case of the initial load, all rates are considered
309: -- "changed" since the last run). To figure out precisely which
310: -- rates have changed, we'd have to look at all records and determine:
311: -- 1. If the conversion of the reporting UOM to the base UOM has changed
312: -- since the last run, then all intra class standard rates will
313: -- be different.
314: -- 2. If the conversion of any other rate to the base UOM has changed,
315: -- then only that intra class standard rate has changed.
316: -- However, given that there are only a few reporting UOMs, and that

Line 315: -- then only that intra class standard rate has changed.

311: -- 1. If the conversion of the reporting UOM to the base UOM has changed
312: -- since the last run, then all intra class standard rates will
313: -- be different.
314: -- 2. If the conversion of any other rate to the base UOM has changed,
315: -- then only that intra class standard rate has changed.
316: -- However, given that there are only a few reporting UOMs, and that
317: -- every class has about 8 to 10 UOMs, it is simpler to just
318: -- find all intra-class standard rates to the reporting UOMs.
319: --

Line 318: -- find all intra-class standard rates to the reporting UOMs.

314: -- 2. If the conversion of any other rate to the base UOM has changed,
315: -- then only that intra class standard rate has changed.
316: -- However, given that there are only a few reporting UOMs, and that
317: -- every class has about 8 to 10 UOMs, it is simpler to just
318: -- find all intra-class standard rates to the reporting UOMs.
319: --
320: -- In case there are multiple measures tied to the same reporting UOM,
321: -- we need to pick distinct reporting UOMs, irrespective of the measures.
322: INSERT /*+ append */

Line 370: Compute the standard inter-class conversion rates.

366:
367:
368: /* compute_std_inter_class_conv
369:
370: Compute the standard inter-class conversion rates.
371:
372: Rates will be computed for all UOMs belonging to the
373: class(es) whose base UOM(s) have a defined conversion to the
374: base UOM(s) of the class(es) of the reporting UOM(s).

Line 418: -- find all inter-class standard rates to the reporting UOMs.

414: -- and the target UOM.
415: --
416: -- However, given that there are only a few reporting UOMs, and that
417: -- every class has about 8 to 10 UOMs, it is simpler to just
418: -- find all inter-class standard rates to the reporting UOMs.
419: --
420: -- In case there are multiple measures tied to the same reporting UOM,
421: -- we need to pick distinct reporting UOMs, irrespective of the measures.
422: INSERT /*+ append */

Line 637: Insert the new standard conversion rates found from the

633: END setup_tables_init;
634:
635: /* insert_std_rates_init
636:
637: Insert the new standard conversion rates found from the
638: staging table to the fact table.
639:
640: No commits done here. Calling function coordinates commit.
641:

Line 669: -- Insert all standard rates where from UOM/reporting UOM combination

665:
666: -- Initialization block
667: l_stmt_id := 0;
668:
669: -- Insert all standard rates where from UOM/reporting UOM combination
670: -- is not in in the fact table.
671: -- Standard rates have an item id of 0;
672: INSERT /*+ append */
673: INTO opi_dbi_rep_uom_std_conv_f (

Line 671: -- Standard rates have an item id of 0;

667: l_stmt_id := 0;
668:
669: -- Insert all standard rates where from UOM/reporting UOM combination
670: -- is not in in the fact table.
671: -- Standard rates have an item id of 0;
672: INSERT /*+ append */
673: INTO opi_dbi_rep_uom_std_conv_f (
674: from_uom_code,
675: from_uom_class,

Line 726: Wrapper routine for the initial load of the standard conversion

722:
723:
724: /* populate_rep_uom_std_conv_init
725:
726: Wrapper routine for the initial load of the standard conversion
727: rates program.
728:
729: Parameters:
730: errbuf - error message on unsuccessful termination

Line 767: -- Compute all intra-class standard conversion rates and put them

763: setup_tables_init ();
764: print_stage_done_mesg (l_proc_name, l_stmt_id);
765:
766: l_stmt_id := 40;
767: -- Compute all intra-class standard conversion rates and put them
768: -- in the staging table.
769: compute_std_intra_class_conv ();
770: print_stage_done_mesg (l_proc_name, l_stmt_id);
771:

Line 778: -- Compute all inter-class standard conversion rates and put them

774: commit;
775: print_stage_done_mesg (l_proc_name, l_stmt_id);
776:
777: l_stmt_id := 60;
778: -- Compute all inter-class standard conversion rates and put them
779: -- in the staging table.
780: compute_std_inter_class_conv ();
781: print_stage_done_mesg (l_proc_name, l_stmt_id);
782:

Line 1110: Wrapper routine for the incremental load of the standard conversion

1106:
1107:
1108: /* populate_rep_uom_std_conv_incr
1109:
1110: Wrapper routine for the incremental load of the standard conversion
1111: rates program.
1112:
1113: Parameters:
1114: errbuf - error message on unsuccessful termination

Line 1149: -- Compute all intra-class standard conversion rates and put them

1145: setup_tables_incr ();
1146: print_stage_done_mesg (l_proc_name, l_stmt_id);
1147:
1148: l_stmt_id := 40;
1149: -- Compute all intra-class standard conversion rates and put them
1150: -- in the staging table.
1151: compute_std_intra_class_conv ();
1152: print_stage_done_mesg (l_proc_name, l_stmt_id);
1153:

Line 1160: -- Compute all inter-class standard conversion rates and put them

1156: commit;
1157: print_stage_done_mesg (l_proc_name, l_stmt_id);
1158:
1159: l_stmt_id := 60;
1160: -- Compute all inter-class standard conversion rates and put them
1161: -- in the staging table.
1162: compute_std_inter_class_conv ();
1163: print_stage_done_mesg (l_proc_name, l_stmt_id);
1164: