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.EGO_PUB_WS_ICC dependencies on DBMS_SQL

Line 334: p_icc_id_tab IN OUT NOCOPY DBMS_SQL.number_table,

330: p_session_id NUMBER,
331: p_icc_id NUMBER,
332: p_icc_ver_id NUMBER,
333: p_icc_name VARCHAR2,
334: p_icc_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
335: p_icc_ver_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
336: p_icc_name_tab IN OUT NOCOPY DBMS_SQL.varchar2_table,
337: p_show_error_flag IN VARCHAR2,
338: p_user_entered_flag IN VARCHAR2

Line 335: p_icc_ver_id_tab IN OUT NOCOPY DBMS_SQL.number_table,

331: p_icc_id NUMBER,
332: p_icc_ver_id NUMBER,
333: p_icc_name VARCHAR2,
334: p_icc_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
335: p_icc_ver_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
336: p_icc_name_tab IN OUT NOCOPY DBMS_SQL.varchar2_table,
337: p_show_error_flag IN VARCHAR2,
338: p_user_entered_flag IN VARCHAR2
339: )

Line 336: p_icc_name_tab IN OUT NOCOPY DBMS_SQL.varchar2_table,

332: p_icc_ver_id NUMBER,
333: p_icc_name VARCHAR2,
334: p_icc_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
335: p_icc_ver_id_tab IN OUT NOCOPY DBMS_SQL.number_table,
336: p_icc_name_tab IN OUT NOCOPY DBMS_SQL.varchar2_table,
337: p_show_error_flag IN VARCHAR2,
338: p_user_entered_flag IN VARCHAR2
339: )
340: IS

Line 1149: l_dup_icc_id_tab DBMS_SQL.varchar2_table;

1145:
1146: /*Netsed table of varchar2 to store ICCId's.
1147: It is a varchar2 table b'cos we have to handle '?' when icc_id null.
1148: SOAP UI tool passes null values as '?' */
1149: l_dup_icc_id_tab DBMS_SQL.varchar2_table;
1150: l_dup_icc_name_tab DBMS_SQL.varchar2_table;
1151: l_dup_icc_ver_id_tab DBMS_SQL.varchar2_table;
1152:
1153: /* The below tables are for storing validated and non-duplicate values.

Line 1150: l_dup_icc_name_tab DBMS_SQL.varchar2_table;

1146: /*Netsed table of varchar2 to store ICCId's.
1147: It is a varchar2 table b'cos we have to handle '?' when icc_id null.
1148: SOAP UI tool passes null values as '?' */
1149: l_dup_icc_id_tab DBMS_SQL.varchar2_table;
1150: l_dup_icc_name_tab DBMS_SQL.varchar2_table;
1151: l_dup_icc_ver_id_tab DBMS_SQL.varchar2_table;
1152:
1153: /* The below tables are for storing validated and non-duplicate values.
1154: Note that we are using number tables for icc_id, icc_ver_id */

Line 1151: l_dup_icc_ver_id_tab DBMS_SQL.varchar2_table;

1147: It is a varchar2 table b'cos we have to handle '?' when icc_id null.
1148: SOAP UI tool passes null values as '?' */
1149: l_dup_icc_id_tab DBMS_SQL.varchar2_table;
1150: l_dup_icc_name_tab DBMS_SQL.varchar2_table;
1151: l_dup_icc_ver_id_tab DBMS_SQL.varchar2_table;
1152:
1153: /* The below tables are for storing validated and non-duplicate values.
1154: Note that we are using number tables for icc_id, icc_ver_id */
1155: l_icc_id_tab DBMS_SQL.number_table;

Line 1155: l_icc_id_tab DBMS_SQL.number_table;

1151: l_dup_icc_ver_id_tab DBMS_SQL.varchar2_table;
1152:
1153: /* The below tables are for storing validated and non-duplicate values.
1154: Note that we are using number tables for icc_id, icc_ver_id */
1155: l_icc_id_tab DBMS_SQL.number_table;
1156: l_icc_name_tab DBMS_SQL.varchar2_table;
1157: l_icc_ver_id_tab DBMS_SQL.number_table;
1158:
1159: l_is_duplicate BOOLEAN := FALSE;

Line 1156: l_icc_name_tab DBMS_SQL.varchar2_table;

1152:
1153: /* The below tables are for storing validated and non-duplicate values.
1154: Note that we are using number tables for icc_id, icc_ver_id */
1155: l_icc_id_tab DBMS_SQL.number_table;
1156: l_icc_name_tab DBMS_SQL.varchar2_table;
1157: l_icc_ver_id_tab DBMS_SQL.number_table;
1158:
1159: l_is_duplicate BOOLEAN := FALSE;
1160: l_is_valid BOOLEAN;

Line 1157: l_icc_ver_id_tab DBMS_SQL.number_table;

1153: /* The below tables are for storing validated and non-duplicate values.
1154: Note that we are using number tables for icc_id, icc_ver_id */
1155: l_icc_id_tab DBMS_SQL.number_table;
1156: l_icc_name_tab DBMS_SQL.varchar2_table;
1157: l_icc_ver_id_tab DBMS_SQL.number_table;
1158:
1159: l_is_duplicate BOOLEAN := FALSE;
1160: l_is_valid BOOLEAN;
1161: