DBA Data[Home] [Help]

APPS.IGS_UC_RELEASE_TRANS_PKG dependencies on IGS_GE_DATE

Line 182: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_from));

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 <= ');

Line 187: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_creation_dt_to));

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

Line 193: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_from));

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 <= ');

Line 198: fnd_dsql.add_bind(IGS_GE_DATE.igsdate(p_trans_transmit_dt_to));

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);