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_BANK_BRANCHES_PKG dependencies on HR_API

Line 18: hr_api.mandatory_arg_error

14: begin
15: --
16: -- p_branch_code and p_legislation_code must both be not NULL.
17: --
18: hr_api.mandatory_arg_error
19: (p_api_name => 'chk_primary_key_args'
20: ,p_argument => 'P_BRANCH_CODE'
21: ,p_argument_value => p_branch_code
22: );

Line 24: hr_api.mandatory_arg_error

20: ,p_argument => 'P_BRANCH_CODE'
21: ,p_argument_value => p_branch_code
22: );
23: --
24: hr_api.mandatory_arg_error
25: (p_api_name => 'chk_primary_key_args'
26: ,p_argument => 'P_LEGISLATION_CODE'
27: ,p_argument_value => p_legislation_code
28: );

Line 43: ,p_start_date_active in date default hr_api.g_sot

39: ,p_extra_information3 in varchar2 default null
40: ,p_extra_information4 in varchar2 default null
41: ,p_extra_information5 in varchar2 default null
42: ,p_enabled_flag in varchar2 default 'Y'
43: ,p_start_date_active in date default hr_api.g_sot
44: ,p_end_date_active in date default hr_api.g_eot
45: ) is
46: l_dummy varchar2(32);
47: --

Line 44: ,p_end_date_active in date default hr_api.g_eot

40: ,p_extra_information4 in varchar2 default null
41: ,p_extra_information5 in varchar2 default null
42: ,p_enabled_flag in varchar2 default 'Y'
43: ,p_start_date_active in date default hr_api.g_sot
44: ,p_end_date_active in date default hr_api.g_eot
45: ) is
46: l_dummy varchar2(32);
47: --
48: cursor csr_leg_code(p_legislation_code in varchar2) is

Line 69: hr_api.not_exists_in_hr_lookups

65: --
66: -- ENABLED_FLAG must be a code for lookup type YES_NO.
67: --
68: if p_enabled_flag is not null and
69: hr_api.not_exists_in_hr_lookups
70: (p_effective_date => trunc(sysdate)
71: ,p_lookup_type => 'YES_NO'
72: ,p_lookup_code => p_enabled_flag
73: )

Line 158: ,p_bank_code in varchar2 default hr_api.g_varchar2

154: ------------------------------< UPDATE_ROW >-------------------------------
155: procedure update_row
156: (p_branch_code in varchar2
157: ,p_legislation_code in varchar2
158: ,p_bank_code in varchar2 default hr_api.g_varchar2
159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2

Line 159: ,p_branch in varchar2 default hr_api.g_varchar2

155: procedure update_row
156: (p_branch_code in varchar2
157: ,p_legislation_code in varchar2
158: ,p_bank_code in varchar2 default hr_api.g_varchar2
159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2

Line 160: ,p_long_branch in varchar2 default hr_api.g_varchar2

156: (p_branch_code in varchar2
157: ,p_legislation_code in varchar2
158: ,p_bank_code in varchar2 default hr_api.g_varchar2
159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2

Line 161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2

157: ,p_legislation_code in varchar2
158: ,p_bank_code in varchar2 default hr_api.g_varchar2
159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2

Line 162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2

158: ,p_bank_code in varchar2 default hr_api.g_varchar2
159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

Line 163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2

159: ,p_branch in varchar2 default hr_api.g_varchar2
160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date

Line 164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2

160: ,p_long_branch in varchar2 default hr_api.g_varchar2
161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date
168: ,p_end_date_active in date default hr_api.g_date

Line 165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2

161: ,p_extra_information1 in varchar2 default hr_api.g_varchar2
162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date
168: ,p_end_date_active in date default hr_api.g_date
169: ) is

Line 166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

162: ,p_extra_information2 in varchar2 default hr_api.g_varchar2
163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date
168: ,p_end_date_active in date default hr_api.g_date
169: ) is
170: l_legislation_code pay_bank_branches.legislation_code%type;

Line 167: ,p_start_date_active in date default hr_api.g_date

163: ,p_extra_information3 in varchar2 default hr_api.g_varchar2
164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date
168: ,p_end_date_active in date default hr_api.g_date
169: ) is
170: l_legislation_code pay_bank_branches.legislation_code%type;
171: l_branch_code pay_bank_branches.branch_code%type;

Line 168: ,p_end_date_active in date default hr_api.g_date

164: ,p_extra_information4 in varchar2 default hr_api.g_varchar2
165: ,p_extra_information5 in varchar2 default hr_api.g_varchar2
166: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
167: ,p_start_date_active in date default hr_api.g_date
168: ,p_end_date_active in date default hr_api.g_date
169: ) is
170: l_legislation_code pay_bank_branches.legislation_code%type;
171: l_branch_code pay_bank_branches.branch_code%type;
172: l_bank_code pay_bank_branches.bank_code%type;

Line 205: if nval <> hr_api.g_varchar2 then

201: ;
202: --
203: procedure conv(nval in varchar2, oval in out nocopy varchar2) is
204: begin
205: if nval <> hr_api.g_varchar2 then
206: oval := nval;
207: end if;
208: end conv;
209: --

Line 212: if nval <> hr_api.g_date then

208: end conv;
209: --
210: procedure conv(nval in date, oval in out nocopy date) is
211: begin
212: if nval <> hr_api.g_date then
213: oval := nval;
214: end if;
215: end conv;
216: begin

Line 270: hr_api.not_exists_in_hr_lookups

266: --
267: -- ENABLED_FLAG must be a code for lookup type YES_NO.
268: --
269: if l_enabled_flag is not null and
270: hr_api.not_exists_in_hr_lookups
271: (p_effective_date => trunc(sysdate)
272: ,p_lookup_type => 'YES_NO'
273: ,p_lookup_code => l_enabled_flag
274: )

Line 393: hr_api.not_exists_in_hr_lookups

389: --
390: -- BANK_CODE must be a code for lookup type GB_BANKS.
391: --
392: if p_insert and
393: hr_api.not_exists_in_hr_lookups
394: (p_effective_date => trunc(sysdate)
395: ,p_lookup_type => 'GB_BANKS'
396: ,p_lookup_code => p_bank_code
397: )

Line 425: ,p_start_date_active in date default hr_api.g_sot

421: ,p_branch in varchar2
422: ,p_long_branch in varchar2 default null
423: ,p_building_society_acct in out nocopy varchar2
424: ,p_enabled_flag in varchar2 default 'Y'
425: ,p_start_date_active in date default hr_api.g_sot
426: ,p_end_date_active in date default hr_api.g_eot
427: ) is
428: begin
429: validate_gb_values

Line 426: ,p_end_date_active in date default hr_api.g_eot

422: ,p_long_branch in varchar2 default null
423: ,p_building_society_acct in out nocopy varchar2
424: ,p_enabled_flag in varchar2 default 'Y'
425: ,p_start_date_active in date default hr_api.g_sot
426: ,p_end_date_active in date default hr_api.g_eot
427: ) is
428: begin
429: validate_gb_values
430: (p_sort_code => p_sort_code

Line 450: ,p_branch in varchar2 default hr_api.g_varchar2

446: end insert_gb_row;
447: ----------------------------< UPDATE_GB_ROW >------------------------------
448: procedure update_gb_row
449: (p_sort_code in varchar2
450: ,p_branch in varchar2 default hr_api.g_varchar2
451: ,p_long_branch in varchar2 default hr_api.g_varchar2
452: ,p_building_society_acct in out nocopy varchar2
453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
454: ,p_start_date_active in date default hr_api.g_date

Line 451: ,p_long_branch in varchar2 default hr_api.g_varchar2

447: ----------------------------< UPDATE_GB_ROW >------------------------------
448: procedure update_gb_row
449: (p_sort_code in varchar2
450: ,p_branch in varchar2 default hr_api.g_varchar2
451: ,p_long_branch in varchar2 default hr_api.g_varchar2
452: ,p_building_society_acct in out nocopy varchar2
453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
454: ,p_start_date_active in date default hr_api.g_date
455: ,p_end_date_active in date default hr_api.g_date

Line 453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

449: (p_sort_code in varchar2
450: ,p_branch in varchar2 default hr_api.g_varchar2
451: ,p_long_branch in varchar2 default hr_api.g_varchar2
452: ,p_building_society_acct in out nocopy varchar2
453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
454: ,p_start_date_active in date default hr_api.g_date
455: ,p_end_date_active in date default hr_api.g_date
456: ) is
457: l_sort_code varchar2(100);

Line 454: ,p_start_date_active in date default hr_api.g_date

450: ,p_branch in varchar2 default hr_api.g_varchar2
451: ,p_long_branch in varchar2 default hr_api.g_varchar2
452: ,p_building_society_acct in out nocopy varchar2
453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
454: ,p_start_date_active in date default hr_api.g_date
455: ,p_end_date_active in date default hr_api.g_date
456: ) is
457: l_sort_code varchar2(100);
458: -- Values to pass to VALIDATE_GB_VALUES.

Line 455: ,p_end_date_active in date default hr_api.g_date

451: ,p_long_branch in varchar2 default hr_api.g_varchar2
452: ,p_building_society_acct in out nocopy varchar2
453: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
454: ,p_start_date_active in date default hr_api.g_date
455: ,p_end_date_active in date default hr_api.g_date
456: ) is
457: l_sort_code varchar2(100);
458: -- Values to pass to VALIDATE_GB_VALUES.
459: l_branch pay_bank_branches.branch%type;

Line 471: -- hr_api.g_varchar2.

467: begin
468: --
469: -- Get the existing values for branch and building society account to
470: -- use in validation for the case where the passed in values are
471: -- hr_api.g_varchar2.
472: --
473: l_sort_code := lpad(p_sort_code, g_gb_sort_code_len, '0');
474: open csr_existing_row(p_sort_code => l_sort_code);
475: fetch csr_existing_row

Line 479: if p_branch <> hr_api.g_varchar2 then

475: fetch csr_existing_row
476: into l_branch
477: ;
478: if csr_existing_row%found then
479: if p_branch <> hr_api.g_varchar2 then
480: l_branch := p_branch;
481: end if;
482: --
483: -- The existing row was not found. Allow the validation to succeed and

Line 621: nvl(l_branch_info.start_date_active, hr_api.g_sot) and

617: if csr_branch_info%found then
618: l_enabled :=
619: nvl(upper(l_branch_info.enabled_flag), 'Y') = 'Y' and
620: p_effective_date between
621: nvl(l_branch_info.start_date_active, hr_api.g_sot) and
622: nvl(l_branch_info.end_date_active, hr_api.g_eot);
623: else
624: l_enabled := false;
625: end if;

Line 622: nvl(l_branch_info.end_date_active, hr_api.g_eot);

618: l_enabled :=
619: nvl(upper(l_branch_info.enabled_flag), 'Y') = 'Y' and
620: p_effective_date between
621: nvl(l_branch_info.start_date_active, hr_api.g_sot) and
622: nvl(l_branch_info.end_date_active, hr_api.g_eot);
623: else
624: l_enabled := false;
625: end if;
626: close csr_branch_info;