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.AP_WEB_CC_VALIDATIONS_PKG dependencies on AP_CARD_DETAILS

Line 662: select full_name into l_full_name from ap_card_details where card_id = p_card_id;

658: -- Assign the employee to the card and activate it.
659: procedure assign_employee(p_card_id in number, p_employee_id in number) is
660: l_full_name VARCHAR2(80);
661: begin
662: select full_name into l_full_name from ap_card_details where card_id = p_card_id;
663:
664: if (l_full_name is null) then
665: select substr(FIRST_NAME|| ' ' || MIDDLE_NAME|| ' ' || LAST_NAME,1,80)
666: into l_full_name from ap_card_details where card_id = p_card_id;

Line 666: into l_full_name from ap_card_details where card_id = p_card_id;

662: select full_name into l_full_name from ap_card_details where card_id = p_card_id;
663:
664: if (l_full_name is null) then
665: select substr(FIRST_NAME|| ' ' || MIDDLE_NAME|| ' ' || LAST_NAME,1,80)
666: into l_full_name from ap_card_details where card_id = p_card_id;
667: end if;
668:
669: if (l_full_name is null or trim(l_full_name) is null) then
670: select substrb(full_name, 1, 80) into l_full_name

Line 682: -- This version does not delete the AP_CARD_DETAILS record

678: end;
679:
680: --
681: -- This version should only be called by the web interface
682: -- This version does not delete the AP_CARD_DETAILS record
683: -- and assumes that the web version will take care of that.
684: -- (Kind of a workaround)
685: procedure assign_employee(p_card_id in number, p_employee_id in number, p_full_name in varchar2)
686: is