DBA Data[Home] [Help]

APPS.JL_ZZ_PO_LIBRARY_1_PKG dependencies on JL_ZZ_PO_LIBRARY_1_PKG

Line 1: PACKAGE BODY JL_ZZ_PO_LIBRARY_1_PKG AS

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,

Line 138: fnd_file.put_line( FND_FILE.LOG, 'Calling JL_ZZ_PO_LIBRARY_1_PKG.get_trx_reason1:Org_id: '||org_id );

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

Line 431: END JL_ZZ_PO_LIBRARY_1_PKG;

427: x_error_code);
428:
429: END get_trx_reason_cd_per_req_line;
430:
431: END JL_ZZ_PO_LIBRARY_1_PKG;