[Home] [Help]
PACKAGE: APPS.AP_PREPAY_TRAK_REP_TURK_PKG
Source
1 PACKAGE AP_PREPAY_TRAK_REP_TURK_PKG 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;