APPS.POA_GA_UTIL_PKG dependencies on PO_HEADERS_ALL

Line 4: FUNCTION is_enabled(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

1: PACKAGE BODY POA_GA_UTIL_PKG as
2: /* $Header: poagautilb.pls 115.2 2004/01/24 00:00:08 mangupta noship $ */
3:
4: FUNCTION is_enabled(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
5: p_org_id IN PO_HEADERS_ALL.org_id%TYPE)
6: RETURN VARCHAR2 IS
7:
8: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;

Line 5: p_org_id IN PO_HEADERS_ALL.org_id%TYPE)

1: PACKAGE BODY POA_GA_UTIL_PKG as
2: /* $Header: poagautilb.pls 115.2 2004/01/24 00:00:08 mangupta noship $ */
3:
4: FUNCTION is_enabled(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
5: p_org_id IN PO_HEADERS_ALL.org_id%TYPE)
6: RETURN VARCHAR2 IS
7:
8: l_enabled_flag PO_GA_ORG_ASSIGNMENTS.enabled_flag%TYPE;
9:

Line 27: FUNCTION is_global_agreement(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE)

23: return 'N';
24:
25: END is_enabled;
26:
27: FUNCTION is_global_agreement(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE)
28: RETURN VARCHAR2 IS
29:
30: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
31:

Line 30: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

26:
27: FUNCTION is_global_agreement(p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE)
28: RETURN VARCHAR2 IS
29:
30: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
31:
32: BEGIN
33:
34: SELECT global_agreement_flag

Line 36: FROM po_headers_all

32: BEGIN
33:
34: SELECT global_agreement_flag
35: INTO l_global_agreement_flag
36: FROM po_headers_all
37: WHERE po_header_id = p_po_header_id;
38:
39: return nvl(l_global_agreement_flag, 'N');
40: