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_PUR_BUS dependencies on FND_NUMBER

Line 879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between

875: or ( p_legislation_code is not null and
876: usr.legislation_code is null and usr.business_group_id is null)
877: or ( p_legislation_code is not null and
878: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))
879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between

Line 880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)

876: usr.legislation_code is null and usr.business_group_id is null)
877: or ( p_legislation_code is not null and
878: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))
879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))

Line 881: or (fnd_number.canonical_to_number(p_row_high_range) between

877: or ( p_legislation_code is not null and
878: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))
879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between

Line 882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))

878: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id) ))
879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between
886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))

Line 883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between

879: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between
886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
887: and ( usr.effective_start_date <= p_validation_end_date and

Line 884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))

880: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between
886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
887: and ( usr.effective_start_date <= p_validation_end_date and
888: usr.effective_end_date >= p_validation_start_date );

Line 885: or (fnd_number.canonical_to_number(usr.row_high_range) between

881: or (fnd_number.canonical_to_number(p_row_high_range) between
882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between
886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
887: and ( usr.effective_start_date <= p_validation_end_date and
888: usr.effective_end_date >= p_validation_start_date );
889:

Line 886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))

882: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
883: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
884: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
885: or (fnd_number.canonical_to_number(usr.row_high_range) between
886: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
887: and ( usr.effective_start_date <= p_validation_end_date and
888: usr.effective_end_date >= p_validation_start_date );
889:
890: l_proc varchar2(100) := g_package || 'chk_range';

Line 937: if fnd_number.canonical_to_number(p_row_high_range) <

933:
934: -- Bug 3832215. Convert row_low_range_or_name and row_high_range
935: -- from canonical to number before compare.
936:
937: if fnd_number.canonical_to_number(p_row_high_range) <
938: fnd_number.canonical_to_number(p_row_low_range_or_name) then
939: fnd_message.set_name('PAY','PAY_33178_RANGE_INVALID');
940: fnd_message.raise_error ;
941: end if;

Line 938: fnd_number.canonical_to_number(p_row_low_range_or_name) then

934: -- Bug 3832215. Convert row_low_range_or_name and row_high_range
935: -- from canonical to number before compare.
936:
937: if fnd_number.canonical_to_number(p_row_high_range) <
938: fnd_number.canonical_to_number(p_row_low_range_or_name) then
939: fnd_message.set_name('PAY','PAY_33178_RANGE_INVALID');
940: fnd_message.raise_error ;
941: end if;
942:

Line 1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between

1138: or ( p_legislation_code is not null and
1139: usr.legislation_code is null and usr.business_group_id is null)
1140: or ( p_legislation_code is not null and
1141: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between

Line 1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)

1139: usr.legislation_code is null and usr.business_group_id is null)
1140: or ( p_legislation_code is not null and
1141: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))

Line 1144: or (fnd_number.canonical_to_number(p_row_high_range) between

1140: or ( p_legislation_code is not null and
1141: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between

Line 1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))

1141: p_legislation_code = hr_api.return_legislation_code(usr.business_group_id ) ))
1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between
1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))

Line 1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between

1142: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between
1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between
1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
1150: and ( usr.effective_start_date <= p_validation_end_date and

Line 1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))

1143: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range)
1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between
1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
1150: and ( usr.effective_start_date <= p_validation_end_date and
1151: usr.effective_end_date >= p_validation_start_date );

Line 1148: or (fnd_number.canonical_to_number(usr.row_high_range) between

1144: or (fnd_number.canonical_to_number(p_row_high_range) between
1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between
1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
1150: and ( usr.effective_start_date <= p_validation_end_date and
1151: usr.effective_end_date >= p_validation_start_date );
1152:

Line 1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))

1145: fnd_number.canonical_to_number(usr.row_low_range_or_name) and fnd_number.canonical_to_number(usr.row_high_range))
1146: or (fnd_number.canonical_to_number(usr.row_low_range_or_name) between
1147: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range))
1148: or (fnd_number.canonical_to_number(usr.row_high_range) between
1149: fnd_number.canonical_to_number(p_row_low_range_or_name) and fnd_number.canonical_to_number(p_row_high_range)))
1150: and ( usr.effective_start_date <= p_validation_end_date and
1151: usr.effective_end_date >= p_validation_start_date );
1152:
1153: cursor csr_zap_mode is