DBA Data[Home] [Help]

APPS.AMS_LISTSOURCETYPE_PVT dependencies on FND_API

Line 70: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

66: -- the sequence.
67: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
68: -- Raise exception for invalid flag.
69: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
70: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
71: --------------------------------------------------------------------
72: PROCEDURE Create_ListSourceType (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

70: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
71: --------------------------------------------------------------------
72: PROCEDURE Create_ListSourceType (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
75: p_commit IN VARCHAR2 := FND_API.g_false,
76: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
77:
78: x_return_status OUT NOCOPY VARCHAR2,

Line 75: p_commit IN VARCHAR2 := FND_API.g_false,

71: --------------------------------------------------------------------
72: PROCEDURE Create_ListSourceType (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
75: p_commit IN VARCHAR2 := FND_API.g_false,
76: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
77:
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,

Line 76: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

72: PROCEDURE Create_ListSourceType (
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
75: p_commit IN VARCHAR2 := FND_API.g_false,
76: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
77:
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,

Line 107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

103: -- 1. Raise exception if the object_version_number doesn't match.
104: --------------------------------------------------------------------
105: PROCEDURE Delete_ListSourceType (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110:
111: x_return_status OUT NOCOPY VARCHAR2,

Line 108: p_commit IN VARCHAR2 := FND_API.g_false,

104: --------------------------------------------------------------------
105: PROCEDURE Delete_ListSourceType (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110:
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,

Line 109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

105: PROCEDURE Delete_ListSourceType (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110:
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,

Line 138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

134: -- 1. Raise exception if the object_version_number doesn't match.
135: --------------------------------------------------------------------
136: PROCEDURE Lock_ListSourceType (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
141:
142: x_return_status OUT NOCOPY VARCHAR2,

Line 139: p_commit IN VARCHAR2 := FND_API.g_false,

135: --------------------------------------------------------------------
136: PROCEDURE Lock_ListSourceType (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
141:
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,

Line 140: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

136: PROCEDURE Lock_ListSourceType (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
139: p_commit IN VARCHAR2 := FND_API.g_false,
140: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
141:
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,

Line 163: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

159: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.
160: --
161: -- NOTES
162: -- 1. Raise exception if the object_version_number doesn't match.
163: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
164: -- that column won't be updated.
165: --------------------------------------------------------------------
166: PROCEDURE Update_ListSourceType (
167: p_api_version IN NUMBER,

Line 168: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

164: -- that column won't be updated.
165: --------------------------------------------------------------------
166: PROCEDURE Update_ListSourceType (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
169: p_commit IN VARCHAR2 := FND_API.g_false,
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171:
172: x_return_status OUT NOCOPY VARCHAR2,

Line 169: p_commit IN VARCHAR2 := FND_API.g_false,

165: --------------------------------------------------------------------
166: PROCEDURE Update_ListSourceType (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
169: p_commit IN VARCHAR2 := FND_API.g_false,
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171:
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

Line 170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

166: PROCEDURE Update_ListSourceType (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
169: p_commit IN VARCHAR2 := FND_API.g_false,
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171:
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,

Line 192: -- should not be any FND_API.g_miss_char/num/date in it.

188: -- p_listsrctype_rec: the record representing AMS_LIST_SRC_TYPES.
189: --
190: -- NOTES
191: -- 1. p_listsrctype_rec should be the complete list source type record. There
192: -- should not be any FND_API.g_miss_char/num/date in it.
193: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
194: -- an exception, as those values are not handled.
195: --------------------------------------------------------------------
196: PROCEDURE Validate_ListSourceType (

Line 193: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise

189: --
190: -- NOTES
191: -- 1. p_listsrctype_rec should be the complete list source type record. There
192: -- should not be any FND_API.g_miss_char/num/date in it.
193: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
194: -- an exception, as those values are not handled.
195: --------------------------------------------------------------------
196: PROCEDURE Validate_ListSourceType (
197: p_api_version IN NUMBER,

Line 198: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

194: -- an exception, as those values are not handled.
195: --------------------------------------------------------------------
196: PROCEDURE Validate_ListSourceType (
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
199: p_commit IN VARCHAR2 := FND_API.g_false,
200: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
201:
202: x_return_status OUT NOCOPY VARCHAR2,

Line 199: p_commit IN VARCHAR2 := FND_API.g_false,

195: --------------------------------------------------------------------
196: PROCEDURE Validate_ListSourceType (
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
199: p_commit IN VARCHAR2 := FND_API.g_false,
200: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
201:
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,

Line 200: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

196: PROCEDURE Validate_ListSourceType (
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
199: p_commit IN VARCHAR2 := FND_API.g_false,
200: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
201:
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,

Line 238: -- as FND_API.g_miss_char/num/date

234: -- Check the record level business rules.
235: --
236: -- PARAMETERS
237: -- p_listsrctype_rec: the record to be validated; may contain attributes
238: -- as FND_API.g_miss_char/num/date
239: -- p_complete_rec: the complete record after all "g_miss" items
240: -- have been replaced by current database values
241: ---------------------------------------------------------------------
242: PROCEDURE Check_ListSourceType_Record (

Line 254: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

250: -- PROCEDURE
251: -- Init_ListSourceType_Rec
252: --
253: -- PURPOSE
254: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
255: ---------------------------------------------------------------------
256: PROCEDURE Init_ListSourceType_Rec (
257: x_listsrctype_rec OUT NOCOPY ListSourceType_Rec_Type
258: );

Line 267: -- FND_API.g_miss_char/num/date if the user doesn't want to

263: -- Complete_ListSourceType_Rec
264: --
265: -- PURPOSE
266: -- For Update_ListSourceType, some attributes may be passed in as
267: -- FND_API.g_miss_char/num/date if the user doesn't want to
268: -- update those attributes. This procedure will replace the
269: -- "g_miss" attributes with current database values.
270: --
271: -- PARAMETERS

Line 273: -- FND_API.g_miss_char/num/date

269: -- "g_miss" attributes with current database values.
270: --
271: -- PARAMETERS
272: -- p_listdr_rec: the record which may contain attributes as
273: -- FND_API.g_miss_char/num/date
274: -- x_complete_rec: the complete record after all "g_miss" items
275: -- have been replaced by current database values
276: ---------------------------------------------------------------------
277: PROCEDURE Complete_ListSourceType_Rec (