[Home] [Help]
PACKAGE: APPS.POS_ORDER_MODIFIERS_PKG
Source
1 PACKAGE POS_ORDER_MODIFIERS_PKG AUTHID CURRENT_USER as
2 /* $Header: POSORDNS.pls 115.3 2004/01/23 00:44:00 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_MODIFIERS(
40 p_asl_id IN NUMBER,
41 p_proc_lead_time IN NUMBER,
42 p_min_order_qty IN NUMBER,
43 p_fixed_lot_multiple IN NUMBER,
44 p_created_by in number,
45 p_error_code OUT NOCOPY VARCHAR2,
46 p_error_message OUT NOCOPY VARCHAR2);
47
48 PROCEDURE UPDATE_EXIST(p_asl_id in NUMBER,
49 p_return_code out NOCOPY number);
50
51 PROCEDURE StartWorkflow(p_asl_id in NUMBER);
52
53 PROCEDURE getInfo(p_asl_id in NUMBER,
54 p_item_num out NOCOPY varchar2,
55 p_supplier_item_num out NOCOPY varchar2,
56 p_approval_flag out NOCOPY varchar2,
57 p_buyer_name out NOCOPY varchar2,
58 p_planner_name out NOCOPY varchar2);
59
60 procedure INIT_ATTRIBUTES( itemtype in varchar2,
61 itemkey in varchar2,
62 actid in number,
63 funcmode in varchar2,
64 resultout out NOCOPY varchar2 );
65
66 procedure GET_BUYER_NAME( itemtype in varchar2,
67 itemkey in varchar2,
68 actid in number,
69 funcmode in varchar2,
70 resultout out NOCOPY varchar2 );
71 procedure GET_PLANNER_NAME( itemtype in varchar2,
72 itemkey in varchar2,
73 actid in number,
74 funcmode in varchar2,
75 resultout out NOCOPY varchar2 );
76 procedure BUYER_APPROVAL_REQUIRED( itemtype in varchar2,
77 itemkey in varchar2,
78 actid in number,
79 funcmode in varchar2,
80 resultout out NOCOPY varchar2 );
81 procedure BUYER_EXIST( itemtype in varchar2,
82 itemkey in varchar2,
83 actid in number,
84 funcmode in varchar2,
85 resultout out NOCOPY varchar2 );
86 procedure PLANNER_APPROVAL_REQUIRED( itemtype in varchar2,
87 itemkey in varchar2,
88 actid in number,
89 funcmode in varchar2,
90 resultout out NOCOPY varchar2 );
91 procedure PLANNER_EXIST( itemtype in varchar2,
92 itemkey in varchar2,
93 actid in number,
94 funcmode in varchar2,
95 resultout out NOCOPY varchar2 );
96 procedure UPDATE_ASL( itemtype in varchar2,
97 itemkey in varchar2,
98 actid in number,
99 funcmode in varchar2,
100 resultout out NOCOPY varchar2 );
101 procedure DEFAULT_APPROVAL_MODE( itemtype in varchar2,
102 itemkey in varchar2,
103 actid in number,
104 funcmode in varchar2,
105 resultout out NOCOPY varchar2 );
106 procedure UPDATE_STATUS( itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 resultout out NOCOPY varchar2 );
111
112 procedure BUYER_SAME_AS_PLANNER( itemtype in varchar2,
113 itemkey in varchar2,
114 actid in number,
115 funcmode in varchar2,
116 resultout out NOCOPY varchar2 );
117
118
119
120
121 PROCEDURE GENERATE_ORD_MOD_HEADER(document in OUT NOCOPY varchar2,
122 itemtype in varchar2,
123 itemkey in varchar2);
124
125 PROCEDURE GENERATE_APPR_NOTIF(document_id in varchar2,
126 display_type in varchar2,
127 document in OUT NOCOPY varchar2,
128 document_type in OUT NOCOPY varchar2);
129
130 PROCEDURE GENERATE_SUPPL_NOTIF_APPR(document_id in varchar2,
131 display_type in varchar2,
132 document in OUT NOCOPY varchar2,
133 document_type in OUT NOCOPY varchar2);
134
135 PROCEDURE GENERATE_SUPPL_NOTIF_REJ(document_id in varchar2,
136 display_type in varchar2,
137 document in OUT NOCOPY varchar2,
138 document_type in OUT NOCOPY varchar2);
139
140
141 END POS_ORDER_MODIFIERS_PKG;
142