DBA Data[Home] [Help]

APPS.PO_REQS_INQ_SV dependencies on PO_REQS_INQ_SV

Line 1: PACKAGE BODY PO_REQS_INQ_SV as

1: PACKAGE BODY PO_REQS_INQ_SV as
2: /* $Header: POXRQVRB.pls 115.9 2003/12/12 04:17:15 sbull ship $*/
3: /*============================= PO_REQS_INQ_SV ===============================*/
4:
5:

Line 3: /*============================= PO_REQS_INQ_SV ===============================*/

1: PACKAGE BODY PO_REQS_INQ_SV as
2: /* $Header: POXRQVRB.pls 115.9 2003/12/12 04:17:15 sbull ship $*/
3: /*============================= PO_REQS_INQ_SV ===============================*/
4:
5:
6: /*===========================================================================
7:

Line 162: x_reserved_flag := PO_REQS_INQ_SV.GET_RESERVED_FLAG (x_req_num);

158: x_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer);
159: END IF;
160:
161: IF x_req_num IS NOT NULL THEN
162: x_reserved_flag := PO_REQS_INQ_SV.GET_RESERVED_FLAG (x_req_num);
163: x_req_header_amount := PO_CORE_S.GET_TOTAL('E', x_req_num);
164: END IF;
165:
166:

Line 266: v_blanket_po_num_dsp := PO_REQS_INQ_SV.GET_PO_NUMBER(x_blanket_po_header_id);

262: v_preparer_name := PO_INQ_SV.GET_PERSON_NAME(x_preparer_id);
263: END IF;
264:
265: IF x_blanket_po_header_id IS NOT NULL THEN
266: v_blanket_po_num_dsp := PO_REQS_INQ_SV.GET_PO_NUMBER(x_blanket_po_header_id);
267:
268: END IF;
269:
270:

Line 286: v_req_line_amount := PO_REQS_INQ_SV.get_req_amount('I',x_requsition_line_id);

282:
283: -- SERVICES FPJ
284: -- Changed to the new function which handles both services and goods lines
285:
286: v_req_line_amount := PO_REQS_INQ_SV.get_req_amount('I',x_requsition_line_id);
287:
288:
289: END po_req_line_inq_wrapper;
290: /*===========================================================================

Line 324: v_req_distribution_amount := PO_REQS_INQ_SV.get_req_amount ('J' , x_distribution_id);

320:
321: -- SERVICES FPJ
322: -- Changed to the new function which handles both services and goods lines
323:
324: v_req_distribution_amount := PO_REQS_INQ_SV.get_req_amount ('J' , x_distribution_id);
325:
326: END po_req_dist_inq_wrapper;
327:
328: /*===========================================================================

Line 409: po_message_s.sql_error('po_reqs_inq_sv.get_reqln_pq_lookups', x_progress, sqlcode);

405: end if;
406:
407: EXCEPTION
408: WHEN OTHERS THEN
409: po_message_s.sql_error('po_reqs_inq_sv.get_reqln_pq_lookups', x_progress, sqlcode);
410: raise;
411:
412: END get_reqln_pq_lookups;
413:

Line 567: po_message_s.sql_error('po_reqs_inq_sv.get_req_amount', l_progress, sqlcode);

563: Return l_req_amount;
564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: po_message_s.sql_error('po_reqs_inq_sv.get_req_amount', l_progress, sqlcode);
568: raise;
569: END get_req_amount;
570:
571: END PO_REQS_INQ_SV;

Line 571: END PO_REQS_INQ_SV;

567: po_message_s.sql_error('po_reqs_inq_sv.get_req_amount', l_progress, sqlcode);
568: raise;
569: END get_req_amount;
570:
571: END PO_REQS_INQ_SV;