APPS.PA_RESOURCE_PUB SQL Statements

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

Line: 7

   G_LAST_UPDATED_BY	NUMBER(15) 	:= FND_GLOBAL.USER_ID;

Line: 8

   G_LAST_UPDATE_DATE        	DATE       	:= SYSDATE;

Line: 11

   G_LAST_UPDATE_LOGIN       	NUMBER(15) 	:= FND_GLOBAL.LOGIN_ID;

Line: 27

PROCEDURE Insert_Members (
   p_resource_list_id           IN  NUMBER,
   p_group_resource_type        IN  VARCHAR2,
   p_resource_type_code         IN  VARCHAR2,
   p_resource_group_alias       IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_resource_group_name        IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_resource_alias             IN  VARCHAR2,
   p_sort_order                 IN  NUMBER,
   p_enabled_flag               IN  VARCHAR2,
   p_resource_attr_value        IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_job_group_id               IN  NUMBER,   --Added for bug 2486405.
   p_parent_member_id          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_resource_list_member_id   OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_track_as_labor_flag       OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_err_code               IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_err_stage              IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_err_stack              IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_return_status             OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line: 325

            Insert_Members (
             p_resource_list_id          => p_resource_list_id,
             p_group_resource_type       => p_group_resource_type,
             p_resource_type_code        =>
                   p_member_tbl(i).resource_type_code,
             p_resource_group_alias      =>
                   p_member_tbl(i).resource_group_alias,
             p_resource_group_name       =>
                   p_member_tbl(i).resource_group_name,
             p_resource_alias            => p_member_tbl(i).resource_alias,
             p_sort_order                => p_member_tbl(i).sort_order,
             p_enabled_flag              => p_member_tbl(i).enabled_flag,
             p_resource_attr_value       =>
                   p_member_tbl(i).resource_attr_value,
             p_job_group_id              => p_job_group_id,         --Added for bug 2486405.
             p_parent_member_id          => l_parent_member_id,
             p_resource_list_member_id   => l_resource_list_member_id,
             p_track_as_labor_flag       => l_track_as_labor_flag,
             p_err_code                  => l_err_code,
             p_err_stage                 => l_err_stage,
             p_err_stack                 => l_err_stack,
             p_return_status             => l_return_status );

Line: 437

PROCEDURE Insert_Members (
   p_resource_list_id           IN  NUMBER,
   p_group_resource_type        IN  VARCHAR2,
   p_resource_type_code         IN  VARCHAR2,
   p_resource_group_alias       IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_resource_group_name        IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_resource_alias	        IN  VARCHAR2,
   p_sort_order                 IN  NUMBER,
   p_enabled_flag               IN  VARCHAR2,
   p_resource_attr_value        IN  VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
   p_job_group_id               IN  NUMBER,   --Added for bug 2486405.
   p_parent_member_id          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_resource_list_member_id   OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_track_as_labor_flag       OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_err_code               IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
   p_err_stage              IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_err_stack              IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   p_return_status             OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)

IS
l_err_code                NUMBER := 0;

Line: 472

l_api_name              CONSTANT    VARCHAR2(30):=  'Insert_Members';

Line: 477

SELECT organization_id
FROM   pa_organizations_res_v
WHERE  organization_name = l_resource_group_name;

Line: 626

END Insert_Members;

Line: 655

	g_member_tbl.DELETE;

Line: 656

	g_member_out_tbl.DELETE;

Line: 661

	g_load_member_tbl.DELETE;

Line: 662

	g_load_member_out_tbl.DELETE;

Line: 1131

PROCEDURE Update_Resource_List
(p_commit                   IN  VARCHAR2 := FND_API.G_FALSE,
 p_api_version_number       IN  NUMBER,
 p_init_msg_list            IN  VARCHAR2 := FND_API.G_FALSE,
 p_return_status            OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 p_msg_count                OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
 p_msg_data                 OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 p_resource_list_name       IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
 p_resource_list_id         IN  NUMBER        := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_new_list_name            IN  VARCHAR2      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
 p_grouped_by_type          IN  VARCHAR2      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
 p_description              IN  VARCHAR2      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
 p_start_date               IN  DATE          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
 p_end_date                 IN  DATE          := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,
 p_member_tbl               IN  member_tbl,
 p_member_out_tbl           OUT NOCOPY member_out_tbl  --File.Sql.39 bug 4440895
)
IS

l_api_version_number   	CONSTANT NUMBER := G_API_VERSION_NUMBER;

Line: 1151

l_api_name             	CONSTANT VARCHAR2(30) := 'Update_Resource_List';

Line: 1158

l_version_update_member NUMBER := G_API_VERSION_NUMBER;

Line: 1166

l_update_header_flag		VARCHAR2(1);

Line: 1167

l_update_member_flag		VARCHAR2(1);

Line: 1187

SELECT	'x'
FROM		pa_resource_lists rl
WHERE		rl.name = p_new_list_name;

Line: 1199

SELECT	'x'
FROM 		sys.dual
WHERE		EXISTS
		(SELECT 'x'
		FROM pa_resource_list_members rlm
			, pa_resources r
			, pa_resource_types rt
	              WHERE
		rlm.resource_list_id = l_resource_list_id
		AND rlm.resource_id = r.resource_id
		AND r.resource_type_id = rt.resource_type_id
		AND rt.resource_type_code <> 'UNCLASSIFIED');

Line: 1216

SELECT	rta.resource_type_id
FROM		pa_resource_types_active_v rta
WHERE		rta.resource_type_code = p_grouped_by_type;

Line: 1224

SELECT	rl.name, rl.group_resource_type_id, rl.description, rl.start_date_active, rl.end_date_active,   ROWID
FROM		pa_resource_lists rl
WHERE		rl.resource_list_id = l_resource_list_id;

Line: 1232

SELECT	'x'
FROM		pa_resource_lists
WHERE		ROWID = l_rowid_old
FOR UPDATE NOWAIT;

Line: 1242

       SAVEPOINT Update_Resource_List_Pub;

Line: 1262

       p_function_name      => 'PA_PM_UPDATE_RESOURCE_LIST',
       p_msg_count	    => l_msg_count,
       p_msg_data           => l_msg_data,
       p_return_status	    => l_return_status,
       p_function_allowed   => l_function_allowed );

Line: 1461

	l_update_header_flag	:= 'N';

Line: 1462

	l_statement		:= 'UPDATE PA_RESOURCE_LISTS SET ';

Line: 1471

		l_update_header_flag  := 'Y';

Line: 1479

		l_update_header_flag  := 'Y';

Line: 1487

		l_update_header_flag  := 'Y';

Line: 1495

		l_update_header_flag  := 'Y';

Line: 1503

		l_update_header_flag  := 'Y';

Line: 1507

	IF (l_update_header_flag = 'Y') THEN

		l_statement := l_statement ||'LAST_UPDATE_DATE ='||''''||TO_CHAR(g_last_update_date)||''''||',';

Line: 1510

		l_statement := l_statement ||'LAST_UPDATED_BY  ='||''''||TO_CHAR(g_last_updated_by)||''''||',';

Line: 1511

		l_statement := l_statement ||'LAST_UPDATE_LOGIN = '||''''||TO_CHAR(g_last_update_login)||'''';

Line: 1630

		Update_Resource_List_Member
		( p_commit               =>	FND_API.G_FALSE
		, p_init_msg_list        =>	FND_API.G_FALSE
		, p_api_version_number   => 	l_version_update_member
		, p_resource_list_id     =>	l_resource_list_id
		, p_resource_list_member_id  =>	l_resource_list_member_id
		, p_new_alias            =>	p_member_tbl(i).new_alias
		, p_sort_order 		 =>	p_member_tbl(i).sort_order
		, p_enabled_flag 	 =>	p_member_tbl(i).enabled_flag
		, p_return_status 	 =>	p_member_out_tbl(i).return_status
		, p_msg_count            =>	p_msg_count
		, p_msg_data 		 =>	p_msg_data
		);

Line: 1668

        ROLLBACK TO Update_Resource_List_Pub;

Line: 1677

        ROLLBACK TO Update_Resource_List_Pub;

Line: 1693

        ROLLBACK TO Update_Resource_List_Mbr_Pub;

Line: 1703

	ROLLBACK TO Update_Resource_List_Pub;

Line: 1718

END Update_Resource_List;

Line: 1734

PROCEDURE Init_Update_Members IS

l_api_name                CONSTANT   VARCHAR2(30) := 'Init_Update_Members';

Line: 1740

g_member_tbl.DELETE;

Line: 1741

