APPS.PAY_EXA_INS dependencies on PAY_EXTERNAL_ACCOUNTS

Line 90: UPDATE PAY_EXTERNAL_ACCOUNTS

86: --
87: if ( pay_exa_shd.g_old_rec.territory_code is null ) then
88: hr_utility.trace('| updating territory_code');
89: --
90: UPDATE PAY_EXTERNAL_ACCOUNTS
91: SET territory_code = p_rec.territory_code
92: WHERE external_account_id = p_rec.external_account_id
93: ;
94: end if;

Line 113: UPDATE PAY_EXTERNAL_ACCOUNTS

109: elsif ( nvl(p_rec.prenote_date, hr_api.g_date) <>
110: nvl(pay_exa_shd.g_old_rec.prenote_date, hr_api.g_date) ) then
111: hr_utility.trace('| updating prenote_date');
112: --
113: UPDATE PAY_EXTERNAL_ACCOUNTS
114: SET prenote_date = p_rec.prenote_date
115: WHERE external_account_id = p_rec.external_account_id
116: ;
117: end if;

Line 121: UPDATE PAY_EXTERNAL_ACCOUNTS

117: end if;
118: --
119: -- U has occurred, increment object version number
120: --
121: UPDATE PAY_EXTERNAL_ACCOUNTS
122: SET object_version_number = nvl(object_version_number, 0) + 1
123: WHERE external_account_id = p_rec.external_account_id
124: ;
125: end if;

Line 352: FROM PAY_EXTERNAL_ACCOUNTS pea

348: l_proc varchar2(72) := g_package||'ins';
349: --
350: cursor csr_ovn(p_external_account_id number) is
351: SELECT pea.object_version_number
352: FROM PAY_EXTERNAL_ACCOUNTS pea
353: WHERE pea.external_account_id = p_external_account_id
354: ;
355: --
356: begin

Line 474: l_external_account_id pay_external_accounts.external_account_id%type;

470: ,p_object_version_number out nocopy number
471: ,p_validate in boolean default false
472: ) is
473: --
474: l_external_account_id pay_external_accounts.external_account_id%type;
475: l_proc varchar2(72) := g_package||'ins_or_sel';
476: l_object_version_number pay_external_accounts.object_version_number%type;
477: l_prenote_date pay_external_accounts.prenote_date%type;
478: --

Line 476: l_object_version_number pay_external_accounts.object_version_number%type;

472: ) is
473: --
474: l_external_account_id pay_external_accounts.external_account_id%type;
475: l_proc varchar2(72) := g_package||'ins_or_sel';
476: l_object_version_number pay_external_accounts.object_version_number%type;
477: l_prenote_date pay_external_accounts.prenote_date%type;
478: --
479: l_concat_segments_out varchar2(4600);
480: --

Line 477: l_prenote_date pay_external_accounts.prenote_date%type;

473: --
474: l_external_account_id pay_external_accounts.external_account_id%type;
475: l_proc varchar2(72) := g_package||'ins_or_sel';
476: l_object_version_number pay_external_accounts.object_version_number%type;
477: l_prenote_date pay_external_accounts.prenote_date%type;
478: --
479: l_concat_segments_out varchar2(4600);
480: --
481: begin