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.FND_USER_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 579: -- attributes to AK_WEB_USER_SEC_ATTR_VALUES as the final step

575: end if;
576:
577: -- Enhancement 7311235 / Bug 8222658
578: -- Just like the FND Define User form, add/modify default securing
579: -- attributes to AK_WEB_USER_SEC_ATTR_VALUES as the final step
580: -- in the process of creating or updating a user.
581: -- Determine which attributes apply based on employee_id,
582: -- customer_id, supplier_id.
583: -- Bug 13989225

Line 588: select count(1) into l_icx_sec_attr_exists from AK_WEB_USER_SEC_ATTR_VALUES

584: if (l_employee_id is not null) then
585: begin
586: -- Determine if the ICX Attributes exist already for this user regardless
587: -- of the employee_id associated
588: select count(1) into l_icx_sec_attr_exists from AK_WEB_USER_SEC_ATTR_VALUES
589: where WEB_USER_ID = l_user_id
590: and ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID'
591: and ATTRIBUTE_APPLICATION_ID = 178;
592:

Line 593: select count(1) into l_person_sec_attr_exists from AK_WEB_USER_SEC_ATTR_VALUES

589: where WEB_USER_ID = l_user_id
590: and ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID'
591: and ATTRIBUTE_APPLICATION_ID = 178;
592:
593: select count(1) into l_person_sec_attr_exists from AK_WEB_USER_SEC_ATTR_VALUES
594: where WEB_USER_ID = l_user_id
595: and ATTRIBUTE_CODE = 'TO_PERSON_ID'
596: and ATTRIBUTE_APPLICATION_ID = 178;
597:

Line 600: insert into AK_WEB_USER_SEC_ATTR_VALUES (

596: and ATTRIBUTE_APPLICATION_ID = 178;
597:
598: if (l_old_employee_id is null) then
599: -- Attribute should not be there so insert the records
600: insert into AK_WEB_USER_SEC_ATTR_VALUES (
601: WEB_USER_ID,
602: ATTRIBUTE_CODE,
603: ATTRIBUTE_APPLICATION_ID,
604: NUMBER_VALUE,

Line 621: insert into AK_WEB_USER_SEC_ATTR_VALUES (

617: owner_id,
618: sysdate,
619: owner_id);
620:
621: insert into AK_WEB_USER_SEC_ATTR_VALUES (
622: WEB_USER_ID,
623: ATTRIBUTE_CODE,
624: ATTRIBUTE_APPLICATION_ID,
625: NUMBER_VALUE,

Line 646: insert into AK_WEB_USER_SEC_ATTR_VALUES (

642: elsif (l_employee_id <> l_old_employee_id) then
643:
644: -- If the attribute exists then update...otherwise insert new records
645: if (l_icx_sec_attr_exists = 0) then
646: insert into AK_WEB_USER_SEC_ATTR_VALUES (
647: WEB_USER_ID,
648: ATTRIBUTE_CODE,
649: ATTRIBUTE_APPLICATION_ID,
650: NUMBER_VALUE,

Line 669: update AK_WEB_USER_SEC_ATTR_VALUES set

665: owner_id);
666: else
667:
668: -- Update existing record - ICX_HR_PERSON_ID
669: update AK_WEB_USER_SEC_ATTR_VALUES set
670: NUMBER_VALUE = l_employee_id,
671: LAST_UPDATED_BY = owner_id,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATE_LOGIN = owner_id

Line 682: insert into AK_WEB_USER_SEC_ATTR_VALUES (

678:
679: end if;
680:
681: if (l_person_sec_attr_exists = 0) then
682: insert into AK_WEB_USER_SEC_ATTR_VALUES (
683: WEB_USER_ID,
684: ATTRIBUTE_CODE,
685: ATTRIBUTE_APPLICATION_ID,
686: NUMBER_VALUE,

Line 704: update AK_WEB_USER_SEC_ATTR_VALUES set

700: sysdate,
701: owner_id);
702: else
703: -- Update existing record - TO__PERSON_ID
704: update AK_WEB_USER_SEC_ATTR_VALUES set
705: NUMBER_VALUE = l_employee_id,
706: LAST_UPDATED_BY = owner_id,
707: LAST_UPDATE_DATE = sysdate,
708: LAST_UPDATE_LOGIN = owner_id

Line 731: delete from AK_WEB_USER_SEC_ATTR_VALUES

727:
728: if (l_employee_id is null and l_old_employee_id is not null) then
729: begin
730: -- Delete securing attrs if new value is null
731: delete from AK_WEB_USER_SEC_ATTR_VALUES
732: where ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID'
733: and ATTRIBUTE_APPLICATION_ID = 178
734: and WEB_USER_ID = l_user_id
735: and NUMBER_VALUE = l_old_employee_id;

Line 737: delete from AK_WEB_USER_SEC_ATTR_VALUES

733: and ATTRIBUTE_APPLICATION_ID = 178
734: and WEB_USER_ID = l_user_id
735: and NUMBER_VALUE = l_old_employee_id;
736:
737: delete from AK_WEB_USER_SEC_ATTR_VALUES
738: where ATTRIBUTE_CODE = 'TO_PERSON_ID'
739: and ATTRIBUTE_APPLICATION_ID = 178
740: and WEB_USER_ID = l_user_id
741: and NUMBER_VALUE = l_old_employee_id;

Line 755: update AK_WEB_USER_SEC_ATTR_VALUES set

751: end if;
752:
753: if (l_customer_id is not null) then
754: begin
755: update AK_WEB_USER_SEC_ATTR_VALUES set
756: NUMBER_VALUE = l_customer_id,
757: LAST_UPDATED_BY = owner_id,
758: LAST_UPDATE_DATE = sysdate,
759: LAST_UPDATE_LOGIN = owner_id

Line 766: insert into AK_WEB_USER_SEC_ATTR_VALUES (

762: and ATTRIBUTE_APPLICATION_ID = 178
763: and NUMBER_VALUE = l_old_customer_id; -- bug 10371150
764:
765: if (sql%rowcount = 0) then
766: insert into AK_WEB_USER_SEC_ATTR_VALUES (
767: WEB_USER_ID,
768: ATTRIBUTE_CODE,
769: ATTRIBUTE_APPLICATION_ID,
770: NUMBER_VALUE,

Line 799: update AK_WEB_USER_SEC_ATTR_VALUES set

795: end if;
796:
797: if (l_supplier_id is not null) then
798: begin
799: update AK_WEB_USER_SEC_ATTR_VALUES set
800: NUMBER_VALUE = l_supplier_id,
801: LAST_UPDATED_BY = owner_id,
802: LAST_UPDATE_DATE = sysdate,
803: LAST_UPDATE_LOGIN = owner_id

Line 810: insert into AK_WEB_USER_SEC_ATTR_VALUES (

806: and ATTRIBUTE_APPLICATION_ID = 178
807: and NUMBER_VALUE = l_old_supplier_id; -- bug 10371150
808:
809: if (sql%rowcount = 0) then
810: insert into AK_WEB_USER_SEC_ATTR_VALUES (
811: WEB_USER_ID,
812: ATTRIBUTE_CODE,
813: ATTRIBUTE_APPLICATION_ID,
814: NUMBER_VALUE,