APPS.MRP_ATP_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 74

		     p_insert_flag   NUMBER,
		     p_partial_flag  NUMBER,
		     p_err_message   IN OUT NoCopy VARCHAR2)
RETURN NUMBER is

v_dummy			NUMBER := 0;

Line: 182

      mast_rec_insert mrp_atp_schedule_temp_typ;

Line: 191

	      ' SELECT '||
	      '     rowidtochar(rowid),'||
	      '     sequence_number,'||
	      '     firm_flag,'||
	      '     order_line_number,'||
	      '     option_number,'||
	      '     shipment_number,'||
	      '     item_desc,'||
	      '     customer_name,'||
	      '     customer_location,'||
	      '     ship_set_name,'||
	      '     arrival_set_name,'||
	      '     old_line_schedule_date,'||
	      '     old_source_organization_code,'||
	      '     project_id,'||
	      '     task_id,'||
	      '     project_number,'||
	      '     task_number '||
	      '     FROM '||
	      '     mrp_atp_schedule_temp'||l_dynstring||
	      '     WHERE session_id = :x_session_id '||
	      '     AND status_flag = 1';