APPS.IEX_STRY_CUWF_PUB SQL Statements

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

Line: 76

  **Appends to a message  the name of the object anf the operation (insert, update ,delete)
*/
PROCEDURE AddfailMsg
  ( p_object	    IN	VARCHAR2,
    p_operation 	IN	VARCHAR2 ) IS

BEGIN
      fnd_message.set_name('IEX', 'IEX_FAILED_OPERATION');

Line: 99

Select user_name
from jtf_rs_resource_extns
where resource_id =p_resource_id;

Line: 150

   select a.party_id, a.party_type, a.party_name,
          b.cust_account_id,
          b.status, b.payment_schedule_id,
          b.aging_bucket_line_id,c.delinquency_id
    from iex_delinquencies_all b, hz_parties a,iex_strategies c
    where a.party_id(+)  = b.party_cust_id
    and c.strategy_id    = p_strategy_id
    and c.delinquency_id = b.delinquency_id;

Line: 162

  select a.amount_due_remaining
   from ar_payment_schedules a, iex_delinquencies b
  where a.payment_schedule_id = b.payment_schedule_id
  and b.delinquency_id = p_delinquency_id;

Line: 168

  select a.amount_due_remaining
   from ar_payment_schedules a, iex_delinquencies b
  where a.payment_schedule_id(+) = b.payment_schedule_id
  and b.delinquency_id = p_delinquency_id;*/

Line: 240

**The standard API for the selector/callback function is as follows
*/


procedure start_process (item_type   in varchar2,
                         item_key    in varchar2,
                         activity_id in number,
                         command     in varchar2,
                         result      in out NOCOPY varchar2) IS
BEGIN
       null;

Line: 460

          select resource_id into l_resource_id
          from iex_strategy_work_items
          where work_item_id =p_Custom_WF_rec.workitem_id;

Line: 532

 * also updates the work item
 **/

procedure wf_send_signal(
  itemtype    in   varchar2,
  itemkey     in   varchar2,
  actid       in   number,
  funcmode    in   varchar2,
  result      out NOCOPY  varchar2)
IS

l_work_item_id number;

Line: 599

    iex_stry_utl_pub.update_work_item(
                           p_api_version   => 1.0,
                           p_commit        => FND_API.G_TRUE,
                           p_init_msg_list => FND_API.G_TRUE,
                           p_work_item_id  => l_work_item_id,
                           p_status        => 'COMPLETE',
                           x_return_status => l_return_status,
                           x_msg_count     => l_msg_count,
                           x_msg_data      => l_msg_data
                           );

Line: 619

   end if; -- if update is succcessful;