1 package CTO_WIP_WRAPPER AUTHID CURRENT_USER as
2 /* $Header: CTOWIPWS.pls 120.0.12020000.2 2012/10/04 11:11:42 abhissri ship $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8 | |
9 | FILE NAME : CTOWIPWB.pls |
10 | |
11 | DESCRIPTION: |
12 | This file creates the utilities that are required to create |
13 | work orders for ATO configurations. |
14 | |
15 | insert_wip_interface - inserts a record into |
16 | WIP_JOB_SCHEDULE_INTERFACE for |
17 | WIP_MASS_LOAD to create work orders |
18 | |
19 | To Do: Handle Errors. Need to discuss with Usha and Girish what |
20 | error information to include in Notification. |
21 | |
22 | HISTORY : |
23 | August 14, 99 Angela Makalintal Initial version |
24 =============================================================================*/
25
26 /*****************************************************************************
27 Procedure: insert_wip_interface
28 Parameters: p_model_line_id - line id of the configuration item in
29 oe_order_lines
30 p_wip_seq - group id to be used in interface table
31 x_error_message - error message if insert fails
32 x_message_name - name of error message if insert
33 fails
34
35 Description: This function inserts a record into the
36 WIP_JOB_SCHEDULE_INTERFACE table for the creation of
37 work orders.
38
39 *****************************************************************************/
40 FUNCTION get_order_lines(p_org_id IN NUMBER,
41 p_offset_days IN NUMBER,
42 p_load_type IN NUMBER, -- config, non-config, both
43 p_class_code IN varchar2, -- for job creation
44 p_status_type IN NUMBER, -- for job creation
45 p_order_number IN NUMBER,
46 p_line_id IN NUMBER,
47 p_conc_request_id IN NUMBER,
48 p_conc_program_id IN NUMBER,
49 p_conc_login_id IN NUMBER,
50 p_user_id IN NUMBER,
51 p_appl_conc_program_id IN NUMBER,
52 --Flow ER 14595064
53 p_create_flow_schedule IN NUMBER DEFAULT 2,
54 x_orders_loaded OUT NoCopy NUMBER,
55 x_wip_seq OUT NoCopy NUMBER,
56 x_message_name OUT NoCopy VARCHAR2,
57 x_message_text OUT NoCopy VARCHAR2
58 )
59 RETURN integer;
60
61 FUNCTION reserve_wo_to_so(p_wip_seq IN NUMBER,
62 p_message_text VARCHAR2,
63 p_message_name VARCHAR2
64 )
65
66 RETURN integer;
67
68 FUNCTION Get_Reserved_Qty(pLineId IN NUMBER)
69 RETURN number;
70
71 --
72 -- begin bugfix 2095043 :
73 -- Added function Get_NotInv_Qty to find out how much has been NOT
74 -- been inventory-interfaced.
75 --
76
77 FUNCTION Get_NotInv_Qty(pLineId IN NUMBER)
78 RETURN number;
79
80 -- end bugfix 2095043
81
82 end CTO_WIP_WRAPPER;