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
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
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: )
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
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 ;
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:
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;
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;
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:
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) ;
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) ;
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:
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;
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;
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:
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) ;
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:
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
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;
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;
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:
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);
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;
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);
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;
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;
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:
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);
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;
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);
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;
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;
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;
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;
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:
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