APPS.IGS_PR_GEN_003 dependencies on IGS_PR_STU_OU_HIST

Line 964: r_spoh IGS_PR_STU_OU_HIST%ROWTYPE;

960: IS
961: gv_other_detail VARCHAR2(255);
962: BEGIN -- IGS_PR_INS_SPO_HIST
963: DECLARE
964: r_spoh IGS_PR_STU_OU_HIST%ROWTYPE;
965: v_create_history BOOLEAN DEFAULT FALSE;
966: BEGIN
967: -- check if a history record is required
968: IF NVL(p_new_prg_cal_type, 'NULL') <> NVL(p_old_prg_cal_type, 'NULL') THEN

Line 1134: INSERT INTO IGS_PR_STU_OU_HIST (

1130: IF r_spoh.hist_start_dt = r_spoh.hist_end_dt THEN
1131: r_spoh.hist_start_dt := r_spoh.hist_start_dt - 1 / (60*24*60);
1132: END IF;
1133: /*
1134: INSERT INTO IGS_PR_STU_OU_HIST (
1135: person_id,
1136: course_cd,
1137: sequence_number,
1138: hist_start_dt,

Line 1214: IGS_PR_STU_OU_HIST_PKG.INSERT_ROW (

1210: lv_rowid VARCHAR2(25);
1211: l_org_id NUMBER(15);
1212: BEGIN
1213: l_org_id := igs_ge_gen_003.get_org_id;
1214: IGS_PR_STU_OU_HIST_PKG.INSERT_ROW (
1215: X_ROWID => lv_rowid,
1216: x_PERSON_ID => r_spoh.person_id,
1217: x_COURSE_CD => r_spoh.course_cd,
1218: x_SEQUENCE_NUMBER => r_spoh.sequence_number,