PACKAGE: APPS.AP_PREPAY_TRAK_REP_TURK_PKG

Source

1 PACKAGE AP_PREPAY_TRAK_REP_TURK_PKG AUTHID CURRENT_USER AS
2 -- $Header: APPPTRPS.pls 120.3 2007/10/31 06:46:56 sgudupat noship $
3 -- ****************************************************************************************
4 -- Copyright (c)  2000  Oracle Solution Services (India)     Product Development
5 -- All rights reserved
6 -- ****************************************************************************************
7 --
8 -- PROGRAM NAME
9 -- APPPTRPS.pls
10 --
11 -- DESCRIPTION
12 --  This script creates the package body of APPPTRPS.pls.
13 --  This package is used to generate Prepayment Tracking Report for Turkey.
14 --
15 -- USAGE
16 --   To install        How to Install
17 --   To execute        How to Execute
18 --
19 -- DEPENDENCIES
20 --   None.
21 --
22 --
23 -- LAST UPDATE DATE   26-JAN-2007
24 --   Date the program has been modified for the last time
25 --
26 -- HISTORY
27 -- =======
28 --
29 -- VERSION DATE        AUTHOR(S)         DESCRIPTION
30 -- ------- ----------- ---------------   ------------------------------------
31 -- 1.0    26-JAN-2007 Pgollu M Creation
32 --
33 --****************************************************************************************
34 
35 /*=========================================
36 Variables to Hold the Parameter Values
37 =========================================*/
38 gd_date_from 			DATE;
39 gd_date_to 				DATE;
40 P_INVOICE_FROM			VARCHAR2(30);
41 P_INVOICE_TO			VARCHAR2(30);
42 P_SUPPLIER_FROM         VARCHAR2(50);
43 P_SUPPLIER_TO           VARCHAR2(50);
44 P_CURRENCY              VARCHAR2(15);
45 P_VENDOR_TYPE           VARCHAR2(30);
46 P_ORG_ID				NUMBER;
47 P_PREPAY_STATUS         VARCHAR2(30);
48 
49 
50 /*=========================================
51 Constants to obtain dynamic values
52 =========================================*/
53 
54 c_lex_invoice_date 		VARCHAR2(900);
55 c_lex_supplier			VARCHAR2(200);
56 c_lex_currency			VARCHAR2(200);
57 c_lex_vendor_type       VARCHAR2(200);
58 gc_org_where       		VARCHAR2(100);
59 c_lex_prepay_status     VARCHAR2(200);
60 
61 /*=========================================
62 Public Functions
63 =========================================*/
64 
65 FUNCTION beforeReport  RETURN BOOLEAN;
66 FUNCTION date_close(prepay_inv_num IN VARCHAR2
67 					, prepay_line_number_param IN NUMBER
68 					,prepay_amount_remaining IN NUMBER) RETURN DATE;
69 END AP_PREPAY_TRAK_REP_TURK_PKG;