DBA Data[Home] [Help]

APPS.IGS_PS_GEN_008 dependencies on IGS_PS_TCH_RESP_OVRD

Line 1174: FROM IGS_PS_TCH_RESP_OVRD tro

1170: tro.unit_class,
1171: tro.org_unit_cd,
1172: tro.ou_start_dt,
1173: tro.percentage
1174: FROM IGS_PS_TCH_RESP_OVRD tro
1175: WHERE tro.unit_cd = p_unit_cd AND
1176: tro.version_number = p_version_number AND
1177: tro.cal_type = p_cal_type AND
1178: tro.ci_sequence_number = p_ci_sequence_number AND

Line 1185: -- copy old IGS_PS_UNIT_VER IGS_PS_TCH_RESP_OVRD details to

1181:
1182: l_org_id NUMBER(15);
1183: BEGIN
1184: FOR c_tro_rec in c_tro LOOP
1185: -- copy old IGS_PS_UNIT_VER IGS_PS_TCH_RESP_OVRD details to
1186: -- new IGS_PS_UNIT-version
1187: BEGIN
1188: x_rowid := NULL;
1189:

Line 1192: IGS_PS_TCH_RESP_OVRD_PKG.INSERT_ROW(

1188: x_rowid := NULL;
1189:
1190: l_org_id := igs_ge_gen_003.get_org_id;
1191:
1192: IGS_PS_TCH_RESP_OVRD_PKG.INSERT_ROW(
1193: X_ROWID => x_rowid,
1194: X_UNIT_CD => p_new_unit_cd,
1195: X_VERSION_NUMBER => p_new_version_number,
1196: X_LOCATION_CD => c_tro_rec.location_cd,