PACKAGE: APPS.GMI_PIR05_XMLP_PKG

Source

1 PACKAGE GMI_PIR05_XMLP_PKG AS
2 /* $Header: PIR05S.pls 120.0 2007/12/24 13:19:12 nchinnam noship $ */
3   WHSE VARCHAR2(4);
4 
5   CYCLE VARCHAR2(32);
6 
7   FROM_COUNT NUMBER;
8 
9   TO_COUNT NUMBER;
10 
11   SORT_BY VARCHAR2(100);
12 
13   CYCLE_ID NUMBER;
14 
15   CYCLE_ID_1 NUMBER;
16 
17   PRN_FOR NUMBER;
18 
19   ORGN VARCHAR2(4);
20 
21   NONBLOCKSQL VARCHAR2(5);
22 
23   F_ORDER_BY VARCHAR2(100) := 'COUNT_NO';
24 
25   PHYSICAL_OR_CYCLE NUMBER:='1';
26 
27   P_CONC_REQUEST_ID NUMBER;
28 
29   P_ITEMUM2LABEL VARCHAR2(20);
30 
31   P_ITEMUM2DASH VARCHAR2(22);
32 
33   P_CSITEMUM2_LABEL VARCHAR2(20);
34 
35   P_CSITEMUM2_DASH VARCHAR2(22);
36 
37   FUNCTION WHSE_DESCFORMULA RETURN VARCHAR2;
38 
39   FUNCTION AFTERPFORM RETURN BOOLEAN;
40 
41   FUNCTION CYCLE_NOFORMULA RETURN VARCHAR2;
42 
43   PROCEDURE GMI_PIR05_XMLP_PKG_HEADER;
44 
45   FUNCTION BEFOREREPORT RETURN BOOLEAN;
46 
47   FUNCTION F_ITEMUM2FORMULA(ITEM_UM2 IN VARCHAR2) RETURN NUMBER;
48 
49   FUNCTION AFTERREPORT RETURN BOOLEAN;
50 
51   FUNCTION P_ITEMUM2LABEL_P RETURN VARCHAR2;
52 
53   FUNCTION P_ITEMUM2DASH_P RETURN VARCHAR2;
54 
55   FUNCTION P_CSITEMUM2_LABEL_P RETURN VARCHAR2;
56 
57   FUNCTION P_CSITEMUM2_DASH_P RETURN VARCHAR2;
58 
59 END GMI_PIR05_XMLP_PKG;
60