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

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 158: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';

154: BEGIN
155: l_old_stack := p_err_stack;
156: p_err_code := 0;
157: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_group';
158: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
159:
160: -- Get Resource List Id ,Group_resource_type_id from
161: -- PA_RESOURCE_LISTS with the
162: -- X_Resource_list_id.

Line 161: -- PA_RESOURCE_LISTS with the

157: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_group';
158: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
159:
160: -- Get Resource List Id ,Group_resource_type_id from
161: -- PA_RESOURCE_LISTS with the
162: -- X_Resource_list_id.
163: OPEN c_res_list_csr;
164: FETCH c_res_list_csr INTO
165: l_resource_type_id;

Line 584: pa_resource_lists

580: l_resource_list_name Varchar2(60);
581:
582: CURSOR c_res_list_csr IS
583: SELECT 'x' FROM
584: pa_resource_lists
585: WHERE NAME = p_resource_list_name;
586:
587: CURSOR c_res_list_member_seq_csr IS
588: SELECT

Line 621: SELECT pa_resource_lists_s.NEXTVAL

617: pa_resource_groups_valid_v
618: WHERE resource_group = p_group_resource_type;
619:
620: CURSOR c_res_list_seq_csr IS
621: SELECT pa_resource_lists_s.NEXTVAL
622: FROM
623: SYS.DUAL;
624:
625: -- Added for Bug 2486405.

Line 648: p_err_stage := 'Select x from pa_resource_lists ';

644:
645: l_old_stack := p_err_stack;
646: p_err_code := 0;
647: p_err_stack := p_err_stack ||'->PA_CREATE_RESOURCE.create_resource_list';
648: p_err_stage := 'Select x from pa_resource_lists ';
649:
650: -- First clear the message stack if called from html.
651: IF p_migration_code IS NOT NULL THEN
652: FND_MSG_PUB.initialize;

Line 718: p_err_stage := 'Select pa_resource_lists_s.nextval from dual ';

714: CLOSE c_resource_groups_csr;
715: END IF;
716: END IF; -- Added by RM
717:
718: p_err_stage := 'Select pa_resource_lists_s.nextval from dual ';
719: OPEN c_res_list_seq_csr;
720: FETCH c_res_list_seq_csr INTO
721: l_resource_list_id;
722: IF c_res_list_seq_csr%NOTFOUND THEN

Line 750: p_err_stage := 'Insert into pa_resource_lists ';

746: END IF;
747: End If;
748: -----------------------Bug 2486405--------------------------
749:
750: p_err_stage := 'Insert into pa_resource_lists ';
751:
752: IF (p_job_group_id IS NOT NULL ) OR (p_job_group_name IS NOT NULL) THEN
753: pa_job_utils.Check_Job_GroupName_Or_Id(
754: p_job_group_id => p_job_group_id,

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 825: insert into pa_resource_lists_tl (

821: );
822:
823: /* commented for bug 6079140 IF p_migration_code = 'N' THEN -- Added by RM */
824: -- New lists - insert into TL table
825: insert into pa_resource_lists_tl (
826: LAST_UPDATE_LOGIN,
827: CREATION_DATE,
828: CREATED_BY,
829: LAST_UPDATE_DATE,

Line 851: from pa_resource_lists_tl T

847: from FND_LANGUAGES L
848: where L.INSTALLED_FLAG in ('I', 'B')
849: and not exists
850: (select NULL
851: from pa_resource_lists_tl T
852: where T.RESOURCE_LIST_ID = L_RESOURCE_LIST_ID
853: and T.LANGUAGE = L.LANGUAGE_CODE);
854:
855: /* commented for bug 6079140 END IF; -- Adding to TL */

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 1489: update pa_resource_lists_tl set

1485: END IF;
1486:
1487: p_record_version_number := p_record_version_number + 1;
1488:
1489: update pa_resource_lists_tl set
1490: NAME = nvl(p_resource_list_name, name),
1491: DESCRIPTION = P_DESCRIPTION,
1492: LAST_UPDATE_DATE = g_last_update_date,
1493: LAST_UPDATED_BY = g_last_updated_by,

Line 1692: pa_resource_lists_tl

1688: p_resource_list_id IN NUMBER) return BOOLEAN
1689: IS
1690: CURSOR check_plan_rl_unique IS
1691: SELECT 'N' FROM
1692: pa_resource_lists_tl
1693: WHERE NAME = p_resource_list_name
1694: AND LANGUAGE = userenv('LANG')
1695: AND ((resource_list_id <> p_resource_list_id
1696: AND p_resource_list_id IS NOT NULL)

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 2174: p_err_stage := 'Select group_resource_type_id from pa_resource_lists ';

2170: p_err_code := 10;
2171: p_err_stage := 'PA_NO_PROJECT_ROLE_ID';
2172: RETURN;
2173: END IF;
2174: p_err_stage := 'Select group_resource_type_id from pa_resource_lists ';
2175: OPEN c_resource_lists_csr;
2176: FETCH c_resource_lists_csr INTO
2177: l_grouped_resource_type_id;
2178: IF c_resource_lists_csr%NOTFOUND THEN

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 3035: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';

3031: BEGIN
3032: l_old_stack := p_err_stack;
3033: p_err_code := 0;
3034: p_err_stack := p_err_stack||'->PA_CREATE_RESOURCE.add_resource_list_member';
3035: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
3036:
3037: -- Get Resource List Id ,Group_resource_type_id from
3038: -- PA_RESOURCE_LISTS with the
3039: -- X_Resource_list_id.

Line 3038: -- PA_RESOURCE_LISTS with the

3034: p_err_stack := p_err_stack||'->PA_CREATE_RESOURCE.add_resource_list_member';
3035: p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
3036:
3037: -- Get Resource List Id ,Group_resource_type_id from
3038: -- PA_RESOURCE_LISTS with the
3039: -- X_Resource_list_id.
3040: OPEN c_res_list_csr;
3041: FETCH c_res_list_csr INTO
3042: l_grouped_resource_type_id;

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 3708: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';

3704: X_err_code := 0;
3705: X_err_stack :=
3706: X_err_stack ||'->PA_CREATE_RESOURCE.Create_Default_Res_List';
3707:
3708: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3709:
3710: FOR eachRL IN Seeded_RLs LOOP
3711:
3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';

Line 3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';

3708: X_err_stage := 'Select seeded_resource_list From PA_RESOURCE_LISTS';
3709:
3710: FOR eachRL IN Seeded_RLs LOOP
3711:
3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3713:
3714: SELECT pa_resource_lists_s.NEXTVAL
3715: INTO X_resource_list_id
3716: FROM sys.dual;

Line 3714: SELECT pa_resource_lists_s.NEXTVAL

3710: FOR eachRL IN Seeded_RLs LOOP
3711:
3712: X_err_stage := 'Select pa_resource_lists_s.NEXTVAL From Dual';
3713:
3714: SELECT pa_resource_lists_s.NEXTVAL
3715: INTO X_resource_list_id
3716: FROM sys.dual;
3717:
3718: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';

Line 3718: X_err_stage := 'Insert Into PA_RESOURCE_LISTS';

3714: SELECT pa_resource_lists_s.NEXTVAL
3715: INTO X_resource_list_id
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

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 3762: FROM pa_resource_lists rl

3758: FROM
3759: sys.dual
3760: WHERE NOT EXISTS (
3761: SELECT NULL
3762: FROM pa_resource_lists rl
3763: WHERE business_group_id =
3764: NVL(X_business_group_id,
3765: fnd_profile.value('PER_BUSINESS_GROUP_ID'))
3766: AND rl.name = eachRL.name );

Line 3769: INSERT into pa_resource_lists_tl (

3765: fnd_profile.value('PER_BUSINESS_GROUP_ID'))
3766: AND rl.name = eachRL.name );
3767:
3768: --Adding to TL
3769: INSERT into pa_resource_lists_tl (
3770: last_update_login,
3771: creation_date,
3772: created_by,
3773: last_update_date,

Line 3795: from pa_resource_lists_tl T

3791: FROM FND_LANGUAGES L
3792: WHERE L.INSTALLED_FLAG in ('I', 'B')
3793: and not exists
3794: (select NULL
3795: from pa_resource_lists_tl T
3796: where T.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);
3797:
3798: X_err_stage := 'Insert Into PA_RESOURCE_LIST_MEMBERS';
3799:

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 3964: delete from pa_resource_lists_tl

3960: delete from pa_plan_rl_formats
3961: where resource_list_id = p_resource_list_id;
3962:
3963: -- Delete the planning resource list - TL
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

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 4010: delete from pa_resource_lists_tl T

4006: **********************************************/
4007: procedure ADD_LANGUAGE
4008: is
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

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 4017: update pa_resource_lists_tl T set (

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 (
4018: NAME,
4019: DESCRIPTION
4020: ) = (select
4021: B.NAME,

Line 4023: from pa_resource_lists_tl b

4019: DESCRIPTION
4020: ) = (select
4021: B.NAME,
4022: B.DESCRIPTION
4023: from pa_resource_lists_tl b
4024: where B.RESOURCE_LIST_ID = T.RESOURCE_LIST_ID
4025: and B.LANGUAGE = T.SOURCE_LANG)
4026: where (
4027: T.RESOURCE_LIST_ID,

Line 4032: from pa_resource_lists_tl SUBB, pa_resource_lists_tl SUBT

4028: T.LANGUAGE
4029: ) in (select
4030: SUBT.RESOURCE_LIST_ID,
4031: SUBT.LANGUAGE
4032: from pa_resource_lists_tl SUBB, pa_resource_lists_tl SUBT
4033: where SUBB.RESOURCE_LIST_ID = SUBT.RESOURCE_LIST_ID
4034: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
4035: and (SUBB.NAME <> SUBT.NAME
4036: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 4041: insert into pa_resource_lists_tl (

4037: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
4038: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
4039: ));
4040:
4041: insert into pa_resource_lists_tl (
4042: LAST_UPDATE_LOGIN,
4043: CREATION_DATE,
4044: CREATED_BY,
4045: LAST_UPDATE_DATE,

Line 4063: from pa_resource_lists_tl B, FND_LANGUAGES L

4059: B.NAME,
4060: B.DESCRIPTION,
4061: L.LANGUAGE_CODE,
4062: B.SOURCE_LANG
4063: from pa_resource_lists_tl B, FND_LANGUAGES L
4064: where L.INSTALLED_FLAG in ('I', 'B')
4065: and B.LANGUAGE = userenv('LANG')
4066: and not exists
4067: (select NULL

Line 4068: from pa_resource_lists_tl T

4064: where L.INSTALLED_FLAG in ('I', 'B')
4065: and B.LANGUAGE = userenv('LANG')
4066: and not exists
4067: (select NULL
4068: from pa_resource_lists_tl T
4069: where T.RESOURCE_LIST_ID = B.RESOURCE_LIST_ID
4070: and T.LANGUAGE = L.LANGUAGE_CODE);
4071: end ADD_LANGUAGE;
4072: /***************************/

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 4612: INSERT into pa_resource_lists_tl (

4608: -- hr_utility.trace('member insert');
4609:
4610:
4611: --Adding to TL
4612: INSERT into pa_resource_lists_tl (
4613: last_update_login,
4614: creation_date,
4615: created_by,
4616: last_update_date,

Line 4638: from pa_resource_lists_tl T

4634: FROM FND_LANGUAGES L
4635: WHERE L.INSTALLED_FLAG in ('I', 'B')
4636: and not exists
4637: (select NULL
4638: from pa_resource_lists_tl T
4639: where T.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID
4640: and T.LANGUAGE = L.LANGUAGE_CODE);
4641:
4642:

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 5240: update pa_resource_lists_tl set

5236: P_DESCRIPTION in VARCHAR2
5237: ) is
5238: begin
5239:
5240: update pa_resource_lists_tl set
5241: NAME = P_NAME,
5242: DESCRIPTION = P_DESCRIPTION,
5243: LAST_UPDATE_DATE = sysdate,
5244: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),

Line 5260: * into table pa_resource_lists_bg and

5256:
5257: /******************************************************
5258: * Procedure : LOAD_ROW
5259: * Description : This API is used to update or insert rows
5260: * into table pa_resource_lists_bg and
5261: * pa_resource_lits_tl table. This procedure
5262: * is called from the lct file.
5263: * **************************************************/
5264: procedure LOAD_ROW(

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 5304: SELECT nvl(p_resource_list_id,pa_resource_lists_s.NEXTVAL)

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
5306: FROM dual;
5307: */
5308: --End of Commenting for Bug#5094347

Line 5313: --unique constraint (PA.PA_RESOURCE_LISTS_U2) violation error in case table pa_resource_lists_tl

5309:
5310: /*Bug 4202015 - Changes Start*/
5311: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call 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

Line 5315: --record in table pa_resource_lists_tl, we try to insert the same record in table

5311: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call 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:

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 ,

Line 5384: update pa_resource_lists_tl

5380: NULL);
5381: end if;
5382:
5383:
5384: update pa_resource_lists_tl
5385: set
5386: NAME = P_NAME,
5387: DESCRIPTION = P_DESCRIPTION,
5388: LAST_UPDATE_DATE = sysdate,

Line 5396: insert into pa_resource_lists_tl (

5392: where resource_list_id = P_RESOURCE_LIST_ID
5393: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
5394:
5395: if (sql%notfound) then
5396: insert into pa_resource_lists_tl (
5397: LAST_UPDATE_LOGIN,
5398: CREATION_DATE,
5399: CREATED_BY,
5400: LAST_UPDATE_DATE,

Line 5422: from pa_resource_lists_tl T

5418: from FND_LANGUAGES L
5419: where L.INSTALLED_FLAG in ('I', 'B')
5420: and not exists
5421: (select NULL
5422: from pa_resource_lists_tl T
5423: where T.RESOURCE_LIST_ID = P_RESOURCE_LIST_ID
5424: and T.LANGUAGE = L.LANGUAGE_CODE);
5425: end if;
5426: