APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_UC_TRANSACTIONS

Line 23: | update IGS_UC_TRANSACTIONS table directly as |

19: | Who When What |
20: | rbezawad 25-Sep-02 Modified w.r.t. UCFD06 Build, Bug No: 2574566. |
21: | rgangara 11-Nov-02 Added *G, *T transaction processing and modified |
22: | Acknowledgement/echo transaction processing to |
23: | update IGS_UC_TRANSACTIONS table directly as |
24: | part of UCFD02_Small_Systems Enh. Bug# 2643048 |
25: | Also added validation for ensuring that files |
26: are processed in seqeuence only. |
27: | rgangara 27-Nov-02 Removed TRIM for CAMPUS fields in *C and *G |

Line 2207: || Also to update IGS_UC_TRANSACTIONS table directly instead of

2203: || rgangara 11-Nov-02 Modified the procedure to work for different types of ECHO/
2204: || Acknowledgment transactions.
2205: || NOTE: Clarified that the processing remains same for all the
2206: || different types of Transactions falling under this category
2207: || Also to update IGS_UC_TRANSACTIONS table directly instead of
2208: || Marvin tranin table.
2209: || rbezawad 17-Dec-02 Modified the procedure to remove the code which is loggig
2210: || IGS_UC_TRAN_PROC_APPCH for 2nd time w.r.t. Bug 2711183.
2211: || smaddali 30-jun-03 Modified for ucfd203- multiple cycles build , bug#2669208

Line 2219: cp_appno igs_uc_transactions.app_no%TYPE,

2215: -- Get transactions for the application, Choice number , ucas_cycle and Transaction Type having NULL error_code.
2216: -- NULL error code implies that the no response/echo/Ack transaction has been received against it.
2217: -- smaddali modified this cursor for ucfd203 - multiple cycles build to add ucas_cycle check in where clause
2218: CURSOR cur_trans(
2219: cp_appno igs_uc_transactions.app_no%TYPE,
2220: cp_choiceno igs_uc_transactions.choice_no%TYPE
2221: ) IS
2222: SELECT rowid ,
2223: uc_tran_id ,

Line 2220: cp_choiceno igs_uc_transactions.choice_no%TYPE

2216: -- NULL error code implies that the no response/echo/Ack transaction has been received against it.
2217: -- smaddali modified this cursor for ucfd203 - multiple cycles build to add ucas_cycle check in where clause
2218: CURSOR cur_trans(
2219: cp_appno igs_uc_transactions.app_no%TYPE,
2220: cp_choiceno igs_uc_transactions.choice_no%TYPE
2221: ) IS
2222: SELECT rowid ,
2223: uc_tran_id ,
2224: transaction_id ,

Line 2256: FROM igs_uc_transactions

2252: system_code ,
2253: ucas_cycle ,
2254: modular ,
2255: part_time
2256: FROM igs_uc_transactions
2257: WHERE app_no = cp_appno
2258: AND choice_no = cp_choiceno
2259: AND transaction_type = p_trans_type
2260: AND error_code IS NULL

Line 2265: ln_choiceno igs_uc_transactions.choice_no%TYPE;

2261: AND ucas_cycle = g_c_cycles.configured_cycle
2262: ORDER BY uc_tran_id;
2263:
2264: trans_rec cur_trans%ROWTYPE;
2265: ln_choiceno igs_uc_transactions.choice_no%TYPE;
2266: l_char_choice VARCHAR2(1) := TRIM(SUBSTR(p_record_data,10,1));
2267: ln_appno igs_uc_transactions.app_no%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
2268: BEGIN
2269:

Line 2267: ln_appno igs_uc_transactions.app_no%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));

2263:
2264: trans_rec cur_trans%ROWTYPE;
2265: ln_choiceno igs_uc_transactions.choice_no%TYPE;
2266: l_char_choice VARCHAR2(1) := TRIM(SUBSTR(p_record_data,10,1));
2267: ln_appno igs_uc_transactions.app_no%TYPE := TO_NUMBER(TRIM(SUBSTR(p_record_data,1,8)));
2268: BEGIN
2269:
2270: fnd_message.set_name('IGS', 'IGS_UC_TRAN_PROC_APPCH');
2271: fnd_message.set_token('TTYPE',p_trans_type);

Line 2303: igs_uc_transactions_pkg.update_row(

2299: app_exception.raise_exception;
2300:
2301: ELSE
2302: -- update the corresponding transaction record with Timestamp and Errorcode
2303: igs_uc_transactions_pkg.update_row(
2304: x_rowid => trans_rec.rowid ,
2305: x_uc_tran_id => trans_rec.uc_tran_id ,
2306: x_transaction_id => trans_rec.transaction_id ,
2307: x_datetimestamp => SYSDATE , -- update