[Home] [Help]
PACKAGE: APPS.OKL_ALS_PVT
Source
1 Package OKL_ALS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSALSS.pls 120.3 2007/02/27 06:59:41 dpsingh noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ALS_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 object_version_number NUMBER := okl_api.G_MISS_NUM,
9 org_id NUMBER := okl_api.G_MISS_NUM,
10 AE_LINE_TYPE OKL_AG_SOURCE_MAPS.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
11 SOURCE OKL_AG_SOURCE_MAPS.SOURCE%TYPE := okl_api.G_MISS_CHAR,
12 PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
13 SELECT_COLUMN OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
14 created_by NUMBER := okl_api.G_MISS_NUM,
15 creation_date OKL_AG_SOURCE_MAPS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
16 last_updated_by NUMBER := okl_api.G_MISS_NUM,
17 last_update_date OKL_AG_SOURCE_MAPS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
18 last_update_login NUMBER := okl_api.G_MISS_NUM);
19 g_miss_ALS_rec ALS_rec_type;
20 TYPE ALS_tbl_type IS TABLE OF ALS_rec_type
21 INDEX BY BINARY_INTEGER;
22 TYPE ALSv_rec_type IS RECORD (
23 id NUMBER := okl_api.G_MISS_NUM,
24 object_version_number NUMBER := okl_api.G_MISS_NUM,
25 AE_LINE_TYPE OKL_AG_SOURCE_MAPS_ALL.AE_LINE_TYPE%TYPE := okl_api.G_MISS_CHAR,
26 SOURCE OKL_AG_SOURCE_MAPS_ALL.SOURCE%TYPE := okl_api.G_MISS_CHAR,
27 PRIMARY_KEY_COLUMN OKL_AG_SOURCE_MAPS_ALL.PRIMARY_KEY_COLUMN%TYPE := okl_api.G_MISS_CHAR,
28 SELECT_COLUMN OKL_AG_SOURCE_MAPS_ALL.SELECT_COLUMN%TYPE := okl_api.G_MISS_CHAR,
29 org_id NUMBER := okl_api.G_MISS_NUM,
30 created_by NUMBER := okl_api.G_MISS_NUM,
31 creation_date OKL_AG_SOURCE_MAPS_ALL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
32 last_updated_by NUMBER := okl_api.G_MISS_NUM,
33 last_update_date OKL_AG_SOURCE_MAPS_ALL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
34 last_update_login NUMBER := okl_api.G_MISS_NUM);
35 g_miss_ALSv_rec ALSv_rec_type;
36 TYPE ALSv_tbl_type IS TABLE OF ALSv_rec_type
37 INDEX BY BINARY_INTEGER;
38 ---------------------------------------------------------------------------
39 -- GLOBAL MESSAGE CONSTANTS
40 ---------------------------------------------------------------------------
41 -- Added 04/27/2001 Robin Edwin for validate attribute
42 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
43 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
44 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
45 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
46 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
47 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
48 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
49 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
50 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
51 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
52 G_OKL_ENTITY_NOT_UNIQUE CONSTANT VARCHAR2(200) := 'OKL_ENTITY_NOT_UNIQUE';
53 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
54 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
55 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
56 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
57 ---------------------------------------------------------------------------
58 -- GLOBAL VARIABLES
59 ---------------------------------------------------------------------------
60 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ALS_PVT';
61 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
62 ---------------------------------------------------------------------------
63 -- Procedures and Functions
64 ---------------------------------------------------------------------------
65 PROCEDURE qc;
66 PROCEDURE change_version;
67 PROCEDURE api_copy;
68 PROCEDURE insert_row(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_ALSv_rec IN ALSv_rec_type,
75 x_ALSv_rec OUT NOCOPY ALSv_rec_type);
76 PROCEDURE insert_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_ALSv_tbl IN ALSv_tbl_type,
83 x_ALSv_tbl OUT NOCOPY ALSv_tbl_type);
84 PROCEDURE lock_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_ALSv_rec IN ALSv_rec_type);
91 PROCEDURE lock_row(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_ALSv_tbl IN ALSv_tbl_type);
98 PROCEDURE update_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_ALSv_rec IN ALSv_rec_type,
105 x_ALSv_rec OUT NOCOPY ALSv_rec_type);
106 PROCEDURE update_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_ALSv_tbl IN ALSv_tbl_type,
113 x_ALSv_tbl OUT NOCOPY ALSv_tbl_type);
114 PROCEDURE delete_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_ALSv_rec IN ALSv_rec_type);
121 PROCEDURE delete_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_ALSv_tbl IN ALSv_tbl_type);
128 PROCEDURE validate_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_ALSv_rec IN ALSv_rec_type);
135 PROCEDURE validate_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_ALSv_tbl IN ALSv_tbl_type);
142 END OKL_ALS_PVT;