APPS.IBY_FNDCPT_SETUP_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 3358: CURSOR trxn_ref(AUTH_ID IN IBY_TRXN_SUMMARIES_ALL.DEBIT_AUTHORIZATION_ID%TYPE) IS

3354:
3355: --l_trxnmid NUMBER;
3356: --l_trxn_list TrxnId_tbl_type;
3357:
3358: CURSOR trxn_ref(AUTH_ID IN IBY_TRXN_SUMMARIES_ALL.DEBIT_AUTHORIZATION_ID%TYPE) IS
3359: (SELECT TRXNMID FROM IBY_TRXN_SUMMARIES_ALL WHERE DEBIT_AUTHORIZATION_ID = AUTH_ID
3360: AND REQTYPE = 'ORAPMTBATCHREQ' AND TRXNTYPEID = 100 AND INSTRTYPE = 'BANKACCOUNT' AND STATUS = 100);
3361:
3362:

Line 3359: (SELECT TRXNMID FROM IBY_TRXN_SUMMARIES_ALL WHERE DEBIT_AUTHORIZATION_ID = AUTH_ID

3355: --l_trxnmid NUMBER;
3356: --l_trxn_list TrxnId_tbl_type;
3357:
3358: CURSOR trxn_ref(AUTH_ID IN IBY_TRXN_SUMMARIES_ALL.DEBIT_AUTHORIZATION_ID%TYPE) IS
3359: (SELECT TRXNMID FROM IBY_TRXN_SUMMARIES_ALL WHERE DEBIT_AUTHORIZATION_ID = AUTH_ID
3360: AND REQTYPE = 'ORAPMTBATCHREQ' AND TRXNTYPEID = 100 AND INSTRTYPE = 'BANKACCOUNT' AND STATUS = 100);
3361:
3362:
3363: BEGIN

Line 3445: UPDATE IBY_TRXN_SUMMARIES_ALL SET DEBIT_AUTHORIZATION_ID = l_seq_number where debit_authorization_id = p_debit_auth_id and trxnmid = trxn_rec.trxnmid;

3441: -- Update mandate to have the updated debit authorization id. .
3442:
3443: FOR trxn_rec IN trxn_ref(p_debit_auth_id)
3444: LOOP
3445: UPDATE IBY_TRXN_SUMMARIES_ALL SET DEBIT_AUTHORIZATION_ID = l_seq_number where debit_authorization_id = p_debit_auth_id and trxnmid = trxn_rec.trxnmid;
3446:
3447: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3448: print_debuginfo('Trxn Id : ' || trxn_rec.trxnmid || 'with debit-authorization_id = ' || p_debit_auth_id || 'updated with debit auth : ' || l_seq_number,
3449: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);