18: --------------------------------------------------------------------------------
19:
20: -- encumbrance actions
21: g_action_RESERVE CONSTANT VARCHAR2(30)
22: := PO_DOCUMENT_FUNDS_PVT.g_action_RESERVE;
23:
24: g_action_UNRESERVE CONSTANT VARCHAR2(30)
25: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
26:
21: g_action_RESERVE CONSTANT VARCHAR2(30)
22: := PO_DOCUMENT_FUNDS_PVT.g_action_RESERVE;
23:
24: g_action_UNRESERVE CONSTANT VARCHAR2(30)
25: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
26:
27: g_action_ADJUST CONSTANT VARCHAR2(30)
28: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
29:
24: g_action_UNRESERVE CONSTANT VARCHAR2(30)
25: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
26:
27: g_action_ADJUST CONSTANT VARCHAR2(30)
28: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
29:
30: g_action_REQ_SPLIT CONSTANT
31: VARCHAR2(30)
32: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
28: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
29:
30: g_action_REQ_SPLIT CONSTANT
31: VARCHAR2(30)
32: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
33: ;
34: g_action_CANCEL CONSTANT VARCHAR2(30)
35: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
36:
31: VARCHAR2(30)
32: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
33: ;
34: g_action_CANCEL CONSTANT VARCHAR2(30)
35: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
36:
37: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
38: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
39:
34: g_action_CANCEL CONSTANT VARCHAR2(30)
35: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
36:
37: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
38: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
39:
40: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
41: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
42:
37: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
38: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
39:
40: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
41: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
42:
43: g_action_REJECT CONSTANT VARCHAR2(30)
44: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
45:
40: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
41: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
42:
43: g_action_REJECT CONSTANT VARCHAR2(30)
44: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
45:
46: g_action_RETURN CONSTANT VARCHAR2(30)
47: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
48:
43: g_action_REJECT CONSTANT VARCHAR2(30)
44: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
45:
46: g_action_RETURN CONSTANT VARCHAR2(30)
47: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
48:
49: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
50: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
51:
46: g_action_RETURN CONSTANT VARCHAR2(30)
47: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
48:
49: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
50: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
51:
52: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
54:
49: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
50: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
51:
52: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
54:
55: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
56: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
57:
52: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
54:
55: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
56: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
57:
58: g_action_CR_MEMO_CANCEL CONSTANT VARCHAR2(30)
59: := PO_DOCUMENT_FUNDS_PVT.g_action_CR_MEMO_CANCEL;
60:
55: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
56: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
57:
58: g_action_CR_MEMO_CANCEL CONSTANT VARCHAR2(30)
59: := PO_DOCUMENT_FUNDS_PVT.g_action_CR_MEMO_CANCEL;
60:
61:
62: -- doc types
63:
62: -- doc types
63:
64: g_doc_type_REQUISITION CONSTANT
65: PO_DOCUMENT_TYPES.document_type_code%TYPE
66: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION;
67:
68: g_doc_type_PO CONSTANT
69: PO_DOCUMENT_TYPES.document_type_code%TYPE
70: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO;
66: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION;
67:
68: g_doc_type_PO CONSTANT
69: PO_DOCUMENT_TYPES.document_type_code%TYPE
70: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO;
71:
72: g_doc_type_PA CONSTANT
73: PO_DOCUMENT_TYPES.document_type_code%TYPE
74: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA;
70: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO;
71:
72: g_doc_type_PA CONSTANT
73: PO_DOCUMENT_TYPES.document_type_code%TYPE
74: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA;
75:
76: g_doc_type_RELEASE CONSTANT
77: PO_DOCUMENT_TYPES.document_type_code%TYPE
78: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE;
74: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA;
75:
76: g_doc_type_RELEASE CONSTANT
77: PO_DOCUMENT_TYPES.document_type_code%TYPE
78: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE;
79:
80: g_doc_type_MIXED_PO_RELEASE CONSTANT
81: PO_DOCUMENT_TYPES.document_type_code%TYPE
82: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE;
78: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE;
79:
80: g_doc_type_MIXED_PO_RELEASE CONSTANT
81: PO_DOCUMENT_TYPES.document_type_code%TYPE
82: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE;
83:
84: -- doc subtypes
85:
86: g_doc_subtype_STANDARD CONSTANT
84: -- doc subtypes
85:
86: g_doc_subtype_STANDARD CONSTANT
87: PO_HEADERS_ALL.type_lookup_code%TYPE
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
91: PO_HEADERS_ALL.type_lookup_code%TYPE
92: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
88: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
89:
90: g_doc_subtype_PLANNED CONSTANT
91: PO_HEADERS_ALL.type_lookup_code%TYPE
92: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
93:
94: g_doc_subtype_BLANKET CONSTANT
95: PO_RELEASES_ALL.release_type%TYPE
96: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
92: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
93:
94: g_doc_subtype_BLANKET CONSTANT
95: PO_RELEASES_ALL.release_type%TYPE
96: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
97:
98: g_doc_subtype_SCHEDULED CONSTANT
99: PO_RELEASES_ALL.release_type%TYPE
100: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED;
96: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
97:
98: g_doc_subtype_SCHEDULED CONSTANT
99: PO_RELEASES_ALL.release_type%TYPE
100: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED;
101:
102: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
103: PO_HEADERS_ALL.type_lookup_code%TYPE
104: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE;
100: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED;
101:
102: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
103: PO_HEADERS_ALL.type_lookup_code%TYPE
104: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE;
105:
106: -- doc levels
107:
108: g_doc_level_HEADER CONSTANT VARCHAR2(25)
105:
106: -- doc levels
107:
108: g_doc_level_HEADER CONSTANT VARCHAR2(25)
109: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_HEADER;
110:
111: g_doc_level_LINE CONSTANT VARCHAR2(25)
112: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE;
113:
108: g_doc_level_HEADER CONSTANT VARCHAR2(25)
109: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_HEADER;
110:
111: g_doc_level_LINE CONSTANT VARCHAR2(25)
112: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE;
113:
114: g_doc_level_SHIPMENT CONSTANT VARCHAR2(25)
115: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT;
116:
111: g_doc_level_LINE CONSTANT VARCHAR2(25)
112: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE;
113:
114: g_doc_level_SHIPMENT CONSTANT VARCHAR2(25)
115: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT;
116:
117: g_doc_level_DISTRIBUTION CONSTANT VARCHAR2(25)
118: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION;
119:
114: g_doc_level_SHIPMENT CONSTANT VARCHAR2(25)
115: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT;
116:
117: g_doc_level_DISTRIBUTION CONSTANT VARCHAR2(25)
118: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION;
119:
120: -- distribution types
121:
122: g_dist_type_STANDARD CONSTANT
120: -- distribution types
121:
122: g_dist_type_STANDARD CONSTANT
123: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
124: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
125:
126: g_dist_type_PLANNED CONSTANT
127: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
129:
130: g_dist_type_SCHEDULED CONSTANT
131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
128: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
129:
130: g_dist_type_SCHEDULED CONSTANT
131: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
133:
134: g_dist_type_BLANKET CONSTANT
135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
136: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
132: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
133:
134: g_dist_type_BLANKET CONSTANT
135: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
136: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
137:
138: g_dist_type_AGREEMENT CONSTANT
139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
140: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
136: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
137:
138: g_dist_type_AGREEMENT CONSTANT
139: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
140: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
141:
142: g_dist_type_REQUISITION CONSTANT
143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
144: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
140: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
141:
142: g_dist_type_REQUISITION CONSTANT
143: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
144: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
145:
146: g_dist_type_MIXED_PO_RELEASE CONSTANT
147: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
148: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE;
144: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
145:
146: g_dist_type_MIXED_PO_RELEASE CONSTANT
147: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
148: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE;
149:
150: -- parameter values
151:
152: g_parameter_YES CONSTANT VARCHAR2(1)
149:
150: -- parameter values
151:
152: g_parameter_YES CONSTANT VARCHAR2(1)
153: := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES;
154:
155: g_parameter_NO CONSTANT VARCHAR2(1)
156: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
157:
152: g_parameter_YES CONSTANT VARCHAR2(1)
153: := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES;
154:
155: g_parameter_NO CONSTANT VARCHAR2(1)
156: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
157:
158: g_parameter_USE_PROFILE CONSTANT VARCHAR2(1)
159: := PO_DOCUMENT_FUNDS_PVT.g_parameter_USE_PROFILE;
160:
155: g_parameter_NO CONSTANT VARCHAR2(1)
156: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
157:
158: g_parameter_USE_PROFILE CONSTANT VARCHAR2(1)
159: := PO_DOCUMENT_FUNDS_PVT.g_parameter_USE_PROFILE;
160:
161: -- return status
162:
163: g_return_SUCCESS CONSTANT VARCHAR2(10)
160:
161: -- return status
162:
163: g_return_SUCCESS CONSTANT VARCHAR2(10)
164: := PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS;
165:
166: g_return_WARNING CONSTANT VARCHAR2(10)
167: := PO_DOCUMENT_FUNDS_PVT.g_return_WARNING;
168:
163: g_return_SUCCESS CONSTANT VARCHAR2(10)
164: := PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS;
165:
166: g_return_WARNING CONSTANT VARCHAR2(10)
167: := PO_DOCUMENT_FUNDS_PVT.g_return_WARNING;
168:
169: g_return_PARTIAL CONSTANT VARCHAR2(10)
170: := PO_DOCUMENT_FUNDS_PVT.g_return_PARTIAL;
171:
166: g_return_WARNING CONSTANT VARCHAR2(10)
167: := PO_DOCUMENT_FUNDS_PVT.g_return_WARNING;
168:
169: g_return_PARTIAL CONSTANT VARCHAR2(10)
170: := PO_DOCUMENT_FUNDS_PVT.g_return_PARTIAL;
171:
172: g_return_FAILURE CONSTANT VARCHAR2(10)
173: := PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE;
174:
169: g_return_PARTIAL CONSTANT VARCHAR2(10)
170: := PO_DOCUMENT_FUNDS_PVT.g_return_PARTIAL;
171:
172: g_return_FAILURE CONSTANT VARCHAR2(10)
173: := PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE;
174:
175: g_return_FATAL CONSTANT VARCHAR2(10)
176: := PO_DOCUMENT_FUNDS_PVT.g_return_FATAL;
177:
172: g_return_FAILURE CONSTANT VARCHAR2(10)
173: := PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE;
174:
175: g_return_FATAL CONSTANT VARCHAR2(10)
176: := PO_DOCUMENT_FUNDS_PVT.g_return_FATAL;
177:
178: -- gl packet constants
179:
180: g_actual_flag_Encumbrance VARCHAR2(1) := 'E';
184:
185: -- adjustment status
186: g_adjustment_status_OLD CONSTANT
187: PO_ENCUMBRANCE_GT.adjustment_status%TYPE
188: := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_OLD;
189:
190: g_adjustment_status_NEW CONSTANT
191: PO_ENCUMBRANCE_GT.adjustment_status%TYPE
192: := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_NEW;
188: := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_OLD;
189:
190: g_adjustment_status_NEW CONSTANT
191: PO_ENCUMBRANCE_GT.adjustment_status%TYPE
192: := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_NEW;
193:
194:
195: -- result classifications
196: g_result_SUCCESS CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
193:
194:
195: -- result classifications
196: g_result_SUCCESS CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
197: := PO_DOCUMENT_FUNDS_PVT.g_result_SUCCESS;
198:
199: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
200: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
201:
196: g_result_SUCCESS CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
197: := PO_DOCUMENT_FUNDS_PVT.g_result_SUCCESS;
198:
199: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
200: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
201:
202: g_result_ERROR CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
203: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
204: --note: this classification currently maps to Warning, but is
199: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
200: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
201:
202: g_result_ERROR CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
203: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
204: --note: this classification currently maps to Warning, but is
205: --given a seperate label so as to easily identify this condition
206: g_result_NOT_PROCESSED CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
207: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
203: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
204: --note: this classification currently maps to Warning, but is
205: --given a seperate label so as to easily identify this condition
206: g_result_NOT_PROCESSED CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
207: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
208:
209: --note: this classification currently maps to ERROR, but is
210: --given a seperate label so as to easily identify this condition,
211: --which occurs when there is a single high-level failure message
210: --given a seperate label so as to easily identify this condition,
211: --which occurs when there is a single high-level failure message
212: --instead of detailed results for each distribution
213: g_result_TRANSACTION CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
214: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
215:
216: -- current module
217: g_module_ENCUMBRANCE CONSTANT
218: PO_ONLINE_REPORT_TEXT.transaction_type%TYPE := 'ENCUMBRANCE';