DBA Data[Home] [Help]

APPS.AMS_CODE_DEFINITION_PVT dependencies on FND_API

Line 48: creation_date DATE := FND_API.G_MISS_DATE,

44:
45: --===================================================================
46: TYPE code_def_rec_type IS RECORD
47: (
48: creation_date DATE := FND_API.G_MISS_DATE,
49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 49: last_update_date DATE := FND_API.G_MISS_DATE,

45: --===================================================================
46: TYPE code_def_rec_type IS RECORD
47: (
48: creation_date DATE := FND_API.G_MISS_DATE,
49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 50: created_by NUMBER := FND_API.G_MISS_NUM,

46: TYPE code_def_rec_type IS RECORD
47: (
48: creation_date DATE := FND_API.G_MISS_DATE,
49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 51: last_updated_by NUMBER := FND_API.G_MISS_NUM,

47: (
48: creation_date DATE := FND_API.G_MISS_DATE,
49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: last_update_login NUMBER := FND_API.G_MISS_NUM,

48: creation_date DATE := FND_API.G_MISS_DATE,
49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,

Line 53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

49: last_update_date DATE := FND_API.G_MISS_DATE,
50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM

Line 54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

50: created_by NUMBER := FND_API.G_MISS_NUM,
51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM
58: );

Line 55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: last_updated_by NUMBER := FND_API.G_MISS_NUM,
52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM
58: );
59:

Line 56: code_definition_id NUMBER := FND_API.G_MISS_NUM,

52: last_update_login NUMBER := FND_API.G_MISS_NUM,
53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_code_def_rec code_def_rec_type;

Line 57: object_version_number NUMBER := FND_API.G_MISS_NUM

53: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
54: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: object_def VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: code_definition_id NUMBER := FND_API.G_MISS_NUM,
57: object_version_number NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: g_miss_code_def_rec code_def_rec_type;
61: TYPE code_def_tbl_type IS TABLE OF code_def_rec_type INDEX BY BINARY_INTEGER;

Line 77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

73: -- Parameters
74: --
75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_code_def_rec IN code_def_rec_type Required
81: --

Line 78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

74: --
75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_code_def_rec IN code_def_rec_type Required
81: --
82: -- OUT

Line 79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

75: -- IN
76: -- p_api_version_number IN NUMBER Required
77: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
78: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
79: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_code_def_rec IN code_def_rec_type Required
81: --
82: -- OUT
83: -- x_return_status OUT VARCHAR2

Line 96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

92: --
93:
94: PROCEDURE Create_Code_Definition(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,

Line 97: p_commit IN VARCHAR2 := FND_API.G_FALSE,

93:
94: PROCEDURE Create_Code_Definition(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,

Line 98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

94: PROCEDURE Create_Code_Definition(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99:
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,

Line 121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

117: -- Parameters
118: --
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_code_def_rec IN code_def_rec_type Required
125: --

Line 122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

118: --
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_code_def_rec IN code_def_rec_type Required
125: --
126: -- OUT

Line 123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- p_code_def_rec IN code_def_rec_type Required
125: --
126: -- OUT
127: -- x_return_status OUT VARCHAR2

Line 140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

136: --
137:
138: PROCEDURE Update_Code_Definition(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,

Line 141: p_commit IN VARCHAR2 := FND_API.G_FALSE,

137:
138: PROCEDURE Update_Code_Definition(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,

Line 142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

138: PROCEDURE Update_Code_Definition(
139: p_api_version_number IN NUMBER,
140: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
141: p_commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143:
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,

Line 165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

161: -- Parameters
162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_CODE_DEFINITION_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_CODE_DEFINITION_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL
170: --

Line 167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_CODE_DEFINITION_ID IN NUMBER
169: -- p_object_version_number IN NUMBER Optional Default = NULL
170: --
171: -- OUT

Line 185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

181: --
182:
183: PROCEDURE Delete_Code_Definition(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

Line 186: p_commit IN VARCHAR2 := FND_API.G_FALSE,

182:
183: PROCEDURE Delete_Code_Definition(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,

Line 187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

183: PROCEDURE Delete_Code_Definition(
184: p_api_version_number IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_code_definition_id IN NUMBER,

Line 208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

204: -- Parameters
205: --
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_code_def_rec IN code_def_rec_type Required
212: --

Line 209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

205: --
206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_code_def_rec IN code_def_rec_type Required
212: --
213: -- OUT

Line 210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

206: -- IN
207: -- p_api_version_number IN NUMBER Required
208: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
209: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
210: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
211: -- p_code_def_rec IN code_def_rec_type Required
212: --
213: -- OUT
214: -- x_return_status OUT VARCHAR2

Line 227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

223: --
224:
225: PROCEDURE Lock_Code_Definition(
226: p_api_version_number IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
228:
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

247: -- End of Comments
248:
249: PROCEDURE Validate_code_definition(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: p_code_def_rec IN code_def_rec_type,
254: p_validation_mode IN VARCHAR2,
255: x_return_status OUT NOCOPY VARCHAR2,

Line 252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

248:
249: PROCEDURE Validate_code_definition(
250: p_api_version_number IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: p_code_def_rec IN code_def_rec_type,
254: p_validation_mode IN VARCHAR2,
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,

Line 290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

286: -- End of Comments
287:
288: PROCEDURE Validate_code_def_rec(
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
293: x_msg_data OUT NOCOPY VARCHAR2,
294: p_code_def_rec IN code_def_rec_type