eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_GR_CRMN_PKG dependencies on IGS_GE_NUMBER

Line 289: new_references.GRD_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

285: ELSIF upper(Column_name) = 'VENUE_CD' THEN
286: new_references.VENUE_CD:= COLUMN_VALUE ;
287:
288: ELSIF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' THEN
289: new_references.GRD_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
290:
291: ELSIF upper(Column_name) = 'CEREMONY_NUMBER' THEN
292: new_references.CEREMONY_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
293:

Line 292: new_references.CEREMONY_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

288: ELSIF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' THEN
289: new_references.GRD_CI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
290:
291: ELSIF upper(Column_name) = 'CEREMONY_NUMBER' THEN
292: new_references.CEREMONY_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
293:
294: ELSIF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' THEN
295: new_references.CEREMONY_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
296:

Line 295: new_references.CEREMONY_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

291: ELSIF upper(Column_name) = 'CEREMONY_NUMBER' THEN
292: new_references.CEREMONY_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
293:
294: ELSIF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' THEN
295: new_references.CEREMONY_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
296:
297: ELSIF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' THEN
298: new_references.CLOSING_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
299:

Line 298: new_references.CLOSING_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

294: ELSIF upper(Column_name) = 'CEREMONY_DAI_SEQUENCE_NUMBER' THEN
295: new_references.CEREMONY_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
296:
297: ELSIF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' THEN
298: new_references.CLOSING_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
299:
300: ELSIF upper(Column_name) = 'CEREMONY_FEE' THEN
301: new_references.CEREMONY_FEE:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
302:

Line 301: new_references.CEREMONY_FEE:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

297: ELSIF upper(Column_name) = 'CLOSING_DAI_SEQUENCE_NUMBER' THEN
298: new_references.CLOSING_DAI_SEQUENCE_NUMBER:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
299:
300: ELSIF upper(Column_name) = 'CEREMONY_FEE' THEN
301: new_references.CEREMONY_FEE:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
302:
303: ELSIF upper(Column_name) = 'NUMBER_OF_GUESTS' THEN
304: new_references.NUMBER_OF_GUESTS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
305: END IF ;

Line 304: new_references.NUMBER_OF_GUESTS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;

300: ELSIF upper(Column_name) = 'CEREMONY_FEE' THEN
301: new_references.CEREMONY_FEE:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
302:
303: ELSIF upper(Column_name) = 'NUMBER_OF_GUESTS' THEN
304: new_references.NUMBER_OF_GUESTS:= IGS_GE_NUMBER.to_num(COLUMN_VALUE) ;
305: END IF ;
306:
307: IF upper(Column_name) = 'CEREMONY_DT_ALIAS' OR COLUMN_NAME IS NULL THEN
308: IF new_references.CEREMONY_DT_ALIAS<> upper(NEW_REFERENCES.CEREMONY_DT_ALIAS) then