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 337: p_req_header_id IN PO_TBL_NUMBER,

333: -------------------------------------------------------------------------------
334:
335: PROCEDURE check_unreservable (
336: p_count IN NUMBER,
337: p_req_header_id IN PO_TBL_NUMBER,
338: p_req_line_id IN PO_TBL_NUMBER,
339: p_req_distribution_id IN PO_TBL_NUMBER,
340: p_lock_flag IN VARCHAR2 := 'N',
341: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

Line 338: p_req_line_id IN PO_TBL_NUMBER,

334:
335: PROCEDURE check_unreservable (
336: p_count IN NUMBER,
337: p_req_header_id IN PO_TBL_NUMBER,
338: p_req_line_id IN PO_TBL_NUMBER,
339: p_req_distribution_id IN PO_TBL_NUMBER,
340: p_lock_flag IN VARCHAR2 := 'N',
341: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
342: x_return_status OUT NOCOPY VARCHAR2,

Line 339: p_req_distribution_id IN PO_TBL_NUMBER,

335: PROCEDURE check_unreservable (
336: p_count IN NUMBER,
337: p_req_header_id IN PO_TBL_NUMBER,
338: p_req_line_id IN PO_TBL_NUMBER,
339: p_req_distribution_id IN PO_TBL_NUMBER,
340: p_lock_flag IN VARCHAR2 := 'N',
341: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,

Line 470: p_req_header_id IN PO_TBL_NUMBER,

466: -------------------------------------------------------------------------------
467:
468: PROCEDURE get_status (
469: p_count IN NUMBER,
470: p_req_header_id IN PO_TBL_NUMBER,
471: p_req_line_id IN PO_TBL_NUMBER,
472: p_req_distribution_id IN PO_TBL_NUMBER,
473: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
474: x_return_status OUT NOCOPY VARCHAR2,

Line 471: p_req_line_id IN PO_TBL_NUMBER,

467:
468: PROCEDURE get_status (
469: p_count IN NUMBER,
470: p_req_header_id IN PO_TBL_NUMBER,
471: p_req_line_id IN PO_TBL_NUMBER,
472: p_req_distribution_id IN PO_TBL_NUMBER,
473: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,

Line 472: p_req_distribution_id IN PO_TBL_NUMBER,

468: PROCEDURE get_status (
469: p_count IN NUMBER,
470: p_req_header_id IN PO_TBL_NUMBER,
471: p_req_line_id IN PO_TBL_NUMBER,
472: p_req_distribution_id IN PO_TBL_NUMBER,
473: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,
476: x_msg_data OUT NOCOPY VARCHAR2

Line 481: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();

477: ) IS
478:
479: l_api_name CONSTANT VARCHAR(30) := 'GET_STATUS';
480: l_progress VARCHAR2(3) := '000';
481: l_sequence PO_TBL_NUMBER := PO_TBL_NUMBER();
482:
483: BEGIN
484:
485: IF g_fnd_debug = 'Y' THEN

Line 613: p_req_header_id IN PO_TBL_NUMBER,

609: -------------------------------------------------------------------------------
610:
611: PROCEDURE req_status_check (
612: p_api_version IN NUMBER,
613: p_req_header_id IN PO_TBL_NUMBER,
614: p_req_line_id IN PO_TBL_NUMBER,
615: p_req_distribution_id IN PO_TBL_NUMBER,
616: p_mode IN VARCHAR2,
617: p_lock_flag IN VARCHAR2 := 'N',

Line 614: p_req_line_id IN PO_TBL_NUMBER,

610:
611: PROCEDURE req_status_check (
612: p_api_version IN NUMBER,
613: p_req_header_id IN PO_TBL_NUMBER,
614: p_req_line_id IN PO_TBL_NUMBER,
615: p_req_distribution_id IN PO_TBL_NUMBER,
616: p_mode IN VARCHAR2,
617: p_lock_flag IN VARCHAR2 := 'N',
618: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

Line 615: p_req_distribution_id IN PO_TBL_NUMBER,

611: PROCEDURE req_status_check (
612: p_api_version IN NUMBER,
613: p_req_header_id IN PO_TBL_NUMBER,
614: p_req_line_id IN PO_TBL_NUMBER,
615: p_req_distribution_id IN PO_TBL_NUMBER,
616: p_mode IN VARCHAR2,
617: p_lock_flag IN VARCHAR2 := 'N',
618: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,
619: x_return_status OUT NOCOPY VARCHAR2,