g_member_out_tbl.DELETE;

Line: 1742

g_update_member_tbl_count := 0;

Line: 1743

g_update_resource_list_id := 0;

Line: 1756

END Init_Update_Members;

Line: 1771

PROCEDURE Exec_Update_Resource_List
(p_commit                  IN VARCHAR2 := FND_API.G_FALSE,
p_init_msg_list          IN 	VARCHAR2 := FND_API.G_FALSE,
 p_api_version_number      IN NUMBER,
 p_return_status           OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 p_msg_count               OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
 p_msg_data                OUT NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
)
IS

l_api_version_number   	CONSTANT 	NUMBER := G_API_VERSION_NUMBER;

Line: 1782

l_api_name             	CONSTANT 	VARCHAR2(30) := 'Exec_Update_Resource_List';

Line: 1801

      Update_Resource_List
      (p_commit                 => p_commit,
       p_init_msg_list		=> p_init_msg_list,
       p_api_version_number     => p_api_version_number,
       p_return_status          => p_return_status,
       p_msg_count              => p_msg_count,
       p_msg_data               => p_msg_data,
       p_resource_list_id	=> g_resource_list_rec.resource_list_id,
       p_resource_list_name 	=> g_resource_list_rec.resource_list_name,
       p_new_list_name	 	=> g_resource_list_rec.new_list_name,
       p_grouped_by_type 	=> g_resource_list_rec.group_resource_type,
       p_description 	 	=> g_resource_list_rec.description,
       p_start_date		=> g_resource_list_rec.start_date,
       p_end_date  	 	=> g_resource_list_rec.end_date,
       p_member_tbl             => g_member_tbl,
       p_member_out_tbl      	=> g_member_out_tbl);

Line: 1840

END Exec_Update_Resource_List;

Line: 1856

PROCEDURE Clear_Update_Members IS
BEGIN
  Init_Update_Members;

Line: 1859

END Clear_Update_Members;

Line: 1875

PROCEDURE Delete_Resource_list
( p_commit                  IN VARCHAR2 := FND_API.G_FALSE,
  p_api_version_number     IN  NUMBER,
  p_init_msg_list           IN VARCHAR2 := FND_API.G_FALSE,
  p_resource_list_name     IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_resource_list_id       IN  NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  p_msg_data               OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  p_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  x_err_code               IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  x_err_stage              IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
 )
 IS
l_api_version_number   	CONSTANT NUMBER := G_API_VERSION_NUMBER;

Line: 1889

l_api_name             	CONSTANT VARCHAR2(30) := 'Delete_Resource_List';

Line: 1906

SELECT	'x'
FROM		pa_resource_lists rl
WHERE		rl.resource_list_id = l_resource_list_id
FOR UPDATE NOWAIT;

Line: 1913

	SAVEPOINT Delete_Resource_List_Pub;

Line: 1935

       p_function_name      => 'PA_PM_DELETE_RESOURCE_LIST',
       p_msg_count	    => l_msg_count,
       p_msg_data           => l_msg_data,
       p_return_status	    => l_return_status,
       p_function_allowed   => l_function_allowed );

Line: 1983

   PA_GET_RESOURCE.delete_resource_list_ok(
                   l_resource_list_id => l_resource_list_id,
                   x_err_code         => x_err_code,
                   x_err_stage        => x_err_stage);

Line: 2004

		DELETE
			pa_resource_list_members
		WHERE
			resource_list_id = l_resource_list_id;

Line: 2014

		ROLLBACK TO Delete_Resource_List_Pub;

Line: 2018

			FND_MESSAGE.SET_NAME('PA','PA_RL_MEMBER_DELETE_ERROR');

Line: 2036

		DELETE
			pa_resource_lists
		WHERE
			resource_list_id = l_resource_list_id;

Line: 2046

		ROLLBACK TO Delete_Resource_List_Pub;

Line: 2062

		ROLLBACK TO Delete_Resource_List_Pub;

Line: 2066

			FND_MESSAGE.SET_NAME('PA','PA_RL_DELETE_ERROR');

Line: 2092

        ROLLBACK TO Delete_Resource_List_Pub;

Line: 2101

        ROLLBACK TO Delete_Resource_List_Pub;

Line: 2110

	ROLLBACK TO Delete_Resource_List_Pub;

Line: 2124

END Delete_Resource_list;

Line: 2197

