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 631: select full_name into l_full_name from ap_card_details where card_id = p_card_id;

627: -- Assign the employee to the card and activate it.
628: procedure assign_employee(p_card_id in number, p_employee_id in number) is
629: l_full_name VARCHAR2(80);
630: begin
631: select full_name into l_full_name from ap_card_details where card_id = p_card_id;
632: if (l_full_name is null) then
633: select substrb(full_name, 1, 80) into l_full_name
634: from per_employees_x pap, financials_system_parameters fsp
635: where pap.business_group_id = fsp.business_group_id

Line 640: delete from ap_card_details where card_id = p_card_id;

636: and pap.employee_id = p_employee_id;
637: end if;
638:
639: assign_employee(p_card_id, p_employee_id, l_full_name);
640: delete from ap_card_details where card_id = p_card_id;
641: -- commented as this is a duplicate statement in code flow.
642: -- delete from ap_card_emp_candidates where card_id = p_card_id;
643: end;
644:

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

643: end;
644:
645: --
646: -- This version should only be called by the web interface
647: -- This version does not delete the AP_CARD_DETAILS record
648: -- and assumes that the web version will take care of that.
649: -- (Kind of a workaround)
650: procedure assign_employee(p_card_id in number, p_employee_id in number, p_full_name in varchar2)
651: is