DBA Data[Home] [Help]

APPS.QA_SS_RESULTS dependencies on QA_ERES_UTIL

Line 1834: l_esig_status := qa_eres_util.is_esig_status_pending(

1830: END IF;
1831:
1832:
1833: -- check if eSig Status is pending for current plan
1834: l_esig_status := qa_eres_util.is_esig_status_pending(
1835: p_plan_id => p_plan_id ,
1836: p_collection_id => p_plan_collection_id,
1837: p_occurrence => p_plan_occurrence);
1838:

Line 1867: l_par_esig_status := qa_eres_util.is_esig_status_pending(

1863: -- if not, we need to check esig Status for all ancestors
1864: i := parent_occurrences.FIRST;
1865: l_par_esig_status := 'F';
1866: WHILE i IS NOT NULL LOOP
1867: l_par_esig_status := qa_eres_util.is_esig_status_pending(
1868: p_plan_id => parent_plan_ids(i) ,
1869: p_collection_id => parent_collection_ids(i),
1870: p_occurrence => parent_occurrences(i));
1871: EXIT WHEN l_par_esig_status = 'T';

Line 1919: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => p_plan_id ,

1915: -- is pending but not when eSig Status is pending
1916: -- for the parnet plan
1917:
1918: l_esig_status :=
1919: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => p_plan_id ,
1920: p_collection_id => p_plan_collection_id,
1921: p_occurrence => p_plan_occurrence);
1922:
1923:

Line 1955: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => parent_plan_ids(i) ,

1951: l_par_esig_status := 'F';
1952: WHILE i IS NOT NULL
1953: LOOP
1954: l_par_esig_status :=
1955: QA_ERES_UTIL.is_esig_status_pending(p_plan_id => parent_plan_ids(i) ,
1956: p_collection_id => parent_collection_ids(i),
1957: p_occurrence => parent_occurrences(i));
1958: EXIT WHEN l_par_esig_status = 'T';
1959: i := parent_occurrences.NEXT(i);