eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on DBMS_SQL

Line 571: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

567: -----------------------------------------------------------------
568: -- Get Process Entity Table Definitions --
569: -----------------------------------------------------------------
570: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
571: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

Line 572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

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

Line 573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

569: -----------------------------------------------------------------
570: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
571: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: )

Line 574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

570: PROCEDURE Get_Process_IntfTable_Def ( p_process_entity IN VARCHAR2 := NULL
571: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: )
578: IS

Line 575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

571: , x_intf_table IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: )
578: IS
579: I PLS_INTEGER ;

Line 576: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE

572: , x_intf_batch_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
573: , x_intf_proc_flag_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
574: , x_intf_ri_seq_id_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
575: , x_intf_attr_grp_type IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
576: , x_intf_chg_notice_col IN OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE
577: )
578: IS
579: I PLS_INTEGER ;
580:

Line 1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

1058: --------------------------------------------
1059: l_dyn_sql VARCHAR2(10000);
1060:
1061: I PLS_INTEGER ;
1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

1059: l_dyn_sql VARCHAR2(10000);
1060:
1061: I PLS_INTEGER ;
1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

1060:
1061: I PLS_INTEGER ;
1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1068:

Line 1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

1061: I PLS_INTEGER ;
1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1068:
1069: l_error_msg_text VARCHAR2(2000) ;

Line 1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

1062: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1068:
1069: l_error_msg_text VARCHAR2(2000) ;
1070: l_error_msg_name VARCHAR2(30) ;

Line 1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

1063: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
1064: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
1065: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
1066: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
1067: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
1068:
1069: l_error_msg_text VARCHAR2(2000) ;
1070: l_error_msg_name VARCHAR2(30) ;
1071:

Line 2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

2790: -- Long Dynamic SQL String
2791: --------------------------------------------
2792: l_dyn_sql VARCHAR2(10000);
2793:
2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

2791: --------------------------------------------
2792: l_dyn_sql VARCHAR2(10000);
2793:
2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

2792: l_dyn_sql VARCHAR2(10000);
2793:
2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2800:

Line 2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

2793:
2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2800:
2801: l_error_msg VARCHAR2(2000) ;

Line 2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

2794: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2800:
2801: l_error_msg VARCHAR2(2000) ;
2802:

Line 2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

2795: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
2796: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
2797: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
2798: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
2799: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
2800:
2801: l_error_msg VARCHAR2(2000) ;
2802:
2803: BEGIN

Line 3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

3165: --------------------------------------------
3166: l_dyn_sql VARCHAR2(32000);
3167:
3168: I PLS_INTEGER ;
3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

3166: l_dyn_sql VARCHAR2(32000);
3167:
3168: I PLS_INTEGER ;
3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

3167:
3168: I PLS_INTEGER ;
3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3175:

Line 3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

3168: I PLS_INTEGER ;
3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3175:
3176: l_msg_data VARCHAR2(4000);

Line 3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

3169: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3175:
3176: l_msg_data VARCHAR2(4000);
3177: l_msg_count NUMBER;

Line 3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

3170: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3171: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3172: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3173: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3174: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3175:
3176: l_msg_data VARCHAR2(4000);
3177: l_msg_count NUMBER;
3178: l_return_status VARCHAR2(1);

Line 3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;

3592: --------------------------------------------
3593: l_dyn_sql VARCHAR2(10000);
3594:
3595: I PLS_INTEGER ;
3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

Line 3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;

3593: l_dyn_sql VARCHAR2(10000);
3594:
3595: I PLS_INTEGER ;
3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

Line 3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;

3594:
3595: I PLS_INTEGER ;
3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3602:

Line 3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;

3595: I PLS_INTEGER ;
3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3602:
3603: l_msg_data VARCHAR2(4000);

Line 3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;

3596: l_intf_table DBMS_SQL.VARCHAR2_TABLE;
3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3602:
3603: l_msg_data VARCHAR2(4000);
3604: l_msg_count NUMBER;

Line 3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;

3597: l_intf_batch_id_col DBMS_SQL.VARCHAR2_TABLE;
3598: l_intf_proc_flag_col DBMS_SQL.VARCHAR2_TABLE;
3599: l_intf_ri_seq_id_col DBMS_SQL.VARCHAR2_TABLE;
3600: l_intf_attr_grp_type DBMS_SQL.VARCHAR2_TABLE;
3601: l_intf_change_number_col DBMS_SQL.VARCHAR2_TABLE;
3602:
3603: l_msg_data VARCHAR2(4000);
3604: l_msg_count NUMBER;
3605: l_return_status VARCHAR2(1);