DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on PO_STATUS_REC_TYPE

Line 54: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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,
57: x_msg_data OUT NOCOPY VARCHAR2
58: ) IS

Line 205: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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,
208: x_msg_data OUT NOCOPY VARCHAR2
209: ) IS

Line 336: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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,
339: x_msg_data OUT NOCOPY VARCHAR2
340: ) IS

Line 468: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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
472: ) IS

Line 569: -- and PO_STATUS_REC_TYPE for various status information this procedure can find out.

565: --Locks:
566: -- None.
567: --Function:
568: -- Finds the status of a Requisition Header/Line. Refer to p_mode parameter
569: -- and PO_STATUS_REC_TYPE for various status information this procedure can find out.
570: -- A unique header has to be specified in p_req_header_id.
571: -- A line can optionally be specified to check status at that level also.
572: --Parameters:
573: --IN:

Line 613: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

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,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2
617: ) IS

Line 641: x_req_status_rec := PO_STATUS_REC_TYPE(null, null, null, null, null, null, null, null, null);

637: END IF;
638:
639: l_progress := '020'; -- Initialize Local/Output Variables
640: l_count := p_req_header_id.count;
641: x_req_status_rec := PO_STATUS_REC_TYPE(null, null, null, null, null, null, null, null, null);
642:
643: l_progress := '030';
644:
645: IF INSTR(p_mode, G_CHECK_UPDATEABLE) > 0 THEN