DBA Data[Home] [Help]

APPS.OE_HOLDS_PUB dependencies on OE_HOLDS_PVT

Line 65: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
64: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
65: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
66: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
67: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
68: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
69: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 79: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type

75: p_api_version IN NUMBER,
76: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
79: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
80: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
81: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
82: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
83: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694

Line 80: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,

76: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
79: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
80: DEFAULT OE_HOLDS_PVT.G_MISS_HOLD_SOURCE_REC,
81: p_hold_existing_flg IN VARCHAR2 DEFAULT 'Y',
82: p_hold_future_flg IN VARCHAR2 DEFAULT 'Y',
83: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
84: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 187: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,

183: p_api_version IN NUMBER DEFAULT 1.0,
184: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
188: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
189: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
190: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
191: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 188: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,

184: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
187: p_hold_source_rec IN OE_HOLDS_PVT.hold_source_rec_type,
188: p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type,
189: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
190: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
191: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
192: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 199: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,

195: p_api_version IN NUMBER DEFAULT 1.0,
196: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
197: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
199: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
200: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE DEFAULT NULL,
201: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
202: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
203: DEFAULT NULL,

Line 255: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,

251: p_org_id IN NUMBER
252: );
253:
254: PROCEDURE UPDATE_HOLD_COMMENTS (
255: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
256: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
257: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
258: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
259: