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_TL

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