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.GHR_SF113_A dependencies on HR_API

Line 535: l_duty_station := hr_api.g_varchar2;

531: l_susp_flag := 'N';
532:
533: -- Exclude NAF positions (Non-Apropriated Fund Positions) using CPDF dynamics function
534: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
535: l_duty_station := hr_api.g_varchar2;
536:
537: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
538: 'RM','HQ','PS','BQ','WQ','VQ') THEN
539: l_duty_station := 'T';

Line 544: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'

540: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
541: 'RM','HQ','PS','BQ','WQ','VQ')
542: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
543: l_duty_station := 'F';
544: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
545: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
546: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
547: l_duty_station := 'W';
548: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

Line 545: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )

541: 'RM','HQ','PS','BQ','WQ','VQ')
542: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
543: l_duty_station := 'F';
544: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
545: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
546: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
547: l_duty_station := 'W';
548: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
549: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

Line 548: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

544: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
545: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
546: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
547: l_duty_station := 'W';
548: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
549: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
550: or l_msa_code is null)
551: and (l_duty_station_code >= '00' and l_duty_station_code <= '99')
552: THEN

Line 549: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

545: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
546: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
547: l_duty_station := 'W';
548: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
549: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
550: or l_msa_code is null)
551: and (l_duty_station_code >= '00' and l_duty_station_code <= '99')
552: THEN
553: l_duty_station := 'O';

Line 643: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')

639:
640: -- For line 5, check if they're Permanent Appointments(Tenure code 1 or 2)
641: IF (l_tenure in ('1','2') and l_position_code in ('1','2') ) OR
642: (l_tenure = '0' and l_position_code in ('3','4')
643: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
644: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
645: )
646: ) THEN
647: IF l_duty_station = 'T' THEN

Line 644: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')

640: -- For line 5, check if they're Permanent Appointments(Tenure code 1 or 2)
641: IF (l_tenure in ('1','2') and l_position_code in ('1','2') ) OR
642: (l_tenure = '0' and l_position_code in ('3','4')
643: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
644: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
645: )
646: ) THEN
647: IF l_duty_station = 'T' THEN
648: p_l5b := p_l5b + 1;

Line 689: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')

685: l_position_code in ('1','2')
686: )
687: or
688: (l_tenure = '0' and l_position_code in ('3','4')
689: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
690: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
691: )
692: )
693: )

Line 690: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')

686: )
687: or
688: (l_tenure = '0' and l_position_code in ('3','4')
689: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
690: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
691: )
692: )
693: )
694: THEN

Line 733: and ( nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')

729:
730: -- Line 7 - Part time with Permanent Appointments
731: IF ((l_tenure in ('1','2') and l_position_code in ('1','2')) OR
732: ( l_tenure = '0' and l_position_code in ('3','4')
733: and ( nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
734: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
735: )
736: ) AND l_susp_flag = 'N' )THEN
737:

Line 734: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')

730: -- Line 7 - Part time with Permanent Appointments
731: IF ((l_tenure in ('1','2') and l_position_code in ('1','2')) OR
732: ( l_tenure = '0' and l_position_code in ('3','4')
733: and ( nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
734: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
735: )
736: ) AND l_susp_flag = 'N' )THEN
737:
738: IF l_duty_station = 'T' THEN

Line 761: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')

757: and (
758: (l_tenure in ('1','2') and l_position_code in ('1','2'))
759: or
760: (l_tenure = '0' and l_position_code in ('3','4')
761: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
762: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
763: )
764: )
765: )

Line 762: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')

758: (l_tenure in ('1','2') and l_position_code in ('1','2'))
759: or
760: (l_tenure = '0' and l_position_code in ('3','4')
761: and (nvl(l_cur_appt1,hr_api.g_varchar2) not in ('V4M','V4P')
762: and nvl(l_cur_appt2,hr_api.g_varchar2) not in ('V4M','V4P')
763: )
764: )
765: )
766: THEN

Line 875: nvl(l_cur_appt1,hr_api.g_varchar2)

871: OR
872: (l_tenure = '0'
873: and l_position_code in ('3','4')
874: and (
875: nvl(l_cur_appt1,hr_api.g_varchar2)
876: not in ('V4M','V4P')
877: and
878: nvl(l_cur_appt2,hr_api.g_varchar2)
879: not in ('V4M','V4P')

Line 878: nvl(l_cur_appt2,hr_api.g_varchar2)

874: and (
875: nvl(l_cur_appt1,hr_api.g_varchar2)
876: not in ('V4M','V4P')
877: and
878: nvl(l_cur_appt2,hr_api.g_varchar2)
879: not in ('V4M','V4P')
880: )
881: )
882: THEN

Line 950: and nvl(l_cur_appt1,hr_api.g_varchar2)

946:
947:
948:
949: IF nvl(l_susp_flag,'N') = 'N'
950: and nvl(l_cur_appt1,hr_api.g_varchar2)
951: not in ('MBM', 'MAM', 'QDK','NCM',
952: 'YBM', 'YGM', 'Y3M','Y1M',
953: 'Y2M', 'Y1K', 'Y2K','Y3K',
954: 'Y4K', 'Y5K')

Line 955: and nvl(l_cur_appt2,hr_api.g_varchar2)

951: not in ('MBM', 'MAM', 'QDK','NCM',
952: 'YBM', 'YGM', 'Y3M','Y1M',
953: 'Y2M', 'Y1K', 'Y2K','Y3K',
954: 'Y4K', 'Y5K')
955: and nvl(l_cur_appt2,hr_api.g_varchar2)
956: not in ('MBM', 'MAM', 'QDK','NCM',
957: 'YBM', 'YGM', 'Y3M','Y1M',
958: 'Y2M', 'Y1K', 'Y2K','Y3K',
959: 'Y4K', 'Y5K') THEN

Line 1216: l_duty_station := hr_api.g_varchar2;

1212:
1213: -- Exclude NAF positions (Non-Apropriated Fund Positions) using CPDF dynamics function
1214: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1215:
1216: l_duty_station := hr_api.g_varchar2;
1217: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1218: 'RM','HQ','PS','BQ','WQ','VQ') THEN
1219: p_l17b := p_l17b + l_total_sal;
1220: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',

