1 PACKAGE Msc_GET_name AS
2 /* $Header: MSCGPRJS.pls 120.20.12010000.2 2008/09/04 11:08:22 skakani ship $ */
3
4 FUNCTION project(arg_project_id IN NUMBER,
5 arg_org_id IN NUMBER,
6 arg_plan_id IN NUMBER,
7 arg_instance_id IN NUMBER) return varchar2;
8
9 FUNCTION task(arg_task_id IN NUMBER,
10 arg_project_id IN NUMBER,
11 arg_org_id IN NUMBER,
12 arg_plan_id IN NUMBER,
13 arg_instance_id IN NUMBER) return varchar2;
14
15 FUNCTION resource_over_util_cost(arg_resource_id IN NUMBER,
16 arg_department_id IN NUMBER,
17 arg_org_id IN NUMBER,
18 arg_plan_id IN NUMBER,
19 arg_instance_id IN NUMBER) return number;
20
21 FUNCTION planning_group(arg_project_id IN NUMBER,
22 arg_org_id IN NUMBER,
23 arg_plan_id IN NUMBER,
24 arg_instance_id IN NUMBER) return varchar2;
25
26 FUNCTION demand_date (arg_pegging_id IN NUMBER,
27 arg_plan_id IN NUMBER) return DATE;
28
29 FUNCTION supply_date (arg_pegging_id IN NUMBER,
30 arg_plan_id IN NUMBER) return DATE;
31
32 FUNCTION org_code(arg_org_id IN NUMBER,
33 arg_instance_id IN NUMBER) return varchar2;
34 FUNCTION org_code(arg_org_inst_id IN varchar2) return varchar2; -- for SRP
35
36
37 FUNCTION location_code(arg_org_id IN NUMBER,
38 arg_location_id IN NUMBER,
39 arg_instance_id IN NUMBER) return VARCHAR2;
40
41
42 FUNCTION instance_code(arg_instance_id IN NUMBER) return varchar2;
43
44 FUNCTION lookup_meaning(arg_lookup_type IN varchar2,
45 arg_lookup_code IN NUMBER) return varchar2;
46
47 FUNCTION lookup_by_plan(arg_lookup_type IN varchar2,
48 arg_lookup_code IN NUMBER,
49 arg_plan_type IN NUMBER,
50 arg_source_org_id IN NUMBER DEFAULT null) return varchar2;
51
52 FUNCTION fnd_lookup_meaning(arg_lookup_type IN varchar2,
53 arg_lookup_code IN NUMBER) return varchar2;
54
55 FUNCTION supply_order(arg_demand_type IN NUMBER,
56 arg_disp_id IN NUMBER,
57 arg_org_id IN NUMBER,
58 arg_plan_id IN NUMBER,
59 arg_instance_id IN NUMBER,
60 arg_supply_type IN NUMBER DEFAULT NULL)
61 return varchar2;
62
63 FUNCTION order_type (arg_plan_id IN number,
64 arg_transaction_id IN NUMBER,
65 arg_instance_id IN NUMBER) RETURN number;
66
67 FUNCTION job_name (arg_transaction_id IN NUMBER,
68 arg_plan_id IN NUMBER,
69 arg_sr_instance_id IN NUMBER DEFAULT NULL)
70 return varchar2 ;
71
72
73 FUNCTION process_priority(arg_plan_id IN NUMBER,
74 arg_sr_instance_id IN NUMBER,
75 arg_organization_id IN NUMBER,
76 arg_inventory_item_id IN NUMBER,
77 arg_process_sequence_id IN NUMBER)
78 return NUMBER;
79
80 FUNCTION supply_type (arg_transaction_id IN NUMBER,
81 arg_plan_id IN NUMBER)
82 return varchar2;
83
84 FUNCTION from_org(arg_plan_id IN NUMBER,
85 arg_transaction_id IN NUMBER,
86 arg_instance_id IN NUMBER) return varchar2;
87
88 FUNCTION to_org(arg_plan_id IN NUMBER,
89 arg_transaction_id IN NUMBER,
90 arg_instance_id IN NUMBER) return varchar2;
91
92 FUNCTION from_org_id(arg_plan_id IN NUMBER,
93 arg_transaction_id IN NUMBER,
94 arg_instance_id IN NUMBER) return number;
95
96 FUNCTION to_org_id(arg_plan_id IN NUMBER,
97 arg_transaction_id IN NUMBER,
98 arg_instance_id IN NUMBER) return number;
99
100 FUNCTION ship_method(arg_plan_id IN NUMBER,
101 arg_transaction_id IN NUMBER,
102 arg_instance_id IN NUMBER) return varchar2;
103
104
105 FUNCTION item_desc(arg_item_id IN NUMBER,
106 arg_org_id IN NUMBER,
107 arg_plan_id IN NUMBER,
108 arg_instance_id IN NUMBER) return varchar2;
109
110 FUNCTION item_name(arg_item_id IN NUMBER,
111 arg_org_id IN NUMBER,
112 arg_plan_id IN NUMBER,
113 arg_instance_id IN NUMBER) return varchar2;
114
115 FUNCTION item_name(arg_item_id IN NUMBER) return varchar2; -- for SRP
116
117 FUNCTION resource_util_pct (arg_resource_id IN NUMBER,
118 arg_dept_id IN NUMBER,
119 arg_org_id IN NUMBER,
120 arg_plan_id IN NUMBER,
121 arg_instance_id IN NUMBER) return number;
122
123 FUNCTION department_code(arg_line_flag IN NUMBER,
124 arg_dept_id IN NUMBER,
125 arg_org_id IN NUMBER,
126 arg_plan_id IN NUMBER,
127 arg_instance_id IN NUMBER) return varchar2;
128
129 FUNCTION resource_code(arg_resource_id IN NUMBER,
130 arg_dept_id IN NUMBER,
131 arg_org_id IN NUMBER,
132 arg_plan_id IN NUMBER,
133 arg_instance_id IN NUMBER) return varchar2;
134
135 FUNCTION resource_type(arg_resource_id IN NUMBER,
136 arg_dept_id IN NUMBER,
137 arg_org_id IN NUMBER,
138 arg_plan_id IN NUMBER,
139 arg_instance_id IN NUMBER) return number;
140
141
142
143 FUNCTION department_resource_code(arg_resource_id IN NUMBER,
144 arg_dept_id IN NUMBER,
145 arg_org_id IN NUMBER,
146 arg_plan_id IN NUMBER,
147 arg_instance_id IN NUMBER) return varchar2;
148
149 FUNCTION supplier(arg_supplier_id IN NUMBER) return varchar2;
150
151 FUNCTION supplier_site(arg_supplier_site_id IN NUMBER) return varchar2;
152
153 FUNCTION customer(arg_customer_id IN NUMBER) return varchar2;
154
155 FUNCTION customer_site(arg_customer_site_id IN NUMBER) return varchar2;
156
157 FUNCTION customer_address(arg_customer_site_id IN NUMBER) return varchar2;
158
159 FUNCTION action(arg_source_table IN VARCHAR2,
160 arg_bom_item_type IN NUMBER DEFAULT NULL,
161 arg_base_item_id IN NUMBER DEFAULT NULL,
162 arg_wip_supply_type IN NUMBER DEFAULT NULL,
163 arg_order_type IN NUMBER DEFAULT NULL,
164 arg_rescheduled_flag IN NUMBER DEFAULT NULL,
165 arg_disposition_status_type IN NUMBER DEFAULT NULL,
166 arg_new_due_date IN DATE DEFAULT NULL,
167 arg_old_due_date IN DATE DEFAULT NULL,
168 arg_implemented_quantity IN NUMBER DEFAULT NULL,
169 arg_quantity_in_process IN NUMBER DEFAULT NULL,
170 arg_quantity_rate IN NUMBER DEFAULT NULL,
171 arg_release_time_fence_code IN NUMBER DEFAULT NULL,
172 arg_reschedule_days IN NUMBER DEFAULT NULL,
173 arg_firm_quantity IN NUMBER DEFAULT NULL,
174 arg_plan_id IN NUMBER DEFAULT NULL,
175 arg_critical_component IN NUMBER DEFAULT NULL,
176 arg_mrp_planning_code IN NUMBER DEFAULT NULL,
177 arg_lots_exist IN NUMBER DEFAULT NULL,
178 arg_part_condition IN NUMBER DEFAULT NULL) RETURN varchar2;
179
180 FUNCTION cfm_routing_flag(p_plan_id IN NUMBER,
181 p_org_id IN NUMBER,
182 p_instance_id IN NUMBER,
183 p_item_id IN NUMBER,
184 p_alt_rtg_desig IN VARCHAR2) return number;
185
186 FUNCTION alternate_bom(p_plan_id IN NUMBER,
187 p_instance_id IN NUMBER,
188 p_seq_id IN NUMBER) return varchar2;
189
190 FUNCTION alternate_rtg(p_plan_id IN NUMBER,
191 p_instance_id IN NUMBER,
192 p_seq_id IN NUMBER) return varchar2;
193
194 FUNCTION cfm_routing_flag(p_plan_id IN NUMBER,
195 p_instance_id IN NUMBER,
196 p_seq_id IN NUMBER) return number;
197
198 FUNCTION designator(p_desig_id IN NUMBER,
199 p_fcst_set_id IN NUMBER default NULL,
200 p_plan_id in NUMBER default NULL) return varchar2;
201
202 FUNCTION scenario_designator(p_desig_id IN NUMBER,
203 p_plan_id IN NUMBER,
204 p_organization_id IN NUMBER,
205 p_instance_id IN NUMBER) return varchar2;
206
207 FUNCTION forecastsetname(p_desig_id IN NUMBER,
208 p_plan_id IN NUMBER,
209 p_organization_id IN NUMBER,
210 p_instance_id IN NUMBER) return varchar2;
211
212 FUNCTION wip_status(p_transaction_id IN NUMBER) return number;
213
214 FUNCTION source_demand_priority(p_plan_id number,
215 p_demand_id NUMBER) return number;
216
217 FUNCTION resource_batchable_flag(arg_resource_id IN NUMBER,
218 arg_dept_id IN NUMBER,
219 arg_org_id IN NUMBER,
220 arg_plan_id IN NUMBER,
221 arg_instance_id IN NUMBER) return number;
222
223 FUNCTION resource_min_capacity(arg_resource_id IN NUMBER,
224 arg_dept_id IN NUMBER,
225 arg_org_id IN NUMBER,
226 arg_plan_id IN NUMBER,
227 arg_instance_id IN NUMBER) return number;
228
229 FUNCTION resource_max_capacity(arg_resource_id IN NUMBER,
230 arg_dept_id IN NUMBER,
231 arg_org_id IN NUMBER,
232 arg_plan_id IN NUMBER,
233 arg_instance_id IN NUMBER,
234 arg_supply_id IN NUMBER,
235 arg_batch_number IN NUMBER) return number;
236 FUNCTION BATCHABLE_UOM(p_organization_id in NUMBER,
237 p_department_id in NUMBER,
238 p_resource_id in NUMBER) return varchar2;
239
240 FUNCTION demand_quantity(p_plan_id number,
241 p_inst_id number,
242 p_demand_id NUMBER) return number;
243 FUNCTION demand_order_number (p_plan_id number,
244 p_inst_id number,
245 p_demand_id NUMBER) return varchar2;
246
247 FUNCTION ss_method_text (p_plan_id in number,
248 p_org_id in number, p_inst_id in number, p_item_id in number)
249 return varchar2 ;
250
251 -- This procedure executes dynamic sql because we cannot run
252 -- it on the client
253 PROCEDURE execute_dsql(arg_sql_stmt VARCHAR2);
254
255 FUNCTION Date_Timenum_to_DATE(dt dATE, time number) RETURN DATE;
256 PRAGMA RESTRICT_REFERENCES(Date_Timenum_to_DATE, WNDS, WNPS);
257
258 /* this function returns the julian date in floating point format */
259 FUNCTION DT_to_float(dt DATE) RETURN NUMBER;
260 PRAGMA RESTRICT_REFERENCES(DT_to_float, WNDS, WNPS);
261
262 /* this function takes a julian date in a floating point format and returns a date */
263 FUNCTION float_to_DT(fdt NUMBER) RETURN DATE;
264 PRAGMA RESTRICT_REFERENCES(float_to_DT, WNDS, WNPS);
265
266 /* FUNCTION sales_order(arg_demand_id IN NUMBER)
267 return varchar2;
268 */
269 PRAGMA RESTRICT_REFERENCES (project, WNDS,WNPS);
270 PRAGMA RESTRICT_REFERENCES (task, WNDS,WNPS);
271 PRAGMA RESTRICT_REFERENCES (planning_group, WNDS,WNPS);
272
273 PRAGMA RESTRICT_REFERENCES (supply_order, WNDS,WNPS);
274 -- PRAGMA RESTRICT_REFERENCES (sales_order, WNDS, WNPS);
275 FUNCTION plan_name(p_plan_id number) return varchar2;
276 -- new function to calculate the number of workdays between two dates
277 FUNCTION get_number_work_days(start_date date,
278 end_date date,
279 p_org_id number,
280 p_inst_id number) return number;
281 FUNCTION ABC_CLASS_ID (p_org_id number,
282 p_inst_id number) return number;
283
284 FUNCTION DEMAND_CLASS (p_inst_id number,
285 p_org_id number,
286 p_plan varchar2) return varchar2 ;
287
288 FUNCTION DMD_PRIORITY_RULE (p_rule_id number) return varchar2 ;
289
290 FUNCTION OP_SEQ_NUM (p_plan_id number,
291 p_inst_id number,
292 p_org_id number,
293 p_comp_seq_id number,
294 p_bill_seq_id number,
295 p_arg_1 number ) return varchar2 ;
296
297 FUNCTION demand_name (p_plan_id number, p_demand_id number)
298 return varchar2;
299 FUNCTION forward_backward_days(p_plan_id number,
300 p_schedule_desig_id number,
301 p_fb_type number)
302 return number ;
303
304 FUNCTION category_desc(arg_category_name IN VARCHAR2,
305 arg_category_set_id IN NUMBER,
306 arg_org_id IN NUMBER,
307 arg_instance_id IN NUMBER) return varchar2;
308
309 FUNCTION planner_code (arg_item_id IN NUMBER,
310 arg_org_id IN NUMBER,
311 arg_plan_id IN NUMBER,
312 arg_instance_id IN NUMBER) return varchar2;
313
314
315 FUNCTION MSCX_CUST_SHIP_DATE(arg_exception_id IN NUMBER) return date;
316 FUNCTION MSCX_UDE_PUB_ORDER_TYPE (arg_exception_id IN NUMBER) return number;
317 FUNCTION MSCX_PLANNER_CODE (arg_exception_id IN NUMBER) return varchar2;
318 FUNCTION MSCX_QUANTITY (arg_exception_id IN NUMBER) return number;
319 FUNCTION MSCX_COMP_RECEIPT_DATE (arg_exception_id IN NUMBER) return date;
320 FUNCTION MSCX_COMP_REQUEST_DATE (arg_exception_id IN NUMBER) return date;
321 FUNCTION cp_exception_type_text (arg_exception_type IN NUMBER) return varchar2;
322 FUNCTION resource_code_all(arg_resource_id IN NUMBER, arg_dept_id IN NUMBER,
323 arg_org_id IN NUMBER,arg_plan_id IN NUMBER,
324 arg_instance_id IN NUMBER,arg_resource_type in number) return varchar2;
325 FUNCTION resource_desc_all(arg_resource_id IN NUMBER, arg_dept_id IN NUMBER,
326 arg_org_id IN NUMBER,arg_plan_id IN NUMBER,
327 arg_instance_id IN NUMBER,arg_resource_type in number) return varchar2;
328
329 FUNCTION source_supplier(arg_sr_instance_id IN NUMBER,
330 arg_plan_id IN NUMBER,
331 arg_supplier_id IN NUMBER,
332 arg_source_supplier_id IN NUMBER,
333 arg_source_org_id IN NUMBER,
334 arg_order_type IN NUMBER) return varchar2;
335
336 FUNCTION source_supplier_site(arg_sr_instance_id IN NUMBER,
337 arg_plan_id IN NUMBER,
338 arg_supplier_site_id IN NUMBER,
339 arg_source_supplier_site_id IN NUMBER,
340 arg_source_org_id IN NUMBER,
341 arg_order_type IN NUMBER) return varchar2;
342
343 FUNCTION category_name(arg_category_id IN number,
344 arg_category_set_id IN NUMBER,
345 arg_org_id IN NUMBER default null,
346 arg_instance_id IN NUMBER default null) return varchar2;
347 FUNCTION BUDGET_NAME(arg_budget_id in number) return varchar2;
348
349 function drp_alloc_name(arg_rule_id number) return varchar2;
350 function drp_pri_rule_name(arg_rule_id number) return varchar2;
351
352 function get_category_id(p_category_name in varchar2,
353 p_org_id number,
354 p_inst_id number) return number;
355
356 function get_order_number(p_inst_id in number,
357 p_plan_id in number,
358 p_transaction_id in number,
359 p_coprod in number default 0) return varchar2;
360
361 function get_trans_mode(p_ship_method_code in varchar2,
362 p_instance_id in number ) return varchar2;
363 FUNCTION lookup_meaning1(arg_lookup_type IN varchar2,
364 arg_lookup_code IN varchar2,
365 arg_application_id in number,
366 arg_security_group_id in number) return varchar2;
367
368 function res_req_capacity(p_plan_id in number,
369 p_transaction_id in number) return number;
370 FUNCTION set_name(p_inst_id in number,
371 p_so_line_id in number,
372 p_set_type in number) return varchar2;
373 function get_bom_item_type(p_item_id in number) return number;
374
375 FUNCTION get_other_customers(p_plan_id number,
376 p_schedule_desig_id number) return varchar2 ;
377
378 FUNCTION get_days_on_arrival(p_plan_id number,
379 p_exception_id number,
380 p_exception_type number,
381 p_demand_id number,
382 p_schedule_by number,
383 p_late_early_flag number) return number;
384 function get_cat_id (p_inventory_item_id number,
385 p_organization_id number,
386 p_instance_id number) return number;
387
388 function get_cat_set_id (p_inventory_item_id number,
389 p_organization_id number,
390 p_instance_id number) return number;
391
392 FUNCTION resource_group_name(arg_resource_id IN NUMBER,
393 arg_dept_id IN NUMBER,
394 arg_org_id IN NUMBER,
395 arg_plan_id IN NUMBER,
396 arg_instance_id IN NUMBER) return varchar2;
397
398 FUNCTION new_schedule_date (arg_plan_id IN NUMBER,
399 arg_trx_id IN NUMBER) return DATE;
400
401 FUNCTION Get_Zone_Name(p_zone_id IN NUMBER,
402 p_sr_instance_id IN NUMBER )
403 return varchar2 ;
404
405 function alternate_bom_eff(p_process_seq_id number,
406 p_plan_id number,
407 p_sr_instance_id number) return varchar2;
408 function alternate_rtg_eff(p_process_seq_id number,
409 p_plan_id number,
410 p_sr_instance_id number) return varchar2;
411
412 function supply_order_number(p_order_type number,
413 p_order_number varchar2,
414 p_plan_id number ,
415 p_sr_instance_id number,
416 p_transaction_id number ,
417 p_disposition_id number ) return varchar2;
418
419 FUNCTION operation_code(p_plan_id IN NUMBER,
420 p_sr_instance_id IN NUMBER,
421 p_standard_operation_id IN NUMBER) return varchar2;
422
423 FUNCTION setup_code(p_plan_id IN NUMBER,
424 p_sr_instance_id IN NUMBER,
425 p_resource_id IN NUMBER,
426 p_organization_id IN NUMBER,
427 p_setup_id IN NUMBER
428 ) return varchar2;
429
430 function get_mfd_order_number(p_order_type in number,
431 p_order_number in varchar2,
432 p_transaction_id in number,
433 p_sr_instance_id in number,
434 p_plan_id in number,
435 p_disposition_id in number)
436 return varchar2;
437
438 function get_res_and_dept_details(p_plan_id in number,
439 p_sr_instance_id in number,
440 P_res_transaction_id in number,
441 P_column_name in varchar2)
442 return varchar2;
443
444 function get_mtq_details(p_plan_id in number,
445 p_sr_instance_id in number,
446 p_routing_seq_id in number,
447 p_operation_seq_id in number,
448 p_item_id in number,
449 p_cfm_routing_flag in number,
450 p_column_name in varchar2)
451 return number;
452
453 function eam_parent_work_order( p_plan_id number ,
454 p_sr_instance_id number,
455 p_transaction_id number
456 ) return number;
457
458 FUNCTION standard_operation_code(p_plan_id IN NUMBER,
459 p_sr_instance_id IN NUMBER,
460 p_resource_id IN NUMBER,
461 p_org_id IN NUMBER,
462 p_from_setup_id IN NUMBER,
463 p_to_setup_id IN NUMBER
464 ) return varchar2;
465
466 function get_op_seq_id(p_plan_id in number,
467 p_sr_instance_id in number,
468 p_routing_seq_id in number,
469 p_op_seq_num in number)
470 return number;
471
472 function get_mfd_details(p_plan_id number,
473 p_trans_id number,
474 p_inst_id number,
475 p_routing_seq_id number,
476 p_op_seq_id number,
477 p_item_id number,
478 c_trans_id number,
479 c_inst_id number,
480 c_op_seq_id number,
481 p_column_name varchar2)
482 return number;
483
484 function get_mtq_coprod_details(p_plan_id in number,
485 p_sr_instance_id in number,
486 p_routing_seq_id in number,
487 p_operation_seq_id in number,
488 p_item_id in number,
492 function get_supply_order_number(p_plan_id number,
489 p_column_name in varchar2)
490 return number;
491
493 p_inst_id number,
494 p_trans_id number)
495 return varchar2;
496
497 function get_supply_item(p_plan_id number,
498 p_inst_id number,
499 p_trans_id number)
500 return varchar2;
501
502 function get_supply_org_code(p_plan_id number,
503 p_inst_id number,
504 p_trans_id number)
505 return varchar2;
506
507 function get_min_max_offset_time(p_plan_id number,
508 p_inst_id number,
509 p_from_trans_id number,
510 p_to_trans_id number,
511 p_from_op_seq_num number,
512 p_to_op_seq_num number ,
513 p_from_res_seq_num number,
514 p_to_res_seq_num number ,
515 p_min_max_flag varchar2)
516 return number;
517
518 function get_load_ratio_diff_threshold(p_plan_id number,
519 p_sr_instance_id number,
520 p_organization_id number,
521 p_department_id number,
522 p_resource_id number)
523 return number;
524
525 function get_ship_to_consumption_level(p_demand_plan_id number,
526 p_scenario_id number
527 )
528 return number;
529 function GET_preference(p_key varchar2,
530 p_pref_id number,
531 p_plan_type number)
532 return varchar2;
533
534 FUNCTION lookup_fnd(arg_lookup_type IN varchar2, arg_lookup_code IN varchar2) return varchar2;
535 function get_default_pref_id(p_user_id number) return number;
536 FUNCTION get_std_op_code(p_plan_id number,
537 p_sr_instance_id number,
538 p_routing_sequence_id number,
539 p_op_seq_id number) return varchar2;
540
541 function res_instance_data(p_req_column IN varchar2,
542 p_plan_id IN number,
543 p_sr_instance_id IN number,
544 p_organization_id IN number,
545 p_department_id IN number,
546 p_resource_id IN Number,
547 p_supply_id IN Number,
548 p_operation_seq_num IN Number,
549 p_resource_seq_num IN Number,
550 p_orig_resource_seq_num IN Number,
551 p_parent_seq_num IN Number,
552 p_parent_Id IN Number) return varchar2;
553
554 FUNCTION get_processing_leadtime(p_plan_id number,
555 p_org number,
556 p_inst number,
557 p_item number,
558 p_supplier number,
559 p_supplier_site number) return number;
560
561
562 FUNCTION check_cfm(p_plan_id number,p_org_id number,
563 p_instance_id number, p_item_id number,
564 p_transaction_id number,
565 p_impl_alt_routing varchar2)
566 return number;
567
568 FUNCTION load_type ( p_plan_type IN NUMBER
569 , p_plan_id IN NUMBER
570 , p_source_table IN VARCHAR2 -- MSC_SUPPLIES or MSC_DEMANDS
571 , p_transaction_id IN NUMBER -- or demand_id
572 , p_organization_id IN NUMBER
573 , p_sr_instance_id IN NUMBER
574 , p_order_type IN NUMBER
575 , p_implement_as IN NUMBER
576 , p_source_organization_id IN NUMBER
577 , p_source_sr_instance_id IN NUMBER
578 , p_cfm_routing_flag IN NUMBER
579 , p_item_id IN NUMBER DEFAULT NULL
580 , p_impl_alt_routing IN VARCHAR2 DEFAULT NULL
581 ) RETURN NUMBER;
582
583 FUNCTION get_equipment_desc(arg_plan_id IN NUMBER,
584 arg_org_id IN NUMBER,
585 arg_instance_id IN NUMBER,
586 arg_item_id IN NUMBER) return varchar2;
587
588 function isResReqSegments_Available(p_plan_id in number,
589 p_sr_instance_id in number,
590 p_trans_id in number)
591 return number;
592
593 FUNCTION get_application_id(arg_application_name in varchar2) return number;
594
595 FUNCTION setup_std_op_code(
599 p_org_id IN NUMBER,
596 p_plan_id IN NUMBER,
597 p_sr_instance_id IN NUMBER,
598 p_department_id IN NUMBER,
600 p_supply_id IN Number,
601 p_operation_seq_num IN Number,
602 p_resource_seq_num IN number,
603 p_parent_seq_num IN Number,
604 p_setup_id IN Number,
605 p_schedule_flag IN Number
606 ) return varchar2;
607
608 FUNCTION is_within_rel_time_fence(p_plan_start_date IN DATE,
609 P_order_start_date IN DATE,
610 p_release_time_fence_code IN NUMBER,
611 P_cumulative_total_lead_time IN NUMBER,
612 P_cum_manufacturing_lead_time IN NUMBER,
613 P_full_lead_time IN NUMBER,
614 P_release_time_fence_days IN NUMBER
615 ) RETURN NUMBER;
616
617 -- This function executes dynamic sql and returns count.
618 function execute_sql_getcount(arg_sql_stmt VARCHAR2) return number;
619
620 FUNCTION implement_as(p_order_type number,
621 p_org_id number,
622 p_source_org_id number,
623 p_source_supplier_id number,
624 p_build_in_wip_flag number,
625 p_planning_make_buy_code number,
626 p_purchasing_enabled_flag number,
627 p_cfm_routing_flag number) RETURN number;
628
629 FUNCTION get_res_units(p_plan_id IN NUMBER,
630 p_sr_instance_id IN NUMBER,
631 p_org_id IN NUMBER,
632 p_department_id IN NUMBER,
633 p_resource_id IN NUMBER,
634 p_batch_start_date IN DATE,
635 p_batch_end_date IN DATE) RETURN number;
636
637 FUNCTION category_set_name(p_cat_set_id NUMBER) return varchar2;
638
639 FUNCTION get_default_dem_pri_rule_id return number;
640
641 FUNCTION get_default_dem_pri_rule return varchar2;
642
643 --5375991bugfix
644 function op_desc(p_plan_id number, p_sr_instance_id number,
645 p_routing_seq_id number, p_op_seq_id number) return varchar2;
646
647 FUNCTION get_order_view(p_plan_type number, p_plan_id number) return varchar2;
648
649 function get_srp_group_name(p_group_id number default null, p_user_id number default null, p_planned_by number default null) return varchar2;
650
651 function forecast_rule_name(p_forecast_rule_id number) return varchar2;
652
653 Function get_order_Comments(p_plan_id in number,
654 p_entity_type in varchar2,
655 p_transaction_id in number)
656 return varchar2;
657
658
659 end msc_get_name;