1: PACKAGE BODY JL_ZZ_PO_LIBRARY_1_PKG AS
2: /* $Header: jlzzul1b.pls 120.3 2010/08/09 21:34:29 rahulkum ship $ */
3:
4: PROCEDURE get_fcc_code (fcc_code_type IN VARCHAR2,
5: tran_nat_type IN VARCHAR2,
134: row_number IN NUMBER,
135: Errcd IN OUT NOCOPY NUMBER) IS
136: BEGIN
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
427: x_error_code);
428:
429: END get_trx_reason_cd_per_req_line;
430:
431: END JL_ZZ_PO_LIBRARY_1_PKG;