DBA Data[Home] [Help]

APPS.IGS_FI_F_RET_SCHD_HT_PKG dependencies on IGS_GE_NUMBER

Line 106: new_references.retention_percentage := IGS_GE_NUMBER.TO_NUM (column_value);

102: BEGIN
103: IF (column_name IS NULL) THEN
104: NULL;
105: ELSIF (UPPER (column_name) = 'RETENTION_PERCENTAGE') THEN
106: new_references.retention_percentage := IGS_GE_NUMBER.TO_NUM (column_value);
107: ELSIF (UPPER (column_name) = 'RETENTION_AMOUNT') THEN
108: new_references.retention_amount := IGS_GE_NUMBER.TO_NUM (column_value);
109: ELSIF (UPPER (column_name) = 'DT_ALIAS') THEN
110: new_references.dt_alias := column_value;

Line 108: new_references.retention_amount := IGS_GE_NUMBER.TO_NUM (column_value);

104: NULL;
105: ELSIF (UPPER (column_name) = 'RETENTION_PERCENTAGE') THEN
106: new_references.retention_percentage := IGS_GE_NUMBER.TO_NUM (column_value);
107: ELSIF (UPPER (column_name) = 'RETENTION_AMOUNT') THEN
108: new_references.retention_amount := IGS_GE_NUMBER.TO_NUM (column_value);
109: ELSIF (UPPER (column_name) = 'DT_ALIAS') THEN
110: new_references.dt_alias := column_value;
111: ELSIF (UPPER (column_name) = 'FEE_CAL_TYPE') THEN
112: new_references.fee_cal_type := column_value;

Line 116: new_references.sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);

112: new_references.fee_cal_type := column_value;
113: ELSIF (UPPER (column_name) = 'S_RELATION_TYPE') THEN
114: new_references.s_relation_type := column_value;
115: ELSIF (UPPER (column_name) = 'SEQUENCE_NUMBER') THEN
116: new_references.sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
117: ELSIF (UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') THEN
118: new_references.dai_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
119: ELSIF (UPPER (column_name) = 'SCHEDULE_NUMBER') THEN
120: new_references.schedule_number := IGS_GE_NUMBER.TO_NUM (column_value);

Line 118: new_references.dai_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);

114: new_references.s_relation_type := column_value;
115: ELSIF (UPPER (column_name) = 'SEQUENCE_NUMBER') THEN
116: new_references.sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
117: ELSIF (UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') THEN
118: new_references.dai_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
119: ELSIF (UPPER (column_name) = 'SCHEDULE_NUMBER') THEN
120: new_references.schedule_number := IGS_GE_NUMBER.TO_NUM (column_value);
121: ELSIF (UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') THEN
122: new_references.fee_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);

Line 120: new_references.schedule_number := IGS_GE_NUMBER.TO_NUM (column_value);

116: new_references.sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
117: ELSIF (UPPER (column_name) = 'DAI_SEQUENCE_NUMBER') THEN
118: new_references.dai_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
119: ELSIF (UPPER (column_name) = 'SCHEDULE_NUMBER') THEN
120: new_references.schedule_number := IGS_GE_NUMBER.TO_NUM (column_value);
121: ELSIF (UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') THEN
122: new_references.fee_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
123: END IF;
124: IF ((UPPER (column_name) = 'RETENTION_PERCENTAGE') OR (column_name IS NULL)) THEN

Line 122: new_references.fee_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);

118: new_references.dai_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
119: ELSIF (UPPER (column_name) = 'SCHEDULE_NUMBER') THEN
120: new_references.schedule_number := IGS_GE_NUMBER.TO_NUM (column_value);
121: ELSIF (UPPER (column_name) = 'FEE_CI_SEQUENCE_NUMBER') THEN
122: new_references.fee_ci_sequence_number := IGS_GE_NUMBER.TO_NUM (column_value);
123: END IF;
124: IF ((UPPER (column_name) = 'RETENTION_PERCENTAGE') OR (column_name IS NULL)) THEN
125: IF ((new_references.retention_percentage < 0) OR (new_references.retention_percentage > 100.00)) THEN
126: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');