DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_TBL_NUMBER

Line 50: p_req_header_id IN PO_TBL_NUMBER,

46: -------------------------------------------------------------------------------
47:
48: PROCEDURE check_updatable (
49: p_count IN NUMBER,
50: p_req_header_id IN PO_TBL_NUMBER,
51: p_req_line_id IN PO_TBL_NUMBER,
52: p_req_distribution_id IN PO_TBL_NUMBER,
53: p_lock_flag IN VARCHAR2 := 'N',
54: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 51: p_req_line_id IN PO_TBL_NUMBER,

47:
48: PROCEDURE check_updatable (
49: p_count IN NUMBER,
50: p_req_header_id IN PO_TBL_NUMBER,
51: p_req_line_id IN PO_TBL_NUMBER,
52: p_req_distribution_id IN PO_TBL_NUMBER,
53: p_lock_flag IN VARCHAR2 := 'N',
54: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
55: x_return_status OUT NOCOPY VARCHAR2,

Line 52: p_req_distribution_id IN PO_TBL_NUMBER,

48: PROCEDURE check_updatable (
49: p_count IN NUMBER,
50: p_req_header_id IN PO_TBL_NUMBER,
51: p_req_line_id IN PO_TBL_NUMBER,
52: p_req_distribution_id IN PO_TBL_NUMBER,
53: p_lock_flag IN VARCHAR2 := 'N',
54: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,

Line 201: p_req_header_id IN PO_TBL_NUMBER,

197: -------------------------------------------------------------------------------
198:
199: PROCEDURE check_reservable (
200: p_count IN NUMBER,
201: p_req_header_id IN PO_TBL_NUMBER,
202: p_req_line_id IN PO_TBL_NUMBER,
203: p_req_distribution_id IN PO_TBL_NUMBER,
204: p_lock_flag IN VARCHAR2 := 'N',
205: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 202: p_req_line_id IN PO_TBL_NUMBER,

198:
199: PROCEDURE check_reservable (
200: p_count IN NUMBER,
201: p_req_header_id IN PO_TBL_NUMBER,
202: p_req_line_id IN PO_TBL_NUMBER,
203: p_req_distribution_id IN PO_TBL_NUMBER,
204: p_lock_flag IN VARCHAR2 := 'N',
205: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
206: x_return_status OUT NOCOPY VARCHAR2,

Line 203: p_req_distribution_id IN PO_TBL_NUMBER,

199: PROCEDURE check_reservable (
200: p_count IN NUMBER,
201: p_req_header_id IN PO_TBL_NUMBER,
202: p_req_line_id IN PO_TBL_NUMBER,
203: p_req_distribution_id IN PO_TBL_NUMBER,
204: p_lock_flag IN VARCHAR2 := 'N',
205: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,

Line 332: p_req_header_id IN PO_TBL_NUMBER,

328: -------------------------------------------------------------------------------
329:
330: PROCEDURE check_unreservable (
331: p_count IN NUMBER,
332: p_req_header_id IN PO_TBL_NUMBER,
333: p_req_line_id IN PO_TBL_NUMBER,
334: p_req_distribution_id IN PO_TBL_NUMBER,
335: p_lock_flag IN VARCHAR2 := 'N',
336: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 333: p_req_line_id IN PO_TBL_NUMBER,

329:
330: PROCEDURE check_unreservable (
331: p_count IN NUMBER,
332: p_req_header_id IN PO_TBL_NUMBER,
333: p_req_line_id IN PO_TBL_NUMBER,
334: p_req_distribution_id IN PO_TBL_NUMBER,
335: p_lock_flag IN VARCHAR2 := 'N',
336: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,

Line 334: p_req_distribution_id IN PO_TBL_NUMBER,

330: PROCEDURE check_unreservable (
331: p_count IN NUMBER,
332: p_req_header_id IN PO_TBL_NUMBER,
333: p_req_line_id IN PO_TBL_NUMBER,
334: p_req_distribution_id IN PO_TBL_NUMBER,
335: p_lock_flag IN VARCHAR2 := 'N',
336: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,

Line 465: p_req_header_id IN PO_TBL_NUMBER,

461: -------------------------------------------------------------------------------
462:
463: PROCEDURE get_status (
464: p_count IN NUMBER,
465: p_req_header_id IN PO_TBL_NUMBER,
466: p_req_line_id IN PO_TBL_NUMBER,
467: p_req_distribution_id IN PO_TBL_NUMBER,
468: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
469: x_return_status OUT NOCOPY VARCHAR2,

Line 466: p_req_line_id IN PO_TBL_NUMBER,

462:
463: PROCEDURE get_status (
464: p_count IN NUMBER,
465: p_req_header_id IN PO_TBL_NUMBER,
466: p_req_line_id IN PO_TBL_NUMBER,
467: p_req_distribution_id IN PO_TBL_NUMBER,
468: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,

Line 467: p_req_distribution_id IN PO_TBL_NUMBER,

463: PROCEDURE get_status (
464: p_count IN NUMBER,
465: p_req_header_id IN PO_TBL_NUMBER,
466: p_req_line_id IN PO_TBL_NUMBER,
467: p_req_distribution_id IN PO_TBL_NUMBER,
468: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2

Line 476: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();

472: ) IS
473:
474: l_api_name CONSTANT VARCHAR(30) := 'GET_STATUS';
475: l_progress VARCHAR2(3) := '000';
476: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
477:
478: BEGIN
479:
480: IF g_fnd_debug = 'Y' THEN

Line 608: p_req_header_id IN PO_TBL_NUMBER,

604: -------------------------------------------------------------------------------
605:
606: PROCEDURE req_status_check (
607: p_api_version IN NUMBER,
608: p_req_header_id IN PO_TBL_NUMBER,
609: p_req_line_id IN PO_TBL_NUMBER,
610: p_req_distribution_id IN PO_TBL_NUMBER,
611: p_mode IN VARCHAR2,
612: p_lock_flag IN VARCHAR2 := 'N',

Line 609: p_req_line_id IN PO_TBL_NUMBER,

605:
606: PROCEDURE req_status_check (
607: p_api_version IN NUMBER,
608: p_req_header_id IN PO_TBL_NUMBER,
609: p_req_line_id IN PO_TBL_NUMBER,
610: p_req_distribution_id IN PO_TBL_NUMBER,
611: p_mode IN VARCHAR2,
612: p_lock_flag IN VARCHAR2 := 'N',
613: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 610: p_req_distribution_id IN PO_TBL_NUMBER,

606: PROCEDURE req_status_check (
607: p_api_version IN NUMBER,
608: p_req_header_id IN PO_TBL_NUMBER,
609: p_req_line_id IN PO_TBL_NUMBER,
610: p_req_distribution_id IN PO_TBL_NUMBER,
611: p_mode IN VARCHAR2,
612: p_lock_flag IN VARCHAR2 := 'N',
613: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
614: x_return_status OUT NOCOPY VARCHAR2,