APPS.ARP_PROCESS_APPLICATION dependencies on AR_ACTIVITY_DETAILS

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

1642: --
1643: ---------------------------------------------------
1644: arp_app_pkg.insert_p( p_ra_rec, l_ra_id );
1645:
1646: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1647:
1648: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1649:
1650: begin

Line 1652: from ar_activity_details

1648: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1649:
1650: begin
1651: select 'Y' into l_llca_exist
1652: from ar_activity_details
1653: where cash_receipt_id = p_ra_rec.cash_receipt_id
1654: and source_id = p_ra_rec.receivable_application_id
1655: and source_table = 'RA'
1656: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'R';

Line 1674: update ar_activity_details

1670:
1671: IF NVL(l_llca_exist,'N') = 'Y' THEN
1672:
1673:
1674: update ar_activity_details
1675: set source_table = 'RA',
1676: source_id = l_ra_id,
1677: CURRENT_ACTIVITY_FLAG = 'N',
1678: CREATED_BY = NVL(FND_GLOBAL.user_id,-1),

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

1870: p_ra_rec -- IN
1871: , l_ra_id -- OUT NOCOPY
1872: );
1873:
1874: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1875:
1876: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1877:
1878: begin

Line 1880: from ar_activity_details

1876: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1877:
1878: begin
1879: select 'Y' into l_llca_exist
1880: from ar_activity_details
1881: where cash_receipt_id = p_ra_rec.cash_receipt_id
1882: and source_id = p_ra_rec.receivable_application_id
1883: and source_table = 'RA';
1884: exception

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

1895:
1896: -- To handle offset rows
1897:
1898: --{
1899: AR_ACTIVITY_DETAILS_PKG.Chk_offset_Row(l_ra_id,p_ra_rec.receivable_application_id,p_ra_rec.cash_receipt_id);
1900:
1901: --}
1902:
1903: END IF;

Line 1908: from ar_activity_details

1904:
1905:
1906: begin
1907: select 'Y' into l_llca_exist_rev
1908: from ar_activity_details
1909: where cash_receipt_id = p_ra_rec.cash_receipt_id
1910: and source_id = p_ra_rec.receivable_application_id
1911: and source_table = 'RA'
1912: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'R';

Line 1928: update ar_activity_details

1924: END IF;
1925:
1926: IF NVL(l_llca_exist_rev,'N') = 'Y' THEN
1927:
1928: update ar_activity_details
1929: set source_table = 'RA',
1930: source_id = l_ra_id,
1931: CURRENT_ACTIVITY_FLAG = 'N',
1932: CREATED_BY = NVL(FND_GLOBAL.user_id,-1),