1 PACKAGE RA_LL_RCV_GROUPS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARRWGLTS.pls 120.2 2006/01/19 00:10:37 ramenon noship $ */
3
4 PROCEDURE Insert_Row (
5 X_ROWID IN OUT NOCOPY ROWID,
6 X_CASH_RECEIPT_ID IN NUMBER,
7 X_GROUP_ID IN NUMBER,
8 X_CUSTOMER_TRX_ID IN NUMBER,
9 X_line_only in number,
10 x_tax_only in number ,
11 X_lin_dsc in number,
12 x_tax_dsc in number ,
13 x_CREATED_BY_MODULE in varchar2
14 -- Oct 04 added two param below
15 ,x_inv_to_rct_rate in number default 1
16 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
17 );
18
19
20
21 PROCEDURE Update_Row (
22 X_ROWID IN OUT NOCOPY ROWID,
23 X_CASH_RECEIPT_ID IN NUMBER,
24 X_GROUP_ID IN NUMBER,
25 X_CUSTOMER_TRX_ID IN NUMBER,
26 X_line_only in number,
27 x_tax_only in number ,
28 X_lin_dsc in number,
29 x_tax_dsc in number ,
30 x_CREATED_BY_MODULE in varchar2
31 -- Oct 04 added two param below
32 ,x_inv_to_rct_rate in number default 1
33 ,x_rct_curr_code in varchar2 := arpcurr.FunctionalCurrency
34 ) ;
35
36 PROCEDURE Lock_Row (
37 X_CUSTOMER_TRX_ID IN NUMBER,
38 X_CASH_RECEIPT_ID IN NUMBER,
39 x_object_Version_number in number
40 ) ;
41
42
43
44
45 PROCEDURE Select_Row (
46 X_APPLY_TO IN OUT NOCOPY VARCHAR2,
47 X_TAX_BALANCE IN OUT NOCOPY NUMBER,
48 X_CUSTOMER_TRX_LINE_ID IN OUT NOCOPY NUMBER,
49 X_COMMENTS IN OUT NOCOPY VARCHAR2,
50 X_TAX IN OUT NOCOPY NUMBER,
51 X_CASH_RECEIPT_ID IN OUT NOCOPY NUMBER,
52 X_ATTRIBUTE_CATEGORY IN OUT NOCOPY VARCHAR2,
53 X_ALLOCATED_RECEIPT_AMOUNT IN OUT NOCOPY NUMBER,
54 X_GROUP_ID IN OUT NOCOPY NUMBER,
55 X_TAX_DISCOUNT IN OUT NOCOPY NUMBER,
56 X_AMOUNT IN OUT NOCOPY NUMBER,
57 X_LINE_DISCOUNT IN OUT NOCOPY NUMBER,
58 X_ATTRIBUTE9 IN OUT NOCOPY VARCHAR2,
59 X_ATTRIBUTE8 IN OUT NOCOPY VARCHAR2,
60 X_ATTRIBUTE7 IN OUT NOCOPY VARCHAR2,
61 X_ATTRIBUTE6 IN OUT NOCOPY VARCHAR2,
62 X_ATTRIBUTE5 IN OUT NOCOPY VARCHAR2,
63 X_ATTRIBUTE4 IN OUT NOCOPY VARCHAR2,
64 X_ATTRIBUTE3 IN OUT NOCOPY VARCHAR2,
65 X_ATTRIBUTE2 IN OUT NOCOPY VARCHAR2,
66 X_ATTRIBUTE1 IN OUT NOCOPY VARCHAR2,
67 X_LINE_BALANCE IN OUT NOCOPY NUMBER,
68 X_ATTRIBUTE15 IN OUT NOCOPY VARCHAR2,
69 X_ATTRIBUTE14 IN OUT NOCOPY VARCHAR2,
70 X_ATTRIBUTE13 IN OUT NOCOPY VARCHAR2,
71 X_ATTRIBUTE12 IN OUT NOCOPY VARCHAR2,
72 X_ATTRIBUTE11 IN OUT NOCOPY VARCHAR2,
73 X_ATTRIBUTE10 IN OUT NOCOPY VARCHAR2
74 ) ;
75
76 PROCEDURE Delete_Row (
77 X_GROUP_ID IN NUMBER,
78 X_CUSTOMER_TRX_ID IN NUMBER,
79 X_CASH_RECEIPT_ID IN NUMBER
80 ) ;
81
82
83 END RA_LL_RCV_GROUPS_PKG;
84