PACKAGE: APPS.MSD_COMMON_UTILITIES_LB

Source

1 PACKAGE MSD_COMMON_UTILITIES_LB AS
2 /* $Header: msdculbs.pls 120.0 2005/05/25 20:05:21 appldev noship $ */
3 
4 /* Common Table Definitions */
5 
6 
7 LEVEL_VALUES_FACT_TABLE   VARCHAR2(50) := 'MSD_LEVEL_VALUES_LB' ;
8 LEVEL_ASSOC_FACT_TABLE    VARCHAR2(50) := 'MSD_LEVEL_ASSOCIATIONS_LB' ;
9 ITEM_INFO_FACT_TABLE    VARCHAR2(50) := 'MSD_ITEM_LIST_PRICE' ;
10 LEVEL_VALUES_STAGING_TABLE  VARCHAR2(50) := 'MSD_ST_LEVEL_VALUES_LB' ;
11 LEVEL_ASSOC_STAGING_TABLE   VARCHAR2(50) := 'MSD_ST_LEVEL_ASSOCIATIONS_LB' ;
12 
13 
14 
15 /* Common Column Definitions ***/
16 LEVEL_VALUE_COLUMN		VARCHAR2(50) := 'LEVEL_VALUE' ;
17 LEVEL_VALUE_PK_COLUMN		VARCHAR2(50) := 'SR_LEVEL_PK' ;
18 LEVEL_VALUE_DESC_COLUMN         VARCHAR2(50) := 'LEVEL_VALUE_DESC' ;
19 PARENT_LEVEL_VALUE_COLUMN 	VARCHAR2(50) := 'PARENT_LEVEL_VALUE' ;
20 PARENT_LEVEL_VALUE_PK_COLUMN	VARCHAR2(50) := 'SR_PARENT_LEVEL_PK' ;
21 PARENT_LEVEL_VALUE_DESC_COLUMN  VARCHAR2(50) := 'PARENT_VALUE_DESC' ;
22 
23 
24 SHIPMENT_DATE_USED    VARCHAR2(50) := 'SHIPPED_DATE' ;
25 BOOKING_DATE_USED   VARCHAR2(50) := 'BOOKED_DATE' ;
26 CURRENCY_DATE_USED    VARCHAR2(50) := 'CONVERSION_DATE' ;
27 OPPORTUNITY_DATE_USED   VARCHAR2(50) := 'SHIP_DATE' ;
28 
29 /**** Calendar Types *** Same as MSD_CALENDAR_TYPE *********/
30 GREGORIAN_CALENDAR    NUMBER := 1 ;
31 MANUFACTURING_CALENDAR  NUMBER := 2 ;
32 
33 
34 
35 
36 FUNCTION get_level_pk( p_level_id IN NUMBER, p_sr_level_pk IN VARCHAR2) return number ;
37 
38 FUNCTION get_demand_plan_id( p_plan_id IN NUMBER) return NUMBER;
39 
40 FUNCTION get_item_cat_name( p_inventory_item_id IN NUMBER, p_category_set_id IN NUMBER ) return VARCHAR2 ;
41 
42 FUNCTION get_supply_plan_start_date( p_plan_id IN NUMBER) return DATE ;
43 
44 FUNCTION get_supply_plan_end_date( p_plan_id IN NUMBER) return DATE ;
45 
46 FUNCTION get_cp_end_date  return DATE ;
47 
48 FUNCTION get_plan_owning_org( p_plan_id IN NUMBER) return NUMBER ;
49 
50 FUNCTION get_plan_owning_instance( p_plan_id IN NUMBER) return NUMBER ;
51 
52 
53 FUNCTION get_supply_plan_name( p_plan_id IN NUMBER) return VARCHAR2 ;
54 
55 FUNCTION get_item_cat_desc( p_inventory_item_id IN NUMBER, p_category_set_id IN NUMBER ) RETURN VARCHAR2 ;
56 
57 FUNCTION get_supply_plan_id( p_demand_plan_id IN NUMBER) return NUMBER ;
58 
59 PROCEDURE liability_post_process( p_demand_plan_id IN NUMBER , p_scenario_name IN VARCHAR2,p_senario_rev_num IN NUMBER)  ;
60 
61 FUNCTION liability_plan_update( p_demand_plan_id IN NUMBER ) RETURN NUMBER ;
62 
63 FUNCTION get_default_mfg_cal ( p_org_id IN NUMBER , p_instance_id IN  NUMBER ) RETURN VARCHAR2 ;
64 
65 FUNCTION get_default_uom RETURN VARCHAR2 ;
66 
67 function get_liability_url(p_plan_id IN NUMBER ,  p_function_id IN VARCHAR2) RETURN VARCHAR2 ;
68 
69 function get_base_uom(p_item_id in number, p_dp_plan_id in number) return varchar2;
70 
71 
72 procedure liability_preprocessor(p_plan_id IN NUMBER )   ;
73 
74  function liability_plan_exists(p_plan_id IN NUMBER ) return boolean  ;
75 
76 
77 
78 END MSD_COMMON_UTILITIES_LB ;