APPS.OE_GENERATE dependencies on DBMS_SQL

Line 2177: l_attr_csr := DBMS_SQL.open_cursor;

2173: BEGIN
2174:
2175: -- Get entity attributes. Use dynamic SQL.
2176:
2177: l_attr_csr := DBMS_SQL.open_cursor;
2178:
2179: -- Parse statement.
2180:
2181: DBMS_SQL.parse

Line 2181: DBMS_SQL.parse

2177: l_attr_csr := DBMS_SQL.open_cursor;
2178:
2179: -- Parse statement.
2180:
2181: DBMS_SQL.parse
2182: (c => l_attr_csr,
2183: statement => 'BEGIN ' || g_product || '_' ||
2184: p_entity_rec.name ||
2185: '_Attr.Get_Attr_tbl; END;',

Line 2186: language_flag => DBMS_SQL.native

2182: (c => l_attr_csr,
2183: statement => 'BEGIN ' || g_product || '_' ||
2184: p_entity_rec.name ||
2185: '_Attr.Get_Attr_tbl; END;',
2186: language_flag => DBMS_SQL.native
2187: );
2188:
2189: -- Execute procedure
2190:

Line 2191: l_result := DBMS_SQL.execute(l_attr_csr);

2187: );
2188:
2189: -- Execute procedure
2190:
2191: l_result := DBMS_SQL.execute(l_attr_csr);
2192:
2193: IF l_result = 0 THEN
2194:
2195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2201: DBMS_SQL.close_cursor (l_attr_csr);

2197: END IF;
2198:
2199: -- Close the cursor.
2200:
2201: DBMS_SQL.close_cursor (l_attr_csr);
2202:
2203: -- Load the primary key attribute table.
2204:
2205: Load_PK_Attr_Tbl;

Line 2219: l_attr_csr := DBMS_SQL.open_cursor;

2215: BEGIN
2216:
2217: -- Get entity attributes. Use dynamic SQL.
2218:
2219: l_attr_csr := DBMS_SQL.open_cursor;
2220:
2221: -- Parse statement.
2222:
2223: DBMS_SQL.parse

Line 2223: DBMS_SQL.parse

2219: l_attr_csr := DBMS_SQL.open_cursor;
2220:
2221: -- Parse statement.
2222:
2223: DBMS_SQL.parse
2224: (c => l_attr_csr,
2225: statement => 'BEGIN ' || g_product || '_' ||
2226: p_entity_rec.name ||
2227: '_Attr.Get_Attr_Value_tbl; END;',

Line 2228: language_flag => DBMS_SQL.native

2224: (c => l_attr_csr,
2225: statement => 'BEGIN ' || g_product || '_' ||
2226: p_entity_rec.name ||
2227: '_Attr.Get_Attr_Value_tbl; END;',
2228: language_flag => DBMS_SQL.native
2229: );
2230:
2231: -- Execute procedure
2232:

Line 2233: l_result := DBMS_SQL.execute(l_attr_csr);

2229: );
2230:
2231: -- Execute procedure
2232:
2233: l_result := DBMS_SQL.execute(l_attr_csr);
2234:
2235: IF l_result = 0 THEN
2236:
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2243: DBMS_SQL.close_cursor (l_attr_csr);

2239: END IF;
2240:
2241: -- Close the cursor.
2242:
2243: DBMS_SQL.close_cursor (l_attr_csr);
2244:
2245: END Load_Entity_Attribute_Values;
2246:
2247: FUNCTION Multiple_Branch