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

Line 53: from PER_ASSIGNMENT_STATUS_TYPES AST

49: X_BUSINESS_GROUP_ID in NUMBER,
50: X_LEGISLATION_CODE in VARCHAR2
51: ) is
52: select AST.ASSIGNMENT_STATUS_TYPE_ID
53: from PER_ASSIGNMENT_STATUS_TYPES AST
54: where AST.USER_STATUS = X_USER_STATUS
55: and ( AST.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
56: or ( AST.BUSINESS_GROUP_ID is null
57: and X_BUSINESS_GROUP_ID is null))

Line 63: from per_assignment_status_types;

59: or ( AST.LEGISLATION_CODE is null
60: and X_LEGISLATION_CODE is null));
61: cursor csr_max_seq is
62: select max(ASSIGNMENT_STATUS_TYPE_ID)
63: from per_assignment_status_types;
64:
65: cursor CSR_SEQUENCE is
66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval
67: from dual;

Line 66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval

62: select max(ASSIGNMENT_STATUS_TYPE_ID)
63: from per_assignment_status_types;
64:
65: cursor CSR_SEQUENCE is
66: select PER_ASSIGNMENT_STATUS_TYPES_S.nextval
67: from dual;
68: L_BUSINESS_GROUP_ID NUMBER;
69: L_MAX_SEQ NUMBER;
70: begin

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 129: per_assignment_status_types t

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)
133: and nvl(t.legislation_code, nvl(P_LEGISLATION_CODE, 'XXX') )

Line 308: from per_assignment_status_types t

304: order by lookup_code;
305: --
306: cursor csr2 is
307: select t.per_system_status status
308: from per_assignment_status_types t
309: where t.per_system_status is not null
310: and t.default_flag = 'Y'
311: and t.active_flag = 'Y'
312: and nvl(t.business_group_id, nvl(p_business_group_id, -9999) ) =

Line 397: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES

393: X_LAST_UPDATE_DATE in DATE,
394: X_LAST_UPDATED_BY in NUMBER,
395: X_LAST_UPDATE_LOGIN in NUMBER
396: ) is
397: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES
398: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
399: begin
400: insert into PER_ASSIGNMENT_STATUS_TYPES (
401: ASSIGNMENT_STATUS_TYPE_ID,

Line 400: insert into PER_ASSIGNMENT_STATUS_TYPES (

396: ) is
397: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES
398: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
399: begin
400: insert into PER_ASSIGNMENT_STATUS_TYPES (
401: ASSIGNMENT_STATUS_TYPE_ID,
402: BUSINESS_GROUP_ID,
403: LEGISLATION_CODE,
404: USER_STATUS,

Line 432: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (

428: X_LAST_UPDATED_BY,
429: X_LAST_UPDATE_LOGIN
430: );
431:
432: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (
433: ASSIGNMENT_STATUS_TYPE_ID,
434: USER_STATUS,
435: EXTERNAL_STATUS,
436: LAST_UPDATE_DATE,

Line 458: from PER_ASSIGNMENT_STATUS_TYPES_TL T

454: from FND_LANGUAGES L
455: where L.INSTALLED_FLAG in ('I', 'B')
456: and not exists
457: (select NULL
458: from PER_ASSIGNMENT_STATUS_TYPES_TL T
459: where T.ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
460: and T.LANGUAGE = L.LANGUAGE_CODE);
461:
462: open c;

Line 491: from PER_ASSIGNMENT_STATUS_TYPES

487: DEFAULT_FLAG,
488: PRIMARY_FLAG,
489: PAY_SYSTEM_STATUS,
490: PER_SYSTEM_STATUS
491: from PER_ASSIGNMENT_STATUS_TYPES
492: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
493: for update of ASSIGNMENT_STATUS_TYPE_ID nowait;
494: recinfo c%rowtype;
495:

Line 499: from PER_ASSIGNMENT_STATUS_TYPES_TL

495:
496: cursor c1 is select
497: USER_STATUS,
498: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
499: from PER_ASSIGNMENT_STATUS_TYPES_TL
500: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
501: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
502: for update of ASSIGNMENT_STATUS_TYPE_ID nowait;
503: begin

Line 566: update PER_ASSIGNMENT_STATUS_TYPES set

562: -- is not changed when updating the record.
563:
564: if X_BUSINESS_GROUP_ID is not null then
565:
566: update PER_ASSIGNMENT_STATUS_TYPES set
567: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
568: LEGISLATION_CODE = X_LEGISLATION_CODE,
569: USER_STATUS = X_USER_STATUS, -- Bug 2731841
570: ACTIVE_FLAG = X_ACTIVE_FLAG,

Line 582: update PER_ASSIGNMENT_STATUS_TYPES set

578: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
579:
580: else
581:
582: update PER_ASSIGNMENT_STATUS_TYPES set
583: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
584: LEGISLATION_CODE = X_LEGISLATION_CODE,
585: -- USER_STATUS = X_USER_STATUS, -- Bug 2731841
586: ACTIVE_FLAG = X_ACTIVE_FLAG,

Line 603: update PER_ASSIGNMENT_STATUS_TYPES_TL set

599: if (sql%notfound) then
600: raise no_data_found;
601: end if;
602:
603: update PER_ASSIGNMENT_STATUS_TYPES_TL set
604: USER_STATUS = X_USER_STATUS,
605: EXTERNAL_STATUS = X_EXTERNAL_STATUS,
606: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
607: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 622: delete from PER_ASSIGNMENT_STATUS_TYPES_TL

618: procedure DELETE_ROW (
619: X_ASSIGNMENT_STATUS_TYPE_ID in NUMBER
620: ) is
621: begin
622: delete from PER_ASSIGNMENT_STATUS_TYPES_TL
623: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
624:
625: if (sql%notfound) then
626: raise no_data_found;

Line 629: delete from PER_ASSIGNMENT_STATUS_TYPES

625: if (sql%notfound) then
626: raise no_data_found;
627: end if;
628:
629: delete from PER_ASSIGNMENT_STATUS_TYPES
630: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
631:
632: if (sql%notfound) then
633: raise no_data_found;

Line 695: from PER_ASSIGNMENT_STATUS_TYPES

691: -- Translate char last_update_date to date
692: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
693: select LAST_UPDATED_BY, LAST_UPDATE_DATE
694: into db_luby, db_ludate
695: from PER_ASSIGNMENT_STATUS_TYPES
696: where ASSIGNMENT_STATUS_TYPE_ID = TO_NUMBER(X_ASSIGNMENT_STATUS_TYPE_ID);
697:
698: -- Test for customization and version
699: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 785: from PER_ASSIGNMENT_STATUS_TYPES_TL

781: -- Translate char last_update_date to date
782: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
783: select LAST_UPDATED_BY, LAST_UPDATE_DATE
784: into db_luby, db_ludate
785: from PER_ASSIGNMENT_STATUS_TYPES_TL
786: where ASSIGNMENT_STATUS_TYPE_ID = TO_NUMBER(X_ASSIGNMENT_STATUS_TYPE_ID)
787: and LANGUAGE=userenv('LANG');
788:
789: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 792: update PER_ASSIGNMENT_STATUS_TYPES_TL set

788:
789: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
790: db_ludate,X_CUSTOM_MODE)) then
791:
792: update PER_ASSIGNMENT_STATUS_TYPES_TL set
793: USER_STATUS = X_USER_STATUS,
794: EXTERNAL_STATUS = X_USER_STATUS, -- Bug fix 3627126.
795: LAST_UPDATE_DATE = db_ludate,
796: LAST_UPDATED_BY = db_luby,

Line 807: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table

803: --
804: procedure ADD_LANGUAGE
805: is
806: begin
807: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table
808: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T
809: where not exists
810: (select NULL
811: from PER_ASSIGNMENT_STATUS_TYPES B

Line 808: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T

804: procedure ADD_LANGUAGE
805: is
806: begin
807: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table
808: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T
809: where not exists
810: (select NULL
811: from PER_ASSIGNMENT_STATUS_TYPES B
812: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID

Line 811: from PER_ASSIGNMENT_STATUS_TYPES B

807: -- process PER_ASSIGNMENT_STATUS_TYPES_TL table
808: delete from PER_ASSIGNMENT_STATUS_TYPES_TL T
809: where not exists
810: (select NULL
811: from PER_ASSIGNMENT_STATUS_TYPES B
812: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
813: );
814:
815: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (

Line 815: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (

811: from PER_ASSIGNMENT_STATUS_TYPES B
812: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
813: );
814:
815: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (
816: USER_STATUS
817: ) = (select
818: B.USER_STATUS
819: from PER_ASSIGNMENT_STATUS_TYPES_TL B

Line 819: from PER_ASSIGNMENT_STATUS_TYPES_TL B

815: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (
816: USER_STATUS
817: ) = (select
818: B.USER_STATUS
819: from PER_ASSIGNMENT_STATUS_TYPES_TL B
820: where B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
821: and B.LANGUAGE = T.SOURCE_LANG)
822: where (
823: T.ASSIGNMENT_STATUS_TYPE_ID,

Line 828: from PER_ASSIGNMENT_STATUS_TYPES_TL SUBB, PER_ASSIGNMENT_STATUS_TYPES_TL SUBT

824: T.LANGUAGE
825: ) in (select
826: SUBT.ASSIGNMENT_STATUS_TYPE_ID,
827: SUBT.LANGUAGE
828: from PER_ASSIGNMENT_STATUS_TYPES_TL SUBB, PER_ASSIGNMENT_STATUS_TYPES_TL SUBT
829: where SUBB.ASSIGNMENT_STATUS_TYPE_ID = SUBT.ASSIGNMENT_STATUS_TYPE_ID
830: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
831: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
832: ));

Line 834: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (

830: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
831: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
832: ));
833:
834: insert into PER_ASSIGNMENT_STATUS_TYPES_TL (
835: ASSIGNMENT_STATUS_TYPE_ID,
836: USER_STATUS,
837: LAST_UPDATE_DATE,
838: LAST_UPDATED_BY,

Line 854: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L

850: B.CREATED_BY,
851: B.CREATION_DATE,
852: L.LANGUAGE_CODE,
853: B.SOURCE_LANG
854: from PER_ASSIGNMENT_STATUS_TYPES_TL B, FND_LANGUAGES L
855: where L.INSTALLED_FLAG in ('I', 'B')
856: and B.LANGUAGE = userenv('LANG')
857: and not exists
858: (select NULL

Line 859: from PER_ASSIGNMENT_STATUS_TYPES_TL T

855: where L.INSTALLED_FLAG in ('I', 'B')
856: and B.LANGUAGE = userenv('LANG')
857: and not exists
858: (select NULL
859: from PER_ASSIGNMENT_STATUS_TYPES_TL T
860: where T.ASSIGNMENT_STATUS_TYPE_ID = B.ASSIGNMENT_STATUS_TYPE_ID
861: and T.LANGUAGE = L.LANGUAGE_CODE);
862: --
863: -- process PER_ASS_STATUS_TYPES_AMENDS_TL table

Line 955: FROM per_assignment_status_types_tl astt,

951: p_assignment_status_type_id IN NUMBER,
952: p_bus_grp_id IN NUMBER)
953: IS
954: SELECT 1
955: FROM per_assignment_status_types_tl astt,
956: per_assignment_status_types ast
957: WHERE upper(astt.user_status)=upper(p_user_status)
958: AND astt.assignment_status_type_id = ast.assignment_status_type_id
959: AND astt.language = p_language

Line 956: per_assignment_status_types ast

952: p_bus_grp_id IN NUMBER)
953: IS
954: SELECT 1
955: FROM per_assignment_status_types_tl astt,
956: per_assignment_status_types ast
957: WHERE upper(astt.user_status)=upper(p_user_status)
958: AND astt.assignment_status_type_id = ast.assignment_status_type_id
959: AND astt.language = p_language
960: AND (ast.assignment_status_type_id <> p_assignment_status_type_id