APPS.PAY_EXA_UPD dependencies on PAY_EXTERNAL_ACCOUNTS

Line 88: UPDATE PAY_EXTERNAL_ACCOUNTS

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

Line 111: UPDATE PAY_EXTERNAL_ACCOUNTS

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

Line 119: UPDATE PAY_EXTERNAL_ACCOUNTS

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

Line 494: FROM PAY_EXTERNAL_ACCOUNTS pea

490: l_proc varchar2(72) := g_package||'upd';
491: --
492: cursor csr_ovn(p_external_account_id number) is
493: SELECT pea.object_version_number
494: FROM PAY_EXTERNAL_ACCOUNTS pea
495: WHERE pea.external_account_id = p_external_account_id
496: ;
497: --
498: begin

Line 610: l_external_account_id_init pay_external_accounts.external_account_id%type;

606: --
607: l_proc varchar2(72) := g_package||'upd_or_sel';
608: l_rec pay_exa_shd.g_rec_type;
609: l_concat_segments_out varchar2(4600);
610: l_external_account_id_init pay_external_accounts.external_account_id%type;
611: l_prenote_date pay_external_accounts.prenote_date%type;
612: l_object_version_number_init pay_external_accounts.object_version_number%type;
613: --
614: begin

Line 611: l_prenote_date pay_external_accounts.prenote_date%type;

607: l_proc varchar2(72) := g_package||'upd_or_sel';
608: l_rec pay_exa_shd.g_rec_type;
609: l_concat_segments_out varchar2(4600);
610: l_external_account_id_init pay_external_accounts.external_account_id%type;
611: l_prenote_date pay_external_accounts.prenote_date%type;
612: l_object_version_number_init pay_external_accounts.object_version_number%type;
613: --
614: begin
615: hr_utility.set_location('***** Entering:' || l_proc || ' *****', 5);

Line 612: l_object_version_number_init pay_external_accounts.object_version_number%type;

608: l_rec pay_exa_shd.g_rec_type;
609: l_concat_segments_out varchar2(4600);
610: l_external_account_id_init pay_external_accounts.external_account_id%type;
611: l_prenote_date pay_external_accounts.prenote_date%type;
612: l_object_version_number_init pay_external_accounts.object_version_number%type;
613: --
614: begin
615: hr_utility.set_location('***** Entering:' || l_proc || ' *****', 5);
616: --

Line 696: -- ie. a row in PAY_EXTERNAL_ACCOUNTS,

692: --
693:
694: --
695: -- ccid passed in must always point to a combination row,
696: -- ie. a row in PAY_EXTERNAL_ACCOUNTS,
697: --
698: -- if segments1 ... 30 are changed, then we may be I'ing a
699: -- new combination row or changing the ccid to point to an
700: -- existing row