Line 1224: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'

1220: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1221: 'RM','HQ','PS','BQ','WQ','VQ')
1222: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1223: p_l17c := p_l17c + l_total_sal;
1224: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1225: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1226: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1227: p_l17d := p_l17d + l_total_sal;
1228: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

Line 1225: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )

1221: 'RM','HQ','PS','BQ','WQ','VQ')
1222: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1223: p_l17c := p_l17c + l_total_sal;
1224: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1225: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1226: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1227: p_l17d := p_l17d + l_total_sal;
1228: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1229: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

Line 1228: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

1224: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1225: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1226: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1227: p_l17d := p_l17d + l_total_sal;
1228: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1229: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1230: or l_msa_code is null )
1231: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1232: p_l17e := p_l17e + l_total_sal;

Line 1229: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

1225: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1226: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1227: p_l17d := p_l17d + l_total_sal;
1228: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1229: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1230: or l_msa_code is null )
1231: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1232: p_l17e := p_l17e + l_total_sal;
1233: END IF;

Line 1241: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'

1237: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1238: 'RM','HQ','PS','BQ','WQ','VQ')
1239: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1240: p_l18c := p_l18c + l_total_lump;
1241: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1242: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1243: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1244: p_l18d := p_l18d + l_total_lump;
1245: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

Line 1242: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )

1238: 'RM','HQ','PS','BQ','WQ','VQ')
1239: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1240: p_l18c := p_l18c + l_total_lump;
1241: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1242: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1243: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1244: p_l18d := p_l18d + l_total_lump;
1245: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1246: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

Line 1245: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

1241: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1242: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1243: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1244: p_l18d := p_l18d + l_total_lump;
1245: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1246: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1247: or l_msa_code is null )
1248: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1249: p_l18e := p_l18e + l_total_lump;

Line 1246: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

1242: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1243: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1244: p_l18d := p_l18d + l_total_lump;
1245: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1246: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1247: or l_msa_code is null )
1248: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1249: p_l18e := p_l18e + l_total_lump;
1250: END IF;

Line 1631: l_duty_station := hr_api.g_varchar2;

1627: -- Exclude NAF positions (Non-Appropriate Fund positions)
1628:
1629: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1630:
1631: l_duty_station := hr_api.g_varchar2;
1632:
1633: -- Bug 3264666
1634: -- Check if the NTE date more than report date + 30 days.
1635:

Line 1673: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'

1669: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1670: 'RM','HQ','PS','BQ','WQ','VQ')
1671: AND (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1672: l_duty_station := 'F';
1673: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1674: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1675: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1676: l_duty_station := 'W';
1677: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

Line 1674: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )

1670: 'RM','HQ','PS','BQ','WQ','VQ')
1671: AND (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1672: l_duty_station := 'F';
1673: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1674: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1675: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1676: l_duty_station := 'W';
1677: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1678: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

Line 1677: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

1673: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1674: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1675: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1676: l_duty_station := 'W';
1677: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1678: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1679: or l_msa_code is null )
1680: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1681: l_duty_station := 'O';

Line 1678: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

1674: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1675: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1676: l_duty_station := 'W';
1677: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1678: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1679: or l_msa_code is null )
1680: AND (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1681: l_duty_station := 'O';
1682: END IF;

Line 1775: l_duty_station := hr_api.g_varchar2;

1771:
1772: -- Exclude NAF positions (Non-Appropriate Fund positions)
1773: IF NOT ghr_cpdf_dynrpt.exclude_position(l_position_id, p_rpt_date) THEN
1774:
1775: l_duty_station := hr_api.g_varchar2;
1776:
1777: IF l_duty_station_code in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1778: 'RM','HQ','PS','BQ','WQ','VQ') THEN
1779: l_duty_station := 'T';

Line 1784: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'

1780: ELSIF l_duty_station_code not in ('GQ','RQ','AQ','FM','JQ','CQ','MQ',
1781: 'RM','HQ','PS','BQ','WQ','VQ')
1782: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1783: l_duty_station := 'F';
1784: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1785: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1786: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1787: l_duty_station := 'W';
1788: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

Line 1785: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )

1781: 'RM','HQ','PS','BQ','WQ','VQ')
1782: and (l_duty_station_code >= 'AA' and l_duty_station_code <= 'ZZ') THEN
1783: l_duty_station := 'F';
1784: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1785: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1786: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1787: l_duty_station := 'W';
1788: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1789: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

Line 1788: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'

1784: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) = '8840'
1785: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1786: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1787: l_duty_station := 'W';
1788: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1789: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1790: or l_msa_code is null )
1791: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1792: l_duty_station := 'O';

Line 1789: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'

1785: or nvl(l_msa_code,hr_api.g_varchar2) = '47900' )
1786: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1787: l_duty_station := 'W';
1788: ELSIF (nvl(l_msa_code,hr_api.g_varchar2) <> '8840'
1789: or nvl(l_msa_code,hr_api.g_varchar2) <> '47900'
1790: or l_msa_code is null )
1791: and (l_duty_station_code >= '00' and l_duty_station_code <= '99') THEN
1792: l_duty_station := 'O';
1793: END IF;