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