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.AR_RAAPI_UTIL dependencies on ARPT_SQL_FUNC_UTIL

Line 65: g_un_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

61: OPEN c_get_category_set;
62: FETCH c_get_category_set INTO g_category_set_id, g_category_structure_id;
63: CLOSE c_get_category_set;
64:
65: g_un_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
66: (p_lookup_type => 'REV_ADJ_TYPE'
67: ,p_lookup_code => 'UN');
68: g_ea_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
69: (p_lookup_type => 'REV_ADJ_TYPE'

Line 68: g_ea_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

64:
65: g_un_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
66: (p_lookup_type => 'REV_ADJ_TYPE'
67: ,p_lookup_code => 'UN');
68: g_ea_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
69: (p_lookup_type => 'REV_ADJ_TYPE'
70: ,p_lookup_code => 'EA');
71: g_sa_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
72: (p_lookup_type => 'REV_ADJ_TYPE'

Line 71: g_sa_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

67: ,p_lookup_code => 'UN');
68: g_ea_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
69: (p_lookup_type => 'REV_ADJ_TYPE'
70: ,p_lookup_code => 'EA');
71: g_sa_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
72: (p_lookup_type => 'REV_ADJ_TYPE'
73: ,p_lookup_code => 'SA');
74: g_nr_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
75: (p_lookup_type => 'REV_ADJ_TYPE'

Line 74: g_nr_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

70: ,p_lookup_code => 'EA');
71: g_sa_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
72: (p_lookup_type => 'REV_ADJ_TYPE'
73: ,p_lookup_code => 'SA');
74: g_nr_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
75: (p_lookup_type => 'REV_ADJ_TYPE'
76: ,p_lookup_code => 'NR');
77: g_ll_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
78: (p_lookup_type => 'REV_ADJ_TYPE'

Line 77: g_ll_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

73: ,p_lookup_code => 'SA');
74: g_nr_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
75: (p_lookup_type => 'REV_ADJ_TYPE'
76: ,p_lookup_code => 'NR');
77: g_ll_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
78: (p_lookup_type => 'REV_ADJ_TYPE'
79: ,p_lookup_code => 'LL');
80:
81: g_system_cache_flag := 'Y';

Line 723: -- ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME'));

719: p_app_short_name => 'AR'));
720: FND_MESSAGE.set_token('SALESREP_NAME',
721: --begin anuj
722: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
723: -- ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME'));
724: ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME',l_org_id));
725: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
726: --end anuj
727: FND_MSG_PUB.Add;

Line 724: ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME',l_org_id));

720: FND_MESSAGE.set_token('SALESREP_NAME',
721: --begin anuj
722: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
723: -- ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME'));
724: ARPT_SQL_FUNC_UTIL.get_salesrep_name_number(g_from_salesrep_id,'NAME',l_org_id));
725: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
726: --end anuj
727: FND_MSG_PUB.Add;
728: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1706: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

1702: IF AR_Revenue_Adjustment_PVT.g_update_db_flag = 'Y'
1703: THEN
1704: /* Bug 4304865 - separate lookup for sales credit adjustments */
1705: IF p_rev_adj_rec.adjustment_type IN ('SA','NR') THEN
1706: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
1707: (p_lookup_type => 'SALESCRED_ADJ_REASON'
1708: ,p_lookup_code => p_rev_adj_rec.reason_code);
1709: ELSE
1710: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

Line 1710: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning

1706: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
1707: (p_lookup_type => 'SALESCRED_ADJ_REASON'
1708: ,p_lookup_code => p_rev_adj_rec.reason_code);
1709: ELSE
1710: l_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning
1711: (p_lookup_type => 'REV_ADJ_REASON'
1712: ,p_lookup_code => p_rev_adj_rec.reason_code);
1713: END IF;
1714: IF l_meaning IS NULL