APPS.FND_OAM_DSCFG_OBJECTS_PKG dependencies on DBMS_SQL

Line 87: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)

83: END;
84:
85: -- Public
86: PROCEDURE GET_OBJECTS_FOR_TYPE(p_object_type IN VARCHAR2,
87: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)
88: IS
89: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE';
90:
91: l_object_ids DBMS_SQL.NUMBER_TABLE;

Line 91: l_object_ids DBMS_SQL.NUMBER_TABLE;

87: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)
88: IS
89: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE';
90:
91: l_object_ids DBMS_SQL.NUMBER_TABLE;
92: BEGIN
93: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
94:
95: --do the fetch

Line 115: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)

111:
112: -- Public
113: PROCEDURE GET_OBJECTS_FOR_TYPE(p_object_type IN VARCHAR2,
114: p_errors_found_flag IN VARCHAR2,
115: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)
116: IS
117: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE(errors_found_flag)';
118:
119: l_object_ids DBMS_SQL.NUMBER_TABLE;

Line 119: l_object_ids DBMS_SQL.NUMBER_TABLE;

115: x_object_ids OUT NOCOPY DBMS_SQL.NUMBER_TABLE)
116: IS
117: l_ctxt VARCHAR2(60) := PKG_NAME||'GET_OBJECTS_FOR_TYPE(errors_found_flag)';
118:
119: l_object_ids DBMS_SQL.NUMBER_TABLE;
120: BEGIN
121: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
122:
123: --do the fetch

Line 157: l_prop_ids DBMS_SQL.NUMBER_TABLE;

153: RETURN BOOLEAN
154: IS
155: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_OBJECT';
156:
157: l_prop_ids DBMS_SQL.NUMBER_TABLE;
158:
159: k NUMBER;
160: l_failed BOOLEAN := FALSE;
161: BEGIN