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 PAY_BANK_BRANCHES

Line 1: package body pay_bank_branches_pkg as

1: package body pay_bank_branches_pkg as
2: /* $Header: pybbr01t.pkb 115.10 2004/08/20 10:50:23 arashid noship $ */
3: g_gb_sort_code_len number := 6; -- GB sort code length.
4: g_gb_accno_len number := 8; -- GB account number length.
5: -------------------------< CHK_PRIMARY_KEY_ARGS >--------------------------

Line 81: insert into pay_bank_branches

77: fnd_message.set_token('COLUMN', 'P_ENABLED_FLAG');
78: fnd_message.raise_error;
79: end if;
80:
81: insert into pay_bank_branches
82: (branch_code
83: ,legislation_code
84: ,bank_code
85: ,branch

Line 119: from pay_bank_branches

115: ,p_legislation_code in varchar2
116: ) is
117: cursor c1 is
118: select *
119: from pay_bank_branches
120: where legislation_code = p_legislation_code
121: and branch_code = p_branch_code
122: for update nowait
123: ;

Line 129: hr_utility.set_location('Entering:pay_bank_branches.lock_row', 0);

125: row1 c1%rowtype;
126: l_debug boolean := hr_utility.debug_enabled;
127: begin
128: if l_debug then
129: hr_utility.set_location('Entering:pay_bank_branches.lock_row', 0);
130: end if;
131: --
132: chk_primary_key_args
133: (p_legislation_code => p_legislation_code

Line 141: hr_utility.set_location('Leaving:pay_bank_branches.lock_row', 10);

137: open c1;
138: fetch c1 into row1;
139: if c1%notfound then
140: if l_debug then
141: hr_utility.set_location('Leaving:pay_bank_branches.lock_row', 10);
142: end if;
143: --
144: close c1;
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

Line 151: hr_utility.set_location('Leaving:pay_bank_branches.lock_row', 20);

147: end if;
148: close c1;
149: --
150: if l_debug then
151: hr_utility.set_location('Leaving:pay_bank_branches.lock_row', 20);
152: end if;
153: end lock_row;
154: ------------------------------< UPDATE_ROW >-------------------------------
155: procedure update_row

Line 170: l_legislation_code pay_bank_branches.legislation_code%type;

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;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;

Line 171: l_branch_code pay_bank_branches.branch_code%type;

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;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;

Line 172: l_bank_code pay_bank_branches.bank_code%type;

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;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;

Line 173: l_branch pay_bank_branches.branch%type;

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;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;

Line 174: l_long_branch pay_bank_branches.long_branch%type;

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;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;

Line 175: l_extra_information1 pay_bank_branches.extra_information1%type;

171: l_branch_code pay_bank_branches.branch_code%type;
172: l_bank_code pay_bank_branches.bank_code%type;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;

Line 176: l_extra_information2 pay_bank_branches.extra_information2%type;

172: l_bank_code pay_bank_branches.bank_code%type;
173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;

Line 177: l_extra_information3 pay_bank_branches.extra_information3%type;

173: l_branch pay_bank_branches.branch%type;
174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;

Line 178: l_extra_information4 pay_bank_branches.extra_information4%type;

174: l_long_branch pay_bank_branches.long_branch%type;
175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;
182: l_end_date_active pay_bank_branches.end_date_active%type;

Line 179: l_extra_information5 pay_bank_branches.extra_information5%type;

175: l_extra_information1 pay_bank_branches.extra_information1%type;
176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;
182: l_end_date_active pay_bank_branches.end_date_active%type;
183: l_debug boolean := hr_utility.debug_enabled;

Line 180: l_enabled_flag pay_bank_branches.enabled_flag%type;

176: l_extra_information2 pay_bank_branches.extra_information2%type;
177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;
182: l_end_date_active pay_bank_branches.end_date_active%type;
183: l_debug boolean := hr_utility.debug_enabled;
184: cursor c1 is

Line 181: l_start_date_active pay_bank_branches.start_date_active%type;

177: l_extra_information3 pay_bank_branches.extra_information3%type;
178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;
182: l_end_date_active pay_bank_branches.end_date_active%type;
183: l_debug boolean := hr_utility.debug_enabled;
184: cursor c1 is
185: select legislation_code

Line 182: l_end_date_active pay_bank_branches.end_date_active%type;

178: l_extra_information4 pay_bank_branches.extra_information4%type;
179: l_extra_information5 pay_bank_branches.extra_information5%type;
180: l_enabled_flag pay_bank_branches.enabled_flag%type;
181: l_start_date_active pay_bank_branches.start_date_active%type;
182: l_end_date_active pay_bank_branches.end_date_active%type;
183: l_debug boolean := hr_utility.debug_enabled;
184: cursor c1 is
185: select legislation_code
186: , branch_code

Line 198: from pay_bank_branches

194: , extra_information5
195: , enabled_flag
196: , start_date_active
197: , end_date_active
198: from pay_bank_branches
199: where branch_code = p_branch_code
200: and legislation_code = p_legislation_code
201: ;
202: --

Line 218: hr_utility.set_location('Entering:pay_bank_branches.update_row', 0);

214: end if;
215: end conv;
216: begin
217: if l_debug then
218: hr_utility.set_location('Entering:pay_bank_branches.update_row', 0);
219: end if;
220: --
221: chk_primary_key_args
222: (p_legislation_code => p_legislation_code

Line 244: hr_utility.set_location('Leaving:pay_bank_branches.update_row', 10);

240: , l_end_date_active
241: ;
242: if c1%notfound then
243: if l_debug then
244: hr_utility.set_location('Leaving:pay_bank_branches.update_row', 10);
245: end if;
246: --
247: close c1;
248: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

Line 282: update pay_bank_branches

278: fnd_message.set_token('COLUMN', 'P_ENABLED_FLAG');
279: fnd_message.raise_error;
280: end if;
281:
282: update pay_bank_branches
283: set bank_code = l_bank_code
284: , branch = l_branch
285: , long_branch = l_long_branch
286: , extra_information1 = l_extra_information1

Line 299: hr_utility.set_location('Leaving:pay_bank_branches.update_row', 20);

295: and legislation_code = l_legislation_code
296: ;
297: --
298: if l_debug then
299: hr_utility.set_location('Leaving:pay_bank_branches.update_row', 20);
300: end if;
301: end update_row;
302: ------------------------------< DELETE_ROW >-------------------------------
303: procedure delete_row

Line 310: hr_utility.set_location('Entering:pay_bank_branches.delete_row', 0);

306: ) is
307: l_debug boolean := hr_utility.debug_enabled;
308: begin
309: if l_debug then
310: hr_utility.set_location('Entering:pay_bank_branches.delete_row', 0);
311: end if;
312: --
313: chk_primary_key_args
314: (p_legislation_code => p_legislation_code

Line 319: hr_utility.set_location('pay_bank_branches.delete_row', 10);

315: ,p_branch_code => p_branch_code
316: );
317: --
318: if l_debug then
319: hr_utility.set_location('pay_bank_branches.delete_row', 10);
320: end if;
321: --
322: delete
323: from pay_bank_branches

Line 323: from pay_bank_branches

319: hr_utility.set_location('pay_bank_branches.delete_row', 10);
320: end if;
321: --
322: delete
323: from pay_bank_branches
324: where legislation_code = p_legislation_code
325: and branch_code = p_branch_code
326: ;
327: --

Line 329: hr_utility.set_location('Leaving:pay_bank_branches.delete_row', 20);

325: and branch_code = p_branch_code
326: ;
327: --
328: if l_debug then
329: hr_utility.set_location('Leaving:pay_bank_branches.delete_row', 20);
330: end if;
331: end delete_row;
332: --------------------------< VALIDATE_GB_VALUES >--------------------------
333: --

Line 350: l_proc varchar2(100) := 'pay_bank_branches_pkg.validate_gb_values';

346: ) is
347: l_sort_code_len number := g_gb_sort_code_len;
348: l_branch_len number := 35;
349: l_bs_acct_len number := 18;
350: l_proc varchar2(100) := 'pay_bank_branches_pkg.validate_gb_values';
351: l_temp_string varchar2(100);
352: l_debug boolean := hr_utility.debug_enabled;
353: begin
354: if l_debug then

Line 459: l_branch pay_bank_branches.branch%type;

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;
460: --
461: cursor csr_existing_row(p_sort_code in varchar2) is
462: select branch
463: from pay_bank_branches

Line 463: from pay_bank_branches

459: l_branch pay_bank_branches.branch%type;
460: --
461: cursor csr_existing_row(p_sort_code in varchar2) is
462: select branch
463: from pay_bank_branches
464: where branch_code = p_sort_code
465: and legislation_code = 'GB'
466: ;
467: begin

Line 547: from pay_bank_branches pbb

543: , pbb.branch
544: , pbb.enabled_flag
545: , pbb.start_date_active
546: , pbb.end_date_active
547: from pay_bank_branches pbb
548: where pbb.legislation_code = 'GB'
549: and pbb.branch_code = p_sort_code
550: ;
551: --

Line 560: l_proc varchar2(64) := 'pay_bank_branches_pkg.display_to_gb_account';

556: l_branch_info csr_branch_info%rowtype;
557: l_accno varchar2(2000);
558: l_sort_code varchar2(2000);
559: l_temp_string varchar2(2000);
560: l_proc varchar2(64) := 'pay_bank_branches_pkg.display_to_gb_account';
561: begin
562: if l_debug then
563: hr_utility.set_location('Entering:' || l_proc, 0);
564: end if;

Line 696: end pay_bank_branches_pkg;

692: raise;
693: end if;
694: end display_to_gb_account;
695: --
696: end pay_bank_branches_pkg;