[Home] [Help]
PACKAGE: APPS.MSC_DRP_UTIL
Source
1 PACKAGE MSC_DRP_UTIL AUTHID CURRENT_USER AS
2 /* $Header: MSCDRPUS.pls 120.9.12020000.2 2012/09/04 16:39:22 eychen ship $ */
3
4 TYPE numberArr IS TABLE OF number INDEX BY BINARY_INTEGER;
5
6 FUNCTION order_type_text(arg_lookup_type IN varchar2,
7 arg_lookup_code IN NUMBER,
8 arg_org_id IN NUMBER,
9 arg_source_org IN NUMBER,
10 arg_demand_source_type IN NUMBER default null) return varchar2;
11
12 FUNCTION cost_under_util(p_plan_id number,
13 p_weight_cap number, p_volume_cap number,
14 p_weight number, p_volume number,
15 p_from_org_id number, p_from_inst_id number,
16 p_to_org_id number, p_to_inst_id number,
17 p_ship_method varchar2) RETURN number;
18
19 FUNCTION material_avail_date(p_plan_id number, p_supply_id number)
20 RETURN date ;
21
22 PROCEDURE offset_date(p_anchor_date in varchar2,
23 p_plan_id in number,
24 p_from_org in number, p_to_org in number,
25 p_inst_id in number,
26 p_ship_method in varchar2,
27 p_lead_time in out nocopy number,
28 p_ship_calendar in out nocopy varchar2,
29 p_deliver_calendar in out nocopy varchar2,
30 p_receive_calendar in out nocopy varchar2,
31 p_ship_date in out nocopy date,
32 p_dock_date in out nocopy date,
33 p_source_sr_instance_id in number default null);
34
35 PROCEDURE offset_dates(p_anchor_date in varchar2,
36 p_plan_id in number,
37 p_from_org in number, p_to_org in number,
38 p_inst_id in number,
39 p_item_id in number,
40 p_ship_method in varchar2,
41 p_lead_time in number,
42 p_ship_calendar in varchar2,
43 p_deliver_calendar in varchar2,
44 p_receive_calendar in varchar2,
45 p_ship_date in out nocopy date,
46 p_dock_date in out nocopy date,
47 p_due_date in out nocopy date,
48 p_source_sr_instance_id in number default null);
49
50 PROCEDURE IR_dates( p_plan_id in number,
51 p_inst_id in number,
52 p_transaction_id in number,
53 p_ship_date out nocopy date,
54 p_dock_date out nocopy date,
55 p_due_date out nocopy date);
56
57
58 FUNCTION wt_convert_ratio(p_item_id number, p_org_id number, p_inst_id number,
59 p_uom_code varchar2) return number;
60 FUNCTION vl_convert_ratio(p_item_id number, p_org_id number, p_inst_id number,
61 p_uom_code varchar2) return number;
62
63 FUNCTION sourcing_rule_name(p_plan_id number, p_item_id number,
64 p_from_org_id number, p_from_org_inst_id number,
65 p_to_org_id number, p_to_org_inst_id number,
66 p_rank number) return varchar2;
67
68 FUNCTION get_pref_key(p_plan_type number,
69 p_lookup_type varchar2, p_lookup_code number,
70 p_pref_tab varchar2) RETURN varchar2;
71
72
73 FUNCTION alloc_rule_name(p_rule_id number) return varchar2;
74
75 FUNCTION get_cal_violation(p_violated_calendars varchar2 )
76 return varchar2;
77
78 PROCEDURE update_supply_row(p_plan_id number,
79 p_transaction_id number,
80 p_shipment_id number,
81 p_firm_flag number,
82 p_ship_date date,
83 p_dock_date date,
84 p_ship_method varchar2,
85 p_lead_time number);
86
87 PROCEDURE mark_supply_undo(p_plan_id number);
88
89 FUNCTION notEqual(p_value number, p_value2 number) return boolean;
90 FUNCTION notEqual(p_value varchar2, p_value2 varchar2) return boolean;
91 FUNCTION notEqual(p_value date, p_value2 date) return boolean;
92 Function get_msg(p_product varchar2, p_name varchar2) RETURN varchar2;
93 FUNCTION get_iso_trip(p_plan_id number, p_instance_id number,
94 p_disposition_id number) return number;
95 FUNCTION forecast_name(p_plan_id number,p_instance_id number,p_org_id number,
96 p_schedule_designator_id number,p_forecast_set_id number)
97 RETURN varchar2;
98 FUNCTION get_iso_name(p_plan_id number, p_instance_id number,
99 p_transaction_id number) return varchar2;
100 FUNCTION get_work_day( p_next_or_prev IN varchar2,
101 p_calendar_code IN varchar2,
102 p_instance_id IN number,
103 p_calendar_date IN date) return date;
104
105 FUNCTION construct_list(p_id numberArr) RETURN varchar2;
106
107 FUNCTION related_excp(p_id numberArr,p_related_excp_type number,
108 p_plan_id number, p_org_id number,
109 p_inst_id number, p_item_id number,
110 p_start_date date, p_end_date date,
111 p_max_time number, p_min_time number,
112 p_lt_window number) RETURN numberArr;
113
114 FUNCTION rel_exp_where_clause(p_exc_type number,
115 p_plan_id number, p_org_id number,
116 p_inst_id number, p_item_id number,
117 p_source_org_id number, p_source_inst_id number,
118 p_supplier_id number, p_supply_id number,
119 p_demand_id number,
120 p_due_date date, p_dmd_satisfied_date date,
121 p_start_date date, p_end_date date) RETURN varchar2;
122
123 PROCEDURE update_exp_version(p_rowid rowid,
124 p_action_taken number);
125
126 PROCEDURE retrieve_exp_version(p_plan_id number);
127
128 END MSC_DRP_UTIL;