60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
62: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
64: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
65: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
66: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
67: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
68: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
73: p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
79: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
80: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
81: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
74: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
75: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
79: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
80: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
81: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
82: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
179: p_api_version IN NUMBER DEFAULT 1.0,
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
185: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
186: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
187: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
180: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
185: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
186: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
187: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
188:
190: p_api_version IN NUMBER DEFAULT 1.0,
191: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
192: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
194: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
195: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
196: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
197: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
198: DEFAULT NULL,
245: p_org_id IN NUMBER
246: );
247:
248: PROCEDURE UPDATE_HOLD_COMMENTS (
249: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
250: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
251: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
252: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
253: