APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on DBMS_SQL

Line 583: l_lang_table DBMS_SQL.VARCHAR2_TABLE;

579: )
580: IS
581: l_err_loc PLS_INTEGER;
582:
583: l_lang_table DBMS_SQL.VARCHAR2_TABLE;
584:
585: CURSOR translate_category_lang_csr
586: IS
587: SELECT language

Line 669: l_child_cat_table DBMS_SQL.NUMBER_TABLE;

665: )
666: IS
667: l_err_loc PLS_INTEGER;
668:
669: l_child_cat_table DBMS_SQL.NUMBER_TABLE;
670: l_child_cat_type_table DBMS_SQL.VARCHAR2_TABLE;
671: l_parent_cat_count_table DBMS_SQL.NUMBER_TABLE;
672:
673: CURSOR category_children_csr

Line 670: l_child_cat_type_table DBMS_SQL.VARCHAR2_TABLE;

666: IS
667: l_err_loc PLS_INTEGER;
668:
669: l_child_cat_table DBMS_SQL.NUMBER_TABLE;
670: l_child_cat_type_table DBMS_SQL.VARCHAR2_TABLE;
671: l_parent_cat_count_table DBMS_SQL.NUMBER_TABLE;
672:
673: CURSOR category_children_csr
674: IS

Line 671: l_parent_cat_count_table DBMS_SQL.NUMBER_TABLE;

667: l_err_loc PLS_INTEGER;
668:
669: l_child_cat_table DBMS_SQL.NUMBER_TABLE;
670: l_child_cat_type_table DBMS_SQL.VARCHAR2_TABLE;
671: l_parent_cat_count_table DBMS_SQL.NUMBER_TABLE;
672:
673: CURSOR category_children_csr
674: IS
675: SELECT browse.child_category_id, cat.type, count(*)

Line 2934: l_job_number_tbl DBMS_SQL.NUMBER_TABLE;

2930: IS
2931: l_err_loc PLS_INTEGER;
2932: l_number_of_days NUMBER;
2933: l_commit_size NUMBER;
2934: l_job_number_tbl DBMS_SQL.NUMBER_TABLE;
2935: l_continue BOOLEAN := TRUE;
2936: BEGIN
2937:
2938: l_err_loc := 100;