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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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',
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,
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,