APPS.AP_TP_STMT_PKG dependencies on AP_TP_STMT_PKG

Line 1: PACKAGE BODY AP_TP_STMT_PKG AS

1: PACKAGE BODY AP_TP_STMT_PKG AS
2: -- $Header: APTPSTMTPB.pls 120.3.12020000.2 2012/11/06 05:29:40 sabadu ship $
3: /*===========================================================================+
4: --*************************************************************************
5: -- Copyright (c) 2000 Oracle Product Development

Line 16: -- This script creates the package body of AP_TP_STMT_PKG

12: -- PROGRAM NAME
13: -- APARTPSTMTPB.pls
14: --
15: -- DESCRIPTION
16: -- This script creates the package body of AP_TP_STMT_PKG
17: -- This package is used for Supplier Statement Reports.
18: --
19: -- USAGE
20: -- To install sqlplus / @APTPSTMTPB.pls

Line 21: -- To execute sqlplus / AP_TP_STMT_PKG.

17: -- This package is used for Supplier Statement Reports.
18: --
19: -- USAGE
20: -- To install sqlplus / @APTPSTMTPB.pls
21: -- To execute sqlplus / AP_TP_STMT_PKG.
22: --
23: -- PROGRAM LIST DESCRIPTION
24: --
25: -- BEFOREREPORT This function is used to dynamically get the

Line 229: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y' --'Y' Bug9252303

225: AND ai.invoice_type_lookup_code <> 'PREPAYMENT' --Bug9252303
226: AND ai.gl_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')
227: AND ai.invoice_currency_code = NVL2(P_CURRENCY,DECODE(P_CURRENCY,'ANY',ai.invoice_currency_code,P_CURRENCY),ai.invoice_currency_code)
228: AND ai.org_id = p_in_org_id
229: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y' --'Y' Bug9252303
230: AND P_UNVALIDATED_TRX = 'N')
231: OR P_UNVALIDATED_TRX = 'Y')
232: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
233: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'

Line 282: END AP_TP_STMT_PKG;

278: );
279: RETURN (NVL(ln_amount,0));
280: END balance_brought_forward;
281:
282: END AP_TP_STMT_PKG;