PACKAGE: APPS.GMI_CMXFER02_XMLP_PKG

Source

1 PACKAGE GMI_CMXFER02_XMLP_PKG AS
2 /* $Header: CMXFER02S.pls 120.2 2007/12/27 15:47:09 nchinnam noship $ */
3   P_FROM_RELEASE_DATE DATE;
4 
5   P_TO_RELEASE_DATE DATE;
6 
7   P_FROM_SOURCE_WAREHOUSE VARCHAR2(10);
8 
9   CP_FROM_SOURCE_WAREHOUSE VARCHAR2(10);
10 
11   P_TO_SOURCE_WAREHOUSE VARCHAR2(10);
12 
13   CP_TO_SOURCE_WAREHOUSE VARCHAR2(10);
14 
15   P_FROM_DESTINATION_WAREHOUSE VARCHAR2(10);
16 
17   CP_FROM_DESTINATION_WAREHOUSE VARCHAR2(10);
18 
19   P_TO_DESTINATION_WAREHOUSE VARCHAR2(10);
20 
21   CP_TO_DESTINATION_WAREHOUSE VARCHAR2(10);
22 
23   P_FROM_TRANSFER_STATUS VARCHAR2(6);
24 
25   CP_FROM_TRANSFER_STATUS VARCHAR2(6);
26 
27   P_TO_TRANSFER_STATUS VARCHAR2(6);
28 
29   CP_TO_TRANSFER_STATUS VARCHAR2(6);
30 
31   P_FROM_ACTUAL_RECEIVE_DATE DATE;
32 
33   P_TO_ACTUAL_RECEIVE_DATE DATE;
34 
35   P_FROM_CANCEL_DATE DATE;
36 
37   P_TO_CANCEL_DATE DATE;
38 
39   P_FROM_SCHEDULED_RELEASE_DATE DATE;
40 
41   P_TO_SCHEDULED_RELEASE_DATE DATE;
42 
43   P_CONC_REQUEST_ID NUMBER;
44 
45   V_REPORT_NUMBER VARCHAR2(30);
46 
47   V_REPORT_TITLE VARCHAR2(250);
48 
49   LV_REPORT_TITLE VARCHAR2(250);
50 
51   V_SET_OF_BOOKS_NAME VARCHAR2(30);
52 
53   V_SUBTITLE VARCHAR2(240);
54 
55   P_FROM_BATCH_NUM VARCHAR2(50);
56 
57   P_TO_BATCH_NUM VARCHAR2(50);
58 
59   V_USER_ID VARCHAR2(30);
60 
61   RELEASEDATECP VARCHAR2(200):=' ';
62 
63   SOURCEWAREHOUSECP VARCHAR2(200) := ' ';
64 
65   DESTINATIONWAREHOUSECP VARCHAR2(200):= ' ';
66 
67   TRANSFERSTATUSCP VARCHAR2(200):= ' ';
68 
69   SCHEDULEDSHIPDATECP VARCHAR2(200):= ' ';
70 
71   CANCELDATECP VARCHAR2(200) := ' ';
72 
73   ACTUALRECEIVEDATECP VARCHAR2(200):= ' ';
74 
75   BATCHNOCP VARCHAR2(2500):= ' ';
76 
77   FUNCTION RELEASEDATECFFORMULA RETURN VARCHAR2;
78 
79   FUNCTION SOURCEWAREHOUSECFFORMULA RETURN VARCHAR2;
80 
81   FUNCTION DESTINATIONWAREHOUSECFFORMULA RETURN VARCHAR2;
82 
83   FUNCTION TREANSFERSTATUSCFFORMULA RETURN VARCHAR2;
84 
85   FUNCTION SCHEDULEDSHIPDATECFFORMULA RETURN VARCHAR2;
86 
87   FUNCTION CANCELDATECFFORMULA RETURN VARCHAR2;
88 
89   FUNCTION ACTUALRECEIVEDATECFFORMULA RETURN VARCHAR2;
90 
91   FUNCTION BEFOREREPORT RETURN BOOLEAN;
92 
93   PROCEDURE SETUP_REPORT;
94 
95   FUNCTION BATCHNOCFFORMULA RETURN VARCHAR2;
96 
97   FUNCTION RELEASE_CFFORMULA(STAT IN VARCHAR2) RETURN VARCHAR2;
98 
99   FUNCTION RECEIVE_CFFORMULA(STAT IN VARCHAR2) RETURN VARCHAR2;
100 
101   PROCEDURE HEADER;
102 
103   FUNCTION AFTERREPORT RETURN BOOLEAN;
104 
105   FUNCTION RELEASEDATECP_P RETURN VARCHAR2;
106 
107   FUNCTION SOURCEWAREHOUSECP_P RETURN VARCHAR2;
108 
109   FUNCTION DESTINATIONWAREHOUSECP_P RETURN VARCHAR2;
110 
111   FUNCTION TRANSFERSTATUSCP_P RETURN VARCHAR2;
112 
113   FUNCTION SCHEDULEDSHIPDATECP_P RETURN VARCHAR2;
114 
115   FUNCTION CANCELDATECP_P RETURN VARCHAR2;
116 
117   FUNCTION ACTUALRECEIVEDATECP_P RETURN VARCHAR2;
118 
119   FUNCTION BATCHNOCP_P RETURN VARCHAR2;
120 
121 END GMI_CMXFER02_XMLP_PKG;
122