1 PACKAGE FV_IPAC_TRANSACTIONS_SUMM_PKG as
2 /* $Header: FVIPATHS.pls 120.2 2002/11/11 20:04:10 ksriniva ship $ */
3
4 PROCEDURE Insert_Row(X_ROWID IN OUT NOCOPY VARCHAR2,
5 X_IPAC_BILLING_ID IN OUT NOCOPY NUMBER,
6 X_CUSTOMER_TRX_ID NUMBER ,
7 X_CUSTOMER_ID NUMBER ,
8 X_CUSTOMER_NAME VARCHAR2 ,
9 X_TAXPAYER_NUMBER VARCHAR2 ,
10 X_TRX_NUMBER VARCHAR2 ,
11 X_TRX_DATE DATE ,
12 X_PO_NUMBER VARCHAR2 ,
13 X_CONTRACT_NO VARCHAR2 ,
14 X_CLIN VARCHAR2 ,
15 X_SENDER_ALC VARCHAR2 ,
16 X_SENDER_DO_SYM VARCHAR2 ,
17 X_TRN_SET_ID NUMBER ,
18 X_ORG_DCM_RFR VARCHAR2 ,
19 X_ORG_ACC_DT DATE ,
20 X_DPR_CD VARCHAR2 ,
21 X_DSC VARCHAR2 ,
22 X_OBL_DCM_NR VARCHAR2 ,
23 X_PAY_FLG VARCHAR2 ,
24 X_QTY NUMBER ,
25 X_SND_APP_SYM VARCHAR2 ,
26 X_UNT_ISS VARCHAR2 ,
27 X_UNT_PRC NUMBER ,
28 X_ORG_LN_ITM NUMBER ,
29 X_EXCLUDE_FLAG VARCHAR2 ,
30 X_PROCESSED_FLAG VARCHAR2 ,
31 X_RUN_DATE DATE ,
32 X_SET_OF_BOOKS_ID NUMBER ,
33 X_EXCEPTION_CATEGORY VARCHAR2 ,
34 X_ORG_ID NUMBER ,
35 X_LAST_UPDATE_DATE DATE ,
36 X_LAST_UPDATED_BY NUMBER ,
37 X_LAST_UPDATE_LOGIN NUMBER ,
38 X_CREATION_DATE DATE ,
39 X_CREATED_BY NUMBER ,
40 X_ATTRIBUTE1 VARCHAR2 ,
41 X_ATTRIBUTE2 VARCHAR2 ,
42 X_ATTRIBUTE3 VARCHAR2 ,
43 X_ATTRIBUTE4 VARCHAR2 ,
44 X_ATTRIBUTE5 VARCHAR2 ,
45 X_ATTRIBUTE6 VARCHAR2 ,
46 X_ATTRIBUTE7 VARCHAR2 ,
47 X_ATTRIBUTE8 VARCHAR2 ,
48 X_ATTRIBUTE9 VARCHAR2 ,
49 X_ATTRIBUTE10 VARCHAR2 ,
50 X_ATTRIBUTE11 VARCHAR2 ,
51 X_ATTRIBUTE12 VARCHAR2 ,
52 X_ATTRIBUTE13 VARCHAR2 ,
53 X_ATTRIBUTE14 VARCHAR2 ,
54 X_ATTRIBUTE15 VARCHAR2 ,
55 -- Commented the below lines for the Bug # 2145501
56 /* X_ATTRIBUTE16 VARCHAR2 ,
57 X_ATTRIBUTE17 VARCHAR2 ,
58 X_ATTRIBUTE18 VARCHAR2 ,
59 X_ATTRIBUTE19 VARCHAR2 ,
60 X_ATTRIBUTE20 VARCHAR2 ,
61 X_ATTRIBUTE21 VARCHAR2 ,
62 X_ATTRIBUTE22 VARCHAR2 ,
63 X_ATTRIBUTE23 VARCHAR2 ,
64 X_ATTRIBUTE24 VARCHAR2 ,
65 X_ATTRIBUTE25 VARCHAR2 ,
66 X_ATTRIBUTE26 VARCHAR2 ,
67 X_ATTRIBUTE27 VARCHAR2 ,
68 X_ATTRIBUTE28 VARCHAR2 ,
69 X_ATTRIBUTE29 VARCHAR2 ,
70 X_ATTRIBUTE30 VARCHAR2 , */
71 X_ATTRIBUTE_CATEGORY VARCHAR2 ,
72 X_ADJUSTMENT_ID NUMBER ,
73 X_AMOUNT NUMBER ,
74 X_REPORT_FLAG VARCHAR2 ,
75 X_CNT_NM VARCHAR2 ,
76 X_CNT_PHN_NR VARCHAR2 ,
77 X_TRX_LINE_NO NUMBER ,
78 X_ORG_DO_SYM VARCHAR2
79 );
80
81 PROCEDURE Update_Row(X_ROWID IN OUT NOCOPY VARCHAR2,
82 X_CUSTOMER_TRX_ID NUMBER ,
83 X_CUSTOMER_ID NUMBER ,
84 X_CUSTOMER_NAME VARCHAR2 ,
85 X_TAXPAYER_NUMBER VARCHAR2 ,
86 X_TRX_NUMBER VARCHAR2 ,
87 X_TRX_DATE DATE ,
88 X_PO_NUMBER VARCHAR2 ,
89 X_CONTRACT_NO VARCHAR2 ,
90 X_CLIN VARCHAR2 ,
91 X_SENDER_ALC VARCHAR2 ,
92 X_SENDER_DO_SYM VARCHAR2 ,
93 X_TRN_SET_ID NUMBER ,
94 X_ORG_DCM_RFR VARCHAR2 ,
95 X_ORG_ACC_DT DATE ,
96 X_DPR_CD VARCHAR2 ,
97 X_DSC VARCHAR2 ,
98 X_OBL_DCM_NR VARCHAR2 ,
99 X_PAY_FLG VARCHAR2 ,
100 X_QTY NUMBER ,
101 X_SND_APP_SYM VARCHAR2 ,
102 X_UNT_ISS VARCHAR2 ,
103 X_UNT_PRC NUMBER ,
104 X_ORG_LN_ITM NUMBER ,
105 X_EXCLUDE_FLAG VARCHAR2 ,
106 X_PROCESSED_FLAG VARCHAR2 ,
107 X_RUN_DATE DATE ,
108 X_SET_OF_BOOKS_ID NUMBER ,
109 X_EXCEPTION_CATEGORY VARCHAR2 ,
110 X_ORG_ID NUMBER ,
111 X_LAST_UPDATE_DATE DATE ,
112 X_LAST_UPDATED_BY NUMBER ,
113 X_LAST_UPDATE_LOGIN NUMBER ,
114 X_CREATION_DATE DATE ,
115 X_CREATED_BY NUMBER ,
116 X_ATTRIBUTE1 VARCHAR2 ,
117 X_ATTRIBUTE2 VARCHAR2 ,
118 X_ATTRIBUTE3 VARCHAR2 ,
119 X_ATTRIBUTE4 VARCHAR2 ,
120 X_ATTRIBUTE5 VARCHAR2 ,
121 X_ATTRIBUTE6 VARCHAR2 ,
122 X_ATTRIBUTE7 VARCHAR2 ,
123 X_ATTRIBUTE8 VARCHAR2 ,
124 X_ATTRIBUTE9 VARCHAR2 ,
125 X_ATTRIBUTE10 VARCHAR2 ,
126 X_ATTRIBUTE11 VARCHAR2 ,
127 X_ATTRIBUTE12 VARCHAR2 ,
128 X_ATTRIBUTE13 VARCHAR2 ,
129 X_ATTRIBUTE14 VARCHAR2 ,
130 X_ATTRIBUTE15 VARCHAR2 ,
131 -- commented the below code for the Bug $ 2145501
132 /* X_ATTRIBUTE16 VARCHAR2 ,
133 X_ATTRIBUTE17 VARCHAR2 ,
134 X_ATTRIBUTE18 VARCHAR2 ,
135 X_ATTRIBUTE19 VARCHAR2 ,
136 X_ATTRIBUTE20 VARCHAR2 ,
137 X_ATTRIBUTE21 VARCHAR2 ,
138 X_ATTRIBUTE22 VARCHAR2 ,
139 X_ATTRIBUTE23 VARCHAR2 ,
140 X_ATTRIBUTE24 VARCHAR2 ,
141 X_ATTRIBUTE25 VARCHAR2 ,
142 X_ATTRIBUTE26 VARCHAR2 ,
143 X_ATTRIBUTE27 VARCHAR2 ,
144 X_ATTRIBUTE28 VARCHAR2 ,
145 X_ATTRIBUTE29 VARCHAR2 ,
146 X_ATTRIBUTE30 VARCHAR2 , */
147 X_ATTRIBUTE_CATEGORY VARCHAR2 ,
148 X_ADJUSTMENT_ID NUMBER ,
149 X_AMOUNT NUMBER ,
150 X_REPORT_FLAG VARCHAR2 ,
151 X_CNT_NM VARCHAR2 ,
152 X_CNT_PHN_NR VARCHAR2 ,
153 X_TRX_LINE_NO NUMBER ,
154 X_ORG_DO_SYM VARCHAR2 ,
155 X_IPAC_BILLING_ID NUMBER
156 );
157
158 PROCEDURE Delete_Row(X_ROWID IN OUT NOCOPY VARCHAR2
159 );
160
161 PROCEDURE Lock_Row( X_ROWID IN OUT NOCOPY VARCHAR2,
162 X_CUSTOMER_TRX_ID NUMBER ,
163 X_CUSTOMER_ID NUMBER ,
164 X_TRX_NUMBER VARCHAR2 ,
165 X_SET_OF_BOOKS_ID NUMBER ,
166 X_IPAC_BILLING_ID NUMBER
167
168 );
169
170 END FV_IPAC_TRANSACTIONS_SUMM_PKG;
|
|
|