APPS.QA_SS_RESULTS dependencies on DBMS_SQL

Line 1820: parent_plan_ids dbms_sql.number_table;

1816: l_esig_status VARCHAR(20);
1817: l_par_esig_status VARCHAR(20);
1818: l_ancestors_exists VARCHAR(1);
1819: i NUMBER;
1820: parent_plan_ids dbms_sql.number_table;
1821: parent_collection_ids dbms_sql.number_table;
1822: parent_occurrences dbms_sql.number_table;
1823:
1824: BEGIN

Line 1821: parent_collection_ids dbms_sql.number_table;

1817: l_par_esig_status VARCHAR(20);
1818: l_ancestors_exists VARCHAR(1);
1819: i NUMBER;
1820: parent_plan_ids dbms_sql.number_table;
1821: parent_collection_ids dbms_sql.number_table;
1822: parent_occurrences dbms_sql.number_table;
1823:
1824: BEGIN
1825:

Line 1822: parent_occurrences dbms_sql.number_table;

1818: l_ancestors_exists VARCHAR(1);
1819: i NUMBER;
1820: parent_plan_ids dbms_sql.number_table;
1821: parent_collection_ids dbms_sql.number_table;
1822: parent_occurrences dbms_sql.number_table;
1823:
1824: BEGIN
1825:
1826: l_eres_profile := fnd_profile.value('EDR_ERES_ENABLED');

Line 1900: parent_plan_ids dbms_sql.number_table;

1896: l_esig_status VARCHAR(20);
1897: l_par_esig_status VARCHAR(20);
1898: l_ancestors_exists VARCHAR(1);
1899: i NUMBER;
1900: parent_plan_ids dbms_sql.number_table;
1901: parent_collection_ids dbms_sql.number_table;
1902: parent_occurrences dbms_sql.number_table;
1903:
1904: BEGIN

Line 1901: parent_collection_ids dbms_sql.number_table;

1897: l_par_esig_status VARCHAR(20);
1898: l_ancestors_exists VARCHAR(1);
1899: i NUMBER;
1900: parent_plan_ids dbms_sql.number_table;
1901: parent_collection_ids dbms_sql.number_table;
1902: parent_occurrences dbms_sql.number_table;
1903:
1904: BEGIN
1905:

Line 1902: parent_occurrences dbms_sql.number_table;

1898: l_ancestors_exists VARCHAR(1);
1899: i NUMBER;
1900: parent_plan_ids dbms_sql.number_table;
1901: parent_collection_ids dbms_sql.number_table;
1902: parent_occurrences dbms_sql.number_table;
1903:
1904: BEGIN
1905:
1906: l_eres_profile := FND_PROFILE.VALUE('EDR_ERES_ENABLED');