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 758: * before inserting into the pa_resource_lists_all_bg

754: END IF;
755: /**************************************************
756: * Bug - 3501039
757: * Desc - taking a substr of the p_resource_list_name
758: * before inserting into the pa_resource_lists_all_bg
759: * table.
760: ************************************************/
761: l_resource_list_name := substr(p_resource_list_name,0,58);
762: INSERT INTO pa_resource_lists_all_bg (

Line 762: INSERT INTO pa_resource_lists_all_bg (

758: * before inserting into the pa_resource_lists_all_bg
759: * table.
760: ************************************************/
761: l_resource_list_name := substr(p_resource_list_name,0,58);
762: INSERT INTO pa_resource_lists_all_bg (
763: resource_list_id,
764: name,
765: business_group_id,
766: description,

Line 1067: FROM pa_resource_lists_all_bg rl

1063: --Using pa_resource_list_assignments_v instead of
1064: --pa_resource_list_assignments.
1065: CURSOR chk_wp_disable IS
1066: SELECT 'N'
1067: FROM pa_resource_lists_all_bg rl
1068: WHERE rl.resource_list_id = p_resource_list_id
1069: AND rl.use_for_wp_flag <> p_use_for_wp_flag
1070: --AND exists (select 'Y' from pa_resource_list_assignments rla
1071: AND exists (select 'Y' from pa_resource_list_assignments_v rla

Line 1080: FROM pa_resource_lists_all_bg rl

1076: --Using pa_resource_list_assignments_v instead of
1077: --pa_resource_list_assignments.
1078: CURSOR chk_ctrl_changed IS
1079: SELECT 'N'
1080: FROM pa_resource_lists_all_bg rl
1081: WHERE rl.resource_list_id = p_resource_list_id
1082: AND rl.control_flag <> p_control_flag
1083: --AND exists (select 'Y' from pa_resource_list_assignments rla
1084: AND exists (select 'Y' from pa_resource_list_assignments_v rla

Line 1095: FROM pa_resource_lists_all_bg

1091: AND job_id IS NOT NULL;
1092:
1093: CURSOR get_job_group_id IS
1094: SELECT job_group_id
1095: FROM pa_resource_lists_all_bg
1096: WHERE resource_list_id = p_resource_list_id;
1097:
1098: /********************************************
1099: * Bug : 3473679

Line 1106: FROM pa_resource_lists_all_bg

1102: * the database.
1103: ********************************************/
1104: CURSOR get_wp_flag IS
1105: SELECT use_for_wp_flag
1106: FROM pa_resource_lists_all_bg
1107: WHERE resource_list_id = p_resource_list_id;
1108:
1109: CURSOR chk_migrated_list IS
1110: SELECT 'N'

Line 1111: FROM pa_resource_lists_all_bg rl

1107: WHERE resource_list_id = p_resource_list_id;
1108:
1109: CURSOR chk_migrated_list IS
1110: SELECT 'N'
1111: FROM pa_resource_lists_all_bg rl
1112: WHERE rl.resource_list_id = p_resource_list_id
1113: AND rl.control_flag <> p_control_flag
1114: AND rl.migration_code = 'M';
1115:

Line 1301: update pa_resource_lists_all_bg

1297: close chk_job_group_allow;
1298:
1299: END IF;
1300: --Bug 3501039
1301: update pa_resource_lists_all_bg
1302: set name = substr(nvl(p_resource_list_name, name),0,58),
1303: description = p_description,
1304: job_group_id = p_job_group_id,
1305: start_date_active = nvl(p_start_date, start_date_active),

Line 1357: pa_resource_lists_all_bg

1353: OR p_resource_list_id IS NULL);
1354:
1355: CURSOR check_old_lists IS
1356: SELECT 'N' FROM
1357: pa_resource_lists_all_bg
1358: WHERE NAME = p_resource_list_name
1359: AND ((resource_list_id <> p_resource_list_id
1360: AND p_resource_list_id IS NOT NULL)
1361: OR p_resource_list_id IS NULL);

Line 1700: pa_resource_lists_all_bg

1696: CURSOR c_resource_lists_csr IS
1697: SELECT
1698: group_resource_type_id
1699: FROM
1700: pa_resource_lists_all_bg
1701: WHERE resource_list_id = p_resource_list_id;
1702:
1703: CURSOR c_resource_types_csr IS
1704: SELECT

Line 2524: pa_resource_lists_all_bg

2520: CURSOR c_res_list_csr IS
2521: SELECT
2522: group_resource_type_id
2523: FROM
2524: pa_resource_lists_all_bg
2525: WHERE resource_list_id = p_resource_list_id;
2526:
2527: CURSOR c_resource_types_csr IS
2528: SELECT

Line 3346: FROM pa_resource_lists_all_bg

3342: start_date_active, end_date_active, uncategorized_flag,
3343: control_flag,migration_code,use_for_wp_flag,
3344: last_updated_by, last_update_date, creation_date,
3345: created_by, last_update_login
3346: FROM pa_resource_lists_all_bg
3347: WHERE business_group_id = -3113;
3348:
3349: BEGIN
3350:

Line 3371: INSERT INTO pa_resource_lists_all_bg (

3367: FROM sys.dual;
3368:
3369: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';
3370:
3371: INSERT INTO pa_resource_lists_all_bg (
3372: resource_list_id
3373: , name
3374: , business_group_id
3375: , description

Line 3519: --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

3515: , rlm.UNIT_OF_MEASURE
3516: FROM pa_resource_list_members rlm
3517: WHERE rlm.resource_list_id = eachRL.resource_list_id
3518: --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.
3519: --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
3520: AND EXISTS
3521: (SELECT NULL
3522: FROM pa_resource_lists_all_bg T1
3523: WHERE T1.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);

Line 3522: FROM pa_resource_lists_all_bg T1

3518: --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.
3519: --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
3520: AND EXISTS
3521: (SELECT NULL
3522: FROM pa_resource_lists_all_bg T1
3523: WHERE T1.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);
3524: --end:bug:5925973
3525: END LOOP;
3526:

Line 3619: delete from pa_resource_lists_all_bg

3615: delete from pa_resource_lists_tl
3616: where resource_list_id = p_resource_list_id;
3617:
3618: -- Delete the planning resource list
3619: delete from pa_resource_lists_all_bg
3620: where resource_list_id = p_resource_list_id;
3621:
3622: END Delete_Plan_Res_List;
3623:

Line 3664: from PA_RESOURCE_LISTS_ALL_BG B

3660: begin
3661: delete from pa_resource_lists_tl T
3662: where not exists
3663: (select NULL
3664: from PA_RESOURCE_LISTS_ALL_BG B
3665: where B.RESOURCE_LIST_ID = T.resource_list_id
3666: );
3667:
3668: update pa_resource_lists_tl T set (

Line 3773: FROM pa_resource_lists_all_bg

3769:
3770: BEGIN
3771: SELECT Control_flag
3772: INTO l_central_control
3773: FROM pa_resource_lists_all_bg
3774: where resource_list_id = p_resource_list_id;
3775: EXCEPTION
3776: WHEN OTHERS THEN
3777: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

Line 4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,

4045: PROCEDURE COPY_RESOURCE_LIST(
4046: P_Commit IN Varchar2 Default Fnd_Api.G_False,
4047: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4048: P_API_Version_Number IN Number,
4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,

Line 4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,

4046: P_Commit IN Varchar2 Default Fnd_Api.G_False,
4047: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4048: P_API_Version_Number IN Number,
4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,

Line 4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,

4047: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
4048: P_API_Version_Number IN Number,
4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,

Line 4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,

4048: P_API_Version_Number IN Number,
4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,

Line 4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,

4049: p_parent_resource_list_id IN PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE,
4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4057: x_return_status OUT NOCOPY Varchar2,

Line 4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,

4050: p_name IN PA_RESOURCE_LISTS_ALL_BG.name%TYPE,
4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4057: x_return_status OUT NOCOPY Varchar2,
4058: x_msg_data OUT NOCOPY Varchar2,

Line 4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,

4051: p_description IN PA_RESOURCE_LISTS_ALL_BG.description%TYPE,
4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4057: x_return_status OUT NOCOPY Varchar2,
4058: x_msg_data OUT NOCOPY Varchar2,
4059: x_msg_count OUT NOCOPY NUMBER

Line 4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,

4052: p_start_date_active IN PA_RESOURCE_LISTS_ALL_BG.START_DATE_ACTIVE%TYPE,
4053: p_end_date_active IN PA_RESOURCE_LISTS_ALL_BG.END_DATE_ACTIVE%TYPE,
4054: p_job_group_id IN PA_RESOURCE_LISTS_ALL_BG.JOB_GROUP_ID%TYPE,
4055: p_control_flag IN PA_RESOURCE_LISTS_ALL_BG.CONTROL_FLAG%TYPE,
4056: p_use_for_wp_flag IN PA_RESOURCE_LISTS_ALL_BG.USE_FOR_WP_FLAG%TYPE,
4057: x_return_status OUT NOCOPY Varchar2,
4058: x_msg_data OUT NOCOPY Varchar2,
4059: x_msg_count OUT NOCOPY NUMBER
4060: )

Line 4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;

4058: x_msg_data OUT NOCOPY Varchar2,
4059: x_msg_count OUT NOCOPY NUMBER
4060: )
4061: IS
4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;

Line 4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;

4059: x_msg_count OUT NOCOPY NUMBER
4060: )
4061: IS
4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;

Line 4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;

4060: )
4061: IS
4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;

Line 4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;

4061: IS
4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4069: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

Line 4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;

4062: p_public_flag PA_RESOURCE_LISTS_ALL_BG.public_flag%TYPE;
4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4069: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4070: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

Line 4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;

4063: p_group_resource_type_id PA_RESOURCE_LISTS_ALL_BG.group_resource_type_id%TYPE;
4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4069: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4070: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4071: l_resource_list_id NUMBER:=NULL;

Line 4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;

4064: p_uncategorized_flag PA_RESOURCE_LISTS_ALL_BG.uncategorized_flag%TYPE;
4065: p_business_group_id PA_RESOURCE_LISTS_ALL_BG.business_group_id%TYPE;
4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4069: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4070: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4071: l_resource_list_id NUMBER:=NULL;
4072: --3596702

Line 4070: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

4066: p_adw_notify_flag PA_RESOURCE_LISTS_ALL_BG.adw_notify_flag%TYPE;
4067: p_resource_list_type PA_RESOURCE_LISTS_ALL_BG.resource_list_type%TYPE;
4068: p_migration_code PA_RESOURCE_LISTS_ALL_BG.migration_code%TYPE;
4069: l_resource_list_member_id PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
4070: x_resource_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
4071: l_resource_list_id NUMBER:=NULL;
4072: --3596702
4073: l_res_list_member_id Number;
4074:

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

4205: -- hr_utility.trace('l_error_raised =Y');
4206: Raise l_error;
4207: END IF;
4208:
4209: --Get needed data of parent resource list from pa_resource_lists_all_bg
4210: SELECT
4211: public_flag,
4212: group_resource_type_id,
4213: uncategorized_flag,

Line 4228: pa_resource_lists_all_bg

4224: p_adw_notify_flag,
4225: p_resource_list_type,
4226: p_migration_code
4227: FROM
4228: pa_resource_lists_all_bg
4229: WHERE
4230: resource_list_id=p_parent_resource_list_id;
4231:
4232: -- hr_utility.trace('BG insert');

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

4230: resource_list_id=p_parent_resource_list_id;
4231:
4232: -- hr_utility.trace('BG insert');
4233:
4234: --Call Insert_row which inserts a row into PA_RESOURCE_LISTS_ALL_BG table
4235: PA_Resource_List_tbl_Pkg.Insert_Row(
4236: p_name,
4237: p_description,
4238: p_public_flag,

Line 4645: FROM pa_resource_lists_all_bg

4641: ***************************************************/
4642: BEGIN
4643: SELECT control_flag
4644: INTO l_control_flag
4645: FROM pa_resource_lists_all_bg
4646: WHERE resource_list_id = l_resource_list_id;
4647: EXCEPTION
4648: WHEN OTHERS THEN
4649: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

Line 4932: PA_RESOURCE_LISTS_ALL_BG

4928: CURSOR RES_CUR IS
4929: Select
4930: Rowid
4931: from
4932: PA_RESOURCE_LISTS_ALL_BG
4933: Where Resource_List_Id = P_Resource_List_Id;
4934:
4935: BEGIN
4936:

Line 4946: FROM pa_resource_lists_all_bg

4942:
4943: --Commented the following two Selects For Bug#5094347. These are not used anywhere in the code.
4944: /*SELECT ROWID
4945: INTO l_row_id
4946: FROM pa_resource_lists_all_bg
4947: WHERE resource_list_id = P_RESOURCE_LIST_ID;
4948:
4949: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)
4950: INTO l_resource_list_id

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

4957: --in case no_data_found exception is returned by previous API, then we get
4958: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl
4959: --is empty. This is due to the fact that although no_data_found has been raised while updating
4960: --record in table pa_resource_lists_tl, we try to insert the same record in table
4961: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
4962: --Hence we have coded this API to update the records directly in _BG and _TL tables
4963: --and in case of no_data_found exception we insert records in respective tables.
4964:
4965: Update PA_RESOURCE_LISTS_ALL_BG

Line 4965: Update PA_RESOURCE_LISTS_ALL_BG

4961: --PA_RESOURCE_LISTS_ALL_BG in call to PA_Resource_List_tbl_Pkg.Insert_Row.
4962: --Hence we have coded this API to update the records directly in _BG and _TL tables
4963: --and in case of no_data_found exception we insert records in respective tables.
4964:
4965: Update PA_RESOURCE_LISTS_ALL_BG
4966: SET
4967: NAME = P_NAME ,
4968: DESCRIPTION = P_DESCRIPTION ,
4969: PUBLIC_FLAG = P_PUBLIC_FLAG ,

Line 4983: Insert Into PA_RESOURCE_LISTS_ALL_BG

4979: LAST_UPDATE_LOGIN = 0
4980: WHERE RESOURCE_LIST_ID = P_RESOURCE_LIST_ID;
4981:
4982: If SQL%NOTFOUND Then
4983: Insert Into PA_RESOURCE_LISTS_ALL_BG
4984: (
4985: RESOURCE_LIST_ID,
4986: NAME ,
4987: DESCRIPTION ,