12: -- ============================================================================
13:
14: TYPE Item_Revision_rec_type IS RECORD
15: (
16: inventory_item_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
13:
14: TYPE Item_Revision_rec_type IS RECORD
15: (
16: inventory_item_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
14: TYPE Item_Revision_rec_type IS RECORD
15: (
16: inventory_item_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
15: (
16: inventory_item_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
16: inventory_item_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
17: , organization_id NUMBER := FND_API.g_MISS_NUM
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
18: , revision VARCHAR2(3) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
19: , description VARCHAR2(240) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
20: , change_notice VARCHAR2(10) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
21: , ecn_initiation_date DATE := FND_API.g_MISS_DATE
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
22: , implementation_date DATE := FND_API.g_MISS_DATE
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
23: , effectivity_date DATE := FND_API.g_MISS_DATE
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
24: , revised_item_sequence_id NUMBER := FND_API.g_MISS_NUM
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
25: , attribute_category VARCHAR2(30) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
26: , attribute1 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
27: , attribute2 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
28: , attribute3 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
29: , attribute4 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
30: , attribute5 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
31: , attribute6 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
32: , attribute7 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
33: , attribute8 VARCHAR2(150) := FND_API.g_MISS_CHAR
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
34: , attribute9 VARCHAR2(150) := FND_API.g_MISS_CHAR
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
35: , attribute10 VARCHAR2(150) := FND_API.g_MISS_CHAR
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
36: , attribute11 VARCHAR2(150) := FND_API.g_MISS_CHAR
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
37: , attribute12 VARCHAR2(150) := FND_API.g_MISS_CHAR
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
38: , attribute13 VARCHAR2(150) := FND_API.g_MISS_CHAR
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
39: , attribute14 VARCHAR2(150) := FND_API.g_MISS_CHAR
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
40: , attribute15 VARCHAR2(150) := FND_API.g_MISS_CHAR
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
41: , creation_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
42: , created_by NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
50: , object_version_number NUMBER := FND_API.g_MISS_NUM
43: , last_update_date DATE := FND_API.g_MISS_DATE
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
50: , object_version_number NUMBER := FND_API.g_MISS_NUM
51: );
44: , last_updated_by NUMBER := FND_API.g_MISS_NUM
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
50: , object_version_number NUMBER := FND_API.g_MISS_NUM
51: );
52:
45: , last_update_login NUMBER := FND_API.g_MISS_NUM
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
50: , object_version_number NUMBER := FND_API.g_MISS_NUM
51: );
52:
53:
46: , request_id NUMBER := FND_API.g_MISS_NUM
47: , program_application_id NUMBER := FND_API.g_MISS_NUM
48: , program_id NUMBER := FND_API.g_MISS_NUM
49: , program_update_date DATE := FND_API.g_MISS_DATE
50: , object_version_number NUMBER := FND_API.g_MISS_NUM
51: );
52:
53:
54: -- ------------------- Variables representing missing values ------------------
68: -- Parameters
69: --
70: -- IN
71: -- p_api_version IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: --
75: -- OUT
76: -- x_return_status OUT VARCHAR2
69: --
70: -- IN
71: -- p_api_version IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: --
75: -- OUT
76: -- x_return_status OUT VARCHAR2
77: -- x_msg_count OUT NUMBER
87:
88: PROCEDURE Create_Item_Revision
89: (
90: p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: , p_commit IN VARCHAR2 := FND_API.G_FALSE
93: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_msg_count OUT NOCOPY NUMBER
88: PROCEDURE Create_Item_Revision
89: (
90: p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: , p_commit IN VARCHAR2 := FND_API.G_FALSE
93: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_msg_count OUT NOCOPY NUMBER
96: , x_msg_data OUT NOCOPY VARCHAR2
89: (
90: p_api_version IN NUMBER
91: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: , p_commit IN VARCHAR2 := FND_API.G_FALSE
93: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
94: , x_return_status OUT NOCOPY VARCHAR2
95: , x_msg_count OUT NOCOPY NUMBER
96: , x_msg_data OUT NOCOPY VARCHAR2
97: , p_Item_Revision_rec IN Item_Revision_rec_type
109: -- Parameters
110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_Item_Revision_rec IN Item_Revision_rec_type Required
116: --
117: -- OUT
110: --
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_Item_Revision_rec IN Item_Revision_rec_type Required
116: --
117: -- OUT
118: -- x_return_status OUT VARCHAR2
126:
127: PROCEDURE Update_Item_Revision
128: (
129: p_api_version IN NUMBER
130: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
131: , p_commit IN VARCHAR2 := FND_API.g_FALSE
132: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
133: , x_return_status OUT NOCOPY VARCHAR2
134: , x_msg_count OUT NOCOPY NUMBER
127: PROCEDURE Update_Item_Revision
128: (
129: p_api_version IN NUMBER
130: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
131: , p_commit IN VARCHAR2 := FND_API.g_FALSE
132: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
133: , x_return_status OUT NOCOPY VARCHAR2
134: , x_msg_count OUT NOCOPY NUMBER
135: , x_msg_data OUT NOCOPY VARCHAR2
128: (
129: p_api_version IN NUMBER
130: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
131: , p_commit IN VARCHAR2 := FND_API.g_FALSE
132: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
133: , x_return_status OUT NOCOPY VARCHAR2
134: , x_msg_count OUT NOCOPY NUMBER
135: , x_msg_data OUT NOCOPY VARCHAR2
136: , p_Item_Revision_rec IN Item_Revision_rec_type
149: -- Parameters
150: --
151: -- IN
152: -- p_api_version_number IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
154: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
155: -- p_inventory_item_id IN NUMBER Required
156: -- p_organization_id IN NUMBER Required
157: -- p_revision IN VARCHAR2 Required
150: --
151: -- IN
152: -- p_api_version_number IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
154: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
155: -- p_inventory_item_id IN NUMBER Required
156: -- p_organization_id IN NUMBER Required
157: -- p_revision IN VARCHAR2 Required
158: -- p_object_version_number IN NUMBER Required
169:
170: PROCEDURE Delete_Item_Revision
171: (
172: p_api_version IN NUMBER
173: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
174: , p_commit IN VARCHAR2 := FND_API.g_FALSE
175: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
176: , x_return_status OUT NOCOPY VARCHAR2
177: , x_msg_count OUT NOCOPY NUMBER
170: PROCEDURE Delete_Item_Revision
171: (
172: p_api_version IN NUMBER
173: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
174: , p_commit IN VARCHAR2 := FND_API.g_FALSE
175: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
176: , x_return_status OUT NOCOPY VARCHAR2
177: , x_msg_count OUT NOCOPY NUMBER
178: , x_msg_data OUT NOCOPY VARCHAR2
171: (
172: p_api_version IN NUMBER
173: , p_init_msg_list IN VARCHAR2 := FND_API.g_FALSE
174: , p_commit IN VARCHAR2 := FND_API.g_FALSE
175: , p_validation_level IN NUMBER := FND_API.g_VALID_LEVEL_FULL
176: , x_return_status OUT NOCOPY VARCHAR2
177: , x_msg_count OUT NOCOPY NUMBER
178: , x_msg_data OUT NOCOPY VARCHAR2
179: , p_inventory_item_id IN NUMBER