[Home] [Help]
297: cursor csr_curr_prenote_date
298: (p_external_account_id in number
299: ) is
300: select exa.prenote_date
301: from pay_external_accounts exa
302: where exa.external_account_id = p_external_account_id
303: ;
304: begin
305: if g_debug then
420: --
421: -- {Start Of Comments}
422: --
423: -- Description:
424: -- This procedure is used to update the prenote date in pay_external_accounts
425: -- with the value provided by the user. However the prenote date is updated
426: -- only if prenoting is allowed for the payroll(ie. prl_information3 = 'Y').
427: --
428: -- Prerequisites:
456: ,p_prenote_date in date
457: ) is
458: --
459: l_proc varchar2(72) := 'upd_prenote_date';
460: l_exa_ovn pay_external_accounts.object_version_number%type;
461: l_prenote_allowed pay_all_payrolls_f.prl_information3%type;
462: --
463: cursor csr_payroll_details(p_personal_payment_method_id in number
464: ,p_effective_date in date
478: pap.effective_start_date and pap.effective_end_date;
479: --
480: cursor csr_exa_ovn(p_external_account_id in number) is
481: select pea.object_version_number
482: from pay_external_accounts pea
483: where pea.external_account_id = p_external_account_id;
484: --
485: begin
486: --
1905: l_validate boolean := FALSE;
1906: l_external_account_id
1907: pay_personal_payment_methods_f.external_account_id%TYPE;
1908: l_object_version_number
1909: pay_external_accounts.object_version_number%TYPE;
1910: l_exa_ovn number;
1911: l_effective_date date;
1912: l_ppm_information_category pay_personal_payment_methods_f.ppm_information_category%TYPE;
1913: --
1933: --
1934: cursor ovnsel is
1935: select pea.object_version_number
1936: , pea.territory_code
1937: from pay_external_accounts pea
1938: where pea.external_account_id = l_external_account_id;
1939: --
1940: cursor csr_chk_pay_type is
1941: select pyt.category