APPS.RCV_ACCRUALUTILITIES_GRP dependencies on RCV_RECEIVING_SUB_LEDGER

Line 949: DELETE FROM RCV_RECEIVING_SUB_LEDGER

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);
951: EXCEPTION
952: WHEN OTHERS THEN
953: RAISE DELETE_FAILED;

Line 983: p_error_text => 'Purge of RCV_Accounting_Events/RCV_Receiving_Sub_Ledger Failed'||

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:

Line 1097: from rcv_receiving_sub_ledger rrs,

1093: elsif (l_destTypeCode = 'EXPENSE') then
1094: l_stmt_num := 50;
1095: select sum(nvl(rrs.accounted_dr,0)-nvl(rrs.accounted_cr,0))
1096: into l_encReversalAmt
1097: from rcv_receiving_sub_ledger rrs,
1098: rcv_transactions rt
1099: where rt.po_distribution_id = p_po_distribution_id
1100: and fnd_date.date_to_canonical(rt.transaction_date)
1101: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))