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 878: and (fnd_number.canonical_to_number(p_row_low_range_or_name) between

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 936: if fnd_number.canonical_to_number(p_row_high_range) <

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

Line 937: fnd_number.canonical_to_number(p_row_low_range_or_name) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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