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_VALIDATE_UTIL dependencies on AP_WEB_DB_HR_INT_PKG

Line 453: l_approverid AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;

449: p_approverID in out nocopy varchar2,
450: p_ap_error out nocopy varchar2
451: ) IS
452: l_approvercount NUMBER; -- Bug 709879
453: l_approverid AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;
454: l_approverfullname AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
457: l_paren_position NUMBER;

Line 454: l_approverfullname AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879

450: p_ap_error out nocopy varchar2
451: ) IS
452: l_approvercount NUMBER; -- Bug 709879
453: l_approverid AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;
454: l_approverfullname AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
457: l_paren_position NUMBER;
458: debug_info VARCHAR2(2000);

Line 455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879

451: ) IS
452: l_approvercount NUMBER; -- Bug 709879
453: l_approverid AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;
454: l_approverfullname AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
457: l_paren_position NUMBER;
458: debug_info VARCHAR2(2000);
459: l_approvers_cursor AP_WEB_DB_HR_INT_PKG.EmpInfoCursor;

Line 456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;

452: l_approvercount NUMBER; -- Bug 709879
453: l_approverid AP_WEB_DB_HR_INT_PKG.empCurrent_employeeID;
454: l_approverfullname AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
457: l_paren_position NUMBER;
458: debug_info VARCHAR2(2000);
459: l_approvers_cursor AP_WEB_DB_HR_INT_PKG.EmpInfoCursor;
460:

Line 459: l_approvers_cursor AP_WEB_DB_HR_INT_PKG.EmpInfoCursor;

455: l_upper_approver_name_exact AP_WEB_DB_HR_INT_PKG.empCurrent_fullName; -- Bug 709879
456: l_upper_approver_name_fuzzy AP_WEB_DB_HR_INT_PKG.empCurrent_fullName;
457: l_paren_position NUMBER;
458: debug_info VARCHAR2(2000);
459: l_approvers_cursor AP_WEB_DB_HR_INT_PKG.EmpInfoCursor;
460:
461: BEGIN
462: p_approverName := ltrim(p_approverName);
463: -- If the p_approverID argument is not null, then we are assuming that the

Line 506: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfoCursor(p_approverName,

502: -- fullname was like the exact one being searched on due to fuzzy
503: -- Solution: use a cursor for fuzzy search and check for exact match
504: -- Caveat: Does not handle case where 2+ employees have exact same
505: -- fullname; 1st employee found with exact fullname match wins
506: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfoCursor(p_approverName,
507: l_upper_approver_name_fuzzy, l_approvers_cursor)) THEN
508: FETCH l_approvers_cursor
509: INTO l_approverid, l_approverfullname;
510: WHILE l_approvers_cursor%FOUND LOOP

Line 569: if (l_ApproverID = AP_WEB_DB_HR_INT_PKG.getEmployeeID) then

565: -- Bug 711957/669360
566: -- preparer and employee cannot be the approver
567: -- and hr.employee_id != to_number(p_employee_id);
568: -- Bug 3198236 : corrected error messages
569: if (l_ApproverID = AP_WEB_DB_HR_INT_PKG.getEmployeeID) then
570: fnd_message.set_name('SQLAP', 'AP_WEB_PREP_CANNOT_APPROVE');
571: p_ap_error := fnd_message.get_encoded();
572: elsif (l_ApproverID = to_number(p_employee_id)) then
573: fnd_message.set_name('SQLAP', 'AP_WEB_EMP_CANNOT_APPROVE');

Line 786: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName := 'McKee, Mr. David (Dave)';

782: ---------------------------------------------------------------
783: l_last_receipt VARCHAR2(25);
784: l_last_receipt_date DATE;
785:
786: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName := 'McKee, Mr. David (Dave)';
787: l_employee_num AP_WEB_DB_HR_INT_PKG.empCurrent_empNum := 100;
788: l_default_cost_center VARCHAR2(80);
789: current_calling_sequence VARCHAR2(2000);
790: debug_info VARCHAR2(100);

Line 787: l_employee_num AP_WEB_DB_HR_INT_PKG.empCurrent_empNum := 100;

783: l_last_receipt VARCHAR2(25);
784: l_last_receipt_date DATE;
785:
786: l_employee_name AP_WEB_DB_HR_INT_PKG.empCurrent_fullName := 'McKee, Mr. David (Dave)';
787: l_employee_num AP_WEB_DB_HR_INT_PKG.empCurrent_empNum := 100;
788: l_default_cost_center VARCHAR2(80);
789: current_calling_sequence VARCHAR2(2000);
790: debug_info VARCHAR2(100);
791: