APPS.ARP_PROCESS_APPLICATION dependencies on AR_ACTIVITY_DETAILS

Line 1565: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs

1561: --
1562: ---------------------------------------------------
1563: arp_app_pkg.insert_p( p_ra_rec, l_ra_id );
1564:
1565: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1566:
1567: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1568:
1569: begin

Line 1571: from ar_activity_details

1567: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1568:
1569: begin
1570: select 'Y' into l_llca_exist
1571: from ar_activity_details
1572: where cash_receipt_id = p_ra_rec.cash_receipt_id
1573: and source_id = p_ra_rec.receivable_application_id
1574: and source_table = 'RA'
1575: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'R';

Line 1593: update ar_activity_details

1589:
1590: IF NVL(l_llca_exist,'N') = 'Y' THEN
1591:
1592:
1593: update ar_activity_details
1594: set source_table = 'RA',
1595: source_id = l_ra_id,
1596: CURRENT_ACTIVITY_FLAG = 'N',
1597: CREATED_BY = NVL(FND_GLOBAL.user_id,-1),

Line 1793: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs

1789: p_ra_rec -- IN
1790: , l_ra_id -- OUT NOCOPY
1791: );
1792:
1793: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1794:
1795: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1796:
1797: begin

Line 1799: from ar_activity_details

1795: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1796:
1797: begin
1798: select 'Y' into l_llca_exist
1799: from ar_activity_details
1800: where cash_receipt_id = p_ra_rec.cash_receipt_id
1801: and source_id = p_ra_rec.receivable_application_id
1802: and source_table = 'RA';
1803: exception

Line 1818: AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row(l_ra_id,p_ra_rec.receivable_application_id,p_ra_rec.cash_receipt_id);

1814:
1815: -- To handle offset rows
1816:
1817: --{
1818: AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row(l_ra_id,p_ra_rec.receivable_application_id,p_ra_rec.cash_receipt_id);
1819:
1820: --}
1821:
1822: END IF;

Line 1827: from ar_activity_details

1823:
1824:
1825: begin
1826: select 'Y' into l_llca_exist_rev
1827: from ar_activity_details
1828: where cash_receipt_id = p_ra_rec.cash_receipt_id
1829: and source_id = p_ra_rec.receivable_application_id
1830: and source_table = 'RA'
1831: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'R';

Line 1847: update ar_activity_details

1843: END IF;
1844:
1845: IF NVL(l_llca_exist_rev,'N') = 'Y' THEN
1846:
1847: update ar_activity_details
1848: set source_table = 'RA',
1849: source_id = l_ra_id,
1850: CURRENT_ACTIVITY_FLAG = 'N',
1851: CREATED_BY = NVL(FND_GLOBAL.user_id,-1),