PACKAGE: APPS.POA_EDW_SPEND_PKG

Source

1 PACKAGE POA_EDW_SPEND_PKG AUTHID CURRENT_USER AS
2 /* $Header: POASPNDS.pls 115.3 2003/02/19 20:57:30 mangupta ship $ */
3 
4   FUNCTION	CONTRACT_AMT_RELEASED(p_contract_id	IN NUMBER,
5 				          p_org_id	IN NUMBER,
6                                           p_contract_type IN VARCHAR2)
7 				RETURN NUMBER;
8 
9   FUNCTION      LINE_AMT_RELEASED(p_contract_id IN NUMBER,
10                                       p_org_id      IN NUMBER,
11                                       p_line_id	    IN NUMBER)
12                                 RETURN NUMBER;
13 
14   FUNCTION      LINE_QTY_RELEASED(p_contract_id IN NUMBER,
15                                       p_org_id      IN NUMBER,
16                                       p_line_id     IN NUMBER)
17                                 RETURN NUMBER;
18 
19   FUNCTION	APPROVED_BY(p_po_header_id	IN NUMBER)
20 			        RETURN NUMBER;
21     PRAGMA RESTRICT_REFERENCES(APPROVED_BY, WNDS, WNPS, RNPS);
22 
23   FUNCTION      GET_ACCEPTANCE_DATE(p_doc_id      IN NUMBER,
24                                     p_type        IN VARCHAR2)
25                                 RETURN DATE;
26 
27     PRAGMA RESTRICT_REFERENCES(GET_ACCEPTANCE_DATE, WNDS, WNPS, RNPS);
28 
29   FUNCTION      GET_REQ_APPROVAL_DATE(p_req_dist_id      IN NUMBER)
30                                 RETURN DATE;
31     PRAGMA RESTRICT_REFERENCES(GET_REQ_APPROVAL_DATE, WNDS, WNPS, RNPS);
32 
33   FUNCTION      GET_SUPPLIER_APPROVED(p_po_dist_id      IN NUMBER)
34                                 RETURN VARCHAR2;
35     PRAGMA RESTRICT_REFERENCES(GET_SUPPLIER_APPROVED, WNDS, WNPS, RNPS);
36 
37  FUNCTION      GET_SUPPLIER_APPROVED(p_po_dist_id      IN NUMBER,
38                                      p_vendor_id       IN NUMBER,
39                                      p_vendor_site_id  IN NUMBER,
40                                      p_ship_to_org_id  IN NUMBER,
41                                      p_item_id         IN NUMBER,
42                                      p_category_id     IN NUMBER
43                                      )
44                                 RETURN VARCHAR2;
45     PRAGMA RESTRICT_REFERENCES(GET_SUPPLIER_APPROVED, WNDS, WNPS, RNPS);
46 
47  FUNCTION 	get_check_cut_date(p_po_dist_id		NUMBER)
48 							RETURN DATE;
49 
50     PRAGMA RESTRICT_REFERENCES(get_check_cut_date, WNDS, WNPS, RNPS);
51 
52  FUNCTION	get_invoice_received_date(p_po_dist_id    NUMBER)
53 							RETURN DATE;
54 
55     PRAGMA RESTRICT_REFERENCES(get_invoice_received_date, WNDS, WNPS, RNPS);
56 
57  FUNCTION	get_invoice_creation_date(p_po_dist_id	 NUMBER)
58 							RETURN DATE;
59 
60     PRAGMA RESTRICT_REFERENCES(get_invoice_creation_date, WNDS, WNPS, RNPS);
61 
62  FUNCTION	get_goods_received_date(p_po_line_loc_id	 NUMBER)
63 							RETURN DATE;
64 
65     PRAGMA RESTRICT_REFERENCES(get_goods_received_date, WNDS, WNPS, RNPS);
66 
67  FUNCTION 	get_ipv(p_po_dist_id	NUMBER)
68 							RETURN NUMBER;
69 
70     PRAGMA RESTRICT_REFERENCES(get_ipv, WNDS, WNPS, RNPS);
71 
72 END POA_EDW_SPEND_PKG;