eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_TRX_DEFAULTS_3 dependencies on RA_TERMS

Line 1508: p_term_id IN ra_terms.term_id%type,

1504: | |
1505: +===========================================================================*/
1506:
1507: PROCEDURE get_term_default(
1508: p_term_id IN ra_terms.term_id%type,
1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,

Line 1509: p_type_term_id IN ra_terms.term_id%type,

1505: +===========================================================================*/
1506:
1507: PROCEDURE get_term_default(
1508: p_term_id IN ra_terms.term_id%type,
1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,

Line 1510: p_type_term_name IN ra_terms.name%type,

1506:
1507: PROCEDURE get_term_default(
1508: p_term_id IN ra_terms.term_id%type,
1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,

Line 1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,

1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,
1518: p_number_of_due_dates OUT NOCOPY number,
1519: p_term_due_date OUT NOCOPY
1520: ra_customer_trx.term_due_date%type

Line 1517: p_default_term_name OUT NOCOPY ra_terms.name%type,

1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,
1516: p_default_term_id OUT NOCOPY ra_terms.term_id%type,
1517: p_default_term_name OUT NOCOPY ra_terms.name%type,
1518: p_number_of_due_dates OUT NOCOPY number,
1519: p_term_due_date OUT NOCOPY
1520: ra_customer_trx.term_due_date%type
1521: ) IS

Line 1525: l_cust_term_id ra_terms.term_id%type;

1521: ) IS
1522:
1523: l_number_of_due_dates number;
1524: l_term_due_date ra_customer_trx.term_due_date%type;
1525: l_cust_term_id ra_terms.term_id%type;
1526: l_cust_term_name ra_terms.name%type;
1527: l_org_id ra_customer_trx.org_id%type;
1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592
1529:

Line 1526: l_cust_term_name ra_terms.name%type;

1522:
1523: l_number_of_due_dates number;
1524: l_term_due_date ra_customer_trx.term_due_date%type;
1525: l_cust_term_id ra_terms.term_id%type;
1526: l_cust_term_name ra_terms.name%type;
1527: l_org_id ra_customer_trx.org_id%type;
1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592
1529:
1530: BEGIN

Line 1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592

1524: l_term_due_date ra_customer_trx.term_due_date%type;
1525: l_cust_term_id ra_terms.term_id%type;
1526: l_cust_term_name ra_terms.name%type;
1527: l_org_id ra_customer_trx.org_id%type;
1528: l_billing_cycle_id ra_terms.billing_cycle_id%type; -- Bug 7582592
1529:
1530: BEGIN
1531:
1532: IF PG_DEBUG in ('Y', 'C') THEN

Line 1590: from ra_terms

1586: else
1587: begin
1588: select name, billing_cycle_id
1589: into l_cust_term_name, l_billing_cycle_id
1590: from ra_terms
1591: where term_id = l_cust_term_id;
1592: exception
1593: when no_data_found then
1594: l_cust_term_name := null;

Line 1623: FROM ra_terms t_su,

1619: INTO l_cust_term_id,
1620: l_cust_term_name,
1621: l_term_due_date,
1622: l_number_of_due_dates
1623: FROM ra_terms t_su,
1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,

Line 1624: ra_terms t_cp1,

1620: l_cust_term_name,
1621: l_term_due_date,
1622: l_number_of_due_dates
1623: FROM ra_terms t_su,
1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,

Line 1625: ra_terms t_cp2,

1621: l_term_due_date,
1622: l_number_of_due_dates
1623: FROM ra_terms t_su,
1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,
1629: hz_cust_site_uses su

Line 1626: ra_terms_lines tl,

1622: l_number_of_due_dates
1623: FROM ra_terms t_su,
1624: ra_terms t_cp1,
1625: ra_terms t_cp2,
1626: ra_terms_lines tl,
1627: hz_customer_profiles cp1,
1628: hz_customer_profiles cp2,
1629: hz_cust_site_uses su
1630: WHERE p_customer_id = cp1.cust_account_id(+)

Line 1692: FROM ra_terms_lines

1688: p_type_term_id,
1689: p_trx_date)
1690: INTO l_number_of_due_dates,
1691: l_term_due_date
1692: FROM ra_terms_lines
1693: WHERE term_id = p_type_term_id;
1694:
1695: -- Guarantees cannot have split term terms
1696:

Line 1722: FROM ra_terms rat,

1718: rat.name,
1719: rat.term_id
1720: INTO l_cust_term_name,
1721: l_cust_term_id
1722: FROM ra_terms rat,
1723: ra_cust_trx_types ctt
1724: WHERE ctt.cust_trx_type_id=p_cust_trx_type_id
1725: AND ctt.default_term=rat.term_id(+);
1726:

Line 1735: FROM ra_terms_lines

1731: l_cust_term_id,
1732: p_trx_date)
1733: INTO l_number_of_due_dates,
1734: l_term_due_date
1735: FROM ra_terms_lines
1736: WHERE term_id = l_cust_term_id;
1737:
1738: p_default_term_id := l_cust_term_id;
1739: p_default_term_name := l_cust_term_name;