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.PAY_IN_EOY_REPORTS dependencies on FND_GLOBAL

Line 296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||

292: CLOSE csr_get_location_details;
293:
294: IF p_concatenate = 'Y' THEN
295:
296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

Line 297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||

293:
294: IF p_concatenate = 'Y' THEN
295:
296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
301: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||

Line 298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||

294: IF p_concatenate = 'Y' THEN
295:
296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
301: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
302: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||

Line 299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||

295:
296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
301: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
302: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
303: l_location_zipcode

Line 300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

296: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
297: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
298: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
299: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
300: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
301: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
302: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
303: l_location_zipcode
304: INTO l_details

Line 326: l_details :=RTRIM(l_details,fnd_global.local_chr(10));

322: l_details := l_location_zipcode;
323: ELSIF p_field = 'COUNTRY' THEN
324: l_details := l_location_country;
325: END IF;
326: l_details :=RTRIM(l_details,fnd_global.local_chr(10));
327: l_details :=RTRIM(l_details,',');
328:
329: IF g_debug THEN
330: pay_in_utils.trace('l_details', l_details );

Line 409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||

405: CLOSE csr_get_address_details;
406:
407: IF p_concatenate = 'Y' THEN
408:
409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

Line 410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||

406:
407: IF p_concatenate = 'Y' THEN
408:
409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

Line 411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||

407: IF p_concatenate = 'Y' THEN
408:
409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
415: l_location_country

Line 412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||

408:
409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
415: l_location_country
416: INTO l_details

Line 413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

409: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
415: l_location_country
416: INTO l_details
417: FROM DUAL;

Line 414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

410: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
411: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
412: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
415: l_location_country
416: INTO l_details
417: FROM DUAL;
418:

Line 437: l_details :=RTRIM(l_details,','||fnd_global.local_chr(10));

433: ELSIF p_field = 'COUNTRY' THEN
434: l_details := l_location_country;
435: END IF;
436:
437: l_details :=RTRIM(l_details,','||fnd_global.local_chr(10));
438:
439:
440:
441: IF g_debug THEN

Line 731: || DECODE(pai.action_information9,NULL,'',fnd_global.local_chr(10))

727: , pai.action_information1 empno_value
728: , 'EE_DETAILS' emp_details
729: , UPPER(pai.action_information6
730: || pai.action_information5
731: || DECODE(pai.action_information9,NULL,'',fnd_global.local_chr(10))
732: || pai.action_information9) emp_details_value
733: , 'E_F_NAME' emp_full_name
734: , UPPER(pai.action_information5) emp_full_value
735: , 'E_TITLE' emp_title

Line 1310: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';

1306: l_via_seq_80c_num := 1;
1307: l_via_seq_80cce_num := 97;
1308: l_via_seq_80d_u_num := 97;
1309:
1310: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';
1311:
1312:
1313: FOR i IN csr_deduction_via LOOP
1314: IF (l_via_80c_flag = 0 and i.Description_Value <> 'X') THEN

Line 1366: l_80du_tag_seq := '('||fnd_global.local_chr(l_via_seq_80d_u_num)||')';

1362: '80GG',
1363: '80GGA',
1364: '80U') THEN
1365: l_via_oth_flag := 1;
1366: l_80du_tag_seq := '('||fnd_global.local_chr(l_via_seq_80d_u_num)||')';
1367: l_open_tag := '';
1368: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1369:
1370: l_qualifying_amt := nvl(i.Qualifying_Value,0);

Line 1381: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';

1377: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1378: l_via_seq_80d_u_num := l_via_seq_80d_u_num +1;
1379: ELSIF i.Description_Value IN('80CCC','80CCD') THEN
1380: l_via_cce_flag := 1;
1381: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';
1382: l_qualifying_amt := LEAST(g_80cce_limit,nvl(i.Qualifying_Value,0));
1383: l_tag := substr(i.Description_Value,3);
1384: l_open_tag := '<'||l_tag||'GRP>';
1385: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 1525: select lower(fnd_global.local_chr(r+64)) INTO l_seq

1521:
1522:
1523: l_count := l_count + 1;
1524:
1525: select lower(fnd_global.local_chr(r+64)) INTO l_seq
1526: FROM
1527: ( SELECT LEVEL r
1528: FROM dual
1529: CONNECT BY LEVEL <= 26 )