DBA Data[Home] [Help]

APPS.AMS_DELIVKITITEM_PVT dependencies on FND_API

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

51: -- the sequence.
52: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
53: -- Raise exception for invalid flag.
54: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
55: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
56: -- 7. Create a row in AMS_DELIV_KIT_ITEMS table and an attachmenmt will be inserted
57: -- to AMS_ACT_ATTACHMENTS table if AMS_DELIV_KIT_ITEMS.kit_part_included_from_kit_id
58: -- is not null (Open issue 10/12/99 khung)
59: ---------------------------------------------------------------------

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

60:
61: PROCEDURE create_deliv_kit_item
62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65: p_commit IN VARCHAR2 := FND_API.g_false,
66: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67:
68: x_return_status OUT NOCOPY VARCHAR2,

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

61: PROCEDURE create_deliv_kit_item
62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65: p_commit IN VARCHAR2 := FND_API.g_false,
66: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67:
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,

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

62: (
63: p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
65: p_commit IN VARCHAR2 := FND_API.g_false,
66: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
67:
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,

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

94:
95: PROCEDURE delete_deliv_kit_item
96: (
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99: p_commit IN VARCHAR2 := FND_API.g_false,
100:
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,

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

95: PROCEDURE delete_deliv_kit_item
96: (
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
99: p_commit IN VARCHAR2 := FND_API.g_false,
100:
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,

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

117: -- p_deliv_kit_item_rec: the record with new items
118: --
119: -- NOTES
120: -- 1. Raise exception if the object_version_number doesn't match.
121: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
122: -- that column won't be updated.
123: ----------------------------------------------------------------------
124:
125: PROCEDURE update_deliv_kit_item

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

124:
125: PROCEDURE update_deliv_kit_item
126: (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129: p_commit IN VARCHAR2 := FND_API.g_false,
130: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
131:
132: x_return_status OUT NOCOPY VARCHAR2,

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

125: PROCEDURE update_deliv_kit_item
126: (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129: p_commit IN VARCHAR2 := FND_API.g_false,
130: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
131:
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,

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

126: (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129: p_commit IN VARCHAR2 := FND_API.g_false,
130: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
131:
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,

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

153:
154: PROCEDURE lock_deliv_kit_item
155: (
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
158:
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,

Line 181: -- record. There should not be any FND_API.g_miss_char/num/date in it.

177: -- p_deliv_kit_item_rec: the deliverable kit item record to be validated
178: --
179: -- NOTES
180: -- 1. p_deliv_kit_item_rec should be the complete deliverable kit item
181: -- record. There should not be any FND_API.g_miss_char/num/date in it.
182: ----------------------------------------------------------------------
183:
184: PROCEDURE validate_deliv_kit_item
185: (

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

183:
184: PROCEDURE validate_deliv_kit_item
185: (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
188: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,

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

184: PROCEDURE validate_deliv_kit_item
185: (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
188: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
189:
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,

Line 226: -- attributes as FND_API.g_miss_char/num/date

222: -- Check the record level business rules.
223: --
224: -- PARAMETERS
225: -- p_deliv_kit_item_rec: the record to be validated; may contain
226: -- attributes as FND_API.g_miss_char/num/date
227: -- p_complete_rec: the complete record after all "g_miss" items
228: -- have been replaced by current database values
229: ---------------------------------------------------------------------
230:

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

239: -- PROCEDURE
240: -- init_deliv_kit_item_rec
241: --
242: -- PURPOSE
243: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
244: ---------------------------------------------------------------------
245:
246: PROCEDURE init_deliv_kit_ite_rec
247: (

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

254: -- complete_deliv_kit_item_rec
255: --
256: -- PURPOSE
257: -- For update_deliv_kit_items, some attributes may be passed in as
258: -- FND_API.g_miss_char/num/date if the user doesn't want to
259: -- update those attributes. This procedure will replace the
260: -- "g_miss" attributes with current database values.
261: --
262: -- PARAMETERS

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

260: -- "g_miss" attributes with current database values.
261: --
262: -- PARAMETERS
263: -- p_deliv_kit_item_rec: the record which may contain attributes
264: -- as FND_API.g_miss_char/num/date
265: -- x_complete_rec: the complete record after all "g_miss" items
266: -- have been replaced by current database values
267: ---------------------------------------------------------------------
268: PROCEDURE complete_deliv_kit_item_rec