DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on DBMS_SQL

Line 575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

571: -----------------------------------------------------------------
572: -- Get Process Entity Table Definitions --
573: -----------------------------------------------------------------
574: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

Line 576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

572: -- Get Process Entity Table Definitions --
573: -----------------------------------------------------------------
574: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

Line 577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

573: -----------------------------------------------------------------
574: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
581: )

Line 578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

574: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
581: )
582: IS

Line 579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

575: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
581: )
582: IS
583: I PLS_INTEGER ;

Line 580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

576: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
578: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
579: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
580: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
581: )
582: IS
583: I PLS_INTEGER ;
584:

Line 1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

1062: --------------------------------------------
1063: l_dyn_sql VARCHAR2(10000);
1064:
1065: I PLS_INTEGER ;
1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

1063: l_dyn_sql VARCHAR2(10000);
1064:
1065: I PLS_INTEGER ;
1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

1064:
1065: I PLS_INTEGER ;
1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1072:

Line 1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

1065: I PLS_INTEGER ;
1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1072:
1073: l_error_msg_text VARCHAR2(2000) ;

Line 1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

1066: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1072:
1073: l_error_msg_text VARCHAR2(2000) ;
1074: l_error_msg_name VARCHAR2(30) ;

Line 1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

1067: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1068: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1069: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1070: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1071: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1072:
1073: l_error_msg_text VARCHAR2(2000) ;
1074: l_error_msg_name VARCHAR2(30) ;
1075:

Line 2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

2794: -- Long Dynamic SQL String
2795: --------------------------------------------
2796: l_dyn_sql VARCHAR2(10000);
2797:
2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

2795: --------------------------------------------
2796: l_dyn_sql VARCHAR2(10000);
2797:
2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

2796: l_dyn_sql VARCHAR2(10000);
2797:
2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2804:

Line 2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

2797:
2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2804:
2805: l_error_msg VARCHAR2(2000) ;

Line 2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

2798: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2804:
2805: l_error_msg VARCHAR2(2000) ;
2806:

Line 2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

2799: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2800: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2801: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2802: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2803: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2804:
2805: l_error_msg VARCHAR2(2000) ;
2806:
2807: -- add for bug 13004839

Line 3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

3271: --------------------------------------------
3272: l_dyn_sql VARCHAR2(32000);
3273:
3274: I PLS_INTEGER ;
3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

3272: l_dyn_sql VARCHAR2(32000);
3273:
3274: I PLS_INTEGER ;
3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

3273:
3274: I PLS_INTEGER ;
3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3281:

Line 3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

3274: I PLS_INTEGER ;
3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3281:
3282: l_msg_data VARCHAR2(4000);

Line 3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

3275: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3281:
3282: l_msg_data VARCHAR2(4000);
3283: l_msg_count NUMBER;

Line 3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

3276: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3277: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3278: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3279: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3280: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3281:
3282: l_msg_data VARCHAR2(4000);
3283: l_msg_count NUMBER;
3284: l_return_status VARCHAR2(1);

Line 3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

3698: --------------------------------------------
3699: l_dyn_sql VARCHAR2(10000);
3700:
3701: I PLS_INTEGER ;
3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

3699: l_dyn_sql VARCHAR2(10000);
3700:
3701: I PLS_INTEGER ;
3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

3700:
3701: I PLS_INTEGER ;
3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3708:

Line 3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

3701: I PLS_INTEGER ;
3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3708:
3709: l_msg_data VARCHAR2(4000);

Line 3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

3702: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3708:
3709: l_msg_data VARCHAR2(4000);
3710: l_msg_count NUMBER;

Line 3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

3703: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3704: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3705: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3706: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3707: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3708:
3709: l_msg_data VARCHAR2(4000);
3710: l_msg_count NUMBER;
3711: l_return_status VARCHAR2(1);

Line 6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

6079: l_cm_import_option VARCHAR2(30) ;
6080: l_dyn_sql VARCHAR2(10000);
6081:
6082: I PLS_INTEGER ;
6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

6080: l_dyn_sql VARCHAR2(10000);
6081:
6082: I PLS_INTEGER ;
6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

6081:
6082: I PLS_INTEGER ;
6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
6089: l_dummy NUMBER := 0;

Line 6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

6082: I PLS_INTEGER ;
6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
6089: l_dummy NUMBER := 0;
6090: l_exist NUMBER := 2;

Line 6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

6083: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
6089: l_dummy NUMBER := 0;
6090: l_exist NUMBER := 2;
6091:

Line 6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

6084: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
6085: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
6086: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
6087: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
6088: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
6089: l_dummy NUMBER := 0;
6090: l_exist NUMBER := 2;
6091:
6092: BEGIN