20: -- the sequence.
21: ---------------------------------------------------------------------
22: PROCEDURE create_DelivKitItem(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
21: ---------------------------------------------------------------------
22: PROCEDURE create_DelivKitItem(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
22: PROCEDURE create_DelivKitItem(
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,
50: --
51: --------------------------------------------------------------------
52: PROCEDURE delete_DelivKitItem(
53: p_api_version_number IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
51: --------------------------------------------------------------------
52: PROCEDURE delete_DelivKitItem(
53: p_api_version_number IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
52: PROCEDURE delete_DelivKitItem(
53: p_api_version_number IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
55: p_commit IN VARCHAR2 := FND_API.g_false,
56: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
57:
58: x_return_status OUT NOCOPY VARCHAR2,
59: x_msg_count OUT NOCOPY NUMBER,
60: x_msg_data OUT NOCOPY VARCHAR2,
79: -- 1. Raise exception if the object_version_number doesn't match.
80: --------------------------------------------------------------------
81: PROCEDURE lock_DelivKitItem(
82: p_api_version_number IN NUMBER,
83: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
84:
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
102: -- p_deliv_kit_item_rec: the record with new items
103: --
104: -- NOTES
105: -- 1. Raise exception if the object_version_number doesn't match.
106: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
107: -- that column won't be updated.
108: ----------------------------------------------------------------------
109: PROCEDURE update_DelivKitItem(
110: p_api_version_number IN NUMBER,
107: -- that column won't be updated.
108: ----------------------------------------------------------------------
109: PROCEDURE update_DelivKitItem(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
112: p_commit IN VARCHAR2 := FND_API.g_false,
113: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
108: ----------------------------------------------------------------------
109: PROCEDURE update_DelivKitItem(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
112: p_commit IN VARCHAR2 := FND_API.g_false,
113: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
109: PROCEDURE update_DelivKitItem(
110: p_api_version_number IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
112: p_commit IN VARCHAR2 := FND_API.g_false,
113: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
114:
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
131: -- p_deliv_kit_item_rec: the DelivKitItem record to be validated
132: --
133: -- NOTES
134: -- 1. p_deliv_kit_item_rec should be the complete DelivKitItem record. There
135: -- should not be any FND_API.g_miss_char/num/date in it.
136: ----------------------------------------------------------------------
137: PROCEDURE validate_DelivKitItem(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
135: -- should not be any FND_API.g_miss_char/num/date in it.
136: ----------------------------------------------------------------------
137: PROCEDURE validate_DelivKitItem(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list 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,
136: ----------------------------------------------------------------------
137: PROCEDURE validate_DelivKitItem(
138: p_api_version_number IN NUMBER,
139: p_init_msg_list 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,