APPS.RCV_ACCRUALUTILITIES_GRP dependencies on RCV_RECEIVING_SUB_LEDGER

Line 1054: DELETE FROM RCV_RECEIVING_SUB_LEDGER

1050: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
1051: DELETE FROM RCV_ACCOUNTING_EVENTS
1052: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);
1053: FORALL l_index in p_purge_in_rec.entity_ids.FIRST..p_purge_in_rec.entity_ids.LAST
1054: DELETE FROM RCV_RECEIVING_SUB_LEDGER
1055: WHERE RCV_TRANSACTION_ID = p_purge_in_rec.entity_ids(l_index);
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: RAISE DELETE_FAILED;

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

1084: IF G_MSG_LEVEL_THRESHOLD <= FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH THEN
1085: FND_MSG_PUB.Add_Exc_Msg(
1086: p_pkg_name => G_PKG_NAME,
1087: p_procedure_name => l_api_name,
1088: p_error_text => 'Purge of RCV_Accounting_Events/RCV_Receiving_Sub_Ledger Failed'||
1089: to_char(l_stmt_num) || ' '||
1090: SQLERRM
1091: );
1092:

Line 1202: from rcv_receiving_sub_ledger rrs,

1198: elsif (l_destTypeCode = 'EXPENSE') then
1199: l_stmt_num := 50;
1200: select sum(nvl(rrs.accounted_dr,0)-nvl(rrs.accounted_cr,0))
1201: into l_encReversalAmt
1202: from rcv_receiving_sub_ledger rrs,
1203: rcv_transactions rt
1204: where rt.po_distribution_id = p_po_distribution_id
1205: and fnd_date.date_to_canonical(rt.transaction_date)
1206: between nvl(p_start_txn_date,fnd_date.date_to_canonical(rt.transaction_date))