1 PACKAGE WIP_ATO_JOBS_PRIV AS
2 /* $Header: wipvfass.pls 120.0 2005/07/04 21:46 amgarg noship $ */
3 /*========================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +=========================================================================+
7 | |
8 | File Name : WIPVFASS.PLS |
9 | |
10 | DESCRIPTION : Package Specification for Autocreate FAS. |
11 | |
12 | Coders : Amit Garg |
13 | |
14 | PURPOSE: Create Discrete Jobs to satisfy sales order demand for |
15 | replenish-to-order items that meet the user-input criteria|
16 | |
17 | |
18 | |
19 | PROGRAM SYNOPSIS: |
20 | 1. Update records in mtl_demand that meet criteria with a group_id |
21 | 2. Insert records into wip_entities_interface for mtl_demands records |
22 | marked with group_id |
23 | 3. Read wip_entities_interface records and inform OE of sales order |
24 | lines that have been linked to WIP |
25 | 4. Call mass load routine to create jobs from wip_entities_interface |
26 | records |
27 | 5. Do feedback: |
28 | 1. Update mtl_demand for jobs successfully loaded |
29 | 2. Create records in wip_so_allocations |
30 | 3. Read wip_entities_interface and inform OE of sales order |
31 | lines that should be unlinked from WIP |
32 | 4. Update mtl_demand for jobs that failed load so they can be |
33 | picked up again |
34 | 6. Launch report of what occurred in process |
35 | 7. Delete records from interface table |
36 | |
37 | CALLED BY: Concurrent Program |
38 | |
39 | |
40 | HISTORY: |
41 +=========================================================================*/
42
43 --Global Constants
44
45
46 /*-----------------------------------------------------------+
47 | Defines for linking or unlinking OE order to WIP |
48 +-----------------------------------------------------------+*/
49 WILINK CONSTANT NUMBER := 1;
50 WIUNLINK CONSTANT NUMBER := 2;
51
52 WPENDING CONSTANT NUMBER := 1;
53 WRUNNING CONSTANT NUMBER := 2;
54 WERROR CONSTANT NUMBER := 3;
55 WCOMPLETED CONSTANT NUMBER := 4;
56 WWARNING CONSTANT NUMBER := 5;
57
58 WIP_ML_VALIDATION CONSTANT NUMBER := 2;
59 WIP_ML_EXPLOSION CONSTANT NUMBER := 3;
60 WIP_ML_INSERTION CONSTANT NUMBER := 5;
61 WIP_ML_COMPLETE CONSTANT NUMBER := 4;
62
63
64
65 PROCEDURE CREATE_JOBS(
66 ERRBUF OUT NOCOPY VARCHAR2 ,
67 RETCODE OUT NOCOPY VARCHAR2,
68 P_ORDER_NUMBER IN VARCHAR2 ,
69 P_DUMMY_FIELD IN VARCHAR2 ,
70 P_OFFSET_DAYS IN VARCHAR2 ,
71 P_LOAD_TYPE IN VARCHAR2 , --CHANGED
72 P_STATUS_TYPE IN VARCHAR2 , --CHANGED
73 P_ORG_ID IN VARCHAR2 , --CHANGED
74 P_CLASS_CODE IN VARCHAR2 , --CHANGED
75 P_FAILED_REQ_ID IN VARCHAR2 ,
76 P_ORDER_LINE_ID IN VARCHAR2 ,
77 P_BATCH_ID IN VARCHAR2);
78
79
80 FUNCTION LOAD_ORDERS
81 (
82 ERRBUF OUT NOCOPY VARCHAR2,
83 RETCODE OUT NOCOPY VARCHAR2,
84 P_ORDER_NUMBER IN NUMBER DEFAULT -1,
85 p_DUMMY_FIELD IN NUMBER DEFAULT -1,
86 p_OFFSET_DAYS IN NUMBER DEFAULT -1,
87 p_LOAD_TYPE IN NUMBER DEFAULT -1,
88 p_STATUS_TYPE IN NUMBER DEFAULT -1,
89 p_ORG_ID IN NUMBER DEFAULT -1,
90 p_CLASS_CODE IN VARCHAR2 DEFAULT -1,
91 p_FAILED_REQ_ID IN NUMBER DEFAULT -1,
92 p_ORDER_LINE_ID IN NUMBER DEFAULT -1,
93 p_BATCH_ID IN NUMBER DEFAULT -1,
94 p_all_success_ptr IN OUT NOCOPY NUMBER )
95
96 RETURN boolean;
97
98
99 Function delete_interface_orders(p_wei_group_id NUMBER)
100 return boolean ;
101
102
103 END WIP_ATO_JOBS_PRIV;
104