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.

APPS.IGS_PR_RU_CA_TYPE_PKG dependencies on IGS_GE_NUMBER

Line 667: new_references.pra_sequence_number := IGS_GE_NUMBER.to_num(column_value);

663: BEGIN
664: IF column_name IS NULL THEN
665: NULL;
666: ELSIF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' then
667: new_references.pra_sequence_number := IGS_GE_NUMBER.to_num(column_value);
668: ELSIF upper(Column_name) = 'END_SEQUENCE_NUMBER' then
669: new_references.end_sequence_number := IGS_GE_NUMBER.to_num(column_value);
670: ELSIF upper(Column_name) = 'START_SEQUENCE_NUMBER' then
671: new_references.start_sequence_number := IGS_GE_NUMBER.to_num(column_value);

Line 669: new_references.end_sequence_number := IGS_GE_NUMBER.to_num(column_value);

665: NULL;
666: ELSIF upper(Column_name) = 'PRA_SEQUENCE_NUMBER' then
667: new_references.pra_sequence_number := IGS_GE_NUMBER.to_num(column_value);
668: ELSIF upper(Column_name) = 'END_SEQUENCE_NUMBER' then
669: new_references.end_sequence_number := IGS_GE_NUMBER.to_num(column_value);
670: ELSIF upper(Column_name) = 'START_SEQUENCE_NUMBER' then
671: new_references.start_sequence_number := IGS_GE_NUMBER.to_num(column_value);
672: ELSIF upper(Column_name) = 'PRG_CAL_TYPE' then
673: new_references.prg_cal_type:= column_value;

Line 671: new_references.start_sequence_number := IGS_GE_NUMBER.to_num(column_value);

667: new_references.pra_sequence_number := IGS_GE_NUMBER.to_num(column_value);
668: ELSIF upper(Column_name) = 'END_SEQUENCE_NUMBER' then
669: new_references.end_sequence_number := IGS_GE_NUMBER.to_num(column_value);
670: ELSIF upper(Column_name) = 'START_SEQUENCE_NUMBER' then
671: new_references.start_sequence_number := IGS_GE_NUMBER.to_num(column_value);
672: ELSIF upper(Column_name) = 'PRG_CAL_TYPE' then
673: new_references.prg_cal_type:= column_value;
674: ELSIF upper(Column_name) = 'PROGRESSION_RULE_CAT' then
675: new_references.progression_rule_cat:= column_value;

Line 677: new_references.start_effective_period := IGS_GE_NUMBER.to_num(column_value);

673: new_references.prg_cal_type:= column_value;
674: ELSIF upper(Column_name) = 'PROGRESSION_RULE_CAT' then
675: new_references.progression_rule_cat:= column_value;
676: ELSIF upper(Column_name) = 'START_EFFECTIVE_PERIOD' then
677: new_references.start_effective_period := IGS_GE_NUMBER.to_num(column_value);
678: ELSIF upper(Column_name) = 'NUM_OF_APPLICATIONS' then
679: new_references.num_of_applications := IGS_GE_NUMBER.to_num(column_value);
680: END IF;
681:

Line 679: new_references.num_of_applications := IGS_GE_NUMBER.to_num(column_value);

675: new_references.progression_rule_cat:= column_value;
676: ELSIF upper(Column_name) = 'START_EFFECTIVE_PERIOD' then
677: new_references.start_effective_period := IGS_GE_NUMBER.to_num(column_value);
678: ELSIF upper(Column_name) = 'NUM_OF_APPLICATIONS' then
679: new_references.num_of_applications := IGS_GE_NUMBER.to_num(column_value);
680: END IF;
681:
682: IF UPPER(column_name) = 'PRA_SEQUENCE_NUMBER' OR column_name IS NULL THEN
683: IF new_references.pra_sequence_number < 1 OR