[Home] [Help]
PACKAGE: APPS.GMD_QCR05USR_XMLP_PKG
Source
1 PACKAGE GMD_QCR05USR_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: QCR05USRS.pls 120.0.12020000.2 2012/10/26 16:42:02 plowe ship $ */
3 FROM_LOTSTATUS VARCHAR2(80); -- Bug 14779924 increase from 4 to 80
4
5 TO_LOTSTATUS VARCHAR2(80); -- Bug 14779924 increase from 4 to 80
6
7 EXPIRED_ITEMS VARCHAR2(6);
8
9 RETEST_ITEMS VARCHAR2(4);
10
11 FUTURE_EXPIRE VARCHAR2(4);
12
13 EXCLUSIVE_TEST VARCHAR2(4);
14
15 EXPIRY_WITHIN NUMBER;
16
17 RETEST_WITHIN NUMBER;
18
19 FUTURE_RETEST VARCHAR2(4);
20
21 EXCLUSIVE_WITHIN NUMBER;
22
23 FROM_WHSE VARCHAR2(4);
24
25 TO_WHSE VARCHAR2(4);
26
27 SY_ALL VARCHAR2(3);
28
29 NONBLOCKSQL VARCHAR2(3);
30
31 TO_SUBINVENTORY VARCHAR2(32767);
32
33 FROM_SUBINVENTORY VARCHAR2(100);
34
35 P_ORGANIZATION_ID NUMBER;
36
37 P_CONC_REQUEST_ID NUMBER;
38
39 EXPIREDCP VARCHAR2(300):=' ';
40
41 RETEST_REQCP VARCHAR2(300):=' ';
42
43 FUTURE_EXPIRYCP VARCHAR2(500):=' ';
44
45 FUTURERETESTCP VARCHAR2(500):=' ';
46
47 EXCLUSIVE_TESTSCP VARCHAR2(500):=' ';
48
49 FROM_SUBINVENTORYCP VARCHAR2(80);
50
51 FROM_LOTSTATUSCP VARCHAR2(80); -- Bug 14779924 increase from 4 to 80
52
53 TO_LOTSTATUSCP VARCHAR2(80); -- Bug 14779924 increase from 4 to 80
54
55 TO_SUBINVENTORYCP VARCHAR2(80);
56
57 ORGCP VARCHAR2(20);
58
59 FUNCTION EXPIREDCFFORMULA RETURN VARCHAR2;
60
61 FUNCTION EXPIREDCPFORMULA(EXPIREDCF IN VARCHAR2) RETURN VARCHAR2;
62
63 FUNCTION RETEST_REQCFFORMULA RETURN VARCHAR2;
64
65 FUNCTION FUTURE_EXPIRECFFORMULA RETURN VARCHAR2;
66
67 FUNCTION FUTURE_EXPIRYCPFORMULA(FUTURE_EXPIRYCF IN VARCHAR2) RETURN VARCHAR2;
68
69 FUNCTION FUTURERETESTCPFORMULA(FUTURERETESTCF IN VARCHAR2) RETURN VARCHAR2;
70
71 FUNCTION FUTURERETESTCFFORMULA RETURN VARCHAR2;
72
73 FUNCTION EXCLUSIVE_TESTSCPFORMULA(EXCLUSIVE_TESTSCF IN VARCHAR2) RETURN VARCHAR2;
74
75 FUNCTION EXCLUSIVE_TESTSCFFORMULA RETURN VARCHAR2;
76
77 FUNCTION EXCLUSIVE_TESTVALIDTRIGGER RETURN BOOLEAN;
78
79 FUNCTION EXPIRED_ITEMSVALIDTRIGGER RETURN BOOLEAN;
80
81 FUNCTION EXCLUSIVE_WITHINVALIDTRIGGER RETURN BOOLEAN;
82
83 FUNCTION EXPIRY_WITHINVALIDTRIGGER RETURN BOOLEAN;
84
85 FUNCTION FUTURE_EXPIREVALIDTRIGGER RETURN BOOLEAN;
86
87 FUNCTION FUTURE_RETESTVALIDTRIGGER RETURN BOOLEAN;
88
89 FUNCTION RETEST_ITEMSVALIDTRIGGER RETURN BOOLEAN;
90
91 FUNCTION RETEST_WITHINVALIDTRIGGER RETURN BOOLEAN;
92
93 FUNCTION FROM_WHSEVALIDTRIGGER RETURN BOOLEAN;
94
95 FUNCTION TO_WHSEVALIDTRIGGER RETURN BOOLEAN;
96
97 FUNCTION AFTERPFORM RETURN BOOLEAN;
98
99 FUNCTION SUBINVENTORYCFFORMULA RETURN VARCHAR2;
100
101 FUNCTION LOT_STATUSCFFORMULA RETURN VARCHAR2;
102
103 FUNCTION FROM_SUBINVENTORYCFFORMULA RETURN VARCHAR2;
104
105 FUNCTION FROM_LOTSTATUSCFFORMULA RETURN VARCHAR2;
106
107 FUNCTION TO_LOTSTATUSCFFORMULA RETURN VARCHAR2;
108
109 FUNCTION TO_SUBINVENTORYCFFORMULA RETURN VARCHAR2;
110
111 PROCEDURE QCRO5USR_HEADER;
112
113 FUNCTION BEFOREREPORT RETURN BOOLEAN;
114
115 FUNCTION CF_MINFORMULA(MIN_SPEC IN VARCHAR2
116 ,TEST_TYPE IN VARCHAR2
117 ,PRECISION IN NUMBER) RETURN CHAR;
118
119 FUNCTION CF_MAXFORMULA(MAX_SPEC IN VARCHAR2
120 ,TEST_TYPE IN VARCHAR2
121 ,PRECISION IN NUMBER) RETURN CHAR;
122
123 FUNCTION CF_TARGETFORMULA(TARGET_SPEC IN NUMBER
124 ,TEST_TYPE IN VARCHAR2
125 ,PRECISION IN NUMBER) RETURN CHAR;
126
127 FUNCTION ORGCFFORMULA RETURN CHAR;
128
129 FUNCTION AFTERREPORT RETURN BOOLEAN;
130
131 FUNCTION EXPIREDCP_P RETURN VARCHAR2;
132
133 FUNCTION RETEST_REQCP_P RETURN VARCHAR2;
134
135 FUNCTION FUTURE_EXPIRYCP_P RETURN VARCHAR2;
136
137 FUNCTION FUTURERETESTCP_P RETURN VARCHAR2;
138
139 FUNCTION EXCLUSIVE_TESTSCP_P RETURN VARCHAR2;
140
141 FUNCTION FROM_SUBINVENTORYCP_P RETURN VARCHAR2;
142
143 FUNCTION FROM_LOTSTATUSCP_P RETURN VARCHAR2;
144
145 FUNCTION TO_LOTSTATUSCP_P RETURN VARCHAR2;
146
147 FUNCTION TO_SUBINVENTORYCP_P RETURN VARCHAR2;
148
149 FUNCTION ORGCP_P RETURN VARCHAR2;
150
151 END GMD_QCR05USR_XMLP_PKG;
152