[Home] [Help]
PACKAGE: APPS.MSC_REL_WF
Source
1 PACKAGE msc_rel_wf AS
2 /*$Header: MSCRLWFS.pls 120.2 2007/10/02 02:11:31 eychen ship $ */
3
4 TYPE NumTblTyp IS TABLE OF NUMBER;
5 WIP_DIS_MASS_LOAD CONSTANT INTEGER := 1;
6 WIP_REP_MASS_LOAD CONSTANT INTEGER := 2;
7 WIP_DIS_MASS_RESCHEDULE CONSTANT INTEGER := 4;
8
9 LOT_BASED_JOB_LOAD CONSTANT INTEGER := 5;
10 LOT_BASED_JOB_RESCHEDULE CONSTANT INTEGER := 6;
11
12 PURCHASE_REQ_MASS_LOAD CONSTANT INTEGER := 8;
13 PURCHASE_REQ_RESCHEDULE CONSTANT INTEGER := 16;
14 PURCHASE_ORDER_RESCHEDULE CONSTANT INTEGER := 20;
15 EAM_DIS_MASS_RESCHEDULE CONSTANT INTEGER := 21;
16 PURCHASE_ORDER CONSTANT INTEGER := 1; -- order type lookup
17 PURCHASE_REQ CONSTANT INTEGER := 2;
18 WORK_ORDER CONSTANT INTEGER := 3;
19
20 PROCEDURE release_supplies
21 (
22 errbuf OUT NOCOPY VARCHAR2
23 ,retcode OUT NOCOPY NUMBER
24 , arg_plan_id IN NUMBER
25 , arg_org_id IN NUMBER
26 , arg_instance IN NUMBER
27 , arg_owning_org_id IN NUMBER
28 , arg_owning_instance IN NUMBER);
29
30 PROCEDURE DeleteActivities( p_item_key varchar2,
31 p_dblink varchar2 default null);
32
33 PROCEDURE Select_buyer_supplier( itemtype in varchar2,
34 itemkey in varchar2,
35 actid in number,
36 funcmode in varchar2,
37 resultout out NOCOPY varchar2 );
38 Procedure start_reschedule_po_wf(p_plan_id number,
39 p_transaction_id number,
40 p_instance_id number,
41 p_load_type number);
42 Procedure notify_planner_program(p_plan_id number,
43 p_transaction_id number,
44 p_planner varchar2,
45 p_process varchar2);
46 Procedure notify_planner_decline(
47 errbuf OUT NOCOPY VARCHAR2,
48 retcode OUT NOCOPY NUMBER,
49 p_plan_id number,
50 p_transaction_id number,
51 p_planner varchar2,
52 p_process varchar2);
53 Procedure reset_load_type (p_plan_id number, p_transaction_id number);
54
55 FUNCTION GET_DOCK_DATE (p_instance_id NUMBER,
56 p_receiving_calendar VARCHAR2,
57 p_delivery_calendar VARCHAR2,
58 p_implement_date DATE,
59 p_lead_time NUMBER ) RETURN date;
60
61 PROCEDURE reschedule_purchase_orders
62 ( arg_plan_id IN NUMBER
63 , arg_org_id IN NUMBER
64 , arg_instance IN NUMBER
65 , arg_owning_org IN NUMBER
66 , arg_owning_instance IN NUMBER
67 , arg_count OUT NOCOPY NUMBER
68 , arg_released_instance IN OUT NOCOPY NumTblTyp
69 , arg_po_res_id IN OUT NOCOPY NumTblTyp
70 , arg_po_res_count IN OUT NOCOPY NumTblTyp
71 , arg_po_pwb_count IN OUT NOCOPY NumTblTyp);
72
73 PROCEDURE release_sales_orders
74 ( arg_plan_id IN NUMBER
75 , arg_org_id IN NUMBER
76 , arg_instance IN NUMBER
77 , arg_owning_org IN NUMBER
78 , arg_owning_instance IN NUMBER
79 , arg_released_instance IN OUT NOCOPY NumTblTyp
80 , arg_so_rel_id IN OUT NOCOPY NumTblTyp
81 , arg_so_rel_count IN OUT NOCOPY NumTblTyp
82 , arg_so_pwb_count IN OUT NOCOPY NumTblTyp);
83
84 Function get_job_seq_from_source(p_instance_id number) RETURN number;
85
86 PROCEDURE validate_proj_in_source(
87 p_org_id NUMBER,
88 p_project_id NUMBER,
89 p_task_id NUMBER,
90 p_start_date DATE,
91 p_completion_date DATE,
92 p_instance_id NUMBER,
93 p_valid OUT NOCOPY VARCHAR2,
94 p_error OUT NOCOPY VARCHAR2) ;
95
96 FUNCTION is_pjm_valid(p_org_id NUMBER,
97 p_project_id NUMBER,
98 p_task_id NUMBER,
99 p_start_date DATE,
100 p_completion_date DATE,
101 p_instance_id NUMBER) RETURN NUMBER;
102
103 FUNCTION get_acc_class_from_source(p_org_id number, p_item_id number,
104 p_project_id number,p_instance_id number) RETURN varchar2;
105
106 Function is_source_db_up(p_instance_id number) RETURN boolean;
107
108 Procedure get_load_type(itemtype in varchar2,
109 itemkey in varchar2,
110 actid in number,
111 funcmode in varchar2,
112 resultout out NOCOPY varchar2 );
113
114 Procedure start_release_batch_wf(p_plan_id number,
115 p_org_id number,
116 p_instance_id number,
117 p_owning_org number,
118 p_owning_instance number,
119 p_dblink varchar2,
120 p_load_type number,
121 p_instance_code varchar2) ;
122
123 Procedure insert_temp_table(itemtype in varchar2,
124 itemkey in varchar2,
125 actid in number,
126 funcmode in varchar2,
127 resultout out NOCOPY varchar2 ) ;
128
129 Procedure start_source_program(itemtype in varchar2,
130 itemkey in varchar2,
131 actid in number,
132 funcmode in varchar2,
133 resultout out NOCOPY varchar2 );
134
135 Procedure get_supply_data(p_plan_id in number,
136 p_transaction_id in number,
137 p_query_id in number,
138 p_dblink in varchar2);
139
140 PROCEDURE init_db(p_user_name varchar2);
141
142 PROCEDURE get_profile_value(p_profile_name IN varchar2,
143 p_instance_id IN number,
144 p_calling_source IN varchar2 DEFAULT 'FORM',
145 p_profile_value OUT NOCOPY varchar2);
146
147 FUNCTION get_offset_date(p_calendar_code in varchar2,
148 p_inst_id in number,
149 p_lead_time in number,
150 p_date in date) return date;
151
152 PROCEDURE update_so_dates(p_plan_id number, p_demand_id number,
153 p_inst_id number, p_implement_date date,
154 p_ship_date out nocopy date,
155 p_arrival_date out nocopy date,
156 p_earliest_date out nocopy date);
157
158 PROCEDURE unrelease_so_set(p_plan_id number, p_demand_id number,
159 p_instance_id number);
160
161 FUNCTION verify_so_release(p_plan_id number, p_demand_id number,
162 p_inst_id number)
163 RETURN varchar2;
164 PROCEDURE so_release_workflow_program(p_batch_id in number,
165 p_instance_id in number,
166 p_planner in varchar2,
167 p_request_id out nocopy number);
168 PROCEDURE start_so_release_workflow(
169 errbuf OUT NOCOPY VARCHAR2
170 ,retcode OUT NOCOPY NUMBER,
171 p_batch_id number,
172 p_instance_id number);
173
174 FUNCTION verify_so_dates(p_old_schedule_date date,
175 p_request_date date,
176 p_new_schedule_date date) RETURN date;
177
178 FUNCTION date_offset(p_org_id number, p_instance_id number,
179 p_bucket_type number,
180 p_date date, p_offset_days number) return date;
181
182 END msc_rel_wf;