PACKAGE: APPS.GMI_CMXFER01_XMLP_PKG

Source

1 PACKAGE GMI_CMXFER01_XMLP_PKG AS
2 /* $Header: CMXFER01S.pls 120.0 2007/12/24 13:12:56 nchinnam noship $ */
3   P_FROM_RELEASE_DATE DATE;
4 
5   P_TO_RELEASE_DATE DATE;
6 
7   P_FROM_WAREHOUSE VARCHAR2(10);
8 
9   P_TO_WAREHOUSE VARCHAR2(10);
10 
11   P_FROM_DESTINATION_WAREHOUSE VARCHAR2(10);
12 
13   P_TO_DESTINATION_WAREHOUSE VARCHAR2(10);
14 
15   P_FROM_TRANSFER_STATUS VARCHAR2(80);
16 
17   P_TO_TRANSFER_STATUS VARCHAR2(80);
18 
19   LP_FROM_RELEASE_DATE varchar2(25);
20 LP_TO_RELEASE_DATE varchar2(25);
21 LP_FROM_SCHEDULED_RELEASE_DATE varchar2(25);
22 LP_TO_SCHEDULED_RELEASE_DATE varchar2(25);
23 LP_FROM_ACTUAL_RECEIVE_DATE varchar2(25);
24 LP_TO_ACTUAL_RECEIVE_DATE varchar2(25);
25 LP_FROM_CANCEL_DATE varchar2(25);
26 LP_TO_CANCEL_DATE varchar2(25);
27 
28 LP_FROM_WAREHOUSE VARCHAR2(10);
29 
30   LP_TO_WAREHOUSE VARCHAR2(10);
31 
32   LP_FROM_DESTINATION_WAREHOUSE VARCHAR2(10);
33 
34   LP_TO_DESTINATION_WAREHOUSE VARCHAR2(10);
35 
36   LP_FROM_TRANSFER_STATUS VARCHAR2(80);
37 
38   LP_TO_TRANSFER_STATUS VARCHAR2(80);
39 
40   P_FROM_ACTUAL_RECEIVE_DATE DATE;
41 
42   P_TO_ACTUAL_RECEIVE_DATE DATE;
43 
44   P_FROM_CANCEL_DATE DATE;
45 
46   P_TO_CANCEL_DATE DATE;
47 
48   P_FROM_SCHEDULED_RELEASE_DATE DATE;
49 
50   P_TO_SCHEDULED_RELEASE_DATE DATE;
51 
52   USER_ID VARCHAR2(40);
53 
54   P_ORGN VARCHAR2(40);
55 
56   P_CONC_REQUEST_ID NUMBER;
57 
58   RELEASEDATECP VARCHAR2(200);
59 
60   SOURCEWAREHOUSECP VARCHAR2(200);
61 
62   DESTINATIONWAREHOUSECP VARCHAR2(200);
63 
64   TRANSFERSTATUSCP VARCHAR2(200);
65 
66   SCHEDULEDSHIPDATECP VARCHAR2(200);
67 
68   CANCELDATECP VARCHAR2(200);
69 
70   ACTUALRECEIVEDATECP VARCHAR2(200);
71 
72   FUNCTION RELEASEDATECFFORMULA RETURN VARCHAR2;
73 
74   FUNCTION SOURCEWAREHOUSECFFORMULA RETURN VARCHAR2;
75 
76   FUNCTION DESTINATIONWAREHOUSECFFORMULA RETURN VARCHAR2;
77 
78   FUNCTION TREANSFERSTATUSCFFORMULA RETURN VARCHAR2;
79 
80   FUNCTION SCHEDULEDSHIPDATECFFORMULA RETURN VARCHAR2;
81 
82   FUNCTION CANCELDATECFFORMULA RETURN VARCHAR2;
83 
84   FUNCTION ACTUALRECEIVEDATECFFORMULA RETURN VARCHAR2;
85 
86   FUNCTION BEFOREREPORT RETURN BOOLEAN;
87 
88   PROCEDURE HEADER;
89 
90   FUNCTION AFTERREPORT RETURN BOOLEAN;
91 
92   FUNCTION RELEASEDATECP_P RETURN VARCHAR2;
93 
94   FUNCTION SOURCEWAREHOUSECP_P RETURN VARCHAR2;
95 
96   FUNCTION DESTINATIONWAREHOUSECP_P RETURN VARCHAR2;
97 
98   FUNCTION TRANSFERSTATUSCP_P RETURN VARCHAR2;
99 
100   FUNCTION SCHEDULEDSHIPDATECP_P RETURN VARCHAR2;
101 
102   FUNCTION CANCELDATECP_P RETURN VARCHAR2;
103 
104   FUNCTION ACTUALRECEIVEDATECP_P RETURN VARCHAR2;
105 
106 END GMI_CMXFER01_XMLP_PKG;
107