APPS.PO_INTERFACE_S dependencies on DBMS_SQL

Line 13737: l_cursor := dbms_sql.open_cursor;

13733: ---------------------------------------------------
13734: sqlstmt := 'BEGIN JG_GLOBE_UTIL_PKG.process_po_globe_event(:p_document_type,:p_level_type,:p_level_id); END;';
13735:
13736: -- Create the SQL statement
13737: l_cursor := dbms_sql.open_cursor;
13738:
13739: l_progress := '020';
13740:
13741: -- Parse the SQL statement

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

13738:
13739: l_progress := '020';
13740:
13741: -- Parse the SQL statement
13742: dbms_sql.parse (l_cursor, sqlstmt, dbms_sql.native);
13743:
13744: l_progress := '030';
13745: -- Define the variables
13746: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);

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

13742: dbms_sql.parse (l_cursor, sqlstmt, dbms_sql.native);
13743:
13744: l_progress := '030';
13745: -- Define the variables
13746: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
13747: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
13748: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
13749:
13750: l_progress := '040';

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

13743:
13744: l_progress := '030';
13745: -- Define the variables
13746: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
13747: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
13748: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
13749:
13750: l_progress := '040';
13751: -- Execute the SQL statement

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

13744: l_progress := '030';
13745: -- Define the variables
13746: dbms_sql.bind_variable(l_cursor, ':p_document_type', document_type);
13747: dbms_sql.bind_variable(l_cursor, ':p_level_type', level_type);
13748: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
13749:
13750: l_progress := '040';
13751: -- Execute the SQL statement
13752: l_execute := dbms_sql.execute(l_cursor);

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

13748: dbms_sql.bind_variable(l_cursor, ':p_level_id', level_id);
13749:
13750: l_progress := '040';
13751: -- Execute the SQL statement
13752: l_execute := dbms_sql.execute(l_cursor);
13753:
13754: -- Get the return value (success)
13755: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
13756:

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

13751: -- Execute the SQL statement
13752: l_execute := dbms_sql.execute(l_cursor);
13753:
13754: -- Get the return value (success)
13755: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
13756:
13757: l_progress := '050';
13758: -- Close the cursor
13759: dbms_sql.close_cursor(l_cursor);

Line 13759: dbms_sql.close_cursor(l_cursor);

13755: -- dbms_sql.variable_value(l_cursor, ':b_return', l_return);
13756:
13757: l_progress := '050';
13758: -- Close the cursor
13759: dbms_sql.close_cursor(l_cursor);
13760:
13761: IF g_debug_stmt THEN
13762: PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name);
13763: END IF;