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.

[Home] [Help]

APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL

Line 23: and in the call to insert row of igs_ad_appl_eval_pkg

19: vvutukur 27-Nov-2002 Enh#2584986.GL Interface Build.Modifications done in function copy_child_records.
20: nshee 29-Aug-2002 Bug 2395510 added 6 columns as part of deferments build
21: RRENGARA 13-SEP-2002 Bug 2395510 added p_process parameter to call copy child records
22: rghosh 15-may-2003 Bug#2871426(Evaluator Entry and Assignment) Added the closed ind check in the cursor c_evaluators_cur
23: and in the call to insert row of igs_ad_appl_eval_pkg
24: *******************************************************************************/
25:
26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

Line 26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,

22: rghosh 15-may-2003 Bug#2871426(Evaluator Entry and Assignment) Added the closed ind check in the cursor c_evaluators_cur
23: and in the call to insert row of igs_ad_appl_eval_pkg
24: *******************************************************************************/
25:
26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

Line 29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

25:
26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
31: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
32: p_start_dt DATE)
33: RETURN BOOLEAN AS

Line 473: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

469:
470: -- Variable Declarations ----------------------------------------------------------------------------------------------------
471:
472: -- Resolve the parameters to get calendar types and sequence numbers
473: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:

Line 474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

470: -- Variable Declarations ----------------------------------------------------------------------------------------------------
471:
472: -- Resolve the parameters to get calendar types and sequence numbers
473: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

Line 475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

471:
472: -- Resolve the parameters to get calendar types and sequence numbers
473: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

Line 476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;

472: -- Resolve the parameters to get calendar types and sequence numbers
473: p_prev_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

Line 478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

474: p_prev_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:

Line 479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;

475: p_prev_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:
483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;

Line 480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;

476: p_prev_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:
483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;

Line 481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;

477:
478: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;
479: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE;
480: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE;
481: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE;
482:
483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
485:

Line 487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

483: l_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE;
484: l_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE;
485:
486: l_message_name VARCHAR2(1000);
487: l_new_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
488: l_new_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
489:
490: l_person_number hz_parties.party_number%TYPE;
491: l_group_desc igs_pe_persid_group.description%TYPE;

Line 538: igs_ad_appl aa,

534: CURSOR c_appl_inst(p_person_id hz_parties.party_id%TYPE) IS
535: SELECT
536: acai.*
537: FROM
538: igs_ad_appl aa,
539: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
540: igs_ad_ou_stat aous
541: WHERE
542: acai.adm_outcome_status = aous.adm_outcome_status

Line 572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

568:
569: l_exists VARCHAR2(1);
570: l_pers_grp VARCHAR2(1);
571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id

Line 573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

569: l_exists VARCHAR2(1);
570: l_pers_grp VARCHAR2(1);
571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id
577: AND admission_appl_number = cp_admission_appl_number;

Line 575: FROM igs_ad_appl_all

571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id
577: AND admission_appl_number = cp_admission_appl_number;
578:
579: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,

935: END admp_val_offer_future_term;
936:
937: FUNCTION handle_application(
938: p_person_id hz_parties.party_id%TYPE,
939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

938: p_person_id hz_parties.party_id%TYPE,
939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

Line 943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

939: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE

Line 944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

940: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
948: ) RETURN BOOLEAN IS

Line 945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

941: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
948: ) RETURN BOOLEAN IS
949: /*******************************************************************************

Line 946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

942: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
943: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
944: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
945: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
946: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
947: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE
948: ) RETURN BOOLEAN IS
949: /*******************************************************************************
950: Created by : Ramesh Rengarajan

Line 983: igs_ad_appl aa,

979: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
980: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
981: FROM
982: igs_ad_ps_appl_inst acai, /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
983: igs_ad_appl aa,
984: igs_ad_ps_appl aca
985: WHERE
986: acai.admission_appl_number = p_admission_appl_number
987: AND acai.sequence_number = p_sequence_number

Line 996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

992: AND aca.person_id = acai.person_id
993: AND aca.admission_appl_number = acai.admission_appl_number
994: AND aca.nominated_course_cd = acai.nominated_course_cd;
995:
996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
998: )
999: IS
1000: SELECT admission_application_type

Line 997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

993: AND aca.admission_appl_number = acai.admission_appl_number
994: AND aca.nominated_course_cd = acai.nominated_course_cd;
995:
996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
998: )
999: IS
1000: SELECT admission_application_type
1001: FROM igs_ad_ss_appl_typ

Line 1012: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;

1008: -----End cursor Declarations------------------------------------------------------------------
1009:
1010: -------------------Variable Declarations------------------------------------------------------
1011: l_message_name VARCHAR2(1000);
1012: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1013: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

Line 1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;

1012: l_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
1013: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
1018: l_application_type igs_ad_appl_all.application_type%TYPE;
1019: ------------------- End Variable Declarations------------------------------------------------------
1020: BEGIN

Line 1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;

1013: l_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE;
1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
1018: l_application_type igs_ad_appl_all.application_type%TYPE;
1019: ------------------- End Variable Declarations------------------------------------------------------
1020: BEGIN
1021:

Line 1018: l_application_type igs_ad_appl_all.application_type%TYPE;

1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
1018: l_application_type igs_ad_appl_all.application_type%TYPE;
1019: ------------------- End Variable Declarations------------------------------------------------------
1020: BEGIN
1021:
1022: FOR c_appl_inst_rec IN c_appl_inst LOOP

Line 1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

1183: fnd_file.put_line(fnd_file.log, 'Exception From handle application log ' || SQLERRM);
1184: RETURN FALSE;
1185: END handle_application;
1186:
1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1189: p_person_id HZ_PARTIES.party_id%TYPE,
1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

1186:
1187: FUNCTION copy_child_records(p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1188: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1189: p_person_id HZ_PARTIES.party_id%TYPE,
1190: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
1191: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
1192: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
1193: p_start_dt DATE,
1194: p_process VARCHAR2)

Line 1299: igs_ad_appl_perstat

1295: admission_appl_number ,
1296: persl_stat_type ,
1297: date_received
1298: FROM
1299: igs_ad_appl_perstat
1300: WHERE
1301: person_id = cp_person_id and
1302: admission_appl_number = cp_admission_appl_number;
1303:

Line 1482: igs_ad_appl_pgmapprv

1478: program_approval_date,
1479: program_approval_status,
1480: approval_notes
1481: FROM
1482: igs_ad_appl_pgmapprv
1483: WHERE
1484: person_id = cp_person_id and
1485: nominated_course_cd = cp_nominated_course_cd and
1486: sequence_number = cp_sequence_number and

Line 1547: igs_ad_appl_notes

1543: sequence_number ,
1544: note_type_id ,
1545: ref_notes_id
1546: FROM
1547: igs_ad_appl_notes
1548: WHERE
1549: person_id = cp_person_id and
1550: nominated_course_cd = cp_nominated_course_cd and
1551: sequence_number = cp_sequence_number and

Line 1577: igs_ad_appl_eval

1573: evaluation_sequence ,
1574: rating_scale_id,
1575: closed_ind -- added the closed ind check -- rghosh (bug#2871426)
1576: FROM
1577: igs_ad_appl_eval
1578: WHERE
1579: person_id = cp_person_id and
1580: nominated_course_cd = cp_nominated_course_cd and
1581: sequence_number = cp_sequence_number and

Line 1600: igs_ad_appl_arp

1596: sequence_number ,
1597: appl_rev_profile_id ,
1598: appl_revprof_revgr_id
1599: FROM
1600: igs_ad_appl_arp
1601: WHERE
1602: person_id = cp_person_id and
1603: nominated_course_cd = cp_nominated_course_cd and
1604: sequence_number = cp_sequence_number and

Line 1709: igs_ad_appl_perstat_pkg.insert_row(

1705: l_rowid := NULL;
1706: -- Personal Statements
1707: FOR c_perstat_rec IN c_perstat_cur(p_person_id, p_old_admission_appl_number) LOOP
1708: l_last_error := 'IGS_AD_CHILD_PER_STAT';
1709: igs_ad_appl_perstat_pkg.insert_row(
1710: x_rowid => l_rowid,
1711: x_appl_perstat_id => c_perstat_rec.appl_perstat_id,
1712: x_person_id => c_perstat_rec.person_id,
1713: x_admission_appl_number => p_new_admission_appl_number,

Line 1891: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(

1887: -- program approval
1888:
1889: FOR c_pgmapp_rec IN c_pgmapp_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1890: l_last_error := 'IGS_AD_CHILD_PRG_APPR';
1891: IGS_AD_APPL_PGMAPPRV_pkg.INSERT_ROW(
1892: X_ROWID => l_rowid,
1893: X_APPL_PGMAPPRV_ID => l_primary_key,
1894: X_PERSON_ID => c_pgmapp_rec.person_id,
1895: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,

Line 1950: igs_ad_appl_notes_pkg.INSERT_ROW(

1946:
1947: -- NOTES
1948: FOR c_notes_rec IN c_notes_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1949: l_last_error := 'IGS_AD_CHILD_APPL_NOTES';
1950: igs_ad_appl_notes_pkg.INSERT_ROW(
1951: X_ROWID => l_rowid,
1952: X_APPL_NOTES_ID => l_primary_key,
1953: X_PERSON_ID => c_notes_rec.person_id,
1954: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,

Line 1968: igs_ad_appl_eval_pkg.INSERT_ROW(

1964:
1965: -- Evaluators
1966: FOR c_evaluators_rec IN c_evaluators_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1967: l_last_error := 'IGS_AD_CHILD_EVAL';
1968: igs_ad_appl_eval_pkg.INSERT_ROW(
1969: x_rowid => l_rowid,
1970: x_person_id => c_evaluators_rec.person_id,
1971: x_admission_appl_number => p_new_admission_appl_number,
1972: x_nominated_course_cd => c_evaluators_rec.nominated_course_cd,

Line 1994: igs_ad_appl_arp_pkg.INSERT_ROW(

1990:
1991: -- Evaluators Review group
1992: FOR c_applrep_rec IN c_applrep_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1993: l_last_error := 'IGS_AD_CHILD_EVAL_RGRP';
1994: igs_ad_appl_arp_pkg.INSERT_ROW(
1995: X_ROWID => l_rowid,
1996: X_PERSON_ID => c_applrep_rec.person_id,
1997: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,
1998: X_NOMINATED_COURSE_CD => c_applrep_rec.nominated_course_cd,

Line 2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

2053: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
2061: p_start_dt DATE

Line 2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

2054: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
2061: p_start_dt DATE
2062: ) RETURN BOOLEAN IS

Line 2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

2055: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
2061: p_start_dt DATE
2062: ) RETURN BOOLEAN IS
2063: /*******************************************************************************

Line 2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

2056: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
2057: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
2058: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
2059: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
2060: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
2061: p_start_dt DATE
2062: ) RETURN BOOLEAN IS
2063: /*******************************************************************************
2064: Created by : Ramesh Rengarajan

Line 2098: igs_ad_appl aa,

2094: acai.*, aa.acad_cal_type, aa.acad_ci_sequence_number, aa.adm_fee_status, aa.alt_appl_id,
2095: NVL(acai.adm_cal_type,aa.adm_cal_type) final_adm_cal_type,
2096: NVL(acai.adm_ci_sequence_number,aa.adm_ci_sequence_number) final_adm_ci_sequence_number
2097: FROM
2098: igs_ad_appl aa,
2099: igs_ad_ps_appl_inst acai /* Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst Bug 3150054 */
2100: WHERE
2101: acai.person_id = p_person_id AND
2102: acai.nominated_course_cd = p_nominated_course_cd AND

Line 2112: igs_ad_appl

2108: CURSOR c_admcat_cur IS
2109: SELECT
2110: admission_cat, s_admission_process_type, appl_dt
2111: FROM
2112: igs_ad_appl
2113: WHERE
2114: person_id = p_person_id AND
2115: admission_appl_number = p_admission_appl_number;
2116:

Line 2168: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;

2164: v_deferral_allowed_ind VARCHAR2 (1);
2165: v_pre_enrol_ind VARCHAR2 (1);
2166: v_warn_level VARCHAR2(10);
2167: v_message_name VARCHAR2(100);
2168: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
2169: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
2170: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
2171: -- End Variable Declarations -------------------------------------------------------------------------------
2172:

Line 2169: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

2165: v_pre_enrol_ind VARCHAR2 (1);
2166: v_warn_level VARCHAR2(10);
2167: v_message_name VARCHAR2(100);
2168: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
2169: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
2170: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
2171: -- End Variable Declarations -------------------------------------------------------------------------------
2172:
2173: BEGIN

Line 2170: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;

2166: v_warn_level VARCHAR2(10);
2167: v_message_name VARCHAR2(100);
2168: l_adm_cat IGS_AD_APPL.admission_cat%TYPE;
2169: l_s_adm_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
2170: l_appl_dt IGS_AD_APPL.appl_dt%TYPE;
2171: -- End Variable Declarations -------------------------------------------------------------------------------
2172:
2173: BEGIN
2174: