eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 73: pa_resource_lists_all_bg

69: CURSOR c_res_list_csr IS
70: SELECT
71: group_resource_type_id
72: FROM
73: pa_resource_lists_all_bg
74: WHERE resource_list_id = p_resource_list_id;
75:
76: CURSOR c_res_list_member_csr_1 IS
77: SELECT 'x'

Line 770: * before inserting into the pa_resource_lists_all_bg

766: END IF;
767: /**************************************************
768: * Bug - 3501039
769: * Desc - taking a substr of the p_resource_list_name
770: * before inserting into the pa_resource_lists_all_bg
771: * table.
772: ************************************************/
773: l_resource_list_name := substr(p_resource_list_name,0,58);
774: INSERT INTO pa_resource_lists_all_bg (

Line 774: INSERT INTO pa_resource_lists_all_bg (

770: * before inserting into the pa_resource_lists_all_bg
771: * table.
772: ************************************************/
773: l_resource_list_name := substr(p_resource_list_name,0,58);
774: INSERT INTO pa_resource_lists_all_bg (
775: resource_list_id,
776: name,
777: business_group_id,
778: description,

Line 1193: FROM pa_resource_lists_all_bg rl

1189: --Using pa_resource_list_assignments_v instead of
1190: --pa_resource_list_assignments.
1191: CURSOR chk_wp_disable IS
1192: SELECT 'N'
1193: FROM pa_resource_lists_all_bg rl
1194: WHERE rl.resource_list_id = p_resource_list_id
1195: AND rl.use_for_wp_flag <> p_use_for_wp_flag
1196: --AND exists (select 'Y' from pa_resource_list_assignments rla
1197: AND exists (select 'Y' from pa_resource_list_assignments_v rla

Line 1206: FROM pa_resource_lists_all_bg rl

1202: --Using pa_resource_list_assignments_v instead of
1203: --pa_resource_list_assignments.
1204: CURSOR chk_ctrl_changed IS
1205: SELECT 'N'
1206: FROM pa_resource_lists_all_bg rl
1207: WHERE rl.resource_list_id = p_resource_list_id
1208: AND rl.control_flag <> p_control_flag
1209: --AND exists (select 'Y' from pa_resource_list_assignments rla
1210: AND exists (select 'Y' from pa_resource_list_assignments_v rla

Line 1221: FROM pa_resource_lists_all_bg

1217: AND job_id IS NOT NULL;
1218:
1219: CURSOR get_job_group_id IS
1220: SELECT job_group_id
1221: FROM pa_resource_lists_all_bg
1222: WHERE resource_list_id = p_resource_list_id;
1223:
1224: /********************************************
1225: * Bug : 3473679

Line 1232: FROM pa_resource_lists_all_bg

1228: * the database.
1229: ********************************************/
1230: CURSOR get_wp_flag IS
1231: SELECT use_for_wp_flag
1232: FROM pa_resource_lists_all_bg
1233: WHERE resource_list_id = p_resource_list_id;
1234:
1235: CURSOR chk_migrated_list IS
1236: SELECT 'N'

Line 1237: FROM pa_resource_lists_all_bg rl

1233: WHERE resource_list_id = p_resource_list_id;
1234:
1235: CURSOR chk_migrated_list IS
1236: SELECT 'N'
1237: FROM pa_resource_lists_all_bg rl
1238: WHERE rl.resource_list_id = p_resource_list_id
1239: AND rl.control_flag <> p_control_flag
1240: AND rl.migration_code = 'M';
1241:

Line 1461: update pa_resource_lists_all_bg

1457: close chk_job_group_allow;
1458:
1459: END IF;
1460: --Bug 3501039
1461: update pa_resource_lists_all_bg
1462: set name = substr(nvl(p_resource_list_name, name),0,58),
1463: description = p_description,
1464: job_group_id = p_job_group_id,
1465: start_date_active = nvl(p_start_date, start_date_active),

Line 1701: pa_resource_lists_all_bg

1697: OR p_resource_list_id IS NULL);
1698:
1699: CURSOR check_old_lists IS
1700: SELECT 'N' FROM
1701: pa_resource_lists_all_bg
1702: WHERE NAME = p_resource_list_name
1703: AND ((resource_list_id <> p_resource_list_id
1704: AND p_resource_list_id IS NOT NULL)
1705: OR p_resource_list_id IS NULL);

Line 2048: pa_resource_lists_all_bg

2044: CURSOR c_resource_lists_csr IS
2045: SELECT
2046: group_resource_type_id
2047: FROM
2048: pa_resource_lists_all_bg
2049: WHERE resource_list_id = p_resource_list_id;
2050:
2051: CURSOR c_resource_types_csr IS
2052: SELECT

Line 2872: pa_resource_lists_all_bg

2868: CURSOR c_res_list_csr IS
2869: SELECT
2870: group_resource_type_id
2871: FROM
2872: pa_resource_lists_all_bg
2873: WHERE resource_list_id = p_resource_list_id;
2874:
2875: CURSOR c_resource_types_csr IS
2876: SELECT

Line 3695: FROM pa_resource_lists_all_bg

3691: start_date_active, end_date_active, uncategorized_flag,
3692: control_flag,migration_code,use_for_wp_flag,
3693: last_updated_by, last_update_date, creation_date,
3694: created_by, last_update_login
3695: FROM pa_resource_lists_all_bg
3696: WHERE business_group_id = -3113;
3697:
3698: BEGIN
3699:

Line 3720: INSERT INTO pa_resource_lists_all_bg (

3716: FROM sys.dual;
3717:
3718: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';
3719:
3720: INSERT INTO pa_resource_lists_all_bg (
3721: resource_list_id
3722: , name
3723: , business_group_id
3724: , description

Line 3868: --The Check:check whether the 'X_RESOURCE_LIST_ID' exists in the 'pa_resource_lists_all_bg' table before inserting records into 'pa_resource_list_members' table

3864: , rlm.UNIT_OF_MEASURE
3865: FROM pa_resource_list_members rlm
3866: WHERE rlm.resource_list_id = eachRL.resource_list_id
3867: --begin:bug:5925973:Implementing the logic to restrict the creation of resource list member records when new OU ('Implementation Options' form of the OU)is created for an existing Business Group.
3868: --The Check:check whether the 'X_RESOURCE_LIST_ID' exists in the 'pa_resource_lists_all_bg' table before inserting records into 'pa_resource_list_members' table
3869: AND EXISTS
3870: (SELECT NULL
3871: FROM pa_resource_lists_all_bg T1
3872: WHERE T1.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);

Line 3871: FROM pa_resource_lists_all_bg T1

3867: --begin:bug:5925973:Implementing the logic to restrict the creation of resource list member records when new OU ('Implementation Options' form of the OU)is created for an existing Business Group.
3868: --The Check:check whether the 'X_RESOURCE_LIST_ID' exists in the 'pa_resource_lists_all_bg' table before inserting records into 'pa_resource_list_members' table
3869: AND EXISTS
3870: (SELECT NULL
3871: FROM pa_resource_lists_all_bg T1
3872: WHERE T1.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);
3873: --end:bug:5925973
3874: END LOOP;
3875:

Line 3968: delete from pa_resource_lists_all_bg

3964: delete from pa_resource_lists_tl
3965: where resource_list_id = p_resource_list_id;
3966:
3967: -- Delete the planning resource list
3968: delete from pa_resource_lists_all_bg
3969: where resource_list_id = p_resource_list_id;
3970:
3971: END Delete_Plan_Res_List;
3972:

Line 4013: from PA_RESOURCE_LISTS_ALL_BG B

4009: begin
4010: delete from pa_resource_lists_tl T
4011: where not exists
4012: (select NULL
4013: from PA_RESOURCE_LISTS_ALL_BG B
4014: where B.RESOURCE_LIST_ID = T.resource_list_id
4015: );
4016:
4017: update pa_resource_lists_tl T set (

Line 4122: FROM pa_resource_lists_all_bg

4118:
4119: BEGIN
4120: SELECT Control_flag
4121: INTO l_central_control
4122: FROM pa_resource_lists_all_bg
4123: where resource_list_id = p_resource_list_id;
4124: EXCEPTION
4125: WHEN OTHERS THEN
4126: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

Line 4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,

4396: PROCEDURE COPY_RESOURCE_LIST(
4397: P_Commit IN Varchar2 Default Fnd_Api.G_False,
4398: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4399: P_API_Version_Number IN Number,
4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,

Line 4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,

4397: P_Commit IN Varchar2 Default Fnd_Api.G_False,
4398: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4399: P_API_Version_Number IN Number,
4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,

Line 4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,

4398: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4399: P_API_Version_Number IN Number,
4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,

Line 4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,

4399: P_API_Version_Number IN Number,
4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,

Line 4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,

4400: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4408: p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688

Line 4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,

4401: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4408: p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688
4409: x_return_status OUT NOCOPY Varchar2,

Line 4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,

4402: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4408: p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688
4409: x_return_status OUT NOCOPY Varchar2,
4410: x_msg_data OUT NOCOPY Varchar2,

Line 4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,

4403: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4404: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4405: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4406: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4407: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4408: p_Enable_Resource_Classes IN VARCHAR2 DEFAULT 'Y', -- Added for CBS Bug13535688
4409: x_return_status OUT NOCOPY Varchar2,
4410: x_msg_data OUT NOCOPY Varchar2,
4411: x_msg_count OUT NOCOPY NUMBER

Line 4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;

4410: x_msg_data OUT NOCOPY Varchar2,
4411: x_msg_count OUT NOCOPY NUMBER
4412: )
4413: IS
4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;

Line 4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;

4411: x_msg_count OUT NOCOPY NUMBER
4412: )
4413: IS
4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;

Line 4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;

4412: )
4413: IS
4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;

Line 4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;

4413: IS
4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4421: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

Line 4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;

4414: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4421: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4422: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

Line 4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;

4415: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4421: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4422: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4423: l_resource_list_id NUMBER:=NULL;

Line 4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;

4416: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4417: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4421: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4422: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4423: l_resource_list_id NUMBER:=NULL;
4424: --3596702

Line 4422: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

4418: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4419: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4420: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4421: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4422: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4423: l_resource_list_id NUMBER:=NULL;
4424: --3596702
4425: l_res_list_member_id Number;
4426:

Line 4561: --Get needed data of parent resource list from pa_resource_lists_all_bg

4557: -- hr_utility.trace('l_error_raised =Y');
4558: Raise l_error;
4559: END IF;
4560:
4561: --Get needed data of parent resource list from pa_resource_lists_all_bg
4562: SELECT
4563: public_flag,
4564: group_resource_type_id,
4565: uncategorized_flag,

Line 4580: pa_resource_lists_all_bg

4576: p_adw_notify_flag,
4577: p_resource_list_type,
4578: p_migration_code
4579: FROM
4580: pa_resource_lists_all_bg
4581: WHERE
4582: resource_list_id=p_parent_resource_list_id;
4583:
4584: -- hr_utility.trace('BG insert');

Line 4586: --Call Insert_row which inserts a row into PA_RESOURCE_LISTS_ALL_BG table

4582: resource_list_id=p_parent_resource_list_id;
4583:
4584: -- hr_utility.trace('BG insert');
4585:
4586: --Call Insert_row which inserts a row into PA_RESOURCE_LISTS_ALL_BG table
4587: PA_Resource_List_tbl_Pkg.Insert_Row(
4588: p_name,
4589: p_description,
4590: p_public_flag,

Line 5000: FROM pa_resource_lists_all_bg

4996: ***************************************************/
4997: BEGIN
4998: SELECT control_flag
4999: INTO l_control_flag
5000: FROM pa_resource_lists_all_bg
5001: WHERE resource_list_id = l_resource_list_id;
5002: EXCEPTION
5003: WHEN OTHERS THEN
5004: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

Line 5287: PA_RESOURCE_LISTS_ALL_BG

5283: CURSOR RES_CUR IS
5284: Select
5285: Rowid
5286: from
5287: PA_RESOURCE_LISTS_ALL_BG
5288: Where Resource_List_Id = P_Resource_List_Id;
5289:
5290: BEGIN
5291:

Line 5301: FROM pa_resource_lists_all_bg

5297:
5298: --Commented the following two Selects For Bug#5094347. These are not used anywhere in the code.
5299: /*SELECT ROWID
5300: INTO l_row_id
5301: FROM pa_resource_lists_all_bg
5302: WHERE resource_list_id = P_RESOURCE_LIST_ID;
5303:
5304: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)
5305: INTO l_resource_list_id

Line 5316: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.

5312: --in case no_data_found exception is returned by previous API, then we get
5313: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
5314: --is empty. This is due to the fact that although no_data_found has been raised while updating
5315: --record in table pa_resource_lists_tl, we try to insert the same record in table
5316: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
5317: --Hence we have coded this API to update the records directly in _BG and _TL tables
5318: --and in case of no_data_found exception we insert records in respective tables.
5319:
5320: Update PA_RESOURCE_LISTS_ALL_BG

Line 5320: Update PA_RESOURCE_LISTS_ALL_BG

5316: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
5317: --Hence we have coded this API to update the records directly in _BG and _TL tables
5318: --and in case of no_data_found exception we insert records in respective tables.
5319:
5320: Update PA_RESOURCE_LISTS_ALL_BG
5321: SET
5322: NAME = P_NAME ,
5323: DESCRIPTION = P_DESCRIPTION ,
5324: PUBLIC_FLAG = P_PUBLIC_FLAG ,

Line 5338: Insert Into PA_RESOURCE_LISTS_ALL_BG

5334: LAST_UPDATE_LOGIN = 0
5335: WHERE RESOURCE_LIST_ID = P_RESOURCE_LIST_ID;
5336:
5337: If SQL%NOTFOUND Then
5338: Insert Into PA_RESOURCE_LISTS_ALL_BG
5339: (
5340: RESOURCE_LIST_ID,
5341: NAME ,
5342: DESCRIPTION ,