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 341: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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

Line 473: x_req_status_rec IN OUT NOCOPY PO_STATUS_REC_TYPE,

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

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

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

Line 618: x_req_status_rec OUT NOCOPY PO_STATUS_REC_TYPE,

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,
620: x_msg_count OUT NOCOPY NUMBER,
621: x_msg_data OUT NOCOPY VARCHAR2
622: ) IS

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

642: END IF;
643:
644: l_progress := '020'; -- Initialize Local/Output Variables
645: l_count := p_req_header_id.count;
646: x_req_status_rec := PO_STATUS_REC_TYPE(null, null, null, null, null, null, null, null, null);
647:
648: l_progress := '030';
649:
650: IF INSTR(p_mode, G_CHECK_UPDATEABLE) > 0 THEN