[Home] [Help]
PACKAGE: APPS.AR_LL_RCV_SUMMARY_PKG
Source
1 PACKAGE AR_LL_RCV_SUMMARY_PKG AS
2 /*$Header: ARRWSLTS.pls 120.3.12010000.3 2008/08/26 14:02:44 dgaurab ship $ */
3
4 /*Bug 7311231, Added parameter p_attribute_rec in procedure Insert_Row, Insert_lintax_Rows,
5 Insert_frt_Rows and Insert_chg_Rows */
6 PROCEDURE Insert_Row (
7 X_CASH_RECEIPT_ID IN NUMBER,
8 X_CUSTOMER_TRX_ID IN NUMBER,
9 X_lin in number,
10 x_tax in number ,
11 X_frt in number,
12 x_chg in number ,
13 X_lin_dsc in number,
14 x_tax_dsc in number ,
15 X_frt_dsc in number,
16 x_CREATED_BY_MODULE in varchar2
17 ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
18 ,x_inv_to_rct_rate in number default 1
19 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
20 ,x_attribute_category IN VARCHAR2 DEFAULT NULL
21 ,x_attribute1 IN VARCHAR2 DEFAULT NULL
22 ,x_attribute2 IN VARCHAR2 DEFAULT NULL
23 ,x_attribute3 IN VARCHAR2 DEFAULT NULL
24 ,x_attribute4 IN VARCHAR2 DEFAULT NULL
25 ,x_attribute5 IN VARCHAR2 DEFAULT NULL
26 ,x_attribute6 IN VARCHAR2 DEFAULT NULL
27 ,x_attribute7 IN VARCHAR2 DEFAULT NULL
28 ,x_attribute8 IN VARCHAR2 DEFAULT NULL
29 ,x_attribute9 IN VARCHAR2 DEFAULT NULL
30 ,x_attribute10 IN VARCHAR2 DEFAULT NULL
31 ,x_attribute11 IN VARCHAR2 DEFAULT NULL
32 ,x_attribute12 IN VARCHAR2 DEFAULT NULL
33 ,x_attribute13 IN VARCHAR2 DEFAULT NULL
34 ,x_attribute14 IN VARCHAR2 DEFAULT NULL
35 ,x_attribute15 IN VARCHAR2 DEFAULT NULL
36 ) ;
37
38 PROCEDURE Insert_lintax_Rows (
39 X_CASH_RECEIPT_ID IN NUMBER,
40 X_CUSTOMER_TRX_ID IN NUMBER,
41 X_lin in number,
42 x_tax in number ,
43 X_lin_dsc in number,
44 x_tax_dsc in number ,
45 x_CREATED_BY_MODULE in varchar2
46 ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
47 ,x_inv_to_rct_rate in number default 1
48 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
49 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
50 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
51 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
52 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
53 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
54 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
55 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
56 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
57 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
58 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
59 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
60 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
61 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
62 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
63 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
64 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
65 ) ;
66
67 PROCEDURE Insert_frt_Rows (
68 X_CASH_RECEIPT_ID IN NUMBER,
69 X_CUSTOMER_TRX_ID IN NUMBER,
70 X_frt in number,
71 X_frt_dsc in number,
72 x_CREATED_BY_MODULE in varchar2
73 ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
74 ,x_inv_to_rct_rate in number default 1
75 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
76 ,x_comments in varchar2 default NULL /* Bug 5453663 */
77 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
78 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
79 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
80 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
81 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
82 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
83 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
84 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
85 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
86 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
87 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
88 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
89 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
90 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
91 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
92 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
93 ) ;
94
95 PROCEDURE Insert_chg_Rows (
96 X_CASH_RECEIPT_ID IN NUMBER,
97 X_CUSTOMER_TRX_ID IN NUMBER,
98 X_chg in number,
99 x_CREATED_BY_MODULE in varchar2
100 ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
101 ,x_inv_to_rct_rate in number default 1
102 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
103 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
104 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
105 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
106 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
107 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
108 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
109 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
110 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
111 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
112 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
113 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
114 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
115 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
116 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
117 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
118 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
119 );
120
121 PROCEDURE Update_Row (
122 X_CASH_RECEIPT_ID IN NUMBER,
123 X_CUSTOMER_TRX_ID IN NUMBER,
124 X_lin in number,
125 x_tax in number ,
126 X_frt in number,
127 x_chg in number ,
128 X_lin_dsc in number,
129 x_tax_dsc in number ,
130 X_frt_dsc in number,
131 x_CREATED_BY_MODULE in varchar2
132 ,x_inv_curr_code in varchar2 default arpcurr.FunctionalCurrency /* Bug 5189370 */
133 ,x_inv_to_rct_rate in number default 1
134 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
135 );
136
137 PROCEDURE Lock_Row (
138 X_CUSTOMER_TRX_ID IN NUMBER,
139 X_CASH_RECEIPT_ID IN NUMBER,
140 x_object_Version_number in number
141 ) ;
142
143 PROCEDURE Delete_Row (
144 X_CUSTOMER_TRX_ID IN NUMBER,
145 X_CASH_RECEIPT_ID IN NUMBER
146 );
147
148
149 END AR_LL_RCV_SUMMARY_PKG ;
150