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.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 241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(

237: BEGIN
238: PER_RIC_PKG.chk_integrity (
239: p_entity_name => 'PER_ASS_STATUS_TYPE_AMENDS',
240: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
241: PER_RIC_PKG.ref_info_rec('PER_ASSIGNMENT_STATUS_TYPES', PER_RIC_PKG.column_info_tbl(
242: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,P_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
243: PER_RIC_PKG.ref_info_rec('HR_ALL_ORGANIZATION_UNITS', PER_RIC_PKG.column_info_tbl(
244: PER_RIC_PKG.col_info_rec('ORGANIZATION_ID',NULL,P_BUSINESS_GROUP_ID,NULL)))
245: ),

Line 350: from per_assignment_status_types t

346: order by lookup_code;
347: --
348: cursor csr2 is
349: select t.per_system_status status
350: from per_assignment_status_types t
351: where t.per_system_status is not null
352: and t.default_flag = 'Y'
353: and t.active_flag = 'Y'
354: and nvl(t.business_group_id, nvl(p_business_group_id, -9999) ) =

Line 439: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES

435: X_LAST_UPDATE_DATE in DATE,
436: X_LAST_UPDATED_BY in NUMBER,
437: X_LAST_UPDATE_LOGIN in NUMBER
438: ) is
439: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES
440: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
441: begin
442: insert into PER_ASSIGNMENT_STATUS_TYPES (
443: ASSIGNMENT_STATUS_TYPE_ID,

Line 442: insert into PER_ASSIGNMENT_STATUS_TYPES (

438: ) is
439: cursor C is select ROWID from PER_ASSIGNMENT_STATUS_TYPES
440: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
441: begin
442: insert into PER_ASSIGNMENT_STATUS_TYPES (
443: ASSIGNMENT_STATUS_TYPE_ID,
444: BUSINESS_GROUP_ID,
445: LEGISLATION_CODE,
446: USER_STATUS,

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 482: p_ref_entity => 'PER_ASSIGNMENT_STATUS_TYPES',

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,
486: p_ref_col_value_date => 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 553: from PER_ASSIGNMENT_STATUS_TYPES

549: DEFAULT_FLAG,
550: PRIMARY_FLAG,
551: PAY_SYSTEM_STATUS,
552: PER_SYSTEM_STATUS
553: from PER_ASSIGNMENT_STATUS_TYPES
554: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID
555: for update of ASSIGNMENT_STATUS_TYPE_ID nowait;
556: recinfo c%rowtype;
557:

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 628: update PER_ASSIGNMENT_STATUS_TYPES set

624: -- is not changed when updating the record.
625:
626: if X_BUSINESS_GROUP_ID is not null then
627:
628: update PER_ASSIGNMENT_STATUS_TYPES set
629: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
630: LEGISLATION_CODE = X_LEGISLATION_CODE,
631: USER_STATUS = X_USER_STATUS, -- Bug 2731841
632: ACTIVE_FLAG = X_ACTIVE_FLAG,

Line 644: update PER_ASSIGNMENT_STATUS_TYPES set

640: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
641:
642: else
643:
644: update PER_ASSIGNMENT_STATUS_TYPES set
645: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
646: LEGISLATION_CODE = X_LEGISLATION_CODE,
647: -- USER_STATUS = X_USER_STATUS, -- Bug 2731841
648: ACTIVE_FLAG = X_ACTIVE_FLAG,

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 697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',

693: --
694:
695: BEGIN
696: PER_RIC_PKG.chk_integrity (
697: p_entity_name => 'PER_ASSIGNMENT_STATUS_TYPES',
698: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
699: PER_RIC_PKG.ref_info_rec('PAY_STATUS_PROCESSING_RULES_F', PER_RIC_PKG.column_info_tbl(
700: PER_RIC_PKG.col_info_rec('ASSIGNMENT_STATUS_TYPE_ID',NULL,X_ASSIGNMENT_STATUS_TYPE_ID,NULL))),
701: PER_RIC_PKG.ref_info_rec('PER_ALL_ASSIGNMENTS_F', PER_RIC_PKG.column_info_tbl(

Line 716: delete from PER_ASSIGNMENT_STATUS_TYPES

712: END;
713: --
714: -- Code Ends Here.
715: --
716: delete from PER_ASSIGNMENT_STATUS_TYPES
717: where ASSIGNMENT_STATUS_TYPE_ID = X_ASSIGNMENT_STATUS_TYPE_ID;
718:
719: if (sql%notfound) then
720: raise no_data_found;

Line 782: from PER_ASSIGNMENT_STATUS_TYPES

778: -- Translate char last_update_date to date
779: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
780: select LAST_UPDATED_BY, LAST_UPDATE_DATE
781: into db_luby, db_ludate
782: from PER_ASSIGNMENT_STATUS_TYPES
783: where ASSIGNMENT_STATUS_TYPE_ID = TO_NUMBER(X_ASSIGNMENT_STATUS_TYPE_ID);
784:
785: -- Test for customization and version
786: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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 898: from PER_ASSIGNMENT_STATUS_TYPES B

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
900: );
901:
902: update PER_ASSIGNMENT_STATUS_TYPES_TL T set (

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

Line 1043: per_assignment_status_types ast

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
1047: AND (ast.assignment_status_type_id <> p_assignment_status_type_id