PACKAGE: APPS.IGI_CIS2007_IGIPSUPR_PKG

Source

1 PACKAGE igi_cis2007_igipsupr_pkg AUTHID CURRENT_USER AS
2 -- $Header: igipsups.pls 120.0.12000000.2 2007/07/18 13:07:11 vensubra noship $
3 
4   p_supplier_from VARCHAR2(240);
5   p_supplier_to   VARCHAR2(240);
6   p_active        VARCHAR2(30);
7   p_report        VARCHAR2(30);
8   p_sort_by       VARCHAR2(240);
9 
10   pwhereclause VARCHAR2(3200);
11   porderclause VARCHAR2(1200);
12 
13   FUNCTION beforereport RETURN BOOLEAN;
14   FUNCTION get_p_supplier_from RETURN VARCHAR2;
15   FUNCTION get_p_supplier_to RETURN VARCHAR2;
16   FUNCTION get_p_report_title RETURN VARCHAR2;
17   FUNCTION get_p_org_name RETURN VARCHAR2;
18   FUNCTION get_p_active RETURN VARCHAR2;
19   FUNCTION get_p_sortby RETURN VARCHAR2;
20   FUNCTION check_active
21   (
22     p_start_date DATE,
23     p_end_date   DATE
24   ) RETURN VARCHAR2;
25 
26   FUNCTION igi_cis_is_vendor_verified (l_vendor_id NUMBER)
27         RETURN VARCHAR2 ;
28   FUNCTION igi_cis_is_vendor_paid (l_vendor_id NUMBER,verify_date DATE DEFAULT SYSDATE)
29         RETURN VARCHAR2;
30   FUNCTION igi_cis_is_verify_required (l_vendor_id NUMBER)
31         RETURN VARCHAR2 ;
32 END igi_cis2007_igipsupr_pkg;