APPS.QA_SS_RESULTS dependencies on DBMS_SQL

Line 1889: parent_plan_ids dbms_sql.number_table;

1885: l_esig_status VARCHAR(20);
1886: l_par_esig_status VARCHAR(20);
1887: l_ancestors_exists VARCHAR(1);
1888: i NUMBER;
1889: parent_plan_ids dbms_sql.number_table;
1890: parent_collection_ids dbms_sql.number_table;
1891: parent_occurrences dbms_sql.number_table;
1892:
1893: BEGIN

Line 1890: parent_collection_ids dbms_sql.number_table;

1886: l_par_esig_status VARCHAR(20);
1887: l_ancestors_exists VARCHAR(1);
1888: i NUMBER;
1889: parent_plan_ids dbms_sql.number_table;
1890: parent_collection_ids dbms_sql.number_table;
1891: parent_occurrences dbms_sql.number_table;
1892:
1893: BEGIN
1894:

Line 1891: parent_occurrences dbms_sql.number_table;

1887: l_ancestors_exists VARCHAR(1);
1888: i NUMBER;
1889: parent_plan_ids dbms_sql.number_table;
1890: parent_collection_ids dbms_sql.number_table;
1891: parent_occurrences dbms_sql.number_table;
1892:
1893: BEGIN
1894:
1895: l_eres_profile := fnd_profile.value('EDR_ERES_ENABLED');

Line 1969: parent_plan_ids dbms_sql.number_table;

1965: l_esig_status VARCHAR(20);
1966: l_par_esig_status VARCHAR(20);
1967: l_ancestors_exists VARCHAR(1);
1968: i NUMBER;
1969: parent_plan_ids dbms_sql.number_table;
1970: parent_collection_ids dbms_sql.number_table;
1971: parent_occurrences dbms_sql.number_table;
1972:
1973: BEGIN

Line 1970: parent_collection_ids dbms_sql.number_table;

1966: l_par_esig_status VARCHAR(20);
1967: l_ancestors_exists VARCHAR(1);
1968: i NUMBER;
1969: parent_plan_ids dbms_sql.number_table;
1970: parent_collection_ids dbms_sql.number_table;
1971: parent_occurrences dbms_sql.number_table;
1972:
1973: BEGIN
1974:

Line 1971: parent_occurrences dbms_sql.number_table;

1967: l_ancestors_exists VARCHAR(1);
1968: i NUMBER;
1969: parent_plan_ids dbms_sql.number_table;
1970: parent_collection_ids dbms_sql.number_table;
1971: parent_occurrences dbms_sql.number_table;
1972:
1973: BEGIN
1974:
1975: l_eres_profile := FND_PROFILE.VALUE('EDR_ERES_ENABLED');