PACKAGE: APPS.GML_GMLUNALC_XMLP_PKG

Source

1 PACKAGE GML_GMLUNALC_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: GMLUNALCS.pls 120.0 2007/12/21 11:46:09 krreddy noship $ */
3   P_DEFAULT_LOCATION VARCHAR2(40);
4 
5   P_FROM_CUST_NO VARCHAR2(32);
6 
7   P_FROM_ITEM_NO VARCHAR2(32);
8 
9   P_FROM_ORDER_NO NUMBER;
10 
11   P_FROM_WHSE VARCHAR2(4);
12 
13   P_FROM_SHIPDATE DATE;
14 
15   P_SORT VARCHAR2(100);
16 
17   P_SORT_1 VARCHAR2(30);
18 
19   P_SORT_2 VARCHAR2(30);
20 
21   P_DEFAULT_USER NUMBER;
22 
23   P_SORT_3 VARCHAR2(30);
24 
25   P_SORT_4 VARCHAR2(30);
26 
27   P_TO_CUST_NO VARCHAR2(32);
28 
29   P_TO_ITEM_NO VARCHAR2(32);
30 
31   P_TO_ORDER_NO NUMBER;
32 
33   P_TO_WHSE VARCHAR2(4);
34 
35   PARAM_WHERE_CLAUSE VARCHAR2(4000);
36 
37   P_DEFAULT_ORGN VARCHAR2(200);
38 
39   P_TO_SHIPDATE DATE;
40 
41   P_ORDER_BY_CLAUSE VARCHAR2(2000);
42 
43   P_CONC_REQUEST_ID NUMBER;
44 
45   CP_ORGN_NAME VARCHAR2(240);
46 
47   CP_USER VARCHAR2(40);
48 
49   CP_SORT_4 VARCHAR2(80);
50 
51   CP_SORT_3 VARCHAR2(80);
52 
53   CP_SORT_2 VARCHAR2(80);
54 
55   CP_SORT_1 VARCHAR2(80);
56 
57   FUNCTION AFTERPFORM RETURN BOOLEAN;
58 
59   FUNCTION CF_1FORMULA(ITEM_ID IN NUMBER
60                       ,WHSE_CODE IN VARCHAR2
61                       ,QC_GRADE IN VARCHAR2
62                       ,UOM IN VARCHAR2) RETURN NUMBER;
63 
64   FUNCTION CF_SORT_DESCFORMULA RETURN VARCHAR2;
65 
66   FUNCTION BEFOREREPORT RETURN BOOLEAN;
67 
68   FUNCTION CF_LINE_NUMBERFORMULA(LINE_NUMBER IN NUMBER
69                                 ,SHIPMENT_NUMBER IN NUMBER) RETURN NUMBER;
70 
71   FUNCTION CF_UNALLOCATED_INVENTORYFORMUL(ITEM_ID IN NUMBER
72                                          ,LINE_ID IN NUMBER
73                                          ,UNALLOCATED_INVENTORY IN NUMBER
74                                          ,UOM IN VARCHAR2) RETURN NUMBER;
75 
76   FUNCTION AFTERREPORT RETURN BOOLEAN;
77 
78   FUNCTION CP_ORGN_NAME_P RETURN VARCHAR2;
79 
80   FUNCTION CP_USER_P RETURN VARCHAR2;
81 
82   FUNCTION CP_SORT_4_P RETURN VARCHAR2;
83 
84   FUNCTION CP_SORT_3_P RETURN VARCHAR2;
85 
86   FUNCTION CP_SORT_2_P RETURN VARCHAR2;
87 
88   FUNCTION CP_SORT_1_P RETURN VARCHAR2;
89 
90 END GML_GMLUNALC_XMLP_PKG;
91