[Home] [Help]
PACKAGE: APPS.MSC_REL_WF
Source
1 PACKAGE msc_rel_wf AUTHID CURRENT_USER AS
2 /*$Header: MSCRLWFS.pls 120.3 2010/12/13 23:37:37 cnazarma 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,
60 p_plan_id NUMBER,
61 p_organization_id NUMBER ) RETURN date;
62
63
64 PROCEDURE reschedule_purchase_orders
65 ( arg_plan_id IN NUMBER
66 , arg_org_id IN NUMBER
67 , arg_instance IN NUMBER
68 , arg_owning_org IN NUMBER
69 , arg_owning_instance IN NUMBER
70 , arg_count OUT NOCOPY NUMBER
71 , arg_released_instance IN OUT NOCOPY NumTblTyp
72 , arg_po_res_id IN OUT NOCOPY NumTblTyp
73 , arg_po_res_count IN OUT NOCOPY NumTblTyp
74 , arg_po_pwb_count IN OUT NOCOPY NumTblTyp);
75
76 PROCEDURE release_sales_orders
77 ( arg_plan_id IN NUMBER
78 , arg_org_id IN NUMBER
79 , arg_instance IN NUMBER
80 , arg_owning_org IN NUMBER
81 , arg_owning_instance IN NUMBER
82 , arg_released_instance IN OUT NOCOPY NumTblTyp
83 , arg_so_rel_id IN OUT NOCOPY NumTblTyp
84 , arg_so_rel_count IN OUT NOCOPY NumTblTyp
85 , arg_so_pwb_count IN OUT NOCOPY NumTblTyp);
86
87 Function get_job_seq_from_source(p_instance_id number) RETURN number;
88
89 PROCEDURE validate_proj_in_source(
90 p_org_id NUMBER,
91 p_project_id NUMBER,
92 p_task_id NUMBER,
93 p_start_date DATE,
94 p_completion_date DATE,
95 p_instance_id NUMBER,
96 p_valid OUT NOCOPY VARCHAR2,
97 p_error OUT NOCOPY VARCHAR2) ;
98
99 FUNCTION is_pjm_valid(p_org_id NUMBER,
100 p_project_id NUMBER,
101 p_task_id NUMBER,
102 p_start_date DATE,
103 p_completion_date DATE,
104 p_instance_id NUMBER) RETURN NUMBER;
105
106 FUNCTION get_acc_class_from_source(p_org_id number, p_item_id number,
107 p_project_id number,p_instance_id number) RETURN varchar2;
108
109 Function is_source_db_up(p_instance_id number) RETURN boolean;
110
111 Procedure get_load_type(itemtype in varchar2,
112 itemkey in varchar2,
113 actid in number,
114 funcmode in varchar2,
115 resultout out NOCOPY varchar2 );
116
117 Procedure start_release_batch_wf(p_plan_id number,
118 p_org_id number,
119 p_instance_id number,
120 p_owning_org number,
121 p_owning_instance number,
122 p_dblink varchar2,
123 p_load_type number,
124 p_instance_code varchar2) ;
125
126 Procedure insert_temp_table(itemtype in varchar2,
127 itemkey in varchar2,
128 actid in number,
129 funcmode in varchar2,
130 resultout out NOCOPY varchar2 ) ;
131
132 Procedure start_source_program(itemtype in varchar2,
133 itemkey in varchar2,
134 actid in number,
135 funcmode in varchar2,
136 resultout out NOCOPY varchar2 );
137
138 Procedure get_supply_data(p_plan_id in number,
139 p_transaction_id in number,
140 p_query_id in number,
141 p_dblink in varchar2);
142
143 PROCEDURE init_db(p_user_name varchar2);
144
145 PROCEDURE get_profile_value(p_profile_name IN varchar2,
146 p_instance_id IN number,
147 p_calling_source IN varchar2 DEFAULT 'FORM',
148 p_profile_value OUT NOCOPY varchar2);
149
150 FUNCTION get_offset_date(p_calendar_code in varchar2,
151 p_inst_id in number,
152 p_lead_time in number,
153 p_date in date) return date;
154
155 PROCEDURE update_so_dates(p_plan_id number, p_demand_id number,
156 p_inst_id number, p_implement_date date,
157 p_ship_date out nocopy date,
158 p_arrival_date out nocopy date,
159 p_earliest_date out nocopy date);
160
161 PROCEDURE unrelease_so_set(p_plan_id number, p_demand_id number,
162 p_instance_id number);
163
164 FUNCTION verify_so_release(p_plan_id number, p_demand_id number,
165 p_inst_id number)
166 RETURN varchar2;
167 PROCEDURE so_release_workflow_program(p_batch_id in number,
168 p_instance_id in number,
169 p_planner in varchar2,
170 p_request_id out nocopy number);
171 PROCEDURE start_so_release_workflow(
172 errbuf OUT NOCOPY VARCHAR2
173 ,retcode OUT NOCOPY NUMBER,
174 p_batch_id number,
175 p_instance_id number);
176
177 FUNCTION verify_so_dates(p_old_schedule_date date,
178 p_request_date date,
179 p_new_schedule_date date) RETURN date;
180
181 FUNCTION date_offset(p_org_id number, p_instance_id number,
182 p_bucket_type number,
183 p_date date, p_offset_days number) return date;
184
185 END msc_rel_wf;