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.PER_ASS_STATUSES_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 128: from per_assignment_status_types_tl ttl,

124: v_exists3 number;
125: v_exists4 number;
126: CURSOR C1 IS
127: select 1
128: from per_assignment_status_types_tl ttl,
129: per_assignment_status_types t
130: where upper(ttl.user_status) = upper(P_USER_STATUS)
131: and nvl(t.business_group_id, nvl(P_BUSINESS_GROUP_ID, -9999) )
132: = nvl(P_BUSINESS_GROUP_ID, -9999)

Line 481: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES_TL',

477: --
478:
479: BEGIN
480: PER_RIC_PKG.chk_integrity (
481: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES_TL',
482: p_ref_entity => 'PER_ASSIGNMENT_STATUS_TYPES',
483: p_ref_column_name => 'ASSIGNMENT_STATUS_TYPE_ID',
484: p_ref_col_value_number => X_ASSIGNMENT_STATUS_TYPE_ID,
485: p_ref_col_value_varchar => NULL,

Line 494: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (

490: --
491: -- Code Ends Here.
492: --
493:
494: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (
495: ASSIGNMENT_STATUS_TYPE_ID,
496: USER_STATUS,
497: EXTERNAL_STATUS,
498: LAST_UPDATE_DATE,

Line 520: from PER_ASSIGNMENT_STATUS_TYPES_TL T

516: from FND_LANGUAGES L
517: where L.INSTALLED_FLAG in ('I', 'B')
518: and not exists
519: (select NULL
520: from PER_ASSIGNMENT_STATUS_TYPES_TL T
521: where T.ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
522: and T.LANGUAGE = L.LANGUAGE_CODE);
523:
524: open c;

Line 561: from PER_ASSIGNMENT_STATUS_TYPES_TL

557:
558: cursor c1 is select
559: USER_STATUS,
560: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
561: from PER_ASSIGNMENT_STATUS_TYPES_TL
562: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
563: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
564: for update of ASSIGNMENT_STATUS_TYPE_ID nowait;
565: begin

Line 665: update PER_ASSIGNMENT_STATUS_TYPES_TL set

661: if (sql%notfound) then
662: raise no_data_found;
663: end if;
664:
665: update PER_ASSIGNMENT_STATUS_TYPES_TL set
666: USER_STATUS = X_USER_STATUS,
667: EXTERNAL_STATUS = X_EXTERNAL_STATUS,
668: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
669: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 684: delete from PER_ASSIGNMENT_STATUS_TYPES_TL

680: procedure DELETE_ROW (
681: X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
682: ) is
683: begin
684: delete from PER_ASSIGNMENT_STATUS_TYPES_TL
685: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
686:
687: if (sql%notfound) then
688: raise no_data_found;

Line 872: from PER_ASSIGNMENT_STATUS_TYPES_TL

868: -- Translate char last_update_date to date
869: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
870: select LAST_UPDATED_BY, LAST_UPDATE_DATE
871: into db_luby, db_ludate
872: from PER_ASSIGNMENT_STATUS_TYPES_TL
873: where ASSIGNMENT_STATUS_TYPE_ID = TO_NUMBER(X_ASSIGNMENT_STATUS_TYPE_ID)
874: and LANGUAGE=userenv('LANG');
875:
876: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 879: update PER_ASSIGNMENT_STATUS_TYPES_TL set

875:
876: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
877: db_ludate,X_CUSTOM_MODE)) then
878:
879: update PER_ASSIGNMENT_STATUS_TYPES_TL set
880: USER_STATUS = X_USER_STATUS,
881: EXTERNAL_STATUS = X_USER_STATUS, -- Bug fix 3627126.
882: LAST_UPDATE_DATE = db_ludate,
883: LAST_UPDATED_BY = db_luby,

Line 894: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table

890: --
891: procedure ADD_LANGUAGE
892: is
893: begin
894: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table
895: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T
896: where not exists
897: (select NULL
898: from PER_ASSIGNMENT_STATUS_TYPES B

Line 895: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T

891: procedure ADD_LANGUAGE
892: is
893: begin
894: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table
895: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T
896: where not exists
897: (select NULL
898: from PER_ASSIGNMENT_STATUS_TYPES B
899: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID

Line 902: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (

898: from PER_ASSIGNMENT_STATUS_TYPES B
899: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
900: );
901:
902: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (
903: USER_STATUS
904: ) = (select
905: B.USER_STATUS
906: from PER_ASSIGNMENT_STATUS_TYPES_TL B

Line 906: from PER_ASSIGNMENT_STATUS_TYPES_TL B

902: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (
903: USER_STATUS
904: ) = (select
905: B.USER_STATUS
906: from PER_ASSIGNMENT_STATUS_TYPES_TL B
907: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
908: and B.LANGUAGE = T.SOURCE_LANG)
909: where (
910: T.ASSIGNMENT_STATUS_TYPE_ID,

Line 915: from PER_ASSIGNMENT_STATUS_TYPES_TL SUBB, PER_ASSIGNMENT_STATUS_TYPES_TL SUBT

911: T.LANGUAGE
912: ) in (select
913: SUBT.ASSIGNMENT_STATUS_TYPE_ID,
914: SUBT.LANGUAGE
915: from PER_ASSIGNMENT_STATUS_TYPES_TL SUBB, PER_ASSIGNMENT_STATUS_TYPES_TL SUBT
916: where SUBB.ASSIGNMENT_STATUS_TYPE_ID = SUBT.ASSIGNMENT_STATUS_TYPE_ID
917: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
918: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
919: ));

Line 921: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (

917: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
918: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
919: ));
920:
921: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (
922: ASSIGNMENT_STATUS_TYPE_ID,
923: USER_STATUS,
924: LAST_UPDATE_DATE,
925: LAST_UPDATED_BY,

Line 941: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L

937: B.CREATED_BY,
938: B.CREATION_DATE,
939: L.LANGUAGE_CODE,
940: B.SOURCE_LANG
941: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L
942: where L.INSTALLED_FLAG in ('I', 'B')
943: and B.LANGUAGE = userenv('LANG')
944: and not exists
945: (select NULL

Line 946: from PER_ASSIGNMENT_STATUS_TYPES_TL T

942: where L.INSTALLED_FLAG in ('I', 'B')
943: and B.LANGUAGE = userenv('LANG')
944: and not exists
945: (select NULL
946: from PER_ASSIGNMENT_STATUS_TYPES_TL T
947: where T.ASSIGNMENT_STATUS_TYPE_ID = B.ASSIGNMENT_STATUS_TYPE_ID
948: and T.LANGUAGE = L.LANGUAGE_CODE);
949: --
950: -- process PER_ASS_STATUS_TYPES_AMENDS_TL table

Line 1042: FROM per_assignment_status_types_tl astt,

1038: p_assignment_status_type_id IN NUMBER,
1039: p_bus_grp_id IN NUMBER)
1040: IS
1041: SELECT 1
1042: FROM per_assignment_status_types_tl astt,
1043: per_assignment_status_types ast
1044: WHERE upper(astt.user_status)=upper(p_user_status)
1045: AND astt.assignment_status_type_id = ast.assignment_status_type_id
1046: AND astt.language = p_language