PACKAGE: APPS.POA_EDW_VARIABLES_PKG

Source

1 PACKAGE POA_EDW_VARIABLES_PKG AUTHID CURRENT_USER AS
2 /* $Header: poavars.pls 115.7 2004/01/28 06:34:24 sdiwakar noship $ */
3 
4   FUNCTION get_check_cut_date (p_po_distribution_id IN NUMBER) RETURN DATE;
5   PRAGMA RESTRICT_REFERENCES(get_check_cut_date, WNDS);
6 
7   FUNCTION get_goods_received_date  (p_po_line_location_id IN NUMBER) RETURN DATE;
8   PRAGMA RESTRICT_REFERENCES (get_goods_received_date, WNDS);
9 
10   FUNCTION get_invoice_creation_date (p_po_distribution_id IN NUMBER) RETURN DATE;
11   PRAGMA RESTRICT_REFERENCES (get_invoice_creation_date, WNDS);
12 
13   FUNCTION get_invoice_received_date (p_po_distribution_id IN NUMBER)	RETURN DATE;
14   PRAGMA RESTRICT_REFERENCES (get_invoice_received_date, WNDS);
15 
16   FUNCTION get_req_approval_date (p_po_req_dist_id IN NUMBER) RETURN DATE;
17   PRAGMA RESTRICT_REFERENCES (get_req_approval_date, WNDS);
18 
19   FUNCTION get_ipv (p_po_distribution_id IN NUMBER) RETURN NUMBER;
20   PRAGMA RESTRICT_REFERENCES (get_ipv, WNDS);
21 
22   FUNCTION get_supplier_approved (p_po_distribution_id IN NUMBER) RETURN VARCHAR2;
23   PRAGMA RESTRICT_REFERENCES (get_supplier_approved, WNDS);
24 
25   FUNCTION get_supplier_approved (p_po_distribution_id IN NUMBER,
26                                   p_vendor_id IN NUMBER,
27                                   p_vendor_site_id IN NUMBER,
28                                   p_ship_to_org_id IN NUMBER,
29                                   p_item_id IN NUMBER,
30                                   p_category_id IN NUMBER) RETURN VARCHAR2;
31   PRAGMA RESTRICT_REFERENCES (get_supplier_approved, WNDS);
32 
33   FUNCTION  APPROVED_BY (p_po_header_id  IN NUMBER)  RETURN NUMBER;
34   PRAGMA RESTRICT_REFERENCES (APPROVED_BY, WNDS);
35 
36   FUNCTION get_acceptance_date (p_po_doc_id IN NUMBER, p_type IN VARCHAR2) RETURN DATE;
37   PRAGMA RESTRICT_REFERENCES (get_acceptance_date, WNDS);
38 
39   FUNCTION get_global_currency_rate (p_rate_type      VARCHAR2,
40                                      p_currency_code  VARCHAR2,
41                                      p_rate_date      DATE,
42                                      p_rate           NUMBER)  RETURN NUMBER;
43   PRAGMA RESTRICT_REFERENCES (get_global_currency_rate, WNDS);
44 
45   FUNCTION get_uom_conv_rate (p_uom_code    VARCHAR2,
46                               p_item_id     NUMBER)  RETURN NUMBER;
47 
48   PROCEDURE init;
49 
50 END POA_EDW_VARIABLES_PKG;