APPS.CE_BAT_API dependencies on CE_CASHFLOWS

Line 1127: FROM ce_cashflows

1123: p_result OUT NOCOPY varchar2)
1124: IS
1125: CURSOR c_cashflows(p_pay_trxn_number NUMBER) IS
1126: SELECT cashflow_id
1127: FROM ce_cashflows
1128: WHERE trxn_reference_number=p_pay_trxn_number;
1129:
1130: l_cashflow_id1 NUMBER;
1131: l_cashflow_id2 NUMBER;

Line 1138: UPDATE ce_cashflows

1134: CE_PAYMENT_TRXN_PKG.update_transfer_status(
1135: p_pay_trxn_number, 'REJECTED');
1136:
1137:
1138: UPDATE ce_cashflows
1139: SET cashflow_status_code='CANCELED'
1140: WHERE trxn_reference_number=p_pay_trxn_number;
1141:
1142: p_result := 'SUCCESS';

Line 1174: FROM ce_cashflows cf,

1170: l_cashflow_id NUMBER;
1171:
1172: CURSOR cashflows_c (p_trxn_ref_number NUMBER) IS
1173: SELECT cf.cashflow_id
1174: FROM ce_cashflows cf,
1175: ce_payment_transactions pt
1176: WHERE cf.trxn_reference_number = pt.trxn_reference_number
1177: AND pt.trxn_status_code = 'SETTLED'
1178: AND cf.trxn_reference_number = p_trxn_ref_number;

Line 1196: UPDATE ce_cashflows

1192: END LOOP;
1193: CLOSE cashflows_c;
1194:
1195: -- Update the cashflows status to CANCELED
1196: UPDATE ce_cashflows
1197: SET cashflow_status_code = 'CANCELED'
1198: WHERE trxn_reference_number = p_pay_trxn_number;
1199:
1200: -- Update the payment transaction status to CANCELED

Line 1328: FROM ce_cashflows

1324: l_cashflow_id2 NUMBER;
1325:
1326: CURSOR c_cashflows(p_trxn_ref_number NUMBER) IS
1327: SELECT cashflow_id
1328: FROM ce_cashflows
1329: WHERE trxn_Reference_number=p_trxn_ref_number;
1330: BEGIN
1331: log('>>settle_transfer...' || p_pay_trxn_number);
1332:

Line 1349: UPDATE ce_cashflows

1345: UPDATE ce_payment_transactions
1346: SET bank_trxn_number = p_payment_reference_number
1347: WHERE trxn_reference_number = p_pay_trxn_number;
1348:
1349: UPDATE ce_cashflows
1350: SET bank_trxn_number = p_payment_reference_number
1351: WHERE trxn_reference_number = p_pay_trxn_number;
1352: END IF;
1353: END IF;

Line 1874: UPDATE ce_cashflows

1870: CE_XLA_ACCT_EVENTS_PKG.create_event
1871: (l_cashflow_id,'CE_STMT_CANCELED');
1872:
1873: -- Update the cashflows status to CANCELED
1874: UPDATE ce_cashflows
1875: SET cashflow_status_code = 'CANCELED'
1876: WHERE cashflow_id = l_cashflow_id;
1877:
1878: /*bug4997215*/