[Home] [Help]
PACKAGE: APPS.OKE_PARTY_PVT
Source
1 PACKAGE OKE_PARTY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKEVFPPS.pls 115.6 2002/08/14 01:45:05 alaw ship $*/
3 -- GLOBAL DATA STRUCTURES
4
5 TYPE party_rec_type IS RECORD(
6 POOL_PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
7 FUNDING_POOL_ID NUMBER:= OKE_API.G_MISS_NUM,
8 PARTY_ID NUMBER:= OKE_API.G_MISS_NUM,
9 CURRENCY_CODE OKE_POOL_PARTIES.CURRENCY_CODE%TYPE:=OKE_API.G_MISS_CHAR,
10 CONVERSION_TYPE OKE_POOL_PARTIES.CONVERSION_TYPE%TYPE:=OKE_API.G_MISS_CHAR,
11 CONVERSION_DATE DATE:= OKE_API.G_MISS_DATE,
12 CONVERSION_RATE NUMBER:= OKE_API.G_MISS_NUM,
13 INITIAL_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
14 AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
15 AVAILABLE_AMOUNT NUMBER:= OKE_API.G_MISS_NUM,
16 START_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
17 END_DATE_ACTIVE DATE:= OKE_API.G_MISS_DATE,
18
19 CREATION_DATE DATE:= OKE_API.G_MISS_DATE,
20 CREATED_BY NUMBER:= OKE_API.G_MISS_NUM,
21 LAST_UPDATE_DATE DATE:= OKE_API.G_MISS_DATE,
22 LAST_UPDATED_BY NUMBER:= OKE_API.G_MISS_NUM,
23 LAST_UPDATE_LOGIN NUMBER:= OKE_API.G_MISS_NUM,
24 ATTRIBUTE_CATEGORY OKE_POOL_PARTIES.ATTRIBUTE_CATEGORY%TYPE:=OKE_API.G_MISS_CHAR,
25 ATTRIBUTE1 OKE_POOL_PARTIES.ATTRIBUTE1%TYPE:=OKE_API.G_MISS_CHAR,
26 ATTRIBUTE2 OKE_POOL_PARTIES.ATTRIBUTE2%TYPE:=OKE_API.G_MISS_CHAR,
27 ATTRIBUTE3 OKE_POOL_PARTIES.ATTRIBUTE3%TYPE:=OKE_API.G_MISS_CHAR,
28 ATTRIBUTE4 OKE_POOL_PARTIES.ATTRIBUTE4%TYPE:=OKE_API.G_MISS_CHAR,
29 ATTRIBUTE5 OKE_POOL_PARTIES.ATTRIBUTE5%TYPE:=OKE_API.G_MISS_CHAR,
30 ATTRIBUTE6 OKE_POOL_PARTIES.ATTRIBUTE6%TYPE:=OKE_API.G_MISS_CHAR,
31 ATTRIBUTE7 OKE_POOL_PARTIES.ATTRIBUTE7%TYPE:=OKE_API.G_MISS_CHAR,
32 ATTRIBUTE8 OKE_POOL_PARTIES.ATTRIBUTE8%TYPE:=OKE_API.G_MISS_CHAR,
33 ATTRIBUTE9 OKE_POOL_PARTIES.ATTRIBUTE9%TYPE:=OKE_API.G_MISS_CHAR,
34 ATTRIBUTE10 OKE_POOL_PARTIES.ATTRIBUTE10%TYPE:=OKE_API.G_MISS_CHAR,
35 ATTRIBUTE11 OKE_POOL_PARTIES.ATTRIBUTE11%TYPE:=OKE_API.G_MISS_CHAR,
36 ATTRIBUTE12 OKE_POOL_PARTIES.ATTRIBUTE12%TYPE:=OKE_API.G_MISS_CHAR,
37 ATTRIBUTE13 OKE_POOL_PARTIES.ATTRIBUTE13%TYPE:=OKE_API.G_MISS_CHAR,
38 ATTRIBUTE14 OKE_POOL_PARTIES.ATTRIBUTE14%TYPE:=OKE_API.G_MISS_CHAR,
39 ATTRIBUTE15 OKE_POOL_PARTIES.ATTRIBUTE15%TYPE:=OKE_API.G_MISS_CHAR
40 );
41
42 TYPE party_tbl_type IS TABLE OF party_rec_type
43 INDEX BY BINARY_INTEGER;
44
45 -- GLOBAL MESSAGE CONSTANTS
46
47 G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
48
49 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
50 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
51
52 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
53
54 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
55 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
56 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
57 G_CHILD_RECORD_FOUND CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_RECORD_FOUND;
58 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := OKE_API.G_NO_PARENT_RECORD;
59 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := OKE_API.G_UNEXPECTED_ERROR;
60
61 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
62 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
63 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
64 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLERRM_TOKEN;
65 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := OKE_API.G_SQLCODE_TOKEN;
66 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_PARTY_PVT';
67 G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
68 G_VIEW CONSTANT VARCHAR2(200) := 'OKE_POOL_PARTIES';
69
70 G_EXCEPTION_HALT_VALIDATION exception;
71
72 -- Procedures and functions
73
74 PROCEDURE insert_row(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_party_rec IN party_rec_type,
81 x_party_rec OUT NOCOPY party_rec_type);
82
83 PROCEDURE insert_row(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_party_tbl IN party_tbl_type,
90 x_party_tbl OUT NOCOPY party_tbl_type);
91
92 PROCEDURE update_row(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_party_rec IN party_rec_type,
99 x_party_rec OUT NOCOPY party_rec_type);
100
101 PROCEDURE update_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_party_tbl IN party_tbl_type,
108 x_party_tbl OUT NOCOPY party_tbl_type);
109
110
111
112 PROCEDURE delete_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_party_rec IN party_rec_type);
119
120 PROCEDURE delete_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_party_tbl IN party_tbl_type);
127
128
129 PROCEDURE lock_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_party_rec IN party_rec_type);
136
137
138 END OKE_PARTY_PVT;
139