SELECT rl.group_resource_type_id,
       rg.resource_group,
       rl.job_group_id             -- Added for the bug 2486405.
FROM
pa_resource_lists rl,pa_resource_groups_valid_v rg
WHERE rl.resource_list_id = l_resource_list_id
AND   rl.group_resource_type_id = rg.group_resource_type_id;

Line: 2377

 Insert_Members (
             p_resource_list_id          => l_resource_list_id,
             p_group_resource_type       => l_group_resource_type,
             p_resource_type_code        => p_resource_type_code,
             p_resource_group_alias      => l_resource_group_alias,
             p_resource_group_name       => l_resource_group_name,
             p_resource_alias            => p_resource_alias,
             p_sort_order                => l_sort_order,
             p_enabled_flag              => l_enabled_flag,
             p_resource_attr_value       => p_resource_attr_value,
             p_job_group_id              => l_job_group_id,         --Added for bug 2486405.
             p_parent_member_id          => l_parent_member_id,
             p_resource_list_member_id   => l_resource_list_member_id,
             p_track_as_labor_flag       => l_track_as_labor_flag,
             p_err_code                  => l_err_code,
             p_err_stage                 => l_err_stage,
             p_err_stack                 => l_err_stack,
             p_return_status             => l_return_status );

Line: 2489

PROCEDURE Update_Resource_List_Member
( p_commit                  IN VARCHAR2 := FND_API.G_FALSE,
  p_api_version_number     IN  NUMBER,
  p_init_msg_list           IN VARCHAR2 := FND_API.G_FALSE,
  p_resource_list_name     IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_resource_list_id       IN  NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_resource_alias         IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_resource_list_member_id IN NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_new_alias              IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_sort_order             IN  NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_enabled_flag           IN  VARCHAR2      := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  p_msg_data               OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  p_return_status          OUT NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
)
IS

l_api_version_number   CONSTANT NUMBER := G_API_VERSION_NUMBER;

Line: 2507

l_api_name             CONSTANT VARCHAR2(30) := 'Update_Resource_List_Member';

Line: 2516

l_update_member_flag		VARCHAR2(1);

Line: 2536

SELECT	rl.group_resource_type_id
FROM		pa_resource_lists rl
WHERE		rl.resource_list_id = l_resource_list_id;

Line: 2545

SELECT	'x'
FROM		pa_resource_list_members rlm
WHERE		rlm.resource_list_id = l_resource_list_id
AND		rlm.alias = p_new_alias;

Line: 2554

SELECT	rlm.parent_member_id
FROM		pa_resource_list_members rlm
WHERE		rlm.resource_list_member_id = l_resource_list_member_id;

Line: 2563

SELECT	'x'
FROM		pa_resource_list_members rlm
WHERE		rlm.parent_member_id = l_parent_member_id
AND		rlm.alias = p_new_alias;

Line: 2572

SELECT	rlm.alias, rlm.sort_order, rlm.enabled_flag, ROWID
FROM		pa_resource_list_members rlm
WHERE		rlm.resource_list_member_id = l_resource_list_member_id;

Line: 2580

SELECT	'x'
FROM		pa_resource_list_members
WHERE		ROWID = l_rowid_old
FOR UPDATE NOWAIT;

Line: 2591

       SAVEPOINT Update_Resource_List_Mbr_Pub;

Line: 2783

	l_update_member_flag	:= 'N';

Line: 2784

	l_statement		:= 'UPDATE PA_RESOURCE_LIST_MEMBERS SET ';

Line: 2790

		l_update_member_flag  := 'Y';

Line: 2797

		l_update_member_flag  := 'Y';

Line: 2804

		l_update_member_flag  := 'Y';

Line: 2807

	IF (l_update_member_flag = 'Y') THEN

		l_statement := l_statement ||'LAST_UPDATE_DATE = '||''''||TO_CHAR(g_last_update_date)||''''||',';

Line: 2810

		l_statement := l_statement ||'LAST_UPDATED_BY  = '||''''||TO_CHAR(g_last_updated_by)||''''||',';

Line: 2811

		l_statement := l_statement ||'LAST_UPDATE_LOGIN =
'||''''||TO_CHAR(g_last_update_login)||'''';

Line: 2842

        ROLLBACK TO Update_Resource_List_Mbr_Pub;

Line: 2851

        ROLLBACK TO Update_Resource_List_Mbr_Pub;

Line: 2867

        ROLLBACK TO Update_Resource_List_Mbr_Pub;

Line: 2877

	ROLLBACK TO Update_Resource_List_Mbr_Pub;

Line: 2890

END Update_Resource_List_Member;

Line: 2905

PROCEDURE Delete_Resource_list_Member
( p_commit                  IN VARCHAR2 := FND_API.G_FALSE,
  p_init_msg_list            IN VARCHAR2 := FND_API.G_FALSE,
  p_api_version_number      IN NUMBER,
  p_resource_list_name     IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_resource_list_id       IN  NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_resource_alias         IN  VARCHAR2     := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR,
  p_resource_list_member_id IN NUMBER       := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
  p_msg_count              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  p_msg_data               OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  p_return_status          OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
  x_err_code               IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
  x_err_stage              IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
 )

IS

l_api_version_number   	CONSTANT 	NUMBER := G_API_VERSION_NUMBER;

Line: 2923

l_api_name             	CONSTANT	VARCHAR2(30) := 'Delete_Resource_List_Member';

Line: 2941

SELECT	'x'
FROM		pa_resource_list_members rlm
WHERE		rlm.resource_list_member_id = l_resource_list_member_id
FOR UPDATE NOWAIT;

Line: 2949

SELECT  parent_member_id
FROM pa_resource_list_members
WHERE resource_list_member_id = x_resource_list_member_id;

Line: 2954

SELECT resource_list_member_id
FROM pa_resource_list_members
WHERE parent_member_id =x_parent_member_id
AND resource_type_code ='UNCLASSIFIED';

Line: 2960

	SAVEPOINT Delete_Resource_List_Mbr_Pub;

Line: 3044

PA_GET_RESOURCE.delete_resource_list_member_ok(l_resource_list_id,l_resource_list_member_id,x_err_code,x_err_stage);

Line: 3069

	DELETE
		pa_resource_list_members
	WHERE
		resource_list_member_id = l_resource_list_member_id;

Line: 3084

/*Before Deleting the unclassified Resource , check whether it can be deleted. The same check is done for unclassified resource as for normal resource list member. */

    IF l_unclassified_list_member_id IS NOT NULL THEN

     pa_get_resource.delete_resource_list_member_ok(
              		L_RESOURCE_LIST_ID        =>l_resource_list_id,
	         	L_RESOURCE_LIST_MEMBER_ID =>l_unclassified_list_member_id,
		        X_ERR_CODE                =>x_err_code,
		        X_ERR_STAGE               =>x_err_stage);

Line: 3098

         pa_resource_list_pkg.Delete_Unclassified_Child(
                       X_RESOURCE_LIST_ID   =>l_resource_list_id,
                       X_PARENT_MEMBER_ID   =>l_parent_member_id,
                       X_MSG_COUNT          =>x_err_code,
                       X_MSG_DATA           =>x_err_stage,
                       X_RETURN_STATUS      =>l_return_status);

Line: 3126

	        	ROLLBACK TO Delete_Resource_List_Mbr_Pub;

Line: 3135

	        	ROLLBACK TO Delete_Resource_List_Mbr_Pub;

Line: 3144

        		ROLLBACK TO Delete_Resource_List_Mbr_Pub;

Line: 3160

		ROLLBACK TO Delete_Resource_List_Mbr_Pub;

Line: 3174

END Delete_Resource_list_Member;

Line: 3233

SELECT  	rlm.resource_list_member_id
FROM 		pa_resource_list_members rlm
WHERE 	rlm.resource_list_id = l_resource_list_id
		AND	rlm.parent_member_id IS NULL
	       	AND	rlm.alias = l_resource_group_alias;

Line: 3245

SELECT 	rlm.ROWID, rlm.resource_list_member_id
FROM		pa_resource_list_members rlm,
		pa_resources r,
		pa_resource_types rt
WHERE		rlm.resource_id = r.resource_id
		AND		r.resource_type_id =  rt.resource_type_id
		AND		rt.resource_type_code <> 'UNCLASSIFIED'
		AND		rlm.resource_list_id = l_resource_list_id
		AND		rlm.parent_member_id IS NULL
		AND		rlm.alias = NVL(l_resource_group_alias,rlm.alias)
		ORDER BY 	DECODE(p_sort_by,'ALIAS',rlm.alias,'RESOURCE_NAME', r.name, rlm.alias);

Line: 3261

SELECT 	rlm.ROWID
FROM		pa_resource_list_members rlm,
		pa_resources r,
		pa_resource_types rt
WHERE		rlm.resource_id = r.resource_id
		AND		rlm.parent_member_id = l_rg_rlm_id
		AND		r.resource_type_id =  rt.resource_type_id
		AND		rt.resource_type_code <> 'UNCLASSIFIED'
		ORDER BY 	DECODE(p_sort_by,'ALIAS',rlm.alias,'RESOURCE_NAME', r.name, rlm.alias);

Line: 3275

SELECT	'x'
FROM		pa_resource_list_members rlm
WHERE		rlm.resource_list_id = l_resource_list_id
FOR UPDATE NOWAIT;

Line: 3284

SELECT	'x'
FROM		pa_resource_list_members rlm
WHERE		(rlm.resource_list_member_id = l_resource_list_member_id
			OR rlm.parent_member_id = l_resource_list_member_id)
FOR UPDATE NOWAIT;

Line: 3445

			UPDATE 	pa_resource_list_members
			SET 		sort_order =	l_mbr_sort_order
			WHERE		ROWID	=	l_mbr_rowid;

Line: 3454

		UPDATE 	pa_resource_list_members
		SET 		sort_order =	l_rg_sort_order
		WHERE		ROWID	=	l_rg_rowid;

Line: 3543

SELECT resource_list_id
FROM
pa_resource_lists
WHERE
name = p_resource_list_name;

Line: 3611

SELECT 	'x'
FROM 		pa_resource_lists
WHERE 	resource_list_id  = p_resource_list_id;

Line: 3707

SELECT resource_list_member_id
FROM
pa_resource_list_members
WHERE resource_list_id  = p_resource_list_id
AND   alias             = p_alias;

Line: 3783

SELECT 	'x'
FROM 	pa_resource_list_members
WHERE 	resource_list_member_id  = p_resource_list_member_id
AND     resource_list_id         = p_resource_list_id
AND     nvl(object_id, -99)      = nvl(p_object_id, -99)
AND     nvl(object_type, 'D')    = nvl(p_object_type, 'D');

Line: 3793

SELECT migration_code, control_flag
INTO   l_migration_code, l_control_flag
FROM   pa_resource_lists_all_bg
WHERE  resource_list_id = p_resource_list_id;

Line: 3844

           SELECT resource_list_member_id
             INTO l_resource_list_member_id
             FROM pa_resource_list_members
            WHERE resource_list_id  = p_resource_list_id
              AND object_type       = l_object_type
              AND object_id         = l_object_id
              AND alias             = p_alias;

Line: 3914

SELECT 	employee_name
FROM 	pa_employees_res_v
WHERE 	person_id  = TO_NUMBER(l_resource_attr_value);

Line: 3920

SELECT 	job_name
FROM 	pa_jobs_res_v
WHERE 	job_id  = TO_NUMBER(l_resource_attr_value);

Line: 3926

SELECT 	organization_name
FROM 	pa_organizations_res_v
WHERE 	organization_id  = TO_NUMBER(l_resource_attr_value);

Line: 3932

SELECT 	vendor_name
FROM 	pa_vendors_res_v
WHERE 	vendor_id  = TO_NUMBER(l_resource_attr_value);

Line: 3938

SELECT 	expenditure_type
FROM 	pa_expenditure_types_res_v
WHERE 	expenditure_type  = l_resource_attr_value;

Line: 3944

SELECT 	expenditure_category
FROM 	pa_expend_categories_res_v
WHERE 	expenditure_category  = l_resource_attr_value;

Line: 3950

SELECT 	event_type
FROM 	pa_event_types_res_v
WHERE 	event_type  = l_resource_attr_value;

Line: 3956

SELECT 	revenue_category_code
FROM 	pa_revenue_categories_res_v
WHERE 	revenue_category_code  = l_resource_attr_value;

Line: 4137

   SELECT migration_code
     INTO l_migration_code
     FROM pa_resource_list_members
    WHERE resource_list_member_id = p_resource_list_member_id;

Line: 4168

   SELECT migration_code
     INTO l_migration_code
     FROM pa_resource_lists_all_bg
    WHERE resource_list_id = p_resource_list_id;