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_ARXPDI_XMLP_PKG dependencies on ARPT_SQL_FUNC_UTIL

Line 24: p_balance_due := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Balance Due');

20: lp_where_show_bill := 'and ps.cons_inv_id = ci.cons_inv_id(+)';
21: End if;
22: p_as_of := rtrim(ARP_STANDARD.FND_MESSAGE('AR_REPORTS_AS_OF'));
23: p_as_of := p_as_of || ' ';
24: p_balance_due := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Balance Due');
25: p_customer := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORTY_BY_ARXPDI','Customer');
26: p_salesperson := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');
27: return (TRUE);
28: end;

Line 25: p_customer := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORTY_BY_ARXPDI','Customer');

21: End if;
22: p_as_of := rtrim(ARP_STANDARD.FND_MESSAGE('AR_REPORTS_AS_OF'));
23: p_as_of := p_as_of || ' ';
24: p_balance_due := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Balance Due');
25: p_customer := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORTY_BY_ARXPDI','Customer');
26: p_salesperson := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');
27: return (TRUE);
28: end;
29: function AfterReport return boolean is

Line 26: p_salesperson := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');

22: p_as_of := rtrim(ARP_STANDARD.FND_MESSAGE('AR_REPORTS_AS_OF'));
23: p_as_of := p_as_of || ' ';
24: p_balance_due := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Balance Due');
25: p_customer := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORTY_BY_ARXPDI','Customer');
26: p_salesperson := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');
27: return (TRUE);
28: end;
29: function AfterReport return boolean is
30: begin

Line 167: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') = :p_invoice_type_low ' ;

163: lp_customer_number_high := ' and CUST.ACCOUNT_NUMBER <= :p_customer_number_high ' ;
164: end if ;
165: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NOT NULL then
166: if p_invoice_type_low = p_invoice_type_high then
167: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') = :p_invoice_type_low ' ;
168: else
169: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;
170: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
171: end if ;

Line 169: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;

165: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NOT NULL then
166: if p_invoice_type_low = p_invoice_type_high then
167: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') = :p_invoice_type_low ' ;
168: else
169: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;
170: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
171: end if ;
172: end if ;
173: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NULL then

Line 170: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;

166: if p_invoice_type_low = p_invoice_type_high then
167: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') = :p_invoice_type_low ' ;
168: else
169: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;
170: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
171: end if ;
172: end if ;
173: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NULL then
174: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;

Line 174: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;

170: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
171: end if ;
172: end if ;
173: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NULL then
174: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;
175: end if ;
176: if p_invoice_type_high is NOT NULL and p_invoice_type_low is NULL then
177: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
178: end if ;

Line 177: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;

173: if p_invoice_type_low is NOT NULL and p_invoice_type_high is NULL then
174: lp_invoice_type_low := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') >= :p_invoice_type_low ' ;
175: end if ;
176: if p_invoice_type_high is NOT NULL and p_invoice_type_low is NULL then
177: lp_invoice_type_high := ' and arpt_sql_func_util.get_trx_type_details(ctx.cust_trx_type_id ,''NAME'') <= :p_invoice_type_high ' ;
178: end if ;
179: if p_salesrep_low is NOT NULL then
180: lp_salesrep_low := ' and ( (srep.name >= :p_salesrep_low) ) ' ;
181: end if ;

Line 302: Order_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI',p_order_by);

298: RETURN NULL; end;
299: function CF_ORDER_BYFormula return Char is
300: order_meaning AR_LOOKUPS.MEANING%TYPE;
301: begin
302: Order_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI',p_order_by);
303: RETURN (ORDER_MEANING);
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN
306: RETURN(P_ORDER_BY);

Line 311: Order_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');

307: end;
308: function CF_salespersonFormula return Char is
309: order_meaning AR_LOOKUPS.MEANING%TYPE;
310: begin
311: Order_meaning := ARPT_SQL_FUNC_UTIL.get_lookup_meaning('SORT_BY_ARXPDI','Salesperson');
312: RETURN (ORDER_MEANING);
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: RETURN('Salesperson');