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.1 2008/04/03 12:58:54 sgudupat noship $
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 226: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y'

222: AND ai.vendor_site_id = p_in_vendor_site_id
223: AND ai.gl_date < TO_DATE(P_FROM_GL_DATE,'RRRR/MM/DD HH24:MI:SS')
224: AND ai.invoice_currency_code = NVL2(P_CURRENCY,DECODE(P_CURRENCY,'ANY',ai.invoice_currency_code,P_CURRENCY),ai.invoice_currency_code)
225: AND ai.org_id = p_in_org_id
226: AND ((AP_TP_STMT_PKG.invoice_validate_status(ai.invoice_id) = 'Y'
227: AND P_UNVALIDATED_TRX = 'N')
228: OR P_UNVALIDATED_TRX = 'Y')
229: AND AP_INVOICES_PKG.get_posting_status(ai.invoice_id)
230: = DECODE(P_ACCOUNTED,'ACCOUNTED','Y'

Line 278: END AP_TP_STMT_PKG;

274: );
275: RETURN (NVL(ln_amount,0));
276: END balance_brought_forward;
277:
278: END AP_TP_STMT_PKG;