APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_TRANSACTIONS

Line 316: || from IGS_UC_TRANSACTIONS table instead of IGS_UC_MV_TRANIN.

312: || ayedubat 18-NOV-2002 Changed the signature of the package to add a
313: || new parameter,p_sys_ind. As part of small systems support,
314: || now this process is called once for each system.
315: || As part of this change, all the transactions are selecting
316: || from IGS_UC_TRANSACTIONS table instead of IGS_UC_MV_TRANIN.
317: || Created the new 'LE' type of transaction.
318: || Enh bug # 2643048
319: || ayedubat 13-DEC-2002 Changed the LA and LD transactions to write the Course element,
320: || Entry Year and Entry month , Point of Entry, Sumary of Conditions

Line 331: CURSOR cur_transactions( p_system_code IGS_UC_TRANSACTIONS.system_code%TYPE ) IS

327: || (reverse chronological order - newest change first)
328: */
329:
330: -- Cursor to fetch the pending transactions of a given UCAS System
331: CURSOR cur_transactions( p_system_code IGS_UC_TRANSACTIONS.system_code%TYPE ) IS
332: SELECT
333: ROWID,
334: uc_tran_id,
335: transaction_id,

Line 367: FROM IGS_UC_TRANSACTIONS

363: system_code,
364: ucas_cycle,
365: modular,
366: part_time
367: FROM IGS_UC_TRANSACTIONS
368: WHERE system_code = p_system_code
369: AND ucas_cycle = p_configured_cycle
370: AND sent_to_ucas = 'N'
371: AND hold_flag = 'N'

Line 467: l_tran_type IGS_UC_TRANSACTIONS.transaction_type%TYPE;

463: l_ext_info_first_line NUMBER(3);
464: l_info VARCHAR2(500);
465: l_tran_form NUMBER(1);
466: l_opt_code VARCHAR2(250);
467: l_tran_type IGS_UC_TRANSACTIONS.transaction_type%TYPE;
468: l_digital_num NUMBER(2);
469: l_choice_no VARCHAR2(1);
470:
471: BEGIN

Line 813: igs_uc_transactions_pkg.update_row (

809:
810: -- Update the sent_to_ucas column of the current Transaction record to 'Y' as the trnsactions has
811: -- send to UCAS through flat file
812:
813: igs_uc_transactions_pkg.update_row (
814: x_mode => 'R',
815: x_rowid => cur_transactions_rec.ROWID,
816: x_uc_tran_id => cur_transactions_rec.UC_Tran_Id,
817: x_transaction_id => cur_transactions_rec.transaction_id,

Line 1108: CURSOR cur_pending_trans_exist(cp_system_code IGS_UC_TRANSACTIONS.system_code%TYPE,

1104: || transactions for a system
1105: ||
1106: */
1107: -- Cursor to find whether pending transactions exist to send to UCAS
1108: CURSOR cur_pending_trans_exist(cp_system_code IGS_UC_TRANSACTIONS.system_code%TYPE,
1109: cp_config_cycle IGS_UC_TRANSACTIONS.ucas_cycle%TYPE)IS
1110: SELECT 'X'
1111: FROM IGS_UC_TRANSACTIONS
1112: WHERE

Line 1109: cp_config_cycle IGS_UC_TRANSACTIONS.ucas_cycle%TYPE)IS

1105: ||
1106: */
1107: -- Cursor to find whether pending transactions exist to send to UCAS
1108: CURSOR cur_pending_trans_exist(cp_system_code IGS_UC_TRANSACTIONS.system_code%TYPE,
1109: cp_config_cycle IGS_UC_TRANSACTIONS.ucas_cycle%TYPE)IS
1110: SELECT 'X'
1111: FROM IGS_UC_TRANSACTIONS
1112: WHERE
1113: system_code = NVL(cp_system_code,system_code) AND

Line 1111: FROM IGS_UC_TRANSACTIONS

1107: -- Cursor to find whether pending transactions exist to send to UCAS
1108: CURSOR cur_pending_trans_exist(cp_system_code IGS_UC_TRANSACTIONS.system_code%TYPE,
1109: cp_config_cycle IGS_UC_TRANSACTIONS.ucas_cycle%TYPE)IS
1110: SELECT 'X'
1111: FROM IGS_UC_TRANSACTIONS
1112: WHERE
1113: system_code = NVL(cp_system_code,system_code) AND
1114: NVL(cp_system_code,system_code) IN (SELECT system_code
1115: FROM igs_uc_cyc_defaults