[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
153: BEGIN
154: Errcd := 0;
155: SELECT global_attribute1
156: INTO trx_reason
157: FROM po_system_parameters
158: WHERE rownum = row_number;
159: EXCEPTION
160: WHEN OTHERS THEN
161: Errcd := SQLCODE;
190: -- the value of transaction reason code should get from
191: --
192: PROCEDURE get_trx_reason_def_rule(
193: p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE,
194: p_trx_reason_def_rule OUT NOCOPY PO_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE3%TYPE,
195: p_error_code OUT NOCOPY NUMBER)
196: IS
197:
198: CURSOR get_trx_reason_def_rule_mo_csr(
195: p_error_code OUT NOCOPY NUMBER)
196: IS
197:
198: CURSOR get_trx_reason_def_rule_mo_csr(
199: c_org_id PO_SYSTEM_PARAMETERS.ORG_ID%TYPE)
200: IS
201: SELECT global_attribute3
202: FROM PO_SYSTEM_PARAMETERS_ALL
203: WHERE org_id = c_org_id;
198: CURSOR get_trx_reason_def_rule_mo_csr(
199: c_org_id PO_SYSTEM_PARAMETERS.ORG_ID%TYPE)
200: IS
201: SELECT global_attribute3
202: FROM PO_SYSTEM_PARAMETERS_ALL
203: WHERE org_id = c_org_id;
204:
205: CURSOR get_trx_reason_def_rule_so_csr
206: IS
204:
205: CURSOR get_trx_reason_def_rule_so_csr
206: IS
207: SELECT global_attribute3
208: FROM PO_SYSTEM_PARAMETERS_ALL;
209:
210:
211: BEGIN
212:
244: -- PRIVATE PROCEDURE
245: -- get_trx_reason_from_po
246: --
247: -- DESCRIPTION
248: -- This procedure gets transaction reason code from po_system_parameters
249: --
250: PROCEDURE get_trx_reason_from_po(
251: p_org_id IN PO_SYSTEM_PARAMETERS.ORG_ID%TYPE,
252: p_trx_reason_code OUT NOCOPY MTL_SYSTEM_ITEMS.GLOBAL_ATTRIBUTE2%TYPE,
247: -- DESCRIPTION
248: -- This procedure gets transaction reason code from po_system_parameters
249: --
250: PROCEDURE get_trx_reason_from_po(
251: p_org_id IN PO_SYSTEM_PARAMETERS.ORG_ID%TYPE,
252: p_trx_reason_code OUT NOCOPY MTL_SYSTEM_ITEMS.GLOBAL_ATTRIBUTE2%TYPE,
253: p_error_code OUT NOCOPY NUMBER)
254: IS
255:
255:
256: CURSOR get_trx_reason_code_so_csr
257: IS
258: SELECT global_attribute1
259: FROM PO_SYSTEM_PARAMETERS_ALL;
260:
261: CURSOR get_trx_reason_code_mo_csr(
262: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
263: IS
258: SELECT global_attribute1
259: FROM PO_SYSTEM_PARAMETERS_ALL;
260:
261: CURSOR get_trx_reason_code_mo_csr(
262: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
263: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL
266: WHERE org_id = c_org_id;
261: CURSOR get_trx_reason_code_mo_csr(
262: c_org_id PO_SYSTEM_PARAMETERS_ALL.ORG_ID%TYPE)
263: IS
264: SELECT global_attribute1
265: FROM PO_SYSTEM_PARAMETERS_ALL
266: WHERE org_id = c_org_id;
267:
268: BEGIN
269:
318: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
319: , x_error_code OUT NOCOPY NUMBER)
320: IS
321:
322: l_trx_reason_def_rule PO_SYSTEM_PARAMETERS.GLOBAL_ATTRIBUTE3%TYPE;
323: l_def_from_org_id NUMBER;
324: l_fcc VARCHAR2(15);
325: BEGIN
326:
333: IF p_item_id IS NOT NULL THEN
334: --
335: -- get transaction reason code from mtl system items if
336: -- item is known.
337: -- determine which organization to use from po system parameters
338: --
339: get_trx_reason_def_rule(
340: p_org_id,
341: l_trx_reason_def_rule,
411: -- p_item_id is NULL or
412: -- p_item_id is not NULL but trx reason code is
413: -- not available for Local/Master org
414: -- need to get trx reason code from
415: -- PO system parameters
416: --
417:
418: get_trx_reason_from_po(
419: p_org_id,