14:
15: -- End Of Comments
16: PROCEDURE Create_Listheader
17: ( p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
15: -- End Of Comments
16: PROCEDURE Create_Listheader
17: ( p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
16: PROCEDURE Create_Listheader
17: ( p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,
23: x_msg_data OUT NOCOPY VARCHAR2,
24: p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type,
37: -- p_listheader_rec The Record to be Updated.
38:
39: -- NOTES
40: -- 1. Raise exception if the object_version_number doesn't match.
41: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
42: -- that column won't be updated.
43:
44: -- End Of Comments
45:
44: -- End Of Comments
45:
46: PROCEDURE Update_ListHeader
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
45:
46: PROCEDURE Update_ListHeader
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
46: PROCEDURE Update_ListHeader
47: ( p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type
71: --------------------------------------------------------------------
72:
73: PROCEDURE Delete_ListHeader
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
72:
73: PROCEDURE Delete_ListHeader
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
73: PROCEDURE Delete_ListHeader
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_listheader_id IN NUMBER
99: -- End Of Comments
100:
101: PROCEDURE Lock_ListHeader
102: ( p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
100:
101: PROCEDURE Lock_ListHeader
102: ( p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_listheader_id IN NUMBER,
122: -- p_listheader_rec: the list header record to be validated
123: --
124: -- NOTES
125: -- 1. p_listheader_rec_rec should be the complete list header record. There
126: -- should not be any FND_API.g_miss_char/num/date in it.
127: ----------------------------------------------------------------------
128: -- End Of Comments
129:
130: PROCEDURE Validate_ListHeader
128: -- End Of Comments
129:
130: PROCEDURE Validate_ListHeader
131: ( p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
129:
130: PROCEDURE Validate_ListHeader
131: ( p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_listheader_rec IN AMS_LISTHEADER_PVT.list_header_rec_type
160:
161:
162: PROCEDURE Copy_List
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
161:
162: PROCEDURE Copy_List
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
162: PROCEDURE Copy_List
163: ( p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165: p_commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_source_listheader_id IN NUMBER,