[Home] [Help]
362: l_stmt_num := 60;
363:
364: SELECT count(*)
365: INTO l_rae_count
366: FROM rcv_accounting_events RAE
367: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
368: AND RAE.organization_id = rec_txn.organization_id
369: AND RAE.event_type_id IN (1,2,3,4,5,6)
370: AND RAE.TRX_FLOW_HEADER_ID IS NOT NULL;
567: SELECT sum(decode(RAE.primary_quantity, 0, 0,
568: (RAE.unit_price * nvl(RAE.currency_conversion_rate,1)*
569: RAE.source_doc_quantity/RAE.primary_quantity * RAE.source_doc_quantity)))
570: INTO l_txn_price
571: FROM rcv_accounting_events RAE
572: WHERE RAE.rcv_transaction_id = rec_txn.transaction_id
573: AND RAE.organization_id = rec_txn.organization_id
574: AND RAE.event_type_id IN (1,2,3,4,5,6);
575:
621: 15,rae.primary_quantity,
622: -1*rae.primary_quantity)*
623: (rae.unit_price-rae.prior_unit_price)),0)
624: INTO l_rae_price
625: FROM rcv_accounting_events rae
626: WHERE rae.event_type_id IN (15,16,17)
627: AND rae.rcv_transaction_id = l_rcv_transaction_id
628: AND((p_valuation_date is not null
629: and rae.transaction_date <= p_valuation_date)
942: BEGIN
943: l_stmt_num := 30;
944:
945: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
946: DELETE FROM RCV_ACCOUNTING_EVENTS
947: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);
948: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
949: DELETE FROM RCV_RECEIVING_SUB_LEDGER
950: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);
979: IF G_MSG_LEVEL_THRESHOLD <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH THEN
980: FND_MSG_PUB.Add_Exc_Msg(
981: p_pkg_name => G_PKG_NAME,
982: p_procedure_name => l_api_name,
983: p_error_text => 'Purge of RCV_Accounting_Events/RCV_Receiving_Sub_Ledger Failed'||
984: to_char(l_stmt_num) || ' '||
985: SQLERRM
986: );
987: