DBA Data[Home] [Help]

APPS.IGS_GR_VENUE_PKG dependencies on IGS_GE_NUMBER

Line 230: new_references.SUPERVISOR_LIMIT:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

226: BEGIN
227: IF Column_Name is null THEN
228: NULL;
229: ELSIF upper(Column_name) = 'SUPERVISOR_LIMIT' THEN
230: new_references.SUPERVISOR_LIMIT:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
231:
232: ELSIF upper(Column_name) = 'CLOSED_IND' THEN
233: new_references.CLOSED_IND:= COLUMN_VALUE ;
234:

Line 242: new_references.BOOKING_COST:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

238: ELSIF upper(Column_name) = 'VENUE_CD' THEN
239: new_references.VENUE_CD:= COLUMN_VALUE ;
240:
241: ELSIF upper(Column_name) = 'BOOKING_COST' THEN
242: new_references.BOOKING_COST:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
243:
244: ELSIF upper(Column_name) = 'NUMBER_OF_SEATS' THEN
245: new_references.NUMBER_OF_SEATS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
246:

Line 245: new_references.NUMBER_OF_SEATS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

241: ELSIF upper(Column_name) = 'BOOKING_COST' THEN
242: new_references.BOOKING_COST:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
243:
244: ELSIF upper(Column_name) = 'NUMBER_OF_SEATS' THEN
245: new_references.NUMBER_OF_SEATS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
246:
247: ELSIF upper(Column_name) = 'PRIORITY_CD' THEN
248: new_references.PRIORITY_CD:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
249:

Line 248: new_references.PRIORITY_CD:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

244: ELSIF upper(Column_name) = 'NUMBER_OF_SEATS' THEN
245: new_references.NUMBER_OF_SEATS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
246:
247: ELSIF upper(Column_name) = 'PRIORITY_CD' THEN
248: new_references.PRIORITY_CD:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
249:
250: END IF ;
251:
252: IF upper(Column_name) = 'SUPERVISOR_LIMIT' OR COLUMN_NAME IS NULL THEN