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