APPS.OTA_WF SQL Statements

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

Line: 147

	l_line_rec. operation := 'UPDATE';

Line: 386

	l_line_rec. operation := 'INSERT';

Line: 557

PROCEDURE  UPDATE_FULFILL_DATE (
itemtype	IN	VARCHAR2
,itemkey	IN	VARCHAR2
,actid       IN    NUMBER
,funcmode    IN    VARCHAR2
,resultout   OUT NOCOPY VARCHAR2

) Is
l_proc 	varchar2(72) := g_package||'update_fulfill_date';

Line: 632

SELECT Course_End_date
FROM  OTA_EVENTS
WHERE LINE_ID = l_line_id;

Line: 639

SELECT HEADER_ID,ORG_ID
FROM OE_ORDER_LINES_ALL
WHERE LINE_ID = l_line_id;

Line: 667

      l_line_rec. operation := 'UPDATE';

Line: 759

    wf_core.context('OTA_WF', 'update_fulfill_date',
		    itemtype, itemkey, to_char(actid), funcmode);

Line: 820

SELECT
   decode(invoiced_quantity,null,0,invoiced_quantity)
FROM
   oe_order_lines
WHERE
   line_id = l_line_id;

Line: 943

SELECT
   ol.order_quantity_uom ,
   oh.order_number,
   ol.line_number
FROM
   oe_order_lines_all ol,
   oe_order_headers_all oh
WHERE
   oh.header_id = ol.header_id and
   ol.line_id = l_line_id;

Line: 955

SELECT email_address
FROM per_people_f
WHERE person_id IN(
select owner_id from
ota_events where
line_id = l_line_id);*/

Line: 1082

SELECT
   order_quantity_uom
FROM
   oe_order_lines
WHERE
   line_id = l_line_id;

Line: 1091

SELECT
	null
FROM
	OTA_EVENTS
WHERE
	line_id = l_line_id;

Line: 1100

SELECT
	null
FROM
	ota_delegate_bookings
WHERE
	line_id = l_line_id;

Line: 1224

SELECT
	bst.type
FROM
	ota_delegate_bookings tdb,	ota_booking_status_types bst
WHERE
	line_id = to_number(itemkey)AND
	bst.booking_status_type_id = tdb.booking_status_type_id;

Line: 1336

SELECT
	bst.type
FROM
	ota_delegate_bookings tdb,
	ota_booking_status_types bst
WHERE
	line_id = to_number(itemkey)AND
	bst.booking_status_type_id = tdb.booking_status_type_id;

Line: 1454

SELECT
	invoicing_rule_id
FROM
	oe_order_lines_all
WHERE
    line_id = to_number(itemkey);

Line: 1557

 SELECT
    Booking_status_type_id
 FROM
    OTA_DELEGATE_BOOKINGS
 WHERE
    Line_id = to_number(itemkey);

Line: 1567

 SELECT
   Type
 FROM
   OTA_BOOKING_STATUS_TYPES
 WHERE
   booking_status_type_id = l_booking_status_type_id;

Line: 1593

     		   ota_cancel_api.delete_cancel_line
 					(
  					p_line_id  	=>to_number(itemkey),
  					p_org_id 	=> l_org_id,
  					p_UOM  	=> 'ENR',
  					P_daemon_type  => 'C',
  					x_return_status =>  l_return_status);

Line: 1690

PROCEDURE UPDATE_OWNER_EMAIL (
Itemtype		IN 	VARCHAR2
,Itemkey		IN	VARCHAR2
,actid       	IN    NUMBER
,funcmode    	IN    VARCHAR2
,resultout	 OUT NOCOPY VARCHAR2)

IS

l_proc 	varchar2(72) := g_package||'update_owner_email';

Line: 1705

SELECT
   ol.order_quantity_uom ,
   oh.order_number,
   ol.line_number
FROM
   oe_order_lines_all ol,
   oe_order_headers_all oh
WHERE
   oh.header_id = ol.header_id and
   ol.line_id = l_line_id;

Line: 1717

SELECT user_name
FROM FND_USER
WHERE employee_id IN(
select owner_id from
ota_events where
line_id = l_line_id);

Line: 1755

    wf_core.context('OTA_WF', 'UPDATE_OWNER_EMAIL',
		    itemtype, itemkey, to_char(actid), funcmode);

Line: 1824

SELECT
  EVENT_ID
FROM
  OTA_EVENTS
WHERE
  line_id = to_number(itemkey);

Line: 1833

SELECT
	bst.type
FROM
	ota_delegate_bookings tdb,
	ota_booking_status_types bst
WHERE
	event_id = l_event_id AND
	bst.booking_status_type_id = tdb.booking_status_type_id;

Line: 2096

  select user_name
  from fnd_user
  where upper(email_address)=upper(p_email_address)
  and (end_date is null or end_date >=sysdate);

Line: 2102

  select user_name
  from fnd_user
  where EMPLOYEE_ID = p_person_id
  and (end_date is null or end_date >=sysdate);