APPS.GCS_DYN_FEM_POSTING_PKG dependencies on DBMS_SQL

Line 31: l_entry_id_list DBMS_SQL.NUMBER_TABLE;

27: errbuf IN OUT NOCOPY VARCHAR2,
28: retcode IN OUT NOCOPY VARCHAR2 ) IS
29:
30: l_recur_entry_flag VARCHAR2(1);
31: l_entry_id_list DBMS_SQL.NUMBER_TABLE;
32: l_entity_id_list DBMS_SQL.NUMBER_TABLE;
33: l_currency_code_list DBMS_SQL.VARCHAR2_TABLE;
34:
35: BEGIN

Line 32: l_entity_id_list DBMS_SQL.NUMBER_TABLE;

28: retcode IN OUT NOCOPY VARCHAR2 ) IS
29:
30: l_recur_entry_flag VARCHAR2(1);
31: l_entry_id_list DBMS_SQL.NUMBER_TABLE;
32: l_entity_id_list DBMS_SQL.NUMBER_TABLE;
33: l_currency_code_list DBMS_SQL.VARCHAR2_TABLE;
34:
35: BEGIN
36:

Line 33: l_currency_code_list DBMS_SQL.VARCHAR2_TABLE;

29:
30: l_recur_entry_flag VARCHAR2(1);
31: l_entry_id_list DBMS_SQL.NUMBER_TABLE;
32: l_entity_id_list DBMS_SQL.NUMBER_TABLE;
33: l_currency_code_list DBMS_SQL.VARCHAR2_TABLE;
34:
35: BEGIN
36:
37: IF (procedureloglevel >= runtimeloglevel ) THEN

Line 403: l_entries_id DBMS_SQL.number_table;

399:
400: l_req_id NUMBER := FND_GLOBAL.conc_request_id;
401: l_login_id NUMBER := FND_GLOBAL.login_id;
402: l_user_id NUMBER := FND_GLOBAL.user_id;
403: l_entries_id DBMS_SQL.number_table;
404: l_currencies_code DBMS_SQL.varchar2_table;
405: l_entities_id DBMS_SQL.number_table;
406:
407: BEGIN

Line 404: l_currencies_code DBMS_SQL.varchar2_table;

400: l_req_id NUMBER := FND_GLOBAL.conc_request_id;
401: l_login_id NUMBER := FND_GLOBAL.login_id;
402: l_user_id NUMBER := FND_GLOBAL.user_id;
403: l_entries_id DBMS_SQL.number_table;
404: l_currencies_code DBMS_SQL.varchar2_table;
405: l_entities_id DBMS_SQL.number_table;
406:
407: BEGIN
408:

Line 405: l_entities_id DBMS_SQL.number_table;

401: l_login_id NUMBER := FND_GLOBAL.login_id;
402: l_user_id NUMBER := FND_GLOBAL.user_id;
403: l_entries_id DBMS_SQL.number_table;
404: l_currencies_code DBMS_SQL.varchar2_table;
405: l_entities_id DBMS_SQL.number_table;
406:
407: BEGIN
408:
409: IF (procedureloglevel >= runtimeloglevel ) THEN

Line 990: l_objects_id DBMS_SQL.NUMBER_TABLE;

986: p_entity_type VARCHAR2,
987: p_entity_id NUMBER,
988: p_hier_dataset_code NUMBER) IS
989: l_ledger_id NUMBER;
990: l_objects_id DBMS_SQL.NUMBER_TABLE;
991: l_oper_entity_id NUMBER;
992: l_elim_entity_id NUMBER;
993: g_oper_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-OPERATING_ENTITY').attribute_id;
994: g_elim_entity_attr NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').attribute_id;