APPS.PO_AP_PURGE_GRP dependencies on PO_HEADERS_ALL

Line 23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

19: ( p_po_header_id IN PO_HEADERS.po_header_id%TYPE
20: ) RETURN BOOLEAN;
21:
22: FUNCTION referencing_asl_exist
23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
24: ) RETURN BOOLEAN;
25:
26: FUNCTION referencing_po_exist
27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

Line 27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

23: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
24: ) RETURN BOOLEAN;
25:
26: FUNCTION referencing_po_exist
27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
28: ) RETURN BOOLEAN;
29:
30: FUNCTION referencing_req_exist
31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

Line 31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

27: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
28: ) RETURN BOOLEAN;
29:
30: FUNCTION referencing_req_exist
31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
32: ) RETURN BOOLEAN;
33:
34: FUNCTION stdpo_ref_ga_check
35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

Line 35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

31: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
32: ) RETURN BOOLEAN;
33:
34: FUNCTION stdpo_ref_ga_check
35: ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
36: ) RETURN BOOLEAN;
37:
38: /*=========================================================================*/
39: /*========================== BODY (PUBLIC) ================================*/

Line 60: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

56: */
57:
58: FUNCTION validate_purge
59: (
60: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
61: )
62: RETURN VARCHAR2
63: IS
64: BEGIN

Line 307: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

303: *===========================================================================
304: */
305: FUNCTION referencing_docs_exist
306: (
307: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
308: )
309: RETURN BOOLEAN
310: IS
311: BEGIN

Line 345: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

341: *===========================================================================
342: */
343: FUNCTION referencing_asl_exist
344: (
345: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
346: )
347: RETURN BOOLEAN
348: IS
349: l_dummy VARCHAR2(20);

Line 395: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

391: *===========================================================================
392: */
393: FUNCTION referencing_req_exist
394: (
395: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
396: )
397: RETURN BOOLEAN
398: IS
399: l_dummy VARCHAR2(20);

Line 446: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

442: *===========================================================================
443: */
444: FUNCTION referencing_po_exist
445: (
446: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
447: )
448: RETURN BOOLEAN
449: IS
450: l_dummy VARCHAR2(20);

Line 495: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE

491: *===========================================================================
492: */
493: FUNCTION stdpo_ref_ga_check
494: (
495: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
496: )
497: RETURN BOOLEAN
498: IS
499: l_src_doc_id PO_LINES_ALL.from_header_id%TYPE;

Line 500: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

496: )
497: RETURN BOOLEAN
498: IS
499: l_src_doc_id PO_LINES_ALL.from_header_id%TYPE;
500: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
501: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
502: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
503: l_purge_doc varchar2(1) := 'Y';
504:

Line 501: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;

497: RETURN BOOLEAN
498: IS
499: l_src_doc_id PO_LINES_ALL.from_header_id%TYPE;
500: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
501: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
502: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
503: l_purge_doc varchar2(1) := 'Y';
504:
505: CURSOR C1 is

Line 502: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

498: IS
499: l_src_doc_id PO_LINES_ALL.from_header_id%TYPE;
500: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
501: l_closed_code PO_HEADERS_ALL.closed_code%TYPE;
502: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
503: l_purge_doc varchar2(1) := 'Y';
504:
505: CURSOR C1 is
506: SELECT distinct from_header_id

Line 530: FROM po_headers_all ph

526: nvl(ph.cancel_flag,'N')
527: INTO l_ga_flag,
528: l_closed_code,
529: l_cancel_flag
530: FROM po_headers_all ph
531: WHERE ph.po_header_id = l_src_doc_id;
532:
533: -- if the source is not a GA or if its finally closed/cancelled then
534: -- the std PO can be purged