DBA Data[Home] [Help]

APPS.AHL_ITEMGROUPS_APPROVAL_PVT SQL Statements

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

Line: 36

        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;
Line: 297

        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;
Line: 430

        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;
Line: 576

        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;
Line: 723

        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;
Line: 875

        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;
Line: 1028

        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;
Line: 1186

        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;
Line: 1322

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;
Line: 1364

			'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
Line: 1371

                          ,aname    => 'UPDATE_GEN_STATUS'
                        );
Line: 1375

			'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
Line: 1495

			'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
Line: 1510

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

			'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);
Line: 1523

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

END Update_Status;
Line: 1572

        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;
Line: 1621

              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;
Line: 1627

              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;