PACKAGE: APPS.OE_PAYMENTS_UTIL

Source

1 PACKAGE oe_payments_Util AS
2 /* $Header: OEXULCMS.pls 120.0 2005/05/31 23:44:15 appldev noship $ */
3 
4 Type Payment_Types_Rec_Type  is RECORD
5 (   PAYMENT_TRX_ID			NUMBER
6 ,   COMMITMENT_APPLIED_AMOUNT	   	NUMBER
7 ,   COMMITMENT_INTERFACED_AMOUNT	NUMBER
8 /* START PREPAYMENT */
9 ,   PAYMENT_SET_ID                      NUMBER
10 ,   PREPAID_AMOUNT                      NUMBER
11 ,   PAYMENT_TYPE_CODE                   VARCHAR2(30)
12 ,   CREDIT_CARD_CODE                    VARCHAR2(30)
13 ,   CREDIT_CARD_NUMBER                  VARCHAR2(80)
14 ,   CREDIT_CARD_HOLDER_NAME             VARCHAR2(80)
15 ,   CREDIT_CARD_EXPIRATION_DATE         DATE
16 /* END PREPAYMENT */
17 ,   PAYMENT_LEVEL_CODE		VARCHAR2(30)
18 ,   HEADER_ID				NUMBER
19 ,   LINE_ID				NUMBER
20 ,   CREATION_DATE		DATE
21 ,   CREATED_BY			NUMBER
22 ,   LAST_UPDATE_DATE		DATE
23 ,   LAST_UPDATED_BY			NUMBER
24 ,   LAST_UPDATE_LOGIN			NUMBER
25 ,   REQUEST_ID				NUMBER
26 ,   PROGRAM_APPLICATION_ID		NUMBER
27 ,   PROGRAM_ID				NUMBER
28 ,   PROGRAM_UPDATE_DATE			DATE
29 ,   CONTEXT				VARCHAR2(30)
30 ,   ATTRIBUTE1				VARCHAR2(240)
31 ,   ATTRIBUTE2				VARCHAR2(240)
32 ,   ATTRIBUTE3				VARCHAR2(240)
33 ,   ATTRIBUTE4				VARCHAR2(240)
34 ,   ATTRIBUTE5				VARCHAR2(240)
35 ,   ATTRIBUTE6				VARCHAR2(240)
36 ,   ATTRIBUTE7				VARCHAR2(240)
37 ,   ATTRIBUTE8				VARCHAR2(240)
38 ,   ATTRIBUTE9				VARCHAR2(240)
39 ,   ATTRIBUTE10				VARCHAR2(240)
40 ,   ATTRIBUTE11				VARCHAR2(240)
41 ,   ATTRIBUTE12				VARCHAR2(240)
42 ,   ATTRIBUTE13				VARCHAR2(240)
43 ,   ATTRIBUTE14				VARCHAR2(240)
44 ,   ATTRIBUTE15				VARCHAR2(240)
45 ,   db_flag				VARCHAR2(1)
46 ,   operation				VARCHAR2(30)
47 ,   return_status			VARCHAR2(1)
48 ,   payment_amount                      NUMBER
49 ,   payment_number                      NUMBER
50 );
51 
52 TYPE  Payment_Types_Tbl_Type is TABLE of Payment_Types_Rec_Type
53 	INDEX by BINARY_INTEGER;
54 
55 PROCEDURE Update_Row
56 (   p_payment_types_rec	IN OUT NOCOPY Payment_Types_Rec_Type
57 );
58 
59 --  Procedure Insert_Row
60 
61 PROCEDURE Insert_Row
62 (   p_payment_types_rec	IN OUT NOCOPY Payment_Types_Rec_Type
63 );
64 
65 --  Procedure Delete_Row
66 
67 PROCEDURE Delete_Row
68 (   p_payment_trx_id	IN  NUMBER := FND_API.G_MISS_NUM
69 ,   p_header_id       	IN  NUMBER := FND_API.G_MISS_NUM
70 ,   p_line_id       	IN  NUMBER := FND_API.G_MISS_NUM
71 );
72 
73 --  Procedure Query_Row
74 PROCEDURE Query_Row
75 (   p_payment_trx_id       	IN  	NUMBER
76 ,   p_header_id			IN 	NUMBER
77 ,   p_line_id				IN 	NUMBER
78 ,   x_payment_types_rec 	IN OUT NOCOPY  Payment_Types_Rec_Type
79 );
80 
81 --  Procedure Query_Rows
82 PROCEDURE Query_Rows
83 (   p_payment_trx_id	IN  NUMBER := FND_API.G_MISS_NUM
84 ,   p_Header_id          IN  NUMBER := FND_API.G_MISS_NUM
85 ,   p_line_id            IN  NUMBER := FND_API.G_MISS_NUM
86 ,   x_Payment_Types_Tbl	IN OUT NOCOPY Payment_Types_Tbl_Type
87 , x_return_status OUT NOCOPY VARCHAR2
88 
89 );
90 
91 FUNCTION Get_Uninvoiced_Commitment_Bal
92 	(p_customer_trx_id IN NUMBER
93 	)
94 RETURN NUMBER;
95 
96 
97 /***
98 --  Procedure       lock_Row
99 PROCEDURE Lock_Row
100 ( x_return_status OUT NOCOPY VARCHAR2
101 
102 ,   p_x_payment_types_rec     IN OUT NOCOPY Payment_Types_Rec_Type
103 ,   p_payment_id           	IN NUMBER
104                               	:= FND_API.G_MISS_NUM
105 );
106 
107 --  Procedure       lock_Rows
108 PROCEDURE Lock_Rows
109 (   p_payment_id         IN NUMBER
110                          	:= FND_API.G_MISS_NUM
111 ,   p_line_id           	IN NUMBER
112                          	:= FND_API.G_MISS_NUM
113 ,   x_payment_types_tbl  OUT NOCOPY Payment_Types_Tbl_Type
114 , x_return_status OUT NOCOPY VARCHAR2
115 
116 );
117 ***/
118 
119 
120 END oe_payments_Util;