The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
Into l_timeout_period
From MTL_PARAMETERS
Where organization_id = l_trohdr_rec.organization_id;
Select nvl(MO_APPROVAL_TIMEOUT_ACTION,1)
Into l_timeout_action
From MTL_PARAMETERS
Where organization_id = l_trohdr_rec.organization_id;
Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
Inv_Globals.G_TO_STATUS_APPROVED);
Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
INV_Globals.G_TO_STATUS_CANCELLED);
Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
INV_Globals.G_TO_STATUS_APPROVED);
Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
Inv_Globals.G_TO_STATUS_REJECTED);
Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id,
INV_Globals.G_TO_STATUS_REJECTED);
Inv_trohdr_Util.Update_Row_Status(To_Header_Id,
Inv_Globals.G_TO_STATUS_PENDING_APPROVAL);
select ORIG_SYSTEM_ID
into l_requestor_id
from WF_USERS
where NAME = l_requestor_name;
Inv_trolin_Util.Update_Row_Status(l_trolin_tbl(l_line_count).Line_id ,
INV_Globals.G_TO_STATUS_PENDING_APPROVAL);
Inv_trohdr_Util.Update_Row_Status(l_header_id,
Inv_Globals.G_TO_STATUS_APPROVED);
Inv_trohdr_Util.Update_Row_Status(l_header_id,
Inv_Globals.G_TO_STATUS_PART_APPROVED);
Inv_trohdr_Util.Update_Row_Status(l_header_id,
Inv_Globals.G_TO_STATUS_REJECTED);
/* 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;*/
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;
select employee_id
into l_planner_id
from MTL_PLANNERS
where planner_code = l_planner_code and
organization_id = l_org_id;
Select nvl(MO_APPROVAL_tIMEOUT_ACTION,1)
Into l_timeout_action
From MTL_PARAMETERS
Where organization_id = l_org_id;
select line_status
into l_line_status
from mtl_txn_request_lines
where line_id = l_line_id;
Inv_trolin_Util.Update_Row_Status(l_Line_id ,
INV_Globals.G_TO_STATUS_APPROVED);
select line_status
into l_line_status
from mtl_txn_request_lines
where line_id = l_line_id;
Inv_trolin_Util.Update_Row_Status(l_Line_id ,
INV_Globals.G_TO_STATUS_REJECTED);
Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
Into l_timeout_period
From MTL_PARAMETERS
Where
organization_id = l_org_id;
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);
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;
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;
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);
WF_CORE.CONTEXT('INVTROAP','Selector',itemtype,itemkey,
to_char(actid),command);
End Selector;