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.2.12020000.3 2013/02/10 15:01:00 vegajula 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 'F'
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: -- Bug # 13550798 Added below condition to apply check for GBPAs as well.
606: OR POL.from_header_id = p_po_header_id)

Line 633: END PO_HEADERS_SV2;

629: END val_contract_eff_date;
630:
631: --
632:
633: END PO_HEADERS_SV2;