APPS.XNP_UTILS SQL Statements

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

Line: 28

      SELECT wip.parameter_name name,
        wip.required_flag mandatory_flag
      FROM xdp_workitems wis,
           xdp_wi_parameters wip
      WHERE wis.workitem_name = p_wi_name
      AND wis.workitem_id = wip.workitem_id;

Line: 122

  SELECT geo.code FROM xnp_geo_areas_b geo
  WHERE geo.geo_area_id IN (SELECT nre.geo_area_id
                            FROM xnp_number_ranges nre
                            WHERE subscription_tn BETWEEN
                            starting_number AND ending_number );

Line: 128

    SELECT subscription_tn
    FROM XNP_SV_SOA
    WHERE object_reference = p_porting_id ;

Line: 235

    SELECT DONOR_SP_ID INTO l_DONOR_SP_ID
     FROM XNP_SV_SOA
     WHERE OBJECT_REFERENCE = l_PORTING_ID;

Line: 473

    SELECT RECIPIENT_SP_ID INTO l_RECIPIENT_SP_ID
     FROM XNP_SV_SOA
     WHERE OBJECT_REFERENCE = l_PORTING_ID;

Line: 599

    INSERT INTO XNP_DEBUG (DEBUG_ID
                          ,DEBUG_LEVEL
                          , CONTEXT
                          , DESCRIPTION
                          , created_by
                          , creation_date
                          ,last_updated_by
                          ,last_update_date)
      VALUES( xnp_debug_s.nextval, P_SEVERITY_LEVEL, P_CONTEXT, P_DESCRIPTION
            ,fnd_global.user_id,sysdate,fnd_global.user_id,sysdate) ;

Line: 916

   SELECT fulfillment_element_name
   FROM xdp_fes FET
   WHERE FET.fe_id = p_fe_id;

Line: 955

   SELECT fulfillment_element_name
   FROM xdp_fes FET,
	xnp_sp_adapters SPA,
	xdp_fe_generic_config SWG
   WHERE FET.fe_id = SPA.fe_id
    AND SPA.fe_id = SWG.fe_id
    AND SPA.sp_id = p_sp_id
    AND (sysdate BETWEEN SWG.start_date
    AND NVL(SWG.end_date, sysdate))
    ORDER BY preferred_flag desc, sequence asc ;

Line: 1010

   SELECT fulfillment_element_name
   FROM xdp_fes FET,
	xnp_sp_adapters SPA,
	xdp_fe_generic_config SWG
   WHERE FET.fe_id = SPA.fe_id
    AND SPA.fe_id = SWG.fe_id
    AND SPA.sp_id = p_sp_id
    AND (sysdate BETWEEN SWG.start_date
    AND NVL(SWG.end_date, sysdate))
    ORDER BY preferred_flag desc, sequence asc ;

Line: 1303

    SELECT process_reference
    FROM xnp_callback_events
    WHERE reference_id = p_reference_id;

Line: 1477

     SELECT wip.parameter_name name
      FROM xdp_wi_parameters wip
      WHERE wip.workitem_id =
	(SELECT fwl.workitem_id
         FROM xdp_fulfill_worklist fwl
	 WHERE fwl.workitem_instance_id = p_src_wi_id
	);

Line: 1595

		SELECT fulfillment_element_name, FET.fe_id
		FROM xdp_fes FET,
			xnp_sp_adapters SPA,
			xdp_fe_generic_config SWG
		WHERE FET.fe_id = SPA.fe_id
		AND SPA.fe_id = SWG.fe_id
		AND SPA.sp_id = p_sp_id
		AND (sysdate BETWEEN SWG.start_date
		AND NVL(SWG.end_date, sysdate))
		ORDER BY preferred_flag desc, sequence asc ;

Line: 1659

	SELECT xad.adapter_name
	FROM xdp_adapter_reg xad, xdp_adapter_types_b t,xdp_fes XFE
	WHERE XAD.fe_id = XFE.fe_id
          AND XFE.fulfillment_element_name = p_fe_name
	  AND xad.adapter_type = t.adapter_type
	  AND application_mode='QUEUE'
	  AND xad.adapter_status not in ('NOT_AVAILABLE')
 	ORDER BY
	  DECODE(adapter_status, 'IDLE', 1,
                 'SUSPENDED', 2,
                 'DISCONNECTED', 3,
                 'SHUTDOWN', 4, 5)
          ASC ;

Line: 1718

SELECT number_range_id
  FROM xnp_number_ranges
 WHERE
       -- Case 1
       (    (to_number(starting_number) >= to_number(p_starting_number))
        AND (to_number(starting_number) <= to_number(p_ending_number))
        AND (to_number(ending_number)   >= to_number(p_ending_number)))
       -- Case 2
    OR (    (to_number(starting_number) <= to_number(p_starting_number))
        AND (to_number(ending_number)   >= to_number(p_ending_number)))
       -- Case 3
    OR (    (to_number(starting_number) <= to_number(p_starting_number))
        AND (to_number(ending_number)   >= to_number(p_starting_number))
        AND (to_number(ending_number)   <= to_number(p_ending_number)))
       -- Case 4
    OR (    (to_number(starting_number) >= to_number(p_starting_number))
        AND (to_number(ending_number)   <= to_number(p_ending_number)));