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 291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||

287: CLOSE csr_get_location_details;
288:
289: IF p_concatenate = 'Y' THEN
290:
291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
292: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
293: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
294: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
295: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

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

288:
289: IF p_concatenate = 'Y' THEN
290:
291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
292: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
293: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
294: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
295: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
296: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||

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

289: IF p_concatenate = 'Y' THEN
290:
291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
292: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
293: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
294: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
295: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
296: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
297: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||

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

290:
291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
292: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
293: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
294: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
295: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
296: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
297: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
298: l_location_zipcode

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

291: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
292: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
293: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
294: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
295: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
296: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
297: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
298: l_location_zipcode
299: INTO l_details

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

317: l_details := l_location_zipcode;
318: ELSIF p_field = 'COUNTRY' THEN
319: l_details := l_location_country;
320: END IF;
321: l_details :=RTRIM(l_details,fnd_global.local_chr(10));
322: l_details :=RTRIM(l_details,',');
323:
324: IF g_debug THEN
325: pay_in_utils.trace('l_details', l_details );

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

400: CLOSE csr_get_address_details;
401:
402: IF p_concatenate = 'Y' THEN
403:
404: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

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

401:
402: IF p_concatenate = 'Y' THEN
403:
404: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||

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

402: IF p_concatenate = 'Y' THEN
403:
404: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_country

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

403:
404: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_country
411: INTO l_details

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

404: SELECT l_location_address1 || DECODE(l_location_address1,NULL,NULL,',' || fnd_global.local_chr(10)) ||
405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_country
411: INTO l_details
412: FROM DUAL;

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

405: l_location_address2 || DECODE(l_location_address2,NULL,NULL,',' || fnd_global.local_chr(10)) ||
406: l_location_address3 || DECODE(l_location_address3,NULL,NULL,',' || fnd_global.local_chr(10)) ||
407: l_location_address4 || DECODE(l_location_address4,NULL,NULL,',' || fnd_global.local_chr(10)) ||
408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_country
411: INTO l_details
412: FROM DUAL;
413:

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

428: ELSIF p_field = 'COUNTRY' THEN
429: l_details := l_location_country;
430: END IF;
431:
432: l_details :=RTRIM(l_details,','||fnd_global.local_chr(10));
433:
434:
435:
436: IF g_debug THEN

Line 644: ,get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1'),NULL,NULL,',' || fnd_global.local_chr(10)) ||

640: , 'REP_POSITION' rep_designation
641: , CASE WHEN p_designation ='POS' THEN Action_information13
642: ELSE Action_information21 END rep_designation_value
643: ,'ITAX_ADDRESS' itax_address
644: ,get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
645: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
646: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
647: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS4') itax_address_value
648: , 'ITAX_CITY' itax_city

Line 645: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2'),NULL,NULL,',' || fnd_global.local_chr(10)) ||

641: , CASE WHEN p_designation ='POS' THEN Action_information13
642: ELSE Action_information21 END rep_designation_value
643: ,'ITAX_ADDRESS' itax_address
644: ,get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
645: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
646: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
647: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS4') itax_address_value
648: , 'ITAX_CITY' itax_city
649: , get_location_details ( TO_NUMBER(action_information19),'N','CITY') itax_city_value

Line 646: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3'),NULL,NULL,',' || fnd_global.local_chr(10)) ||

642: ELSE Action_information21 END rep_designation_value
643: ,'ITAX_ADDRESS' itax_address
644: ,get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS1'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
645: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS2'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
646: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3') || DECODE(get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS3'),NULL,NULL,',' || fnd_global.local_chr(10)) ||
647: get_location_details ( TO_NUMBER(action_information19),'N','EMPLOYER_ADDRESS4') itax_address_value
648: , 'ITAX_CITY' itax_city
649: , get_location_details ( TO_NUMBER(action_information19),'N','CITY') itax_city_value
650: ,'ITAX_PIN_CODE' itax_pin_code

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

832: , 'EE_DETAILS' emp_details
833: ,CASE WHEN p_designation ='POS' THEN
834: UPPER(pai.action_information6
835: || pai.action_information5
836: || DECODE(pai.action_information9,NULL,'',fnd_global.local_chr(10))
837: || pai.action_information9)
838: ELSE
839: UPPER(pai.action_information6
840: || pai.action_information5

Line 841: || DECODE(pai.action_information22,NULL,'',fnd_global.local_chr(10))

837: || pai.action_information9)
838: ELSE
839: UPPER(pai.action_information6
840: || pai.action_information5
841: || DECODE(pai.action_information22,NULL,'',fnd_global.local_chr(10))
842: || pai.action_information22)
843: END emp_details_value
844: , 'E_F_NAME' emp_full_name
845: , UPPER(pai.action_information5) emp_full_value

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

1566: l_via_seq_80c_num := 1;
1567: l_via_seq_80cce_num := 97;
1568: l_via_seq_80d_u_num := 97;
1569:
1570: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';
1571:
1572:
1573: FOR i IN csr_deduction_via LOOP
1574: IF (l_via_80c_flag = 0 and i.Description_Value <> 'X') THEN

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

1623: '80GGA',
1624: '80U',
1625: '80CCF') THEN
1626: l_via_oth_flag := 1;
1627: l_80du_tag_seq := '('||fnd_global.local_chr(l_via_seq_80d_u_num)||')';
1628: l_open_tag := '';
1629: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1630:
1631: l_qualifying_amt := nvl(i.Qualifying_Value,0);

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

1638: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1639: l_via_seq_80d_u_num := l_via_seq_80d_u_num +1;
1640: ELSIF i.Description_Value IN('80CCC','80CCD') THEN
1641: l_via_cce_flag := 1;
1642: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';
1643: l_qualifying_amt := LEAST(g_80cce_limit,nvl(i.Qualifying_Value,0));
1644: l_tag := substr(i.Description_Value,3);
1645: l_open_tag := '<'||l_tag||'GRP>';
1646: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

1782:
1783:
1784: l_count := l_count + 1;
1785:
1786: select lower(fnd_global.local_chr(r+64)) INTO l_seq
1787: FROM
1788: ( SELECT LEVEL r
1789: FROM dual
1790: CONNECT BY LEVEL <= 26 )