[Home] [Help]
2114: -- note this assumes all operations have already been
2115: -- propogated to the immediate copy source from the extensions
2116: -- which THEY copied
2117: --
2118: INSERT INTO iby_fndcpt_tx_operations
2119: (trxn_extension_id, transactionid,
2120: created_by, creation_date, last_updated_by, last_update_date,
2121: last_update_login, object_version_number
2122: )
2124: SELECT
2125: x_entity_id, transactionid,
2126: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2127: fnd_global.login_id, 1
2128: FROM iby_fndcpt_tx_operations
2129: WHERE trxn_extension_id = p_entities(i);
2130: END IF;
2131: END LOOP;
2132:
2380: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2381: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
2382: IS
2383: SELECT count(1)
2384: FROM iby_fndcpt_tx_operations o
2385: WHERE o.transactionid = ci_trxn_id
2386: AND o.trxn_extension_id = ci_trxn_extension_id;
2387:
2388: BEGIN
2649: IF ( l_op_count > 0 ) THEN
2650: iby_debug_pub.add( 'operation already recorded',
2651: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2652: ELSE
2653: INSERT INTO iby_fndcpt_tx_operations
2654: (trxn_extension_id, transactionid,
2655: created_by, creation_date, last_updated_by, last_update_date,
2656: last_update_login, object_version_number
2657: )
2663:
2664: --
2665: -- back-propagate the authorization
2666: --
2667: INSERT INTO iby_fndcpt_tx_operations
2668: (trxn_extension_id, transactionid,
2669: created_by, creation_date, last_updated_by, last_update_date,
2670: last_update_login, object_version_number
2671: )
2681:
2682: --
2683: -- forward propogate the authorization
2684: --
2685: INSERT INTO iby_fndcpt_tx_operations
2686: (trxn_extension_id, transactionid,
2687: created_by, creation_date, last_updated_by, last_update_date,
2688: last_update_login, object_version_number
2689: )
3027: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3028: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3029:
3030: l_extension_count NUMBER;
3031: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;
3032:
3033: l_ecapp_id NUMBER;
3034: l_capture_trxn IBY_PAYMENT_ADAPTER_PUB.CaptureTrxn_rec_type;
3035: lx_capresp IBY_PAYMENT_ADAPTER_PUB.CaptureResp_rec_type;
3096:
3097:
3098: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS
3099: select s.payeeid, s.org_id, s.org_type
3100: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o
3101: where s.trxntypeid = 20
3102: and s.transactionid = o.transactionid
3103: and o.trxn_extension_id = ci_trxn_extension_id;
3104:
3106: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3107: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
3108: IS
3109: SELECT count(1)
3110: FROM iby_fndcpt_tx_operations o
3111: WHERE o.transactionid = ci_trxn_id
3112: AND o.trxn_extension_id = ci_trxn_extension_id;
3113:
3114: BEGIN
3314: FETCH c_operation_count INTO l_op_count;
3315: CLOSE c_operation_count;
3316:
3317: IF (NVL(l_op_count,0) = 0) THEN
3318: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
3319: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3320:
3321: INSERT INTO iby_fndcpt_tx_operations
3322: (trxn_extension_id, transactionid,
3317: IF (NVL(l_op_count,0) = 0) THEN
3318: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
3319: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
3320:
3321: INSERT INTO iby_fndcpt_tx_operations
3322: (trxn_extension_id, transactionid,
3323: created_by, creation_date, last_updated_by, last_update_date,
3324: last_update_login, object_version_number
3325: )
3331:
3332: --
3333: -- back-propagate the authorization
3334: --
3335: INSERT INTO iby_fndcpt_tx_operations
3336: (trxn_extension_id, transactionid,
3337: created_by, creation_date, last_updated_by, last_update_date,
3338: last_update_login, object_version_number
3339: )
3349:
3350: --
3351: -- forward propogate the authorization
3352: --
3353: INSERT INTO iby_fndcpt_tx_operations
3354: (trxn_extension_id, transactionid,
3355: created_by, creation_date, last_updated_by, last_update_date,
3356: last_update_login, object_version_number
3357: )
3949: FROM '||l_view_name||' orders,
3950: IBY_FNDCPT_TX_EXTENSIONS trxnext,
3951: IBY_EXTERNAL_PAYERS_ALL payer,
3952: IBY_TRXN_SUMMARIES_ALL auth,
3953: IBY_FNDCPT_TX_OPERATIONS trxnop,
3954: IBY_TRXN_SUMMARIES_ALL captures,
3955: IBY_EXTERNAL_PAYERS_ALL auth_payer,
3956: IBY_BEPINFO bep,
3957: IBY_FNDCPT_USER_EFT_PF_B eft_user,
4667: lx_return_status, lx_msg_count, lx_msg_data, lx_creditresp
4668: );
4669:
4670: IF (NOT lx_creditresp.Trxn_Id IS NULL) THEN
4671: INSERT INTO iby_fndcpt_tx_operations
4672: (trxn_extension_id, transactionid,
4673: created_by, creation_date, last_updated_by, last_update_date,
4674: last_update_login, object_version_number
4675: )
4680: );
4681: --
4682: -- back-propagate the credit
4683: --
4684: INSERT INTO iby_fndcpt_tx_operations
4685: (trxn_extension_id, transactionid,
4686: created_by, creation_date, last_updated_by, last_update_date,
4687: last_update_login, object_version_number
4688: )