APPS.AHL_ITEMCOMP_APPROVAL_PVT SQL Statements

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

Line: 36

        Select
		item_composition_id          ,
		concatenated_segments,
		object_version_number,
		inventory_item_id,
		approval_status_code                 ,
		effective_end_date                   ,
		link_comp_id
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 332

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE                 ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 465

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 613

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 762

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 915

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 1068

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 1226

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 1358

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

AS
          Cursor GetItemCompDet(C_ITEM_COMPOSITION_ID Number) IS

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE                 ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 1401

			'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');

Line: 1408

                          ,aname    => 'UPDATE_GEN_STATUS'
                        );

Line: 1412

			'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');

Line: 1518

			'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);

Line: 1533

      wf_core.context('AHL_FMP_APRV_PVT','UPDATE_STATUS',
                      itemtype,itemkey,actid,funcmode,l_error_msg);

Line: 1540

			'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);

Line: 1546

       ,'Update_Status'
       ,itemtype
       ,itemkey
       ,actid
       ,funcmode
       ,'Unexpected Error!'
     );

Line: 1555

END Update_Status;

Line: 1595

        Select
		ITEM_COMPOSITION_ID ,
		concatenated_segments,
		object_version_number,
		INVENTORY_ITEM_ID,
		APPROVAL_STATUS_CODE              ,
		EFFECTIVE_END_DATE              ,
		LINK_COMP_ID
	FROM
		ahl_item_comp_v
	WHERE
		ITEM_COMPOSITION_ID =C_ITEM_COMPOSITION_ID;

Line: 1643

              UPDATE AHL_ITEM_COMPOSITIONS
                SET APPROVAL_STATUS_CODE = 'DARFT',
                    object_version_number =l_object_version_number+1
              WHERE ITEM_COMPOSITION_ID = l_object_id
              and   object_Version_number=l_object_version_number;