DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on ARP_GLOBAL

Line 359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));

355: arp_standard.debug('application_type = ' || l_ra_rec.application_type);
356: arp_standard.debug('payment_schedule_id = ' || to_char(l_ra_rec.payment_schedule_id));
357: arp_standard.debug('status = ' || l_ra_rec.status);
358: arp_standard.debug('ccid = ' || to_char(l_ra_rec.code_combination_id));
359: arp_standard.debug('sob id = ' || TO_CHAR(arp_global.set_of_books_id));
360: arp_standard.debug('application_rule = ' || TO_CHAR(l_ra_rec.application_rule));
361: arp_standard.debug('confirmed_flag = ' || TO_CHAR(l_ra_rec.confirmed_flag));
362: arp_standard.debug('p_called_from = ' || TO_CHAR(p_called_from));
363: arp_app_pkg.insert_p(l_ra_rec, l_ra_id);

Line 774: p_coa_id => arp_global.chart_of_accounts_id,

770: /* Bug4726219 */
771: IF NVL(FND_PROFILE.value('AR_DISABLE_REC_ACTIVITY_BALSEG_SUBSTITUTION'),
772: 'N') = 'N' AND l_type <> 'MISCCASH' THEN
773: arp_util.Substitute_Ccid(
774: p_coa_id => arp_global.chart_of_accounts_id,
775: p_original_ccid => l_trx_code_combination_id,
776: p_subs_ccid => l_crh_ccid,
777: p_actual_ccid => l_misc_cash_dist_rec.code_combination_id );
778: ELSE

Line 791: l_misc_cash_dist_rec.set_of_books_id := arp_global.set_of_books_id;

787: l_misc_cash_dist_rec.amount := p_amount;
788: l_misc_cash_dist_rec.acctd_amount := p_acctd_amount;
789: l_misc_cash_dist_rec.posting_control_id := -3;
790: l_misc_cash_dist_rec.created_from := p_created_from;
791: l_misc_cash_dist_rec.set_of_books_id := arp_global.set_of_books_id;
792: OPEN c_hist;
793: FETCH c_hist INTO l_misc_cash_dist_rec.cash_receipt_history_id;
794: CLOSE c_hist;
795:

Line 812: structure_number => arp_global.chart_of_accounts_id,

808: --
809: IF fnd_flex_keyval.validate_ccid(
810: appl_short_name => 'SQLGL',
811: key_flex_code => 'GL#',
812: structure_number => arp_global.chart_of_accounts_id,
813: combination_id => l_trx_code_combination_id ) THEN
814: -- Secondly, check is the key flex is enabled.
815: -- Fix 1341201, Added rollback
816: IF not fnd_flex_keyval.enabled_flag THEN

Line 1559: arp_global.base_min_acc_unit, null,

1555: * l_min_unit
1556: ) amount,
1557: decode
1558: (
1559: arp_global.base_min_acc_unit, null,
1560: round((p_amount * percent_distribution/100) * nvl(p_exchange_rate,1),
1561: arp_global.base_precision),
1562: round(p_amount * (percent_distribution/100) * nvl(p_exchange_rate,1)
1563: / arp_global.base_precision) * arp_global.base_precision

Line 1561: arp_global.base_precision),

1557: decode
1558: (
1559: arp_global.base_min_acc_unit, null,
1560: round((p_amount * percent_distribution/100) * nvl(p_exchange_rate,1),
1561: arp_global.base_precision),
1562: round(p_amount * (percent_distribution/100) * nvl(p_exchange_rate,1)
1563: / arp_global.base_precision) * arp_global.base_precision
1564: ) acctd_amount
1565: FROM

Line 1563: / arp_global.base_precision) * arp_global.base_precision

1559: arp_global.base_min_acc_unit, null,
1560: round((p_amount * percent_distribution/100) * nvl(p_exchange_rate,1),
1561: arp_global.base_precision),
1562: round(p_amount * (percent_distribution/100) * nvl(p_exchange_rate,1)
1563: / arp_global.base_precision) * arp_global.base_precision
1564: ) acctd_amount
1565: FROM
1566: ar_distribution_set_lines
1567: WHERE

Line 1606: structure_number => arp_global.chart_of_accounts_id,

1602: --
1603: IF fnd_flex_keyval.validate_ccid(
1604: appl_short_name => 'SQLGL',
1605: key_flex_code => 'GL#',
1606: structure_number => arp_global.chart_of_accounts_id,
1607: combination_id => dist.dist_code_combination_id) THEN
1608: -- Secondly, check is the key flex is enabled.
1609: --
1610: IF not fnd_flex_keyval.enabled_flag THEN

Line 1649: arp_global.user_id,

1645: cash_receipt_history_id)
1646: VALUES
1647: (
1648: l_misc_cash_dist_id,
1649: arp_global.user_id,
1650: arp_global.last_update_date,
1651: arp_global.created_by,
1652: arp_global.creation_date,
1653: p_cash_receipt_id,

Line 1650: arp_global.last_update_date,

1646: VALUES
1647: (
1648: l_misc_cash_dist_id,
1649: arp_global.user_id,
1650: arp_global.last_update_date,
1651: arp_global.created_by,
1652: arp_global.creation_date,
1653: p_cash_receipt_id,
1654: p_gl_date,

Line 1651: arp_global.created_by,

1647: (
1648: l_misc_cash_dist_id,
1649: arp_global.user_id,
1650: arp_global.last_update_date,
1651: arp_global.created_by,
1652: arp_global.creation_date,
1653: p_cash_receipt_id,
1654: p_gl_date,
1655: p_receipt_date,

Line 1652: arp_global.creation_date,

1648: l_misc_cash_dist_id,
1649: arp_global.user_id,
1650: arp_global.last_update_date,
1651: arp_global.created_by,
1652: arp_global.creation_date,
1653: p_cash_receipt_id,
1654: p_gl_date,
1655: p_receipt_date,
1656: dist.dist_code_combination_id,

Line 1659: arp_global.set_of_books_id,

1655: p_receipt_date,
1656: dist.dist_code_combination_id,
1657: dist.percent,
1658: dist.amount,
1659: arp_global.set_of_books_id,
1660: dist.acctd_amount,
1661: -3,
1662: 'ARRERCT',
1663: p_ussgl_trx_code, arp_standard.sysparm.org_id,

Line 1708: arp_global.base_min_acc_unit, null,

1704: NVL(SUM
1705: (
1706: decode
1707: (
1708: arp_global.base_min_acc_unit, null,
1709: round((p_amount * percent_distribution/100)
1710: * nvl(p_exchange_rate,1),
1711: arp_global.base_precision),
1712: round(p_amount * (percent_distribution/100)

Line 1711: arp_global.base_precision),

1707: (
1708: arp_global.base_min_acc_unit, null,
1709: round((p_amount * percent_distribution/100)
1710: * nvl(p_exchange_rate,1),
1711: arp_global.base_precision),
1712: round(p_amount * (percent_distribution/100)
1713: * nvl(p_exchange_rate ,1) /
1714: arp_global.base_precision)
1715: * arp_global.base_precision

Line 1714: arp_global.base_precision)

1710: * nvl(p_exchange_rate,1),
1711: arp_global.base_precision),
1712: round(p_amount * (percent_distribution/100)
1713: * nvl(p_exchange_rate ,1) /
1714: arp_global.base_precision)
1715: * arp_global.base_precision
1716: )
1717: ),0)
1718:

Line 1715: * arp_global.base_precision

1711: arp_global.base_precision),
1712: round(p_amount * (percent_distribution/100)
1713: * nvl(p_exchange_rate ,1) /
1714: arp_global.base_precision)
1715: * arp_global.base_precision
1716: )
1717: ),0)
1718:
1719: INTO l_rounding_diff,

Line 1841: arp_global.base_min_acc_unit, null,

1837: * l_min_unit
1838: ),
1839: acctd_amount = decode
1840: (
1841: arp_global.base_min_acc_unit, null,
1842: round((p_amount * percent/100) * nvl(p_exchange_rate,1),
1843: arp_global.base_precision),
1844: round(p_amount * (percent/100) * nvl(p_exchange_rate,1)
1845: / arp_global.base_precision) * arp_global.base_precision

Line 1843: arp_global.base_precision),

1839: acctd_amount = decode
1840: (
1841: arp_global.base_min_acc_unit, null,
1842: round((p_amount * percent/100) * nvl(p_exchange_rate,1),
1843: arp_global.base_precision),
1844: round(p_amount * (percent/100) * nvl(p_exchange_rate,1)
1845: / arp_global.base_precision) * arp_global.base_precision
1846: ),
1847: last_updated_by = arp_global.user_id,

Line 1845: / arp_global.base_precision) * arp_global.base_precision

1841: arp_global.base_min_acc_unit, null,
1842: round((p_amount * percent/100) * nvl(p_exchange_rate,1),
1843: arp_global.base_precision),
1844: round(p_amount * (percent/100) * nvl(p_exchange_rate,1)
1845: / arp_global.base_precision) * arp_global.base_precision
1846: ),
1847: last_updated_by = arp_global.user_id,
1848: last_update_date = arp_global.last_update_date
1849: WHERE cash_receipt_id = p_cash_receipt_id

Line 1847: last_updated_by = arp_global.user_id,

1843: arp_global.base_precision),
1844: round(p_amount * (percent/100) * nvl(p_exchange_rate,1)
1845: / arp_global.base_precision) * arp_global.base_precision
1846: ),
1847: last_updated_by = arp_global.user_id,
1848: last_update_date = arp_global.last_update_date
1849: WHERE cash_receipt_id = p_cash_receipt_id
1850: RETURNING misc_cash_distribution_id
1851: BULK COLLECT INTO l_misc_cash_key_value_list;

Line 1848: last_update_date = arp_global.last_update_date

1844: round(p_amount * (percent/100) * nvl(p_exchange_rate,1)
1845: / arp_global.base_precision) * arp_global.base_precision
1846: ),
1847: last_updated_by = arp_global.user_id,
1848: last_update_date = arp_global.last_update_date
1849: WHERE cash_receipt_id = p_cash_receipt_id
1850: RETURNING misc_cash_distribution_id
1851: BULK COLLECT INTO l_misc_cash_key_value_list;
1852:

Line 1884: arp_global.base_min_acc_unit, null,

1880: NVL(SUM
1881: (
1882: decode
1883: (
1884: arp_global.base_min_acc_unit, null,
1885: round((p_amount * percent/100)
1886: * nvl(p_exchange_rate,1),
1887: arp_global.base_precision),
1888: round(p_amount * (percent/100)

Line 1887: arp_global.base_precision),

1883: (
1884: arp_global.base_min_acc_unit, null,
1885: round((p_amount * percent/100)
1886: * nvl(p_exchange_rate,1),
1887: arp_global.base_precision),
1888: round(p_amount * (percent/100)
1889: * nvl(p_exchange_rate ,1) /
1890: arp_global.base_precision)
1891: * arp_global.base_precision

Line 1890: arp_global.base_precision)

1886: * nvl(p_exchange_rate,1),
1887: arp_global.base_precision),
1888: round(p_amount * (percent/100)
1889: * nvl(p_exchange_rate ,1) /
1890: arp_global.base_precision)
1891: * arp_global.base_precision
1892: )
1893: ),0)
1894:

Line 1891: * arp_global.base_precision

1887: arp_global.base_precision),
1888: round(p_amount * (percent/100)
1889: * nvl(p_exchange_rate ,1) /
1890: arp_global.base_precision)
1891: * arp_global.base_precision
1892: )
1893: ),0)
1894:
1895: INTO l_rounding_diff,