[Home] [Help]
2637: -- note this assumes all operations have already been
2638: -- propogated to the immediate copy source from the extensions
2639: -- which THEY copied
2640: --
2641: INSERT INTO iby_fndcpt_tx_operations
2642: (trxn_extension_id, transactionid,
2643: created_by, creation_date, last_updated_by, last_update_date,
2644: last_update_login, object_version_number
2645: )
2647: SELECT
2648: x_entity_id, transactionid,
2649: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
2650: fnd_global.login_id, 1
2651: FROM iby_fndcpt_tx_operations
2652: WHERE trxn_extension_id = p_entities(i);
2653: END IF;
2654: END LOOP;
2655:
2894: 'FULLY_REVERSED', 23, 'PARTIALLY_REVERSED', 'GENERAL_SYS_ERROR') auth_result_code,
2895: x.payment_system_order_number
2896: FROM
2897: IBY_FNDCPT_TX_EXTENSIONS X,
2898: IBY_FNDCPT_TX_OPERATIONS O,
2899: IBY_TRXN_SUMMARIES_ALL A,
2900: IBY_TRXN_CORE C
2901: WHERE x.trxn_extension_id = ci_extension_id
2902: AND (x.trxn_extension_id = o.trxn_extension_id)
2922: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
2923: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
2924: IS
2925: SELECT count(1)
2926: FROM iby_fndcpt_tx_operations o
2927: WHERE o.transactionid = ci_trxn_id
2928: AND o.trxn_extension_id = ci_trxn_extension_id;
2929:
2930: CURSOR c_source_extns
3311: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3312: iby_debug_pub.add( 'operation already recorded',G_LEVEL_STATEMENT,l_dbg_mod);
3313: END IF;
3314: ELSE
3315: INSERT INTO iby_fndcpt_tx_operations
3316: (trxn_extension_id, transactionid,
3317: created_by, creation_date, last_updated_by, last_update_date,
3318: last_update_login, object_version_number
3319: )
3325:
3326: --
3327: -- back-propagate the authorization
3328: --
3329: INSERT INTO iby_fndcpt_tx_operations
3330: (trxn_extension_id, transactionid,
3331: created_by, creation_date, last_updated_by, last_update_date,
3332: last_update_login, object_version_number
3333: )
3344:
3345: --
3346: -- forward propogate the authorization
3347: --
3348: INSERT INTO iby_fndcpt_tx_operations
3349: (trxn_extension_id, transactionid,
3350: created_by, creation_date, last_updated_by, last_update_date,
3351: last_update_login, object_version_number
3352: )
3778: l_payer_id iby_external_payers_all.ext_payer_id%TYPE;
3779: l_payer_attribs IBY_FNDCPT_SETUP_PUB.PayerAttributes_rec_type;
3780:
3781: l_extension_count NUMBER;
3782: l_transactionid iby_fndcpt_tx_operations.transactionid%TYPE;
3783:
3784: l_ecapp_id NUMBER;
3785: l_capture_trxn IBY_PAYMENT_ADAPTER_PUB.CaptureTrxn_rec_type;
3786: lx_capresp IBY_PAYMENT_ADAPTER_PUB.CaptureResp_rec_type;
3847:
3848:
3849: CURSOR C_PAYEE (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE) IS
3850: select s.payeeid, s.org_id, s.org_type
3851: from iby_trxn_summaries_all s, iby_fndcpt_tx_operations o
3852: where s.trxntypeid = 20
3853: and s.transactionid = o.transactionid
3854: and o.trxn_extension_id = ci_trxn_extension_id;
3855:
3857: (ci_trxn_extension_id IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
3858: ci_trxn_id IN iby_trxn_summaries_all.transactionid%TYPE)
3859: IS
3860: SELECT count(1)
3861: FROM iby_fndcpt_tx_operations o
3862: WHERE o.transactionid = ci_trxn_id
3863: AND o.trxn_extension_id = ci_trxn_extension_id;
3864:
3865: BEGIN
4081: CLOSE c_operation_count;
4082:
4083: IF (NVL(l_op_count,0) = 0) THEN
4084: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4085: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
4086: G_LEVEL_STATEMENT,l_dbg_mod);
4087: END IF;
4088: INSERT INTO iby_fndcpt_tx_operations
4089: (trxn_extension_id, transactionid,
4084: IF( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4085: iby_debug_pub.add('inserting into iby_fndcpt_tx_operations.',
4086: G_LEVEL_STATEMENT,l_dbg_mod);
4087: END IF;
4088: INSERT INTO iby_fndcpt_tx_operations
4089: (trxn_extension_id, transactionid,
4090: created_by, creation_date, last_updated_by, last_update_date,
4091: last_update_login, object_version_number
4092: )
4098:
4099: --
4100: -- back-propagate the authorization
4101: --
4102: INSERT INTO iby_fndcpt_tx_operations
4103: (trxn_extension_id, transactionid,
4104: created_by, creation_date, last_updated_by, last_update_date,
4105: last_update_login, object_version_number
4106: )
4118:
4119: --
4120: -- forward propogate the authorization
4121: --
4122: INSERT INTO iby_fndcpt_tx_operations
4123: (trxn_extension_id, transactionid,
4124: created_by, creation_date, last_updated_by, last_update_date,
4125: last_update_login, object_version_number
4126: )
4786: FROM '||l_view_name||' orders,
4787: IBY_FNDCPT_TX_EXTENSIONS trxnext,
4788: IBY_EXTERNAL_PAYERS_ALL payer,
4789: IBY_TRXN_SUMMARIES_ALL auth,
4790: IBY_FNDCPT_TX_OPERATIONS trxnop,
4791: IBY_TRXN_SUMMARIES_ALL captures,
4792: IBY_EXTERNAL_PAYERS_ALL auth_payer,
4793: IBY_BEPINFO bep,
4794: IBY_FNDCPT_USER_EFT_PF_B eft_user,
5338:
5339: select count(*) into l_mandate_trxn_count
5340: from iby_trxn_summaries_all summ
5341: ,iby_fndcpt_tx_extensions ext
5342: ,iby_fndcpt_tx_operations op
5343: where summ.transactionid = op.transactionid
5344: and op.trxn_extension_id = ext.trxn_extension_id
5345: and op.transactionid = l_settlement_trxn_rec.auth_transactionid
5346: and ext.seq_type_last = 'Y';
5789: lx_return_status, lx_msg_count, lx_msg_data, lx_creditresp
5790: );
5791:
5792: IF (NOT lx_creditresp.Trxn_Id IS NULL) THEN
5793: INSERT INTO iby_fndcpt_tx_operations
5794: (trxn_extension_id, transactionid,
5795: created_by, creation_date, last_updated_by, last_update_date,
5796: last_update_login, object_version_number
5797: )
5802: );
5803: --
5804: -- back-propagate the credit
5805: --
5806: INSERT INTO iby_fndcpt_tx_operations
5807: (trxn_extension_id, transactionid,
5808: created_by, creation_date, last_updated_by, last_update_date,
5809: last_update_login, object_version_number
5810: )
6142: auth.org_id, core.authcode, core.tracenumber,
6143: core.taxamount, core.shipfromzip, core.shiptozip,
6144: auth.factored_flag, auth.ar_receipt_method_id
6145: FROM iby_fndcpt_tx_extensions xt,
6146: iby_fndcpt_tx_operations op,
6147: iby_trxn_summaries_all auth,
6148: iby_tangible tg,
6149: iby_trxn_core core,
6150: iby_bepinfo bep,