[Home] [Help]
PACKAGE: APPS.AP_APXINHIS_XMLP_PKG
Source
1 PACKAGE AP_APXINHIS_XMLP_PKG AS
2 /* $Header: APXINHISS.pls 120.0 2007/12/27 07:54:33 vjaganat noship $ */
3 H_COMPANY_NAME VARCHAR2(30);
4
5 P_MIN_PRECISION NUMBER := 0;
6
7 H_FUNCTIONAL_CURRENCY VARCHAR2(32767);
8
9 P_BOOK NUMBER;
10
11 LP_VENDOR_ID VARCHAR2(200);
12
13 P_VENDOR_ID NUMBER;
14
15 LP_VENDOR_SITE VARCHAR2(200);
16
17 P_VENDOR_SITE VARCHAR2(200);
18
19 LP_INVOICES VARCHAR2(60);
20
21 P_INVOICES VARCHAR2(60);
22
23 LP_INVOICES_NUMBER_FROM VARCHAR2(60);
24
25 P_INVOICES_NUMBER_TO VARCHAR2(60);
26
27 LP_DOC_SEQUENCE_NUMBER_FROM VARCHAR2(60);
28
29 P_DOC_SEQUENCE_NUMBER_FROM VARCHAR2(60);
30
31 LP_INVOICE_DATE_TO VARCHAR2(200);
32
33 P_INVOICE_DATE_FROM DATE;
34 P_INVOICE_DATE_FROM_T VARCHAR2(200);
35 P_INVOICES_NUMBER_FROM VARCHAR2(60);
36
37 LP_INVOICES_NUMBER_TO VARCHAR2(60);
38
39 LP_DOC_SEQUENCE_NUMBER_TO VARCHAR2(60);
40
41 P_DOC_SEQUENCE_NUMBER_TO VARCHAR2(60);
42
43 LP_INVOICE_DATE_FROM VARCHAR2(200);
44
45 P_INVOICE_DATE_TO DATE;
46 P_INVOICE_DATE_TO_T VARCHAR2(200);
47 P_CONC_REQUEST_ID NUMBER := 0;
48
49 P_PREPAYMENT VARCHAR2(32767);
50
51 P_DEBUG_SWITCH VARCHAR2(1);
52
53 P_TRACE_SWITCH VARCHAR2(1);
54
55 LP_DOC_SEQUENCE_NAME VARCHAR2(200);
56
57 P_DOC_SEQUENCE_NAME VARCHAR2(40);
58
59 P_ALLINVOICES VARCHAR2(32767);
60
61 P_VENDOR_NAME VARCHAR2(240);
62
63 STRUCT_NUM VARCHAR2(15);
64
65 C_NLS_NO_DATA_EXISTS VARCHAR2(240);
66
67 C_NLS_END_OF_REPORT VARCHAR2(100);
68
69 C_NLS_YES VARCHAR2(80);
70
71 C_NLS_NO VARCHAR2(80);
72
73 C_NLS_ALL VARCHAR2(80);
74
75 FUNCTION C_OPEN_BALANCE_AMT1FORMULA(C_TRANSACTION_TYPE3 IN VARCHAR2
76 ,C_OPEN_BALANCE_AMT IN NUMBER
77 ,C_TRX_AMOUNT_SUM IN NUMBER
78 ,C_PREPAY_AMT_F IN NUMBER
79 ,C_TRANSACTION_AMT1_DUMMY_SUM IN NUMBER) RETURN NUMBER;
80
81 FUNCTION BEFOREREPORT RETURN BOOLEAN;
82
83 FUNCTION AFTERREPORT RETURN BOOLEAN;
84
85 FUNCTION C_VENDOR_SITE_TOTALFORMULA(C_TOTAL_INVOICE_AMOUNT_SUM IN NUMBER
86 ,C_TOTAL_PAYMENT_AMOUNT_SUM IN NUMBER
87 ,C_TOTAL_PREPAY_AMT_SUM IN NUMBER) RETURN NUMBER;
88
89 FUNCTION GET_NLS_STRINGS RETURN BOOLEAN;
90
91 FUNCTION C_CURRENCY_TOTALFORMULA(C_TOTAL_INVOICE_AMT_CURR IN NUMBER
92 ,C_TOTAL_PAYMENT_AMT_CURR IN NUMBER
93 ,C_TOTAL_PREPAY_AMT IN NUMBER) RETURN NUMBER;
94
95 FUNCTION T_VENDOR_TOTALFORMULA(T_TOTAL_INV_AMT IN NUMBER
96 ,T_TOTAL_PAY_AMT IN NUMBER
97 ,T_TOTAL_PREPAY_AMT IN NUMBER) RETURN NUMBER;
98
99 FUNCTION T_REPORT_TOTALFORMULA(T_REPORT_INV_AMT IN NUMBER
100 ,T_REPORT_PAY_AMT IN NUMBER
101 ,T_REPORT_PREPAY_AMT IN NUMBER) RETURN NUMBER;
102
103 FUNCTION C_TRANSACTION_AMT1_DUMFORMULA(C_TRANSACTION_TYPE3 IN VARCHAR2
104 ,C_TRANSACTION_AMT1 IN NUMBER) RETURN NUMBER;
105
106 FUNCTION T_TRANSACTION_AMT_DUMFORMULA(T_TRANSACTION_TYPE4 IN VARCHAR2
107 ,T_TRANSACTION_AMT IN NUMBER) RETURN NUMBER;
108
109 FUNCTION T_TRANSACTION_AMT1_DUMFORMULA(T_TRANSACTION_TYPE3 IN VARCHAR2
110 ,T_TRANSACTION_AMT2 IN NUMBER) RETURN NUMBER;
111
112 FUNCTION P_TRX_AMT_SUM_FFORMULA(P_TRX_AMOUNT_SUM IN NUMBER
113 ,C_TOTAL_INVOICE_AMT IN NUMBER) RETURN NUMBER;
114
115 FUNCTION C_PREPAY_AMT_FFORMULA(C_INVOICE_ID1 IN NUMBER) RETURN NUMBER;
116
117 FUNCTION T_PREPAY_AMT_FFORMULA(T_INVOICE_ID IN NUMBER) RETURN NUMBER;
118
119 FUNCTION T_PREPAY_AMT_F1FORMULA(T_INVOICE_ID1 IN NUMBER) RETURN NUMBER;
120
121 FUNCTION STRUCT_NUM_P RETURN VARCHAR2;
122
123 FUNCTION C_NLS_NO_DATA_EXISTS_P RETURN VARCHAR2;
124
125 FUNCTION C_NLS_END_OF_REPORT_P RETURN VARCHAR2;
126
127 FUNCTION C_NLS_YES_P RETURN VARCHAR2;
128
129 FUNCTION C_NLS_NO_P RETURN VARCHAR2;
130
131 FUNCTION C_NLS_ALL_P RETURN VARCHAR2;
132
133 END AP_APXINHIS_XMLP_PKG;
134