DBA Data[Home] [Help]

APPS.OE_HOLDS_PUB dependencies on OE_HOLDS_PVT

Line 64: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

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,

Line 77: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

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,

Line 78: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,

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,

Line 183: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,

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);

Line 184: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,

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:

Line 194: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

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,

Line 249: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,

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: