[Home] [Help]
PACKAGE: APPS.IEX_WRITEOFF_OBJECTS_PVT
Source
1 PACKAGE IEX_WRITEOFF_OBJECTS_PVT as
2 /* $Header: iexvwobs.pls 120.1 2007/10/31 12:29:32 ehuh ship $ */
3 -- Start of Comments
4 -- Package name : IEX_WRITEOFF_OBJECTS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 ------------------------------------------------------------------------------
11 -- Global Variables
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_WRITEOFF_OBJECTS_PVT';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 G_DEFAULT_NUM_REC_FETCH CONSTANT NUMBER := 30;
16 G_YES CONSTANT VARCHAR2(1) := 'Y';
17 G_NO CONSTANT VARCHAR2(1) := 'N';
18 ------------------------------------------------------------------------------
19
20
21 -- Default number of records fetch per call
22 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23
24 TYPE writeoff_obj_rec_type IS RECORD
25 (
26 WRITEOFF_OBJECT_ID NUMBER ,
27 WRITEOFF_ID NUMBER ,
28 OBJECT_VERSION_NUMBER NUMBER ,
29 CONTRACT_ID NUMBER ,
30 CONS_INVOICE_ID NUMBER ,
31 CONS_INVOICE_LINE_ID NUMBER ,
32 TRANSACTION_ID NUMBER ,
33 ADJUSTMENT_AMOUNT NUMBER ,
34 ADJUSTMENT_REASON_CODE VARCHAR2(30) ,
35 RECEVIABLES_ADJUSTMENT_ID NUMBER ,
36 REQUEST_ID NUMBER ,
37 PROGRAM_APPLICATION_ID NUMBER ,
38 PROGRAM_ID NUMBER ,
39 PROGRAM_UPDATE_DATE DATE ,
40 ATTRIBUTE_CATEGORY VARCHAR2(240) ,
41 ATTRIBUTE1 VARCHAR2(240) ,
42 ATTRIBUTE2 VARCHAR2(240) ,
43 ATTRIBUTE3 VARCHAR2(240) ,
44 ATTRIBUTE4 VARCHAR2(240) ,
45 ATTRIBUTE5 VARCHAR2(240) ,
46 ATTRIBUTE6 VARCHAR2(240) ,
47 ATTRIBUTE7 VARCHAR2(240) ,
48 ATTRIBUTE8 VARCHAR2(240) ,
49 ATTRIBUTE9 VARCHAR2(240) ,
50 ATTRIBUTE10 VARCHAR2(240) ,
51 ATTRIBUTE11 VARCHAR2(240) ,
52 ATTRIBUTE12 VARCHAR2(240) ,
53 ATTRIBUTE13 VARCHAR2(240) ,
54 ATTRIBUTE14 VARCHAR2(240) ,
55 ATTRIBUTE15 VARCHAR2(240) ,
56 CREATED_BY NUMBER ,
57 CREATION_DATE DATE ,
58 LAST_UPDATED_BY NUMBER ,
59 LAST_UPDATE_DATE DATE ,
60 LAST_UPDATE_LOGIN NUMBER,
61 WRITEOFF_STATUS VARCHAR2(15),
62 WRITEOFF_TYPE_ID NUMBER,
63 WRITEOFF_TYPE VARCHAR2(50),
64 customer_trx_id number,
65 customer_trx_line_id number);
66
67 G_MISS_writeoff_obj_rec writeoff_obj_rec_type;
68 TYPE writeoff_obj_tbl_Type IS TABLE OF writeoff_obj_rec_type
69 INDEX BY BINARY_INTEGER;
70 G_MISS_writeoff_obj_tbl writeoff_obj_tbl_Type;
71
72 PROCEDURE create_writeoff_objects(
73 P_Api_Version_Number IN NUMBER,
74 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
75 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
76 P_writeoff_obj_rec IN writeoff_obj_rec_type,
77 X_writeoff_object_id OUT NOCOPY NUMBER
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 PROCEDURE update_writeoff_objects(
84 P_Api_Version_Number IN NUMBER,
85 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
86 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
87 P_writeoff_obj_rec IN writeoff_obj_rec_type,
88 x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2
91 ,XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
92 );
93
94 PROCEDURE delete_writeoff_objects(
95 P_Api_Version_Number IN NUMBER,
96 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
97 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_writeoff_object_id IN NUMBER ,
99 x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102
103 );
104
105
106 End IEX_WRITEOFF_OBJECTS_PVT;