APPS.PO_AUTOCREATE_PVT dependencies on DBMS_SQL

Line 254: l_cursor := dbms_sql.open_cursor;

250: ---------------------------------------------------
251: sqlstmt := 'BEGIN JG_GLOBE_UTIL_PKG.process_po_globe_event(:p_document_type,:p_level_type,:p_level_id); END;';
252:
253: -- Create the SQL statement
254: l_cursor := dbms_sql.open_cursor;
255:
256: l_progress := '020';
257:
258: -- Parse the SQL statement

Line 259: dbms_sql.parse (l_cursor, sqlstmt, dbms_sql.native);

255:
256: l_progress := '020';
257:
258: -- Parse the SQL statement
259: dbms_sql.parse (l_cursor, sqlstmt, dbms_sql.native);
260:
261: l_progress := '030';
262: -- Define the variables
263: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);

Line 263: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);

259: dbms_sql.parse (l_cursor, sqlstmt, dbms_sql.native);
260:
261: l_progress := '030';
262: -- Define the variables
263: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
264: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
265: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
266:
267: l_progress := '040';

Line 264: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);

260:
261: l_progress := '030';
262: -- Define the variables
263: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
264: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
265: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
266:
267: l_progress := '040';
268: -- Execute the SQL statement

Line 265: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);

261: l_progress := '030';
262: -- Define the variables
263: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
264: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
265: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
266:
267: l_progress := '040';
268: -- Execute the SQL statement
269: l_execute := dbms_sql.execute(l_cursor);

Line 269: l_execute := dbms_sql.execute(l_cursor);

265: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
266:
267: l_progress := '040';
268: -- Execute the SQL statement
269: l_execute := dbms_sql.execute(l_cursor);
270:
271: -- Get the return value (success)
272: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
273:

Line 272: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);

268: -- Execute the SQL statement
269: l_execute := dbms_sql.execute(l_cursor);
270:
271: -- Get the return value (success)
272: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
273:
274: l_progress := '050';
275: -- Close the cursor
276: dbms_sql.close_cursor(l_cursor);

Line 276: dbms_sql.close_cursor(l_cursor);

272: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
273:
274: l_progress := '050';
275: -- Close the cursor
276: dbms_sql.close_cursor(l_cursor);
277:
278: IF g_debug_stmt THEN
279: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
280: END IF;