1899: END IF;
1900:
1901:
1902: -- check if eSig Status is pending for current plan
1903: l_esig_status := qa_eres_util.is_esig_status_pending(
1904: p_plan_id => p_plan_id ,
1905: p_collection_id => p_plan_collection_id,
1906: p_occurrence => p_plan_occurrence);
1907:
1932: -- if not, we need to check esig Status for all ancestors
1933: i := parent_occurrences.FIRST;
1934: l_par_esig_status := 'F';
1935: WHILE i IS NOT NULL LOOP
1936: l_par_esig_status := qa_eres_util.is_esig_status_pending(
1937: p_plan_id => parent_plan_ids(i) ,
1938: p_collection_id => parent_collection_ids(i),
1939: p_occurrence => parent_occurrences(i));
1940: EXIT WHEN l_par_esig_status = 'T';
1984: -- is pending but not when eSig Status is pending
1985: -- for the parnet plan
1986:
1987: l_esig_status :=
1988: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => p_plan_id ,
1989: p_collection_id => p_plan_collection_id,
1990: p_occurrence => p_plan_occurrence);
1991:
1992:
2020: l_par_esig_status := 'F';
2021: WHILE i IS NOT NULL
2022: LOOP
2023: l_par_esig_status :=
2024: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => parent_plan_ids(i) ,
2025: p_collection_id => parent_collection_ids(i),
2026: p_occurrence => parent_occurrences(i));
2027: EXIT WHEN l_par_esig_status = 'T';
2028: i := parent_occurrences.NEXT(i);