1 PACKAGE PO_UDA_DEFAULTING_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_UDA_DEFAULTING_PKG.pls 120.7 2010/04/15 10:27:27 ssreekum noship $ */
3
4 FUNCTION IS_VALID_AG_LIST
5 (
6 p_pk1_value IN NUMBER
7 ,p_pk2_value IN NUMBER
8 ,p_pk3_value IN NUMBER
9 ,p_pk4_value IN NUMBER
10 ,p_pk5_value IN NUMBER
11 ,p_template_id IN NUMBER
12 ,p_attr_grp_ids_list IN PO_TBL_NUMBER
13 )
14 RETURN BOOLEAN;
15
16 FUNCTION IS_VALID_AG
17 (
18 p_pk1_value IN NUMBER
19 ,p_pk2_value IN NUMBER
20 ,p_pk3_value IN NUMBER
21 ,p_pk4_value IN NUMBER
22 ,p_pk5_value IN NUMBER
23 ,p_template_id IN NUMBER
24 ,p_attr_grp_id IN NUMBER
25 )
26 RETURN BOOLEAN;
27
28 PROCEDURE CONSTRUCT_USAGE_OBJECT_ARRAY
29 (
30 p_pk1_value IN NUMBER
31 ,p_pk2_value IN NUMBER
32 ,p_pk3_value IN NUMBER
33 ,p_pk4_value IN NUMBER
34 ,p_pk5_value IN NUMBER
35 ,p_template_id IN NUMBER
36 ,x_po_uda_usage_object_array OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_errorcode OUT NOCOPY NUMBER
39 ,x_msg_count OUT NOCOPY NUMBER
40 ,x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE UDA_SUBMISSION_CHECK
44 (
45 p_pk1_value IN NUMBER
46 ,p_pk2_value IN NUMBER DEFAULT NULL
47 ,p_pk3_value IN NUMBER DEFAULT NULL
48 ,p_pk4_value IN NUMBER DEFAULT NULL
49 ,p_pk5_value IN NUMBER DEFAULT NULL
50 ,p_template_id IN NUMBER
51 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
52 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_errorcode OUT NOCOPY NUMBER
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE PO_UDA_SUBMISSION_CHECK
60 (
61 p_po_header_id IN NUMBER
62 ,p_draft_id IN NUMBER
63 ,x_external_attr_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 );
67
68 PROCEDURE DEFAULTING_NON_RENDERERED_AGS
69 (
70 p_po_header_id IN NUMBER
71 ,p_draft_id IN NUMBER
72 ,p_doc_type IN VARCHAR2 DEFAULT 'MOD'
73 ,x_external_attr_value_pairs OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
74 ,x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 PROCEDURE DEFAULTING_ATTRIBUTE_GROUPS
78 (
79 p_pk1_value IN NUMBER
80 ,p_pk2_value IN NUMBER DEFAULT NULL
81 ,p_pk3_value IN NUMBER DEFAULT NULL
82 ,p_pk4_value IN NUMBER DEFAULT NULL
83 ,p_pk5_value IN NUMBER DEFAULT NULL
84 ,p_template_id IN NUMBER
85 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
86 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_errorcode OUT NOCOPY NUMBER
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93 PROCEDURE DEFAULT_AGS_FROM_USAGE_OBJECT
94 (
95 p_pk1_value IN NUMBER
96 ,p_pk2_value IN NUMBER DEFAULT NULL
97 ,p_pk3_value IN NUMBER DEFAULT NULL
98 ,p_pk4_value IN NUMBER DEFAULT NULL
99 ,p_pk5_value IN NUMBER DEFAULT NULL
100 ,p_template_id IN NUMBER
101 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
102 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
103 ,x_po_uda_usage_object_array IN OUT NOCOPY PO_UDA_USAGE_OBJECT_ARRAY
104 ,x_return_status OUT NOCOPY VARCHAR2
105 ,x_errorcode OUT NOCOPY NUMBER
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110 PROCEDURE UDA_EXECUTE_ACTIONS(
111 p_pk1_value IN NUMBER
112 ,p_pk2_value IN NUMBER DEFAULT NULL
113 ,p_pk3_value IN NUMBER DEFAULT NULL
114 ,p_pk4_value IN NUMBER DEFAULT NULL
115 ,p_pk5_value IN NUMBER DEFAULT NULL
116 ,p_template_id IN NUMBER
117 ,p_event_type IN VARCHAR2
118 ,p_write_to IN VARCHAR2
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_errorcode OUT NOCOPY NUMBER
121 ,x_msg_count OUT NOCOPY NUMBER
122 ,x_msg_data OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE PO_UDA_EXECUTE_ACTIONS
126 (
127 p_po_header_id IN NUMBER
128 ,p_event_type IN VARCHAR2
129 ,p_write_to IN VARCHAR2
130 ,x_return_status OUT NOCOPY VARCHAR2
131 ,x_msg_count OUT NOCOPY NUMBER
132 );
133
134 PROCEDURE CONSTRUCT_PK_OBJECT
135 (
136 p_obj_name IN VARCHAR2
137 ,p_pk1_value IN NUMBER
138 ,p_pk2_value IN NUMBER DEFAULT NULL
139 ,p_pk3_value IN NUMBER DEFAULT NULL
140 ,p_pk4_value IN NUMBER DEFAULT NULL
141 ,p_pk5_value IN NUMBER DEFAULT NULL
142 ,x_pk_column_name_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
143 );
144
145 PROCEDURE SET_EXT_ATTR_NAME_VALUE_PAIR
146 (
147 p_ext_attr_name IN VARCHAR2
148 ,p_ext_attr_value IN VARCHAR2
149 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
150 );
151
152 PROCEDURE GET_EXT_ATTR_NAME_VALUE_PAIR
153 (
154 p_ext_attr_name IN VARCHAR2
155 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
159 PROCEDURE DEBUG
156 ,x_ext_name_val_obj OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_OBJ
157 );
158
160 (
161 p_structure_array IN EGO_COL_NAME_VALUE_PAIR_ARRAY
162 ,p_progress IN NUMBER
163 );
164
165 PROCEDURE DEBUG
166 (
167 p_structure_array IN EGO_COL_NAME_VALUE_PAIR_TABLE
168 ,p_progress IN NUMBER
169 );
170
171 PROCEDURE DEBUG
172 (
173 p_structure_array IN EGO_ATTR_GROUP_REQUEST_TABLE
174 ,p_progress IN NUMBER
175 );
176
177 PROCEDURE DEBUG
178 (
179 p_structure_array IN EGO_USER_ATTR_DATA_TABLE
180 ,p_progress IN NUMBER
181 );
182
183 PROCEDURE DEBUG
184 (
185 p_structure_array IN EGO_USER_ATTR_ROW_TABLE
186 ,p_progress IN NUMBER
187 );
188
189 PROCEDURE DEBUG
190 (
191 p_structure_array IN PO_UDA_USAGE_OBJECT_ARRAY
192 ,p_progress IN NUMBER
193 );
194
195 PROCEDURE DEBUG
196 (
197 p_structure_array IN PO_TBL_NUMBER
198 ,p_progress IN NUMBER
199 );
200
201 PROCEDURE DEBUG
202 (
203 p_msg IN VARCHAR2
204 ,p_progress IN NUMBER
205 );
206
207 END PO_UDA_DEFAULTING_PKG;