PACKAGE: APPS.GML_ORAUDTR_XMLP_PKG

Source

1 PACKAGE GML_ORAUDTR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ORAUDTRS.pls 120.0 2007/12/24 13:23:49 nchinnam noship $ */
3   P_DEFAULT_ORGN VARCHAR2(4);
4 
5   P_DEFAULT_USER NUMBER;
6 
7   PARAM_WHERE_CLAUSE VARCHAR2(700);
8 
9   P_FROM_SHIP_TO VARCHAR2(32);
10 
11   P_TO_SHIP_TO VARCHAR2(32);
12 
13   P_FROM_ORDER_NO VARCHAR2(32);
14 
15   P_TO_ORDER_NO VARCHAR2(32);
16 
17   P_FROM_ITEM_NO VARCHAR2(32);
18 
19   P_TO_ITEM_NO VARCHAR2(32);
20 
21   P_FROM_CHANGEDATE DATE;
22 
23   P_TO_CHANGEDATE DATE;
24 
25   P_FROM_OPER NUMBER;
26 
27   P_TO_OPER NUMBER;
28 
29   PARAM_WHERE_CLAUSE1 VARCHAR2(700);
30 
31   P_SORT1 VARCHAR2(30);
32 
33   P_SORT2 VARCHAR2(30);
34 
35   P_SORT3 VARCHAR2(30);
36 
37   P_SORT4 VARCHAR2(30);
38 
39   P_SORTM VARCHAR2(400):= '  ';
40 
41   P_SORTD VARCHAR2(300):='  ';
42 
43   P_USER_CLASS1TO8 VARCHAR2(4);
44 
45   P_USER_CLASS9TO16 VARCHAR2(4);
46 
47   P_USER_CLASS17TO24 VARCHAR2(4);
48 
49   P_USER_CLASS25TO30 VARCHAR2(4);
50 
51   P_CONC_REQUEST_ID NUMBER;
52 
53   CP_ORGN_NAME VARCHAR2(40);
54 
55   CP_DEFAULT_USER VARCHAR2(32767);
56 
57   CP_SORT_1 VARCHAR2(80);
58 
59   CP_SORT_2 VARCHAR2(80);
60 
61   CP_SORT_3 VARCHAR2(80);
62 
63   CP_SORT_4 VARCHAR2(80);
64 
65   FUNCTION BEFOREREPORT RETURN BOOLEAN;
66 
67   function F_CF_1(v_value1 number,billing_currency varchar2) return varchar2;
68 
69   FUNCTION AFTERPFORM RETURN BOOLEAN;
70 
71   FUNCTION FMT_MASK(P_VALUE IN NUMBER
72                    ,P_CUR IN CHARACTER) RETURN CHARACTER;
73 
74   FUNCTION CF_SORT_DESCFORMULA RETURN VARCHAR2;
75 
76   PROCEDURE ORUADTR_HEADER;
77 
78   FUNCTION CF_USER_NAMEFORMULA(CREATED_BY_1 IN NUMBER) RETURN CHAR;
79 
80   FUNCTION CF_USER_NAME2FORMULA(CREATED_BY2 IN NUMBER) RETURN CHAR;
81 
82   FUNCTION AFTERREPORT RETURN BOOLEAN;
83 
84   FUNCTION CP_ORGN_NAME_P RETURN VARCHAR2;
85 
86   FUNCTION CP_DEFAULT_USER_P RETURN VARCHAR2;
87 
88   FUNCTION CP_SORT_1_P RETURN VARCHAR2;
89 
90   FUNCTION CP_SORT_2_P RETURN VARCHAR2;
91 
92   FUNCTION CP_SORT_3_P RETURN VARCHAR2;
93 
94   FUNCTION CP_SORT_4_P RETURN VARCHAR2;
95 
96   PRN_LINES NUMBER;
97 
98 END GML_ORAUDTR_XMLP_PKG;
99