APPS.PO_HEADERS_SV2 dependencies on PO_HEADERS

Line 1: PACKAGE BODY PO_HEADERS_SV2 as

1: PACKAGE BODY PO_HEADERS_SV2 as
2: /* $Header: POXPOH2B.pls 120.0.12000000.2 2007/10/11 14:03:11 ppadilam ship $*/
3:
4: /*===========================================================================
5:

Line 45: FROM PO_HEADERS POH

41: ** indicate that the approval status has to be changed */
42:
43: SELECT 'Y'
44: INTO X_change_status
45: FROM PO_HEADERS POH
46: WHERE (poh.po_header_id = X_po_header_id)
47: AND ( (poh.agent_id <> X_agent_id)
48: OR
49: (poh.agent_id is NULL AND

Line 426: FROM PO_HEADERS POH

422: POH.revision_num,
423: POH.vendor_id,
424: POH.vendor_site_id,
425: POH.ship_to_location_id
426: FROM PO_HEADERS POH
427: WHERE POH.po_header_id = X_po_header_id;
428:
429:
430: X_progress VARCHAR2(3) := '';

Line 496: valid_date := po_headers_sv2.val_start_date(X_po_header_id, X_start_date);

492:
493: procedure test_start_date ( X_po_header_id IN number, X_start_date IN date) is
494: valid_date boolean ;
495: begin
496: valid_date := po_headers_sv2.val_start_date(X_po_header_id, X_start_date);
497: /*
498: if valid_date then
499: --dbms_output.put_line('VALID');
500: else

Line 510: X_encumb := po_headers_sv1.get_po_encumbered(X_po_header_id);

506: procedure test_get_po_encumbered (X_po_header_id IN number) is
507: X_encumb boolean;
508:
509: begin
510: X_encumb := po_headers_sv1.get_po_encumbered(X_po_header_id);
511: /*
512: if X_encumb then
513: --dbms_output.put_line('ENCUMBERED');
514: else

Line 602: FROM po_headers_all POH,

598: -- the effective date rule of the contract
599:
600: SELECT 'Y'
601: INTO l_invalid
602: FROM po_headers_all POH,
603: po_lines_all POL
604: WHERE POL.contract_id = p_po_header_id
605: AND POL.po_header_id = POH.po_header_id
606: AND TRUNC(POL.creation_date) NOT BETWEEN

Line 629: END PO_HEADERS_SV2;

625: END val_contract_eff_date;
626:
627: --
628:
629: END PO_HEADERS_SV2;