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.

[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LISTS_TL

Line 809: insert into pa_resource_lists_tl (

805: );
806:
807: /* commented for bug 6079140 IF p_migration_code = 'N' THEN -- Added by RM */
808: -- New lists - insert into TL table
809: insert into pa_resource_lists_tl (
810: LAST_UPDATE_LOGIN,
811: CREATION_DATE,
812: CREATED_BY,
813: LAST_UPDATE_DATE,

Line 835: from pa_resource_lists_tl T

831: from FND_LANGUAGES L
832: where L.INSTALLED_FLAG in ('I', 'B')
833: and not exists
834: (select NULL
835: from pa_resource_lists_tl T
836: where T.RESOURCE_LIST_ID = L_RESOURCE_LIST_ID
837: and T.LANGUAGE = L.LANGUAGE_CODE);
838:
839: /* commented for bug 6079140 END IF; -- Adding to TL */

Line 1327: update pa_resource_lists_tl set

1323: END IF;
1324:
1325: p_record_version_number := p_record_version_number + 1;
1326:
1327: update pa_resource_lists_tl set
1328: NAME = nvl(p_resource_list_name, name),
1329: DESCRIPTION = P_DESCRIPTION,
1330: LAST_UPDATE_DATE = g_last_update_date,
1331: LAST_UPDATED_BY = g_last_updated_by,

Line 1348: pa_resource_lists_tl

1344: p_resource_list_id IN NUMBER) return BOOLEAN
1345: IS
1346: CURSOR check_plan_rl_unique IS
1347: SELECT 'N' FROM
1348: pa_resource_lists_tl
1349: WHERE NAME = p_resource_list_name
1350: AND LANGUAGE = userenv('LANG')
1351: AND ((resource_list_id <> p_resource_list_id
1352: AND p_resource_list_id IS NOT NULL)

Line 3420: INSERT into pa_resource_lists_tl (

3416: fnd_profile.value('PER_BUSINESS_GROUP_ID'))
3417: AND rl.name = eachRL.name );
3418:
3419: --Adding to TL
3420: INSERT into pa_resource_lists_tl (
3421: last_update_login,
3422: creation_date,
3423: created_by,
3424: last_update_date,

Line 3446: from pa_resource_lists_tl T

3442: FROM FND_LANGUAGES L
3443: WHERE L.INSTALLED_FLAG in ('I', 'B')
3444: and not exists
3445: (select NULL
3446: from pa_resource_lists_tl T
3447: where T.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID);
3448:
3449: X_err_stage := 'Insert Into PA_RESOURCE_LIST_MEMBERS';
3450:

Line 3615: delete from pa_resource_lists_tl

3611: delete from pa_plan_rl_formats
3612: where resource_list_id = p_resource_list_id;
3613:
3614: -- Delete the planning resource list - TL
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

Line 3661: delete from pa_resource_lists_tl T

3657: **********************************************/
3658: procedure ADD_LANGUAGE
3659: is
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

Line 3668: update pa_resource_lists_tl T set (

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 (
3669: NAME,
3670: DESCRIPTION
3671: ) = (select
3672: B.NAME,

Line 3674: from pa_resource_lists_tl b

3670: DESCRIPTION
3671: ) = (select
3672: B.NAME,
3673: B.DESCRIPTION
3674: from pa_resource_lists_tl b
3675: where B.RESOURCE_LIST_ID = T.RESOURCE_LIST_ID
3676: and B.LANGUAGE = T.SOURCE_LANG)
3677: where (
3678: T.RESOURCE_LIST_ID,

Line 3683: from pa_resource_lists_tl SUBB, pa_resource_lists_tl SUBT

3679: T.LANGUAGE
3680: ) in (select
3681: SUBT.RESOURCE_LIST_ID,
3682: SUBT.LANGUAGE
3683: from pa_resource_lists_tl SUBB, pa_resource_lists_tl SUBT
3684: where SUBB.RESOURCE_LIST_ID = SUBT.RESOURCE_LIST_ID
3685: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3686: and (SUBB.NAME <> SUBT.NAME
3687: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 3692: insert into pa_resource_lists_tl (

3688: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
3689: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
3690: ));
3691:
3692: insert into pa_resource_lists_tl (
3693: LAST_UPDATE_LOGIN,
3694: CREATION_DATE,
3695: CREATED_BY,
3696: LAST_UPDATE_DATE,

Line 3714: from pa_resource_lists_tl B, FND_LANGUAGES L

3710: B.NAME,
3711: B.DESCRIPTION,
3712: L.LANGUAGE_CODE,
3713: B.SOURCE_LANG
3714: from pa_resource_lists_tl B, FND_LANGUAGES L
3715: where L.INSTALLED_FLAG in ('I', 'B')
3716: and B.LANGUAGE = userenv('LANG')
3717: and not exists
3718: (select NULL

Line 3719: from pa_resource_lists_tl T

3715: where L.INSTALLED_FLAG in ('I', 'B')
3716: and B.LANGUAGE = userenv('LANG')
3717: and not exists
3718: (select NULL
3719: from pa_resource_lists_tl T
3720: where T.RESOURCE_LIST_ID = B.RESOURCE_LIST_ID
3721: and T.LANGUAGE = L.LANGUAGE_CODE);
3722: end ADD_LANGUAGE;
3723: /***************************/

Line 4259: INSERT into pa_resource_lists_tl (

4255: -- hr_utility.trace('member insert');
4256:
4257:
4258: --Adding to TL
4259: INSERT into pa_resource_lists_tl (
4260: last_update_login,
4261: creation_date,
4262: created_by,
4263: last_update_date,

Line 4285: from pa_resource_lists_tl T

4281: FROM FND_LANGUAGES L
4282: WHERE L.INSTALLED_FLAG in ('I', 'B')
4283: and not exists
4284: (select NULL
4285: from pa_resource_lists_tl T
4286: where T.RESOURCE_LIST_ID = X_RESOURCE_LIST_ID
4287: and T.LANGUAGE = L.LANGUAGE_CODE);
4288:
4289:

Line 4885: update pa_resource_lists_tl set

4881: P_DESCRIPTION in VARCHAR2
4882: ) is
4883: begin
4884:
4885: update pa_resource_lists_tl set
4886: NAME = P_NAME,
4887: DESCRIPTION = P_DESCRIPTION,
4888: LAST_UPDATE_DATE = sysdate,
4889: LAST_UPDATED_BY = decode(P_OWNER, 'SEED', 1, 0),

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

4954:
4955: /*Bug 4202015 - Changes Start*/
4956: --If we call PA_Resource_List_tbl_Pkg.Update_Row and then call 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

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

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

Line 5029: update pa_resource_lists_tl

5025: NULL);
5026: end if;
5027:
5028:
5029: update pa_resource_lists_tl
5030: set
5031: NAME = P_NAME,
5032: DESCRIPTION = P_DESCRIPTION,
5033: LAST_UPDATE_DATE = sysdate,

Line 5041: insert into pa_resource_lists_tl (

5037: where resource_list_id = P_RESOURCE_LIST_ID
5038: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
5039:
5040: if (sql%notfound) then
5041: insert into pa_resource_lists_tl (
5042: LAST_UPDATE_LOGIN,
5043: CREATION_DATE,
5044: CREATED_BY,
5045: LAST_UPDATE_DATE,

Line 5067: from pa_resource_lists_tl T

5063: from FND_LANGUAGES L
5064: where L.INSTALLED_FLAG in ('I', 'B')
5065: and not exists
5066: (select NULL
5067: from pa_resource_lists_tl T
5068: where T.RESOURCE_LIST_ID = P_RESOURCE_LIST_ID
5069: and T.LANGUAGE = L.LANGUAGE_CODE);
5070: end if;
5071: