APPS.ARP_TRX_DEFAULTS_3 dependencies on ARPT_SQL_FUNC_UTIL

Line 1599: l_term_due_date := arpt_sql_func_util.get_First_Due_Date(l_cust_term_id,

1595: end;
1596:
1597: /* Bug 7582592 */
1598: IF l_billing_cycle_id is null THEN
1599: l_term_due_date := arpt_sql_func_util.get_First_Due_Date(l_cust_term_id,
1600: p_trx_date);
1601: END IF;
1602:
1603: end if;

Line 1616: arpt_sql_func_util.get_First_Due_Date( tl.term_id,

1612: t_cp1.name,
1613: t_cp2.name
1614: )
1615: ),
1616: arpt_sql_func_util.get_First_Due_Date( tl.term_id,
1617: p_trx_date),
1618: count(*)
1619: INTO l_cust_term_id,
1620: l_cust_term_name,

Line 1687: arpt_sql_func_util.get_First_Due_Date(

1683: ELSIF (p_type_term_id IS NOT NULL)
1684: THEN
1685:
1686: SELECT COUNT(*),
1687: arpt_sql_func_util.get_First_Due_Date(
1688: p_type_term_id,
1689: p_trx_date)
1690: INTO l_number_of_due_dates,
1691: l_term_due_date

Line 1730: arpt_sql_func_util.get_First_Due_Date(

1726:
1727: IF (l_cust_term_id is NOT NULL)
1728: THEN
1729: SELECT COUNT(*),
1730: arpt_sql_func_util.get_First_Due_Date(
1731: l_cust_term_id,
1732: p_trx_date)
1733: INTO l_number_of_due_dates,
1734: l_term_due_date

Line 1823: arpt_sql_func_util.get_override_terms(p_customer_id,

1819: arp_util.debug('arp_trx_defaults_3.Get_Additional_Customer_Info()+');
1820:
1821:
1822: l_override_terms :=
1823: arpt_sql_func_util.get_override_terms(p_customer_id,
1824: p_site_use_id);
1825:
1826: /* Bug 551173: Commented out NOCOPY for performance reasons
1827:

Line 1829: arpt_sql_func_util.get_commitments_exist_flag(

1825:
1826: /* Bug 551173: Commented out NOCOPY for performance reasons
1827:
1828: l_commitments_exist_flag :=
1829: arpt_sql_func_util.get_commitments_exist_flag(
1830: p_customer_id,
1831: p_invoice_currency_code,
1832: p_previous_customer_trx_id,
1833: p_trx_date,

Line 1843: arpt_sql_func_util.get_agreements_exist_flag(

1839: l_commitments_exist_flag := 'Y';
1840:
1841:
1842: l_agreements_exist_flag :=
1843: arpt_sql_func_util.get_agreements_exist_flag(
1844: p_customer_id,
1845: p_trx_date);
1846:
1847: p_override_terms := l_override_terms;