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