APPS.IGS_UC_TRAN_PROCESSOR_PKG dependencies on IGS_UC_DEFAULTS

Line 107: AND institute_code = (SELECT current_inst_code FROM igs_uc_defaults WHERE system_code = p_system_code);

103: CURSOR cur_choices IS
104: SELECT COUNT(*) FROM igs_uc_app_choices
105: WHERE app_no = p_app_no AND (choice_no BETWEEN 1 AND 6)
106: AND ucas_cycle = p_ucas_cycle
107: AND institute_code = (SELECT current_inst_code FROM igs_uc_defaults WHERE system_code = p_system_code);
108:
109: -- Check whether record exists in app_chocies for the cycle
110: CURSOR cur_rec_found(cp_appno igs_uc_app_choices.app_no%TYPE,
111: cp_choice_no igs_uc_app_choices.choice_no%TYPE,

Line 1419: PROCEDURE proc_tranin_2003(p_conf_cycle IN igs_uc_defaults.configured_cycle%TYPE ) IS

1415:
1416: END transaction_validation;
1417:
1418:
1419: PROCEDURE proc_tranin_2003(p_conf_cycle IN igs_uc_defaults.configured_cycle%TYPE ) IS
1420:
1421: /*************************************************************
1422: Created By : solakshm
1423: Date Created By : 23-JAN-2002

Line 1456: CURSOR cur_records_to_write(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS

1452:
1453: (reverse chronological order - newest change first)
1454: ***************************************************************/
1455:
1456: CURSOR cur_records_to_write(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS
1457: SELECT a.ROWID,a.uc_tran_id,a.transaction_id, a.datetimestamp,
1458: a.updater, a.error_code, a.transaction_type, a.app_no,
1459: a.choice_no, a.decision, a.program_code,
1460: a.campus, a.entry_month, a.entry_year, a.entry_point,

Line 1648: PROCEDURE proc_tranin_2004(p_conf_cycle IN igs_uc_defaults.configured_cycle%TYPE,

1644: App_Exception.Raise_Exception;
1645:
1646: END proc_tranin_2003;
1647:
1648: PROCEDURE proc_tranin_2004(p_conf_cycle IN igs_uc_defaults.configured_cycle%TYPE,
1649: p_system_code IN igs_uc_ucas_control.system_code%TYPE) IS
1650:
1651: /*********************************************************************
1652: Created By : pmarada

Line 1671: CURSOR cur_records_to_write(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS

1667: arvsrini 26-Apr-2004 Added code to update IGS_UC_TRANSACTIONS.SOC based on
1668: the errorcode value Bug#3576288
1669: **********************************************************************/
1670:
1671: CURSOR cur_records_to_write(cp_conf_cycle igs_uc_defaults.configured_cycle%TYPE) IS
1672: SELECT a.ROWID,a.uc_tran_id,a.transaction_id, a.datetimestamp,
1673: a.updater, a.error_code, a.transaction_type, a.app_no,
1674: a.choice_no, a.decision, a.program_code,
1675: a.campus, a.entry_month, a.entry_year, a.entry_point,

Line 1970: FROM igs_uc_defaults ;

1966: *************************************************************/
1967:
1968: CURSOR cur_cycle IS
1969: SELECT max(current_cycle) current_cycle, max(configured_cycle) configured_cycle
1970: FROM igs_uc_defaults ;
1971:
1972: cur_cycle_rec cur_cycle%ROWTYPE;
1973:
1974: l_entry_year igs_uc_defaults.configured_cycle%TYPE;

Line 1974: l_entry_year igs_uc_defaults.configured_cycle%TYPE;

1970: FROM igs_uc_defaults ;
1971:
1972: cur_cycle_rec cur_cycle%ROWTYPE;
1973:
1974: l_entry_year igs_uc_defaults.configured_cycle%TYPE;
1975:
1976: BEGIN
1977: --To generate the Header Line in the Log File
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD('-',105,'-'));