71:
72: IF (ret_val = -1) THEN
73: p_order_date_lo := NULL;
74: ELSE
75: p_order_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER
76: (parm_number));
77:
78: END IF;
79:
83:
84: IF (ret_val = -1) THEN
85: p_order_date_hi := NULL;
86: ELSE
87: p_order_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER
88: (parm_number));
89:
90: END IF;
91:
96:
97: IF (ret_val = -1) THEN
98: p_schedule_date_lo := NULL;
99: ELSE
100: p_schedule_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
101:
102: END IF;
103:
104: -- SCHEDULE DATE To
107:
108: IF (ret_val = -1) THEN
109: p_schedule_date_hi := NULL;
110: ELSE
111: p_schedule_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
112:
113: END IF;
114:
115: -- PROMISE DATE(From)
118:
119: IF (ret_val = -1) THEN
120: p_promise_date_lo := NULL;
121: ELSE
122: p_promise_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
123:
124: END IF;
125:
126: -- PROMISE DATE To
129:
130: IF (ret_val = -1) THEN
131: p_promise_date_hi := NULL;
132: ELSE
133: p_promise_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
134:
135: END IF;
136:
137: --REQUEST DATE(From)
140:
141: IF (ret_val = -1) THEN
142: p_request_date_lo := NULL;
143: ELSE
144: p_request_date_lo := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
145:
146: END IF;
147:
148: -- REQUEST DATE To
151:
152: IF (ret_val = -1) THEN
153: p_request_date_hi := NULL;
154: ELSE
155: p_request_date_hi := FND_DATE.CANONICAL_TO_DATE(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
156:
157: END IF;
158:
159: -- BILL TO CUSTOMER NAME(From)