PACKAGE: APPS.GML_AUDIT_REPORTS

Source

1 PACKAGE GML_AUDIT_REPORTS AUTHID CURRENT_USER AS
2 /* $Header: GMLOGMCS.pls 115.3 99/07/16 06:15:42 porting ship  $ */
3 
4   FUNCTION get_ofi_line_count(p_hid NUMBER) RETURN NUMBER;
5   FUNCTION get_ofi_bline_count(p_hid NUMBER) RETURN NUMBER;
6 
7   FUNCTION get_ofi_total_cost(p_hid NUMBER) RETURN NUMBER;
8   FUNCTION get_ofi_btotal_cost(p_hid NUMBER) RETURN NUMBER;
9 
10   FUNCTION get_gemms_line_count(p_id NUMBER) RETURN NUMBER;
11   FUNCTION get_gemms_bline_count(p_hid NUMBER) RETURN NUMBER;
12 
13   FUNCTION get_gemms_total_cost(p_id NUMBER) RETURN NUMBER;
14   FUNCTION get_gemms_btotal_cost(p_hid NUMBER) RETURN NUMBER;
15 
16 
17   PRAGMA RESTRICT_REFERENCES(get_ofi_line_count,WNDS,WNPS);
18   PRAGMA RESTRICT_REFERENCES(get_ofi_bline_count,WNDS,WNPS);
19 
20   PRAGMA RESTRICT_REFERENCES(get_ofi_total_cost,WNDS,WNPS);
21   PRAGMA RESTRICT_REFERENCES(get_ofi_btotal_cost,WNDS,WNPS);
22 
23   PRAGMA RESTRICT_REFERENCES(get_gemms_line_count,WNDS,WNPS);
24   PRAGMA RESTRICT_REFERENCES(get_gemms_bline_count,WNDS,WNPS);
25 
26   PRAGMA RESTRICT_REFERENCES(get_gemms_total_cost,WNDS,WNPS);
27   PRAGMA RESTRICT_REFERENCES(get_gemms_btotal_cost,WNDS,WNPS);
28 
29 
30   FUNCTION match_ofi_gms_po_line(p_ohid  NUMBER,
31 				   p_olid  NUMBER,
32 				   p_ollid NUMBER,
33 				   p_gid   NUMBER,
34 				   p_glid  NUMBER) RETURN VARCHAR2;
35   FUNCTION chk_ofi_gms_poln_itm (p_olid  NUMBER,
36 				   p_glid  NUMBER) RETURN VARCHAR2;
37   FUNCTION chk_ofi_gms_poln_sts (p_ollid NUMBER,
38 				   p_glid  NUMBER) RETURN VARCHAR2;
39 
40   PRAGMA RESTRICT_REFERENCES(match_ofi_gms_po_line,WNDS,WNPS);
41   PRAGMA RESTRICT_REFERENCES(chk_ofi_gms_poln_itm,WNDS,WNPS);
42   PRAGMA RESTRICT_REFERENCES(chk_ofi_gms_poln_sts,WNDS,WNPS);
43 
44 
45   FUNCTION get_po_num( p_ponum VARCHAR2) RETURN VARCHAR2;
46   FUNCTION get_rel_num( p_ponum VARCHAR2) RETURN NUMBER;
47 
48   PRAGMA RESTRICT_REFERENCES(get_po_num,WNDS,WNPS);
49   PRAGMA RESTRICT_REFERENCES(get_rel_num,WNDS,WNPS);
50 
51 END GML_AUDIT_REPORTS;