The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
PROCEDURE Update_Status(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,resultout OUT NOCOPY VARCHAR2
)
AS
Cursor GetItemGroupDet(c_item_group_id Number) IS
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
,aname => 'UPDATE_GEN_STATUS'
);
'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
wf_core.context('AHL_FMP_APRV_PVT','UPDATE_STATUS',
itemtype,itemkey,actid,funcmode,l_error_msg);
'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);
,'Update_Status'
,itemtype
,itemkey
,actid
,funcmode
,'Unexpected Error!'
);
END Update_Status;
Select
item_group_id ,
object_version_number,
name ,
status_code ,
type_code ,
source_item_group_id
FROM
ahl_item_groups_vl
WHERE
item_group_id =c_item_group_id;
UPDATE AHL_ITEM_GROUPS_B
SET STATUS_CODE = 'DRAFT',
object_version_number =l_object_version_number+1
WHERE ITEM_GROUP_ID = l_object_id
and object_Version_number=l_object_version_number;
UPDATE AHL_ITEM_GROUPS_B
SET STATUS = 'COMPLETE',
object_version_number =l_object_version_number+1
WHERE ITEM_GROUP_ID = l_object_id
and object_Version_number=l_object_version_number;