APPS.IGS_PS_GEN_008 dependencies on IGS_PS_TCH_RESP

Line 882: v_teach_resp_rec IGS_PS_TCH_RESP%ROWTYPE;

878: PROCEDURE crspl_ins_teach_resp (
879: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
880: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
881: AS
882: v_teach_resp_rec IGS_PS_TCH_RESP%ROWTYPE;
883: CURSOR c_teach_resp_rec IS
884: SELECT *
885: FROM IGS_PS_TCH_RESP
886: WHERE unit_cd = p_unit_cd AND

Line 885: FROM IGS_PS_TCH_RESP

881: AS
882: v_teach_resp_rec IGS_PS_TCH_RESP%ROWTYPE;
883: CURSOR c_teach_resp_rec IS
884: SELECT *
885: FROM IGS_PS_TCH_RESP
886: WHERE unit_cd = p_unit_cd AND
887: version_number = p_version_number;
888:
889: BEGIN

Line 893: IGS_PS_TCH_RESP_PKG.Insert_Row(

889: BEGIN
890: FOR v_teach_resp_rec IN c_teach_resp_rec LOOP
891: BEGIN
892: x_rowid := NULL;
893: IGS_PS_TCH_RESP_PKG.Insert_Row(
894: X_ROWID => x_rowid,
895: X_UNIT_CD => p_new_unit_cd,
896: X_VERSION_NUMBER => p_new_version_number,
897: X_OU_START_DT => v_teach_resp_rec.ou_start_dt,

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,

Line 2324: --- Check if the IGS_PS_TCH_RESP record exists for the old IGS_PS_UNIT code

2320: --- substituted values. A new IGS_GE_NOTE record must be created as well.
2321: crspl_ins_unit_ver_note(
2322: p_old_unit_cd,
2323: p_old_version_number);
2324: --- Check if the IGS_PS_TCH_RESP record exists for the old IGS_PS_UNIT code
2325: --- and version number. If it does exist, create the new record with the
2326: --- substituted values.
2327: crspl_ins_teach_resp(
2328: p_old_unit_cd,