PACKAGE: APPS.JA_JAINSTAC_XMLP_PKG

Source

1 PACKAGE JA_JAINSTAC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: JAINSTACS.pls 120.1 2007/12/25 16:29:53 dwkrishn noship $ */
3   P_AS_ON_DATE DATE;
4 
5   CP_AS_ON_DATE VARCHAR2(20);
6 
7   CP_AS_ON_DATE1 VARCHAR2(20);
8 
9   P_VENDOR_TYPE VARCHAR2(50);
10 
11   P_VENDOR_ID NUMBER;
12 
13   P_VENDOR_NO VARCHAR2(32767);
14 
15   P_AGING_INTERVAL_DAYS NUMBER := 10;
16 
17   CP_AGING_INTERVAL_DAYS NUMBER;
18 
19   P_NO_OF_INTERVALS NUMBER := 4;
20 
21   CP_NO_OF_INTERVALS NUMBER;
22 
23   P_ORG_ID NUMBER;
24 
25   P_AGE1 DATE;
26 
27   P_AGE2 DATE;
28 
29   P_AGE3 DATE;
30 
31   P_AGE4 DATE;
32 
33   P_AGE1_AMOUNT NUMBER;
34 
35   P_AGE4_AMOUNT NUMBER;
36 
37   P_AGE5 DATE;
38 
39   P_AGE6 DATE;
40 
41   P_AGE7 DATE;
42 
43   P_AGE8 DATE;
44 
45   P_AGE9 DATE;
46 
47   P_AGE10 DATE;
48 
49   P_AGE11 DATE;
50 
51   P_AGE12 DATE;
52 
53   P_AGE13 DATE;
54 
55   P_AGE2_AMOUNT NUMBER;
56 
57   P_AGE3_AMOUNT NUMBER;
58 
59   P_AGE5_AMOUNT NUMBER;
60 
61   P_AGE6_AMOUNT NUMBER;
62 
63   P_AGE7_AMOUNT NUMBER;
64 
65   P_AGE8_AMOUNT NUMBER;
66 
67   P_AGE9_AMOUNT NUMBER;
68 
69   P_AGE10_AMOUNT NUMBER;
70 
71   P_AGE11_AMOUNT NUMBER;
72 
73   P_AGE12_AMOUNT NUMBER;
74 
75   P_AGE13_AMOUNT NUMBER;
76 
77   P_CONC_REQUEST_ID NUMBER;
78 
79   FUNCTION BALANCE(DT1 IN DATE
80                   ,DT2 IN DATE
81                   ,VEND_ID IN NUMBER) RETURN NUMBER;
82 
83   FUNCTION FINAL_BALANCE(DT IN DATE
84                         ,VEND_ID IN NUMBER) RETURN NUMBER;
85 
86   FUNCTION CF_AGE2FORMULA(VENDOR_ID IN NUMBER) RETURN NUMBER;
87 
88   FUNCTION CF_COMP_NAMEFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
89 
90   FUNCTION CF_COMP_ADDRFORMULA(ORG_ID IN NUMBER) RETURN VARCHAR2;
91 
92   FUNCTION BEFOREREPORT RETURN BOOLEAN;
93 
94   FUNCTION CF_SOB_NAMEFORMULA RETURN VARCHAR2;
95 
96   FUNCTION CF_P_VENDORFORMULA RETURN VARCHAR2;
97 
98   FUNCTION CF_INR_AMOUNT1FORMULA(INVOICE_TYPE_LOOKUP_CODE1 IN VARCHAR2
99                                 ,EXCHANGE_RATE1 IN NUMBER
100                                 ,INVOICE_ID1 IN NUMBER
101                                 ,INVOICE_AMOUNT1 IN NUMBER
102                                 ,AMOUNT_PAID1 IN NUMBER) RETURN NUMBER;
103 
104   FUNCTION CF_AMOUNT1FORMULA(INVOICE_TYPE_LOOKUP_CODE1 IN VARCHAR2
105                             ,INVOICE_ID1 IN NUMBER
106                             ,INVOICE_AMOUNT1 IN NUMBER
107                             ,AMOUNT_PAID1 IN NUMBER) RETURN NUMBER;
108 
109   FUNCTION CF_REMARKSFORMULA(PAYMENT_STATUS_FLAG1 IN VARCHAR2) RETURN CHAR;
110 
111   FUNCTION AFTERREPORT RETURN BOOLEAN;
112 
113 END JA_JAINSTAC_XMLP_PKG;
114 
115