APPS.IGS_UC_GEN_001 dependencies on IGS_UC_TRANSACTIONS

Line 118: l_system_code igs_uc_transactions.system_code%TYPE;

114: Change History
115: Who When What
116: ayedubat 24-Nov-2003 To add a new cursor, trans_dtls_cur for deriving decision and system code
117: ***************************************************************** */
118: l_system_code igs_uc_transactions.system_code%TYPE;
119: l_decision igs_uc_transactions.decision%TYPE;
120:
121: -- Get decision and system code from the transaction record
122: CURSOR trans_dtls_cur( p_uc_tran_id IGS_UC_TRANSACTIONS.uc_tran_id%TYPE) IS

Line 119: l_decision igs_uc_transactions.decision%TYPE;

115: Who When What
116: ayedubat 24-Nov-2003 To add a new cursor, trans_dtls_cur for deriving decision and system code
117: ***************************************************************** */
118: l_system_code igs_uc_transactions.system_code%TYPE;
119: l_decision igs_uc_transactions.decision%TYPE;
120:
121: -- Get decision and system code from the transaction record
122: CURSOR trans_dtls_cur( p_uc_tran_id IGS_UC_TRANSACTIONS.uc_tran_id%TYPE) IS
123: SELECT decision, system_code

Line 122: CURSOR trans_dtls_cur( p_uc_tran_id IGS_UC_TRANSACTIONS.uc_tran_id%TYPE) IS

118: l_system_code igs_uc_transactions.system_code%TYPE;
119: l_decision igs_uc_transactions.decision%TYPE;
120:
121: -- Get decision and system code from the transaction record
122: CURSOR trans_dtls_cur( p_uc_tran_id IGS_UC_TRANSACTIONS.uc_tran_id%TYPE) IS
123: SELECT decision, system_code
124: FROM igs_uc_transactions
125: WHERE uc_tran_id = p_uc_tran_id;
126:

Line 124: FROM igs_uc_transactions

120:
121: -- Get decision and system code from the transaction record
122: CURSOR trans_dtls_cur( p_uc_tran_id IGS_UC_TRANSACTIONS.uc_tran_id%TYPE) IS
123: SELECT decision, system_code
124: FROM igs_uc_transactions
125: WHERE uc_tran_id = p_uc_tran_id;
126:
127: BEGIN
128: