DBA Data[Home] [Help]

APPS.IGS_CA_DA_INST_OFCNT_PKG dependencies on IGS_GE_NUMBER

Line 146: new_references.dai_sequence_number := igs_ge_number.to_num(column_value);

142: BEGIN
143: IF column_name is null then
144: NULL;
145: ELSIF UPPER(column_name) = 'DAI_SEQUENCE_NUMBER ' Then
146: new_references.dai_sequence_number := igs_ge_number.to_num(column_value);
147: Elsif UPPER(column_name) = 'CAL_TYPE' Then
148: NEW_REFERENCES.cal_type:= column_value;
149: Elsif UPPER(column_name) = 'DT_ALIAS' Then
150: NEW_REFERENCES.dt_alias := column_value;

Line 160: NEW_REFERENCES.constraint_resolution:= igs_ge_number.to_num(column_value);

156: NEW_REFERENCES.s_dt_offset_constraint_type:= column_value;
157: Elsif UPPER(column_name) = 'CONSTRAINT_CONDITION' Then
158: NEW_REFERENCES.constraint_condition:= column_value;
159: Elsif UPPER(column_name) = 'CONSTRAINT_RESOLUTION' Then
160: NEW_REFERENCES.constraint_resolution:= igs_ge_number.to_num(column_value);
161: ELSIF UPPER(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER' Then
162: new_references.offset_ci_sequence_number := igs_ge_number.to_num(column_value);
163: Elsif UPPER(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' Then
164: NEW_REFERENCES.offset_dai_sequence_number := igs_ge_number.to_num(column_value);

Line 162: new_references.offset_ci_sequence_number := igs_ge_number.to_num(column_value);

158: NEW_REFERENCES.constraint_condition:= column_value;
159: Elsif UPPER(column_name) = 'CONSTRAINT_RESOLUTION' Then
160: NEW_REFERENCES.constraint_resolution:= igs_ge_number.to_num(column_value);
161: ELSIF UPPER(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER' Then
162: new_references.offset_ci_sequence_number := igs_ge_number.to_num(column_value);
163: Elsif UPPER(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' Then
164: NEW_REFERENCES.offset_dai_sequence_number := igs_ge_number.to_num(column_value);
165: Elsif UPPER(column_name) = 'CI_SEQUENCE_NUMBER' Then
166: NEW_REFERENCES.ci_sequence_number :=igs_ge_number.to_num(column_value);

Line 164: NEW_REFERENCES.offset_dai_sequence_number := igs_ge_number.to_num(column_value);

160: NEW_REFERENCES.constraint_resolution:= igs_ge_number.to_num(column_value);
161: ELSIF UPPER(column_name) = 'OFFSET_CI_SEQUENCE_NUMBER' Then
162: new_references.offset_ci_sequence_number := igs_ge_number.to_num(column_value);
163: Elsif UPPER(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' Then
164: NEW_REFERENCES.offset_dai_sequence_number := igs_ge_number.to_num(column_value);
165: Elsif UPPER(column_name) = 'CI_SEQUENCE_NUMBER' Then
166: NEW_REFERENCES.ci_sequence_number :=igs_ge_number.to_num(column_value);
167: end if;
168: If upper(column_name) = 'DAI_SEQUENCE_NUMBER' or column_name is null Then

Line 166: NEW_REFERENCES.ci_sequence_number :=igs_ge_number.to_num(column_value);

162: new_references.offset_ci_sequence_number := igs_ge_number.to_num(column_value);
163: Elsif UPPER(column_name) = 'OFFSET_DAI_SEQUENCE_NUMBER' Then
164: NEW_REFERENCES.offset_dai_sequence_number := igs_ge_number.to_num(column_value);
165: Elsif UPPER(column_name) = 'CI_SEQUENCE_NUMBER' Then
166: NEW_REFERENCES.ci_sequence_number :=igs_ge_number.to_num(column_value);
167: end if;
168: If upper(column_name) = 'DAI_SEQUENCE_NUMBER' or column_name is null Then
169: if NEW_REFERENCES.dai_sequence_number <1 OR
170: NEW_REFERENCES.dai_sequence_number > 999999 then