[Home] [Help]
116: SELECT SUBSTR (description, 1, 30)
117: INTO global_description
118: FROM fnd_descr_flex_contexts_vl
119: WHERE application_id = 7003
120: AND descriptive_flexfield_name = 'JG_PO_SYSTEM_PARAMETERS'
121: AND descriptive_flex_context_code = 'JL.BR.POXSTDPO.PO_OPTIONS'
122: AND enabled_flag = 'Y'
123: AND rownum = row_number;
124: EXCEPTION
159: BEGIN
160: Errcd := 0;
161: SELECT global_attribute1
162: INTO trx_reason
163: FROM po_system_parameters
164: WHERE rownum = row_number;
165: EXCEPTION
166: WHEN OTHERS THEN
167: Errcd := SQLCODE;
196: -- the value of transaction reason code should get from
197: --
198: PROCEDURE get_trx_reason_def_rule(
199: p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE,
200: p_trx_reason_def_rule OUT NOCOPY PO_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE3%TYPE,
201: p_error_code OUT NOCOPY NUMBER)
202: IS
203:
204: CURSOR get_trx_reason_def_rule_mo_csr(
201: p_error_code OUT NOCOPY NUMBER)
202: IS
203:
204: CURSOR get_trx_reason_def_rule_mo_csr(
205: c_org_id PO_SYSTEM_PARAMETERS.ORG_ID%TYPE)
206: IS
207: SELECT global_attribute3
208: FROM PO_SYSTEM_PARAMETERS_ALL
209: WHERE org_id = c_org_id;
204: CURSOR get_trx_reason_def_rule_mo_csr(
205: c_org_id PO_SYSTEM_PARAMETERS.ORG_ID%TYPE)
206: IS
207: SELECT global_attribute3
208: FROM PO_SYSTEM_PARAMETERS_ALL
209: WHERE org_id = c_org_id;
210:
211: CURSOR get_trx_reason_def_rule_so_csr
212: IS
210:
211: CURSOR get_trx_reason_def_rule_so_csr
212: IS
213: SELECT global_attribute3
214: FROM PO_SYSTEM_PARAMETERS_ALL;
215:
216:
217: BEGIN
218:
250: -- PRIVATE PROCEDURE
251: -- get_trx_reason_from_po
252: --
253: -- DESCRIPTION
254: -- This procedure gets transaction reason code from po_system_parameters
255: --
256: PROCEDURE get_trx_reason_from_po(
257: p_org_id IN PO_SYSTEM_PARAMETERS.ORG_ID%TYPE,
258: p_trx_reason_code OUT NOCOPY MTL_SYSTEM_ITEMS.GLOBAL_ATTRIBUTE2%TYPE,
253: -- DESCRIPTION
254: -- This procedure gets transaction reason code from po_system_parameters
255: --
256: PROCEDURE get_trx_reason_from_po(
257: p_org_id IN PO_SYSTEM_PARAMETERS.ORG_ID%TYPE,
258: p_trx_reason_code OUT NOCOPY MTL_SYSTEM_ITEMS.GLOBAL_ATTRIBUTE2%TYPE,
259: p_error_code OUT NOCOPY NUMBER)
260: IS
261:
261:
262: CURSOR get_trx_reason_code_so_csr
263: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL;
266:
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL;
266:
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
270: SELECT global_attribute1
271: FROM PO_SYSTEM_PARAMETERS_ALL
272: WHERE org_id = c_org_id;
267: CURSOR get_trx_reason_code_mo_csr(
268: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
269: IS
270: SELECT global_attribute1
271: FROM PO_SYSTEM_PARAMETERS_ALL
272: WHERE org_id = c_org_id;
273:
274: BEGIN
275:
324: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
325: , x_error_code OUT NOCOPY NUMBER)
326: IS
327:
328: l_trx_reason_def_rule PO_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE3%TYPE;
329: l_def_from_org_id NUMBER;
330: l_fcc VARCHAR2(15);
331: BEGIN
332:
339: IF p_item_id IS NOT NULL THEN
340: --
341: -- get transaction reason code from mtl system items if
342: -- item is known.
343: -- determine which organization to use from po system parameters
344: --
345: get_trx_reason_def_rule(
346: p_org_id,
347: l_trx_reason_def_rule,
417: -- p_item_id is NULL or
418: -- p_item_id is not NULL but trx reason code is
419: -- not available for Local/Master org
420: -- need to get trx reason code from
421: -- PO system parameters
422: --
423:
424: get_trx_reason_from_po(
425: p_org_id,