APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_THS_PNL_MBR

Line 698: FROM IGS_RE_THS_PNL_MBR tpm

694: tpm.thesis_result_cd,
695: tpm.paid_dt,
696: tpm.tracking_id,
697: tpm.recommendation_summary
698: FROM IGS_RE_THS_PNL_MBR tpm
699: WHERE tpm.ca_person_id = p_person_id AND
700: tpm.ca_sequence_number = p_transfer_ca_sequence_number AND
701: tpm.the_sequence_number = cp_tex_the_sequence_number AND
702: tpm.creation_dt = cp_tex_creation_dt;

Line 844: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(

840: DECLARE
841: l_rowid VARCHAR2(25);
842: BEGIN
843:
844: IGS_RE_THS_PNL_MBR_PKG.INSERT_ROW(
845: x_rowid => l_rowid,
846: x_ca_person_id => p_person_id,
847: x_ca_sequence_number => p_ca_sequence_number,
848: x_the_sequence_number => v_the_sequence_number,

Line 904: END LOOP; --(IGS_RE_THS_PNL_MBR)

900: END;
901:
902: END IF; -- c_tpmh%NOTFOUND
903: END IF; -- if IGS_RE_THESIS result_cd IS NOT NULL
904: END LOOP; --(IGS_RE_THS_PNL_MBR)
905: END LOOP; --(IGS_RE_THESIS_EXAM)
906: EXCEPTION
907: WHEN OTHERS THEN
908: ROLLBACK TO sp_thesis;