1 PACKAGE POS_UPDATE_CAPACITY_PKG AUTHID CURRENT_USER as
2 /* $Header: POSUPDNS.pls 115.3 2004/01/23 00:46:15 hvadlamu ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: pos_isp_updmodifiers
6
7
8 DESCRIPTION: Contains the server side APIs: high-level record types,
9 cursors and record type variables.
10
11 CLIENT/SERVER: Server
12
13 LIBRARY NAME NONE
14
15 OWNER: HKUMMATI
16
17 PROCEDURES/FUNCTIONS:
18
19 ============================================================================*/
20 /*===========================================================================
21 PROCEDURE NAME: updatemodifiers()
22
23
24 PARAMETERS:
25
26 DESIGN REFERENCES:
27
28 ALGORITHM:
29
30 NOTES:
31
32 OPEN ISSUES:
33
34 CLOSED ISSUES:
35
36 CHANGE HISTORY: HKUMMATI 09/21/2000 Created
37 ===========================================================================*/
38
39 PROCEDURE INSERT_TEMP_MFG_CAPACITY(
40 p_asl_id IN NUMBER,
41 p_from_date IN DATE,
42 p_to_date IN DATE,
43 p_capacity_per_day IN NUMBER,
44 p_created_by in number,
45 p_capacity_id in number,
46 p_status in varchar2,
47 /*
48 p_supplier_item_number in varchar2,
49 p_item_number in varchar2,
50 p_item_description in varchar2,
51 p_uom in varchar2,
52 p_vendor_id in number,
53 p_vendor_name in varchar2,
54 */
55 p_error_code OUT NOCOPY VARCHAR2,
56 p_error_message OUT NOCOPY VARCHAR2);
57
58 PROCEDURE INSERT_TEMP_CAPACITY_TOLERANCE(
59 p_asl_id IN NUMBER,
60 p_days_in_advance IN NUMBER,
61 p_tolerance IN NUMBER,
62 p_created_by in number,
63 /*
64 p_supplier_item_number in varchar2,
65 p_item_number in varchar2,
66 p_item_description in varchar2,
67 p_uom in varchar2,
68 p_vendor_id in number,
69 p_vendor_name in varchar2,
70 */
71 p_error_code OUT NOCOPY VARCHAR2,
72 p_error_message OUT NOCOPY VARCHAR2);
73
74 PROCEDURE UPDATE_EXIST(p_asl_id in NUMBER,
75 p_return_code out NOCOPY NUMBER);
76
77 PROCEDURE StartWorkflow(p_asl_id in NUMBER);
78
79 procedure INIT_ATTRIBUTES( itemtype in varchar2,
80 itemkey in varchar2,
81 actid in number,
82 funcmode in varchar2,
83 resultout out NOCOPY varchar2 );
84
85 procedure GET_BUYER_NAME( itemtype in varchar2,
86 itemkey in varchar2,
87 actid in number,
88 funcmode in varchar2,
89 resultout out NOCOPY varchar2 );
90 procedure GET_PLANNER_NAME( itemtype in varchar2,
91 itemkey in varchar2,
92 actid in number,
93 funcmode in varchar2,
94 resultout out NOCOPY varchar2 );
95 procedure BUYER_APPROVAL_REQUIRED( itemtype in varchar2,
96 itemkey in varchar2,
97 actid in number,
98 funcmode in varchar2,
99 resultout out NOCOPY varchar2 );
100 procedure BUYER_EXIST( itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 resultout out NOCOPY varchar2 );
105 procedure PLANNER_APPROVAL_REQUIRED( itemtype in varchar2,
106 itemkey in varchar2,
107 actid in number,
108 funcmode in varchar2,
109 resultout out NOCOPY varchar2 );
110 procedure PLANNER_EXIST( itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funcmode in varchar2,
114 resultout out NOCOPY varchar2 );
115 procedure UPDATE_ASL( itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 resultout out NOCOPY varchar2 );
120 procedure DEFAULT_APPROVAL_MODE( itemtype in varchar2,
121 itemkey in varchar2,
122 actid in number,
123 funcmode in varchar2,
124 resultout out NOCOPY varchar2 );
125 procedure UPDATE_STATUS( itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 funcmode in varchar2,
129 resultout out NOCOPY varchar2 );
130 procedure BUYER_SAME_AS_PLANNER( itemtype in varchar2,
131 itemkey in varchar2,
132 actid in number,
133 funcmode in varchar2,
134 resultout out NOCOPY varchar2 );
135
136 PROCEDURE GENERATE_CAP_APP_NOTIF(document_id in varchar2,
137 display_type in varchar2,
138 document in OUT NOCOPY varchar2,
139 document_type in OUT NOCOPY varchar2);
140
141 PROCEDURE GENERATE_HEADER(document in out nocopy varchar2,
142 itemtype in varchar2,
143 itemkey in varchar2);
144
145 PROCEDURE GENERATE_SUPPL_CAP_NOTIF_APPR(document_id in varchar2,
146 display_type in varchar2,
147 document in OUT NOCOPY varchar2,
148 document_type in OUT NOCOPY varchar2);
149
150 PROCEDURE GENERATE_SUPPL_CAP_NOTIF_REJ(document_id in varchar2,
151 display_type in varchar2,
152 document in OUT NOCOPY varchar2,
153 document_type in OUT NOCOPY varchar2);
154
155 END POS_UPDATE_CAPACITY_PKG;
156