[Home] [Help]
PACKAGE: APPS.MSC_DRP_UTIL
Source
1 PACKAGE MSC_DRP_UTIL AS
2 /* $Header: MSCDRPUS.pls 120.9 2007/05/29 21:32:43 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
34 PROCEDURE offset_dates(p_anchor_date in varchar2,
35 p_plan_id in number,
36 p_from_org in number, p_to_org in number,
37 p_inst_id in number,
38 p_item_id in number,
39 p_ship_method in varchar2,
40 p_lead_time in number,
41 p_ship_calendar in varchar2,
42 p_deliver_calendar in varchar2,
43 p_receive_calendar in varchar2,
44 p_ship_date in out nocopy date,
45 p_dock_date in out nocopy date,
46 p_due_date in out nocopy date);
47
48 PROCEDURE IR_dates( p_plan_id in number,
49 p_inst_id in number,
50 p_transaction_id in number,
51 p_ship_date out nocopy date,
52 p_dock_date out nocopy date,
53 p_due_date out nocopy date);
54
55
56 FUNCTION wt_convert_ratio(p_item_id number, p_org_id number, p_inst_id number,
57 p_uom_code varchar2) return number;
58 FUNCTION vl_convert_ratio(p_item_id number, p_org_id number, p_inst_id number,
59 p_uom_code varchar2) return number;
60
61 FUNCTION sourcing_rule_name(p_plan_id number, p_item_id number,
62 p_from_org_id number, p_from_org_inst_id number,
63 p_to_org_id number, p_to_org_inst_id number,
64 p_rank number) return varchar2;
65
66 FUNCTION get_pref_key(p_plan_type number,
67 p_lookup_type varchar2, p_lookup_code number,
68 p_pref_tab varchar2) RETURN varchar2;
69
70
71 FUNCTION alloc_rule_name(p_rule_id number) return varchar2;
72
73 FUNCTION get_cal_violation(p_violated_calendars varchar2 )
74 return varchar2;
75
76 PROCEDURE update_supply_row(p_plan_id number,
77 p_transaction_id number,
78 p_shipment_id number,
79 p_firm_flag number,
80 p_ship_date date,
81 p_dock_date date,
82 p_ship_method varchar2,
83 p_lead_time number);
84
85 PROCEDURE mark_supply_undo(p_plan_id number);
86
87 FUNCTION notEqual(p_value number, p_value2 number) return boolean;
88 FUNCTION notEqual(p_value varchar2, p_value2 varchar2) return boolean;
89 FUNCTION notEqual(p_value date, p_value2 date) return boolean;
90 Function get_msg(p_product varchar2, p_name varchar2) RETURN varchar2;
91 FUNCTION get_iso_trip(p_plan_id number, p_instance_id number,
92 p_disposition_id number) return number;
93 FUNCTION forecast_name(p_plan_id number,p_instance_id number,p_org_id number,
94 p_schedule_designator_id number,p_forecast_set_id number)
95 RETURN varchar2;
96 FUNCTION get_iso_name(p_plan_id number, p_instance_id number,
97 p_transaction_id number) return varchar2;
98 FUNCTION get_work_day( p_next_or_prev IN varchar2,
99 p_calendar_code IN varchar2,
100 p_instance_id IN number,
101 p_calendar_date IN date) return date;
102
103 FUNCTION construct_list(p_id numberArr) RETURN varchar2;
104
105 FUNCTION related_excp(p_id numberArr,p_related_excp_type number,
106 p_plan_id number, p_org_id number,
107 p_inst_id number, p_item_id number,
108 p_start_date date, p_end_date date,
109 p_max_time number, p_min_time number,
110 p_lt_window number) RETURN numberArr;
111
112 FUNCTION rel_exp_where_clause(p_exc_type number,
113 p_plan_id number, p_org_id number,
114 p_inst_id number, p_item_id number,
115 p_source_org_id number, p_source_inst_id number,
116 p_supplier_id number, p_supply_id number,
117 p_demand_id number,
118 p_due_date date, p_dmd_satisfied_date date,
119 p_start_date date, p_end_date date) RETURN varchar2;
120
121 PROCEDURE update_exp_version(p_rowid rowid,
122 p_action_taken number);
123
124 PROCEDURE retrieve_exp_version(p_plan_id number);
125
126 END MSC_DRP_UTIL;