37: else
38: l_gl_date_high := TO_CHAR(p_gl_date_high, 'DD-MON-YYYY');
39: end if ;
40:
41: rp_gl_date := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GL_DATE_FROM_TO',
42: 'FROM_DATE', l_gl_date_low,
43: 'TO_DATE',l_gl_date_high);
44:
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
41: rp_gl_date := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GL_DATE_FROM_TO',
42: 'FROM_DATE', l_gl_date_low,
43: 'TO_DATE',l_gl_date_high);
44:
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
46: rp_sumfor := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM_FOR');
47: rp_total := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_TOTAL');
48: rp_func := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_FUNC');
49: rp_grand := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GRAND');
42: 'FROM_DATE', l_gl_date_low,
43: 'TO_DATE',l_gl_date_high);
44:
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
46: rp_sumfor := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM_FOR');
47: rp_total := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_TOTAL');
48: rp_func := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_FUNC');
49: rp_grand := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GRAND');
50:
43: 'TO_DATE',l_gl_date_high);
44:
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
46: rp_sumfor := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM_FOR');
47: rp_total := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_TOTAL');
48: rp_func := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_FUNC');
49: rp_grand := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GRAND');
50:
51: SELECT substr(cp.user_concurrent_program_name,1, 80)
44:
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
46: rp_sumfor := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM_FOR');
47: rp_total := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_TOTAL');
48: rp_func := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_FUNC');
49: rp_grand := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GRAND');
50:
51: SELECT substr(cp.user_concurrent_program_name,1, 80)
52: INTO l_report_name
45: rp_sum := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM');
46: rp_sumfor := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_SUM_FOR');
47: rp_total := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_TOTAL');
48: rp_func := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_FUNC');
49: rp_grand := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_GRAND');
50:
51: SELECT substr(cp.user_concurrent_program_name,1, 80)
52: INTO l_report_name
53: FROM FND_CONCURRENT_PROGRAMS_VL cp,
240: DECLARE
241: a VARCHAR2(2000);
242: b VARCHAR2(80);
243: BEGIN
244: a := ARP_STANDARD.FND_MESSAGE('AR_REPORTS_ORDER_BY');
245: select meaning
246: into b
247: from ar_lookups
248: where lookup_type = 'SORT_BY_ARXCTA'