1 package CTO_WIP_WRAPPER AUTHID CURRENT_USER as
2 /* $Header: CTOWIPWS.pls 115.8 2002/12/05 02:09:50 uarora 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 x_orders_loaded OUT NoCopy NUMBER,
53 x_wip_seq OUT NoCopy NUMBER,
54 x_message_name OUT NoCopy VARCHAR2,
55 x_message_text OUT NoCopy VARCHAR2
56 )
57 RETURN integer;
58
59 FUNCTION reserve_wo_to_so(p_wip_seq IN NUMBER,
60 p_message_text VARCHAR2,
61 p_message_name VARCHAR2
62 )
63
64 RETURN integer;
65
66 FUNCTION Get_Reserved_Qty(pLineId IN NUMBER)
67 RETURN number;
68
69 --
70 -- begin bugfix 2095043 :
71 -- Added function Get_NotInv_Qty to find out how much has been NOT
72 -- been inventory-interfaced.
73 --
74
75 FUNCTION Get_NotInv_Qty(pLineId IN NUMBER)
76 RETURN number;
77
78 -- end bugfix 2095043
79
80 end CTO_WIP_WRAPPER;