DBA Data[Home] [Help]

PACKAGE: APPS.IEX_WRITEOFF_OBJECTS_PUB

Source


1 PACKAGE IEX_WRITEOFF_OBJECTS_PUB as
2 /* $Header: iexpwobs.pls 120.0 2004/01/24 03:20:16 appldev noship $ */
3 -- Start of Comments
4 -- Package name     : IEX_WRITEOFF_OBJECTS_PUB
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 subtype writeoff_obj_rec_type         is iex_writeoff_objects_pvt.writeoff_obj_rec_type;
11 g_miss_writeoff_obj_rec_type          writeoff_obj_rec_type ;
12 
13 ------------------------------------------------------------------------------
14  -- Global Variables
15  G_PKG_NAME              CONSTANT VARCHAR2(200) := 'IEX_WRITEOFF_OBJECTS_PUB';
16  G_SQLERRM_TOKEN         CONSTANT VARCHAR2(200) := 'SQLERRM';
17  G_SQLCODE_TOKEN         CONSTANT VARCHAR2(200) := 'SQLCODE';
18  G_DEFAULT_NUM_REC_FETCH CONSTANT NUMBER := 30;
19  G_YES                   CONSTANT VARCHAR2(1) := 'Y';
20  G_NO                    CONSTANT VARCHAR2(1) := 'N';
21 ------------------------------------------------------------------------------
22 
23 PROCEDURE create_writeoff_objects(
24     P_Api_Version_Number         IN   NUMBER,
25     P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
26     P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
27     P_writeoff_obj_rec           IN   writeoff_obj_rec_type,
28     X_writeoff_object_id         OUT  NOCOPY NUMBER,
29     x_return_status              OUT  NOCOPY VARCHAR2,
30     x_msg_count                  OUT  NOCOPY NUMBER,
31     x_msg_data                   OUT  NOCOPY VARCHAR2
32     );
33 
34 PROCEDURE update_writeoff_objects(
35     P_Api_Version_Number         IN   NUMBER,
36     P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
37     P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
38     P_writeoff_obj_rec           IN   writeoff_obj_rec_type,
39     x_return_status              OUT  NOCOPY VARCHAR2,
40     x_msg_count                  OUT  NOCOPY NUMBER,
41     x_msg_data                   OUT  NOCOPY VARCHAR2,
42     XO_OBJECT_VERSION_NUMBER     OUT  NOCOPY NUMBER
43     );
44 
45 PROCEDURE  delete_writeoff_objects(
46     P_Api_Version_Number         IN   NUMBER,
47     P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
48     P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
49     p_writeoff_object_id         IN   NUMBER,
50     x_return_status              OUT  NOCOPY VARCHAR2,
51     x_msg_count                  OUT  NOCOPY NUMBER,
52     x_msg_data                   OUT  NOCOPY VARCHAR2
53      );
54 
55 
56 End IEX_WRITEOFF_OBJECTS_PUB;