APPS.GCS_DATASUB_WF_PKG dependencies on DBMS_SQL

Line 2334: l_entity_list DBMS_SQL.NUMBER_TABLE;

2330: l_fch_company_vs_id NUMBER;
2331: l_fch_org_vs_id NUMBER;
2332: l_hier_obj_definition_id NUMBER(9);
2333:
2334: l_entity_list DBMS_SQL.NUMBER_TABLE;
2335: l_xlated_curr_list DBMS_SQL.VARCHAR2_TABLE;
2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;
2337:
2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 2335: l_xlated_curr_list DBMS_SQL.VARCHAR2_TABLE;

2331: l_fch_org_vs_id NUMBER;
2332: l_hier_obj_definition_id NUMBER(9);
2333:
2334: l_entity_list DBMS_SQL.NUMBER_TABLE;
2335: l_xlated_curr_list DBMS_SQL.VARCHAR2_TABLE;
2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;
2337:
2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2339: .attribute_id;

Line 2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;

2332: l_hier_obj_definition_id NUMBER(9);
2333:
2334: l_entity_list DBMS_SQL.NUMBER_TABLE;
2335: l_xlated_curr_list DBMS_SQL.VARCHAR2_TABLE;
2336: l_generated_load_list DBMS_SQL.NUMBER_TABLE;
2337:
2338: l_global_vs_combo_attr NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')
2339: .attribute_id;
2340: l_global_vs_combo_version NUMBER := gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-GLOBAL_VS_COMBO')

Line 3271: --l_load_list DBMS_SQL.NUMBER_TABLE;

3267: -- Bugfix 5676634
3268: l_request_id NUMBER;
3269:
3270: -- Bugfix 5664023 :Start
3271: --l_load_list DBMS_SQL.NUMBER_TABLE;
3272:
3273: TYPE load_rec_type IS RECORD(load_id NUMBER,
3274: most_recent_flag VARCHAR2(1));
3275: TYPE t_load_info IS TABLE OF load_rec_type;