APPS.SSP_MAT_BUS dependencies on SSP_SMP_PKG

Line 378: p_element_details out nocopy ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE

374: PROCEDURE get_SMP_element_details
375: (
376: p_effective_date in date,
377: p_element_name in varchar2,
378: p_element_details out nocopy ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE
379: ) is
380:
381: l_proc varchar2(72) := g_package||'get_SMP_element_details';
382:

Line 385: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date, p_element_name);

381: l_proc varchar2(72) := g_package||'get_SMP_element_details';
382:
383: begin
384:
385: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date, p_element_name);
386: fetch ssp_SMP_pkg.csr_SMP_element_details into p_element_details;
387: close ssp_SMP_pkg.csr_SMP_element_details;
388:
389: end get_SMP_element_details;

Line 386: fetch ssp_SMP_pkg.csr_SMP_element_details into p_element_details;

382:
383: begin
384:
385: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date, p_element_name);
386: fetch ssp_SMP_pkg.csr_SMP_element_details into p_element_details;
387: close ssp_SMP_pkg.csr_SMP_element_details;
388:
389: end get_SMP_element_details;
390: --

Line 387: close ssp_SMP_pkg.csr_SMP_element_details;

383: begin
384:
385: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date, p_element_name);
386: fetch ssp_SMP_pkg.csr_SMP_element_details into p_element_details;
387: close ssp_SMP_pkg.csr_SMP_element_details;
388:
389: end get_SMP_element_details;
390: --
391: -- -----------------------------------------------------------------------------

Line 406: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;

402: p_effective_date in date,
403: p_element_name in varchar2)
404: return boolean is
405: --
406: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;
407: l_late_evidence BOOLEAN;
408: l_chk_date DATE;
409: cursor c1 is
410: select m.mpp_start_date

Line 446: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;

442: p_qualifying_week in date,
443: p_ewc in date,
444: p_maternity_id in number
445: ) is
446: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;
447: l_chk_date date;
448: l_proc varchar2(72) := g_package||'evd_before_ewc_due_date_change';
449:
450: cursor csr_evidence is

Line 482: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;

478: (p_ewc in date,
479: p_evidence_date in date,
480: p_effective_date in date,
481: p_element_name in varchar2) is
482: l_element_details ssp_SMP_pkg.csr_SMP_element_details%ROWTYPE;
483: l_chk_date DATE;
484: BEGIN
485: get_SMP_element_details(p_effective_date, p_element_name, l_element_details);
486: --

Line 731: l_end_date := least(ssp_smp_pkg.get_max_SMP_date(p_rec.maternity_id), nvl(l_get_ma_end_date,to_date('31-12-4712','DD-MM-YYYY')));

727: fetch c_get_ma_end_date into l_get_ma_end_date;
728: close c_get_ma_end_date;
729: -- end;
730:
731: l_end_date := least(ssp_smp_pkg.get_max_SMP_date(p_rec.maternity_id), nvl(l_get_ma_end_date,to_date('31-12-4712','DD-MM-YYYY')));
732:
733: else -- type = 'AD'
734: l_end_date := ssp_sap_pkg.get_max_SAP_date(p_rec.maternity_id);
735: end if;

Line 784: l_earliest_mpp_start := ssp_SMP_pkg.earliest_mpp_start_date (p_rec.due_date);

780: --
781: check_date_notified (p_rec.notification_of_birth_date,
782: p_rec.actual_birth_date);
783: --
784: l_earliest_mpp_start := ssp_SMP_pkg.earliest_mpp_start_date (p_rec.due_date);
785: --
786: check_stated_ret_date (p_rec.stated_return_date,
787: p_rec.intend_to_return_flag,
788: p_rec.mpp_start_date,

Line 841: l_earliest_mpp_start := ssp_SMP_pkg.earliest_mpp_start_date (p_rec.due_date);

837: default_mpp_date (p_rec.actual_birth_date, p_rec.mpp_start_date);
838: --
839: check_date_notified (p_rec.notification_of_birth_date, p_rec.actual_birth_date);
840: --
841: l_earliest_mpp_start := ssp_SMP_pkg.earliest_mpp_start_date (p_rec.due_date);
842: check_stated_ret_date (p_rec.stated_return_date, p_rec.intend_to_return_flag,
843: p_rec.mpp_start_date, l_earliest_mpp_start);
844: --
845: if p_rec.start_date_maternity_allowance is not null then