APPS.INVTROAP SQL Statements

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

Line: 38

    Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
      Into l_timeout_period
      From MTL_PARAMETERS
      Where organization_id = l_trohdr_rec.organization_id;

Line: 44

        Select nvl(MO_APPROVAL_TIMEOUT_ACTION,1)
          Into l_timeout_action
          From MTL_PARAMETERS
          Where organization_id = l_trohdr_rec.organization_id;

Line: 50

            Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
                                Inv_Globals.G_TO_STATUS_APPROVED);

Line: 62

                 Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
                                              INV_Globals.G_TO_STATUS_CANCELLED);

Line: 67

                  Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
                                              INV_Globals.G_TO_STATUS_APPROVED);

Line: 72

            Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
                                Inv_Globals.G_TO_STATUS_REJECTED);

Line: 80

                 Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
                                              INV_Globals.G_TO_STATUS_REJECTED);

Line: 87

        Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
                                Inv_Globals.G_TO_STATUS_PENDING_APPROVAL);

Line: 111

  select ORIG_SYSTEM_ID
  into   l_requestor_id
  from   WF_USERS
  where  NAME = l_requestor_name;

Line: 463

           Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id ,
                                   INV_Globals.G_TO_STATUS_PENDING_APPROVAL);

Line: 568

        Inv_trohdr_Util.Update_Row_Status(l_header_id,
				  Inv_Globals.G_TO_STATUS_APPROVED);

Line: 603

     Inv_trohdr_Util.Update_Row_Status(l_header_id,
				Inv_Globals.G_TO_STATUS_PART_APPROVED);

Line: 641

     Inv_trohdr_Util.Update_Row_Status(l_header_id,
                                       Inv_Globals.G_TO_STATUS_REJECTED);

Line: 691

	/* Commented the select statement from MTL_SYSTEM_ITEMS_KFV AND
	   Selected the values of item name, planner code and description
	   from MTL_SYSTEM_ITEMS_VL which supports MLS.
	   Select Concatenated_segments , planner_code, description -- Description added for Bug# 4148672
             into   l_item_name , l_planner_code, l_item_description -- l_item_description added for Bug# 4148672
             from  MTL_SYSTEM_ITEMS_KFV
             where organization_id = l_org_id and
                   inventory_item_id = l_item_id;*/

Line: 700

	Select
            --segment1,                                --commented segment1 for Bug# 6936609
            CONCATENATED_SEGMENTS,                     --and added CONCATENATED_SEGMENTS for Bug# 6936609
            planner_code, description                  -- Description added for Bug# 4148672
             into   l_item_name , l_planner_code, l_item_description -- l_item_description added for Bug# 4148672
             from  MTL_SYSTEM_ITEMS_VL                  -- Modified the view to MTL_SYSTEM_ITEMS_FVL for Bug# 4148672
             where organization_id = l_org_id and
                   inventory_item_id = l_item_id;

Line: 789

          select employee_id
          into l_planner_id
          from MTL_PLANNERS
          where planner_code = l_planner_code and
                organization_id = l_org_id;

Line: 869

         Select nvl(MO_APPROVAL_tIMEOUT_ACTION,1)
         Into l_timeout_action
         From MTL_PARAMETERS
         Where organization_id = l_org_id;

Line: 918

       select line_status
         into l_line_status
         from mtl_txn_request_lines
         where line_id = l_line_id;

Line: 925

         Inv_trolin_Util.Update_Row_Status(l_Line_id ,
                                       INV_Globals.G_TO_STATUS_APPROVED);

Line: 966

       select line_status
         into l_line_status
         from mtl_txn_request_lines
         where line_id = l_line_id;

Line: 972

         Inv_trolin_Util.Update_Row_Status(l_Line_id ,
                                       INV_Globals.G_TO_STATUS_REJECTED);

Line: 1013

      Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
      Into l_timeout_period
      From MTL_PARAMETERS
      Where
      organization_id = l_org_id;

Line: 1019

      Select c1.calendar_date
      into l_mfg_cal_date
      from mtl_parameters o,
           bom_calendar_dates c1,
           bom_calendar_dates c
        where o.organization_id   = l_org_id
        and   c1.calendar_code    = c.calendar_code
        and   c1.exception_set_id = c.exception_set_id
        and   c1.seq_num          = (nvl(c.seq_num,c.next_seq_num) + l_timeout_period)
        and   c.calendar_code     = o.CALENDAR_CODE
        and   c.exception_set_id  = o.CALENDAR_EXCEPTION_SET_ID
        and   c.calendar_date     = trunc(sysdate);

Line: 1174

        select  NOTIFY_LIST
        into    l_to_notify_role
        from    mtl_secondary_inventories_fk_v
        where   SECONDARY_INVENTORY_NAME =
                         l_trolin_tbl(l_current_line).to_subinventory_code and
                organization_id = l_org_id;

Line: 1191

        select  NOTIFY_LIST
        into    l_from_notify_role
        from    mtl_secondary_inventories_fk_v
        where   SECONDARY_INVENTORY_NAME =
                       l_trolin_tbl(l_current_line).from_subinventory_code and
                organization_id = l_org_id;

Line: 1319

Procedure Selector( itemtype in  varchar2,
                    itemkey  in  varchar2,
                    actid    in  number,
                    command  in  varchar2,
                    result   out nocopy varchar2 ) is
    l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line: 1333

         WF_CORE.CONTEXT('INVTROAP','Selector',itemtype,itemkey,
                          to_char(actid),command);

Line: 1336

End Selector;