[Home] [Help]
14: SELECT fcc.meaning,
15: tn.meaning
16: INTO fcc_code,
17: tran_nat
18: FROM mtl_system_items mtl, fnd_lookups fcc, fnd_lookups tn
19: WHERE fcc.lookup_code = SUBSTR (mtl.global_attribute1, 1, 25)
20: AND fcc.lookup_type = fcc_code_type
21: AND tn.lookup_code = SUBSTR (mtl.global_attribute2, 1, 25)
22: AND tn.lookup_type = tran_nat_type
54: BEGIN
55: Errcd := 0;
56: SELECT global_attribute1
57: INTO fc_code
58: FROM mtl_system_items mtl
59: WHERE mtl.organization_id = form_org_id
60: AND inventory_item_id = form_item_id
61: AND rownum = row_number;
62: EXCEPTION
137: Errcd := 0;
138: fnd_file.put_line( FND_FILE.LOG, 'Calling JL_ZZ_PO_LIBRARY_1_PKG.get_trx_reason1:Org_id: '||org_id );
139: SELECT global_attribute2, global_attribute1
140: INTO trx_reason, fcc
141: FROM mtl_system_items mtl
142: WHERE (mtl.organization_id = org_id OR (mtl.organization_id IN (SELECT ood.organization_id
143: FROM org_organization_definitions ood
144: WHERE ood.operating_unit = org_id
145: )
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:
262: CURSOR get_trx_reason_code_so_csr
308: -- get_trx_reason_cd_per_req_line
309: --
310: -- DESCRIPTION
311: -- This procedure is called from JL library, it gets the transaction
312: -- reason code from mtl_system_items based on a given item_id and the
313: -- organization that user specified from the Transaction Nature
314: -- Defaulting Rule GDF in PO Options form. If no item is provided or
315: -- Transaction Reason code is not available from mtl_system_items for
316: -- the specified Local/Master inventory organization, the
311: -- This procedure is called from JL library, it gets the transaction
312: -- reason code from mtl_system_items based on a given item_id and the
313: -- organization that user specified from the Transaction Nature
314: -- Defaulting Rule GDF in PO Options form. If no item is provided or
315: -- Transaction Reason code is not available from mtl_system_items for
316: -- the specified Local/Master inventory organization, the
317: -- Transaction Reason code from PO Options form will be returned
318:
319: PROCEDURE get_trx_reason_cd_per_req_line(
316: -- the specified Local/Master inventory organization, the
317: -- Transaction Reason code from PO Options form will be returned
318:
319: PROCEDURE get_trx_reason_cd_per_req_line(
320: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
321: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
322: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
323: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
324: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
317: -- Transaction Reason code from PO Options form will be returned
318:
319: PROCEDURE get_trx_reason_cd_per_req_line(
320: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
321: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
322: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
323: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
324: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
325: , x_error_code OUT NOCOPY NUMBER)
318:
319: PROCEDURE get_trx_reason_cd_per_req_line(
320: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
321: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
322: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
323: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
324: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
325: , x_error_code OUT NOCOPY NUMBER)
326: IS
337: x_error_code := 0;
338:
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(