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

Line 1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;

1873: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1874: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1875: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1879: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1880: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1881: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;

Line 1880: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;

1876: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1877: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1878: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1879: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1880: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1881: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1882: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1883: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;
1884:

Line 8056: IF (NOT AP_WEB_DB_HR_INT_PKG.GetSupervisorID(p_employee_id, p_manager_id)) THEN

8052:
8053: -------------------------------------------------------
8054: l_debug_info := 'Trying to retrieve employee manager';
8055: -------------------------------------------------------
8056: IF (NOT AP_WEB_DB_HR_INT_PKG.GetSupervisorID(p_employee_id, p_manager_id)) THEN
8057: p_manager_id := NULL;
8058: END IF;
8059:
8060: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GetManager');

Line 8195: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

8191: l_employee_name per_people_x.full_name%type;
8192:
8193: l_last_approver_id NUMBER;
8194: l_last_approver_name per_workforce_x.full_name%TYPE;
8195: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
8196:
8197: BEGIN
8198:
8199: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GetFinalApprover');

Line 11556: IF (AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id) = 'Y') THEN

11552: and nvl(expense_status_code, 'NULL') <> 'PAID'; -- Bug: 13482337, 13870204
11553:
11554: p_result := 'COMPLETE:Y';
11555:
11556: IF (AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id) = 'Y') THEN
11557: p_result := 'COMPLETE:Y';
11558: ELSE
11559: p_result := 'COMPLETE:N';
11560: END IF;

Line 15333: AP_WEB_DB_HR_INT_PKG.GetUserIdFromName(l_user_name, l_entered_by);

15329: AND ( item_key = p_item_key
15330: OR p_item_key = SubStr(context,7,length(p_item_key)) )
15331: AND status <> 'CANCELED';
15332:
15333: AP_WEB_DB_HR_INT_PKG.GetUserIdFromName(l_user_name, l_entered_by);
15334: EXCEPTION
15335: WHEN OTHERS THEN
15336: l_entered_by := -1;
15337: END;

Line 15373: AP_WEB_DB_HR_INT_PKG.GetUserIdFromName(l_user_name, l_entered_by);

15369: AND ( item_key = p_item_key
15370: OR p_item_key = SubStr(context,7,length(p_item_key)) )
15371: AND status <> 'CANCELED';
15372:
15373: AP_WEB_DB_HR_INT_PKG.GetUserIdFromName(l_user_name, l_entered_by);
15374:
15375: EXCEPTION
15376: WHEN OTHERS THEN
15377: L_ENTERED_BY := -1;

Line 15567: IF (AP_WEB_DB_HR_INT_PKG.isPersonTerminated(l_person_id)='Y') THEN

15563: p_item_key,
15564: 'EMPLOYEE_ID');
15565:
15566: -- Check whether person is terminated
15567: IF (AP_WEB_DB_HR_INT_PKG.isPersonTerminated(l_person_id)='Y') THEN
15568: p_result := 'COMPLETE:Y';
15569: ELSE
15570: p_result := 'COMPLETE:N';
15571: END IF;

Line 15610: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN

15606: p_item_key,
15607: 'EMPLOYEE_ID');
15608:
15609: -- Check whether person is active
15610: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
15611: p_result := 'COMPLETE:Y';
15612: ELSE
15613: p_result := 'COMPLETE:N';
15614: END IF;

Line 15652: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN

15648: p_item_key,
15649: 'MANAGER_ID');
15650:
15651: -- Check whether person is active
15652: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
15653: p_result := 'COMPLETE:Y';
15654: ELSE
15655: p_result := 'COMPLETE:N';
15656: END IF;

Line 15684: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

15680: p_instructions OUT NOCOPY VARCHAR2,
15681: p_special_instr OUT NOCOPY VARCHAR2) IS
15682: ---------------------------------------------------------------------------
15683: l_debug_info VARCHAR2(200);
15684: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
15685: l_employee_name per_workforce_x.full_name%TYPE;
15686: BEGIN
15687:
15688: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GetManagerInfoAndCheckStatus');

Line 15693: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(

15689:
15690: -----------------------------------------------------------
15691: l_debug_info := 'Trying to retrieve employee manager info';
15692: -----------------------------------------------------------
15693: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(
15694: p_employee_id,
15695: p_manager_id,
15696: p_manager_name,
15697: p_manager_status);

Line 15706: IF AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,l_emp_info_rec) THEN

15702: -----------------------------------------------------------------------
15703:
15704: IF (p_manager_id IS NULL) THEN
15705: IF (p_employee_name IS NULL) THEN
15706: IF AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,l_emp_info_rec) THEN
15707: l_employee_name := l_emp_info_rec.employee_name;
15708: END IF;
15709: END IF;
15710: --------------------------------

Line 17291: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN

17287: p_item_key,
17288: 'PREPARER_ID');
17289:
17290: -- Check whether person is active
17291: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
17292: p_result := 'COMPLETE:Y';
17293: ELSE
17294: p_result := 'COMPLETE:N';
17295: END IF;