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

Line 371: g_non_ds_req_dimensions DBMS_SQL.varchar2_table;

367: body VARCHAR2(5000);
368: l_api_name CONSTANT VARCHAR2(30) := 'Execute_Event';
369:
370: g_non_ds_cnt NUMBER := -1;
371: g_non_ds_req_dimensions DBMS_SQL.varchar2_table;
372:
373: --- Bug Fix : 5707630, HRates Enhancemnent
374: l_hrate_select_cols VARCHAR2(2500);
375: l_hrate_view_select_cols VARCHAR2(2500);

Line 385: l_hrate_drm_dimensions DBMS_SQL.varchar2_table;

381: l_hr_dim_counter NUMBER := 0 ;
382: l_hrate_where_dim_clause VARCHAR2(2500);
383:
384: l_hrate_drm_cnt NUMBER := -1;
385: l_hrate_drm_dimensions DBMS_SQL.varchar2_table;
386:
387:
388: BEGIN
389:

Line 1177: l_attribute_id_list DBMS_SQL.varchar2_table;

1173: x_retcode OUT NOCOPY VARCHAR2,
1174: p_sequence_num IN NUMBER,
1175: p_dimension_varchar_label IN VARCHAR2) IS
1176:
1177: l_attribute_id_list DBMS_SQL.varchar2_table;
1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;

Line 1178: l_member_display_code_list DBMS_SQL.varchar2_table;

1174: p_sequence_num IN NUMBER,
1175: p_dimension_varchar_label IN VARCHAR2) IS
1176:
1177: l_attribute_id_list DBMS_SQL.varchar2_table;
1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;
1182: l_attr_varchar_list DBMS_SQL.varchar2_table;

Line 1179: l_member_b_table_list DBMS_SQL.varchar2_table;

1175: p_dimension_varchar_label IN VARCHAR2) IS
1176:
1177: l_attribute_id_list DBMS_SQL.varchar2_table;
1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;
1182: l_attr_varchar_list DBMS_SQL.varchar2_table;
1183:

Line 1180: l_member_col_list DBMS_SQL.varchar2_table;

1176:
1177: l_attribute_id_list DBMS_SQL.varchar2_table;
1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;
1182: l_attr_varchar_list DBMS_SQL.varchar2_table;
1183:
1184: -- Bug Fix : 5232709 , Variables for holding the _tl, _attr table names of the upload dimension

Line 1181: l_default_assign_list DBMS_SQL.varchar2_table;

1177: l_attribute_id_list DBMS_SQL.varchar2_table;
1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;
1182: l_attr_varchar_list DBMS_SQL.varchar2_table;
1183:
1184: -- Bug Fix : 5232709 , Variables for holding the _tl, _attr table names of the upload dimension
1185: l_member_tl_table_name VARCHAR2(30);

Line 1182: l_attr_varchar_list DBMS_SQL.varchar2_table;

1178: l_member_display_code_list DBMS_SQL.varchar2_table;
1179: l_member_b_table_list DBMS_SQL.varchar2_table;
1180: l_member_col_list DBMS_SQL.varchar2_table;
1181: l_default_assign_list DBMS_SQL.varchar2_table;
1182: l_attr_varchar_list DBMS_SQL.varchar2_table;
1183:
1184: -- Bug Fix : 5232709 , Variables for holding the _tl, _attr table names of the upload dimension
1185: l_member_tl_table_name VARCHAR2(30);
1186: l_member_attr_table_name VARCHAR2(30);

Line 1507: l_err_parent_display_code DBMS_SQL.varchar2_table;

1503: p_version_end_dt IN VARCHAR2,
1504: p_analysis_flag IN VARCHAR2,
1505: p_parent_vs_display_code IN VARCHAR2,
1506: p_mvs_flag IN VARCHAR2) IS
1507: l_err_parent_display_code DBMS_SQL.varchar2_table;
1508: l_err_child_display_code DBMS_SQL.varchar2_table;
1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;
1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;
1511: l_err_status DBMS_SQL.varchar2_table;

Line 1508: l_err_child_display_code DBMS_SQL.varchar2_table;

1504: p_analysis_flag IN VARCHAR2,
1505: p_parent_vs_display_code IN VARCHAR2,
1506: p_mvs_flag IN VARCHAR2) IS
1507: l_err_parent_display_code DBMS_SQL.varchar2_table;
1508: l_err_child_display_code DBMS_SQL.varchar2_table;
1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;
1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;
1511: l_err_status DBMS_SQL.varchar2_table;
1512:

Line 1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;

1505: p_parent_vs_display_code IN VARCHAR2,
1506: p_mvs_flag IN VARCHAR2) IS
1507: l_err_parent_display_code DBMS_SQL.varchar2_table;
1508: l_err_child_display_code DBMS_SQL.varchar2_table;
1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;
1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;
1511: l_err_status DBMS_SQL.varchar2_table;
1512:
1513: l_level_exists_flag VARCHAR2(1);

Line 1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;

1506: p_mvs_flag IN VARCHAR2) IS
1507: l_err_parent_display_code DBMS_SQL.varchar2_table;
1508: l_err_child_display_code DBMS_SQL.varchar2_table;
1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;
1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;
1511: l_err_status DBMS_SQL.varchar2_table;
1512:
1513: l_level_exists_flag VARCHAR2(1);
1514: l_status_code VARCHAR2(1);

Line 1511: l_err_status DBMS_SQL.varchar2_table;

1507: l_err_parent_display_code DBMS_SQL.varchar2_table;
1508: l_err_child_display_code DBMS_SQL.varchar2_table;
1509: l_err_parent_vs_display_code DBMS_SQL.varchar2_table;
1510: l_err_child_vs_display_code DBMS_SQL.varchar2_table;
1511: l_err_status DBMS_SQL.varchar2_table;
1512:
1513: l_level_exists_flag VARCHAR2(1);
1514: l_status_code VARCHAR2(1);
1515: l_folder_name VARCHAR2(150);