APPS.FND_OAM_DSCFG_API_PKG dependencies on DBMS_SQL

Line 173: PROCEDURE GET_CURRENT_TARGET_TABLE_LIST(x_table_owners OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

169: -- x_table_owners OWNER of the target table
170: -- x_table_names NAME of the target table, indicies match between lists.
171: -- Return Statuses:
172: -- If the configuration instance state isn't initialized, a NO_DATA_FOUND exception is thrown.
173: PROCEDURE GET_CURRENT_TARGET_TABLE_LIST(x_table_owners OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
174: x_table_names OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE);
175:
176: -- ##################################################
177: -- Object+Properties Complex Creation Procedures --

Line 174: x_table_names OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE);

170: -- x_table_names NAME of the target table, indicies match between lists.
171: -- Return Statuses:
172: -- If the configuration instance state isn't initialized, a NO_DATA_FOUND exception is thrown.
173: PROCEDURE GET_CURRENT_TARGET_TABLE_LIST(x_table_owners OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
174: x_table_names OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE);
175:
176: -- ##################################################
177: -- Object+Properties Complex Creation Procedures --
178: -- ##################################################

Line 254: -- will be executed by wrapping it in an anonymous BEGIN END; block and issuing it through the DBMS_SQL package.

250: p_source_id IN NUMBER DEFAULT NULL,
251: x_object_id OUT NOCOPY NUMBER);
252:
253: -- This API is used to create a new configuration object representing a chunk of PL/SQL text. This text
254: -- will be executed by wrapping it in an anonymous BEGIN END; block and issuing it through the DBMS_SQL package.
255: -- Invariants:
256: -- Assumes Configuration Instance has been initialized, throws NO_DATA_FOUND if not.
257: -- Parameters:
258: -- p_plsql_text PL/SQL text - this should typically be a reference to a PROCEDURE whose inputs are

Line 387: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE);

383: x_object_id OUT NOCOPY NUMBER);
384:
385: -- See FND_OAM_DSCFG_OBJECTS_PKG.GET_OBJECTS_FOR_TYPE for description.
386: PROCEDURE GET_OBJECTS_FOR_TYPE(p_object_type IN VARCHAR2,
387: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE);
388:
389: -- See FND_OAM_DSCFG_OBJECTS_PKG.GET_OBJECTS_FOR_TYPE for description.
390: PROCEDURE GET_OBJECTS_FOR_TYPE(p_object_type IN VARCHAR2,
391: p_errors_found_flag IN VARCHAR2,

Line 392: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE);

388:
389: -- See FND_OAM_DSCFG_OBJECTS_PKG.GET_OBJECTS_FOR_TYPE for description.
390: PROCEDURE GET_OBJECTS_FOR_TYPE(p_object_type IN VARCHAR2,
391: p_errors_found_flag IN VARCHAR2,
392: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE);
393:
394: -- ###################################################
395: -- Wrappers for Generic Operations on Properties --
396: -- ###################################################