PACKAGE: APPS.GML_ORUARPJ_XMLP_PKG

Source

1 PACKAGE GML_ORUARPJ_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: ORUARPJS.pls 120.0 2007/12/24 13:27:19 nchinnam noship $ */
3   P_SORT_1 VARCHAR2(30);
4 
5   P_SORT_2 VARCHAR2(30);
6 
7   P_SORT_3 VARCHAR2(30);
8 
9   P_SORT_4 VARCHAR2(30);
10 
11   PARAM_WHERE_CLAUSE VARCHAR2(700);
12 
13   P_SORT VARCHAR2(100);
14 
15   P_DEFAULT_ORGN VARCHAR2(4);
16 
17   P_DEFAULT_USER NUMBER;
18 
19   P_FROM_CUST_NO VARCHAR2(32);
20 
21   P_FROM_ITEM_NO VARCHAR2(32);
22 
23   P_FROM_ORDER_NO VARCHAR2(32);
24 
25   P_FROM_WHSE VARCHAR2(4);
26 
27   P_TO_WHSE VARCHAR2(4);
28 
29   P_TO_CUST_NO VARCHAR2(32);
30 
31   P_TO_ITEM_NO VARCHAR2(32);
32 
33   P_TO_ORDER_NO VARCHAR2(32);
34 
35   P_SHIPDATE DATE;
36 
37   P_CONC_REQUEST_ID NUMBER;
38 
39   CP_ORGN_NAME VARCHAR2(40);
40 
41   CP_USER VARCHAR2(40);
42 
43   CP_SORT_1 VARCHAR2(80);
44 
45   CP_SORT_2 VARCHAR2(80);
46 
47   CP_SORT_3 VARCHAR2(80);
48 
49   CP_SORT_4 VARCHAR2(80);
50 
51   FUNCTION AFTERPFORM RETURN BOOLEAN;
52 
53   function F_CF_1(v_value1 number,billing_currency varchar2) return varchar2;
54 
55   FUNCTION CF_1FORMULA(QC_GRADE_WANTED IN VARCHAR2
56                       ,ITEM_ID_1 IN NUMBER
57                       ,FROM_WHSE IN VARCHAR2
58                       ,ITEM_UM IN VARCHAR2
59                       ,ORDER_UM1 IN VARCHAR2) RETURN NUMBER;
60 
61   FUNCTION BEFOREREPORT RETURN BOOLEAN;
62 
63   FUNCTION CF_SORT_DESCFORMULA RETURN VARCHAR2;
64 
65   PROCEDURE GML_ORUARPJ_XMLP_PKG_HEADER;
66 
67   FUNCTION AFTERREPORT RETURN BOOLEAN;
68 
69   FUNCTION CP_ORGN_NAME_P RETURN VARCHAR2;
70 
71   FUNCTION CP_USER_P RETURN VARCHAR2;
72 
73   FUNCTION CP_SORT_1_P RETURN VARCHAR2;
74 
75   FUNCTION CP_SORT_2_P RETURN VARCHAR2;
76 
77   FUNCTION CP_SORT_3_P RETURN VARCHAR2;
78 
79   FUNCTION CP_SORT_4_P RETURN VARCHAR2;
80 
81   PRN_LINES NUMBER;
82 
83 END GML_ORUARPJ_XMLP_PKG;
84