178:
179: -- Creation dates search
180: IF p_trans_creation_dt_from IS NOT NULL THEN
181: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE >= ');
182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));
183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN
186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');
183: END IF;
184:
185: IF p_trans_creation_dt_to IS NOT NULL THEN
186: fnd_dsql.add_text(' AND UCTRANS.CREATION_DATE <= ');
187: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_to));
188: END IF;
189:
190: -- Transmission dates search
191: IF p_trans_transmit_dt_from IS NOT NULL THEN
189:
190: -- Transmission dates search
191: IF p_trans_transmit_dt_from IS NOT NULL THEN
192: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP >= ');
193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));
194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN
197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');
194: END IF;
195:
196: IF p_trans_transmit_dt_to IS NOT NULL THEN
197: fnd_dsql.add_text(' AND UCTRANS.DATETIMESTAMP <= ');
198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));
199: END IF;
200:
201:
202: l_update_stmt := fnd_dsql.get_text(FALSE);