eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_INS_CA_TRNSFR dependencies on IGS_RE_CANDIDATURE

Line 966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

962: v_ca_to_exists VARCHAR2(1);
963: cst_ca_to_sca CONSTANT VARCHAR2(3):= 'SCA';
964: cst_ca_to_acai CONSTANT VARCHAR2(4):= 'ACAI';
965: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;

963: cst_ca_to_sca CONSTANT VARCHAR2(3):= 'SCA';
964: cst_ca_to_acai CONSTANT VARCHAR2(4):= 'ACAI';
965: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

Line 968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;

964: cst_ca_to_acai CONSTANT VARCHAR2(4):= 'ACAI';
965: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
972: v_message_name Varchar2(30);

Line 969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;

965: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
972: v_message_name Varchar2(30);
973: v_person_id IGS_RE_CANDIDATURE.person_id%TYPE;

Line 970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

966: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
972: v_message_name Varchar2(30);
973: v_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
974: CURSOR c_ca IS

Line 971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

967: v_ca_govt_type_of_activity_cd IGS_RE_CANDIDATURE.govt_type_of_activity_cd%TYPE;
968: v_ca_research_topic IGS_RE_CANDIDATURE.research_topic%TYPE;
969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
972: v_message_name Varchar2(30);
973: v_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
974: CURSOR c_ca IS
975: SELECT ca.attendance_percentage,

Line 973: v_person_id IGS_RE_CANDIDATURE.person_id%TYPE;

969: v_ca_industry_links IGS_RE_CANDIDATURE.industry_links%TYPE;
970: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
971: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
972: v_message_name Varchar2(30);
973: v_person_id IGS_RE_CANDIDATURE.person_id%TYPE;
974: CURSOR c_ca IS
975: SELECT ca.attendance_percentage,
976: ca.govt_type_of_activity_cd,
977: ca.research_topic,

Line 980: FROM IGS_RE_CANDIDATURE ca

976: ca.govt_type_of_activity_cd,
977: ca.research_topic,
978: ca.industry_links,
979: ca.sequence_number
980: FROM IGS_RE_CANDIDATURE ca
981: WHERE ca.person_id = p_person_id AND
982: ca.sca_course_cd = p_transfer_course_cd;
983: CURSOR c_ca_to IS
984: SELECT 'x'

Line 985: FROM IGS_RE_CANDIDATURE ca_to

981: WHERE ca.person_id = p_person_id AND
982: ca.sca_course_cd = p_transfer_course_cd;
983: CURSOR c_ca_to IS
984: SELECT 'x'
985: FROM IGS_RE_CANDIDATURE ca_to
986: WHERE ca_to.person_id = p_person_id AND
987: (ca_to.sca_course_cd = p_sca_course_cd AND
988: p_parent = cst_ca_to_sca) OR
989: (ca_to.acai_admission_appl_number = p_acai_admission_appl_number AND

Line 994: SELECT IGS_RE_CANDIDATURE_SEQ_NUM_S.nextval

990: ca_to.acai_nominated_course_cd = p_acai_nominated_course_cd AND
991: ca_to.acai_sequence_number = p_acai_sequence_number AND
992: p_parent = cst_ca_to_acai);
993: CURSOR c_dual IS
994: SELECT IGS_RE_CANDIDATURE_SEQ_NUM_S.nextval
995: FROM dual;
996: BEGIN
997: -- Set the default message number
998: p_message_name := null;

Line 1052: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(

1048: l_rowid VARCHAR2(25);
1049: l_org_id NUMBER(15) := IGS_GE_GEN_003.GET_ORG_ID;
1050: BEGIN
1051:
1052: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(
1053: x_rowid => l_rowid,
1054: X_org_id => l_org_id,
1055: x_person_id => p_person_id,
1056: x_sequence_number => v_ca_sequence_number,