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 1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;

1856: l_sys_make_rate_mandatory AP_WEB_DB_AP_INT_PKG.apSetUp_makeMandatoryFlag;
1857: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
1858: l_default_currency_code AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1864: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;

Line 1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;

1859: l_week_end_date AP_WEB_DB_EXPRPT_PKG.expHdr_weekEndDate;
1860: l_exp_check_address_flag AP_WEB_DB_HR_INT_PKG.empCurrent_checkAddrFlag;
1861: l_ven_allow_awt_flag AP_WEB_DB_AP_INT_PKG.vendors_allowAWTFlag;
1862: l_ven_awt_group_id AP_WEB_DB_AP_INT_PKG.vendors_awtGroupID;
1863: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
1864: l_default_emp_segments AP_OIE_KFF_SEGMENTS_T;
1865: l_exp_dist_ccid AP_WEB_DB_EXPLINE_PKG.expLines_codeCombID;
1866: l_id_flex_structure_name fnd_id_flex_structures_vl.id_flex_structure_name%TYPE;
1867:

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

7607:
7608: -------------------------------------------------------
7609: l_debug_info := 'Trying to retrieve employee manager';
7610: -------------------------------------------------------
7611: IF (NOT AP_WEB_DB_HR_INT_PKG.GetSupervisorID(p_employee_id, p_manager_id)) THEN
7612: p_manager_id := NULL;
7613: END IF;
7614:
7615: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GetManager');

Line 7749: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

7745: l_employee_name per_people_x.full_name%type;
7746:
7747: l_last_approver_id NUMBER;
7748: l_last_approver_name per_workforce_x.full_name%TYPE;
7749: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
7750:
7751: BEGIN
7752:
7753: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GetFinalApprover');

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

14424: AND ( item_key = p_item_key
14425: OR p_item_key = SubStr(context,7,length(p_item_key)) )
14426: AND status <> 'CANCELED';
14427:
14428: AP_WEB_DB_HR_INT_PKG.GetUserIdFromName(l_user_name, l_entered_by);
14429: EXCEPTION
14430: WHEN OTHERS THEN
14431: l_entered_by := -1;
14432: END;

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

14623: p_item_key,
14624: 'EMPLOYEE_ID');
14625:
14626: -- Check whether person is terminated
14627: IF (AP_WEB_DB_HR_INT_PKG.isPersonTerminated(l_person_id)='Y') THEN
14628: p_result := 'COMPLETE:Y';
14629: ELSE
14630: p_result := 'COMPLETE:N';
14631: END IF;

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

14666: p_item_key,
14667: 'EMPLOYEE_ID');
14668:
14669: -- Check whether person is active
14670: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
14671: p_result := 'COMPLETE:Y';
14672: ELSE
14673: p_result := 'COMPLETE:N';
14674: END IF;

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

14708: p_item_key,
14709: 'MANAGER_ID');
14710:
14711: -- Check whether person is active
14712: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
14713: p_result := 'COMPLETE:Y';
14714: ELSE
14715: p_result := 'COMPLETE:N';
14716: END IF;

Line 14744: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

14740: p_instructions OUT NOCOPY VARCHAR2,
14741: p_special_instr OUT NOCOPY VARCHAR2) IS
14742: ---------------------------------------------------------------------------
14743: l_debug_info VARCHAR2(200);
14744: l_emp_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
14745: l_employee_name per_workforce_x.full_name%TYPE;
14746: BEGIN
14747:
14748: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GetManagerInfoAndCheckStatus');

Line 14753: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(

14749:
14750: -----------------------------------------------------------
14751: l_debug_info := 'Trying to retrieve employee manager info';
14752: -----------------------------------------------------------
14753: AP_WEB_DB_HR_INT_PKG.GetManagerIdAndStatus(
14754: p_employee_id,
14755: p_manager_id,
14756: p_manager_name,
14757: p_manager_status);

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

14762: -----------------------------------------------------------------------
14763:
14764: IF (p_manager_id IS NULL) THEN
14765: IF (p_employee_name IS NULL) THEN
14766: IF AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(p_employee_id,l_emp_info_rec) THEN
14767: l_employee_name := l_emp_info_rec.employee_name;
14768: END IF;
14769: END IF;
14770: --------------------------------

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

16188: p_item_key,
16189: 'PREPARER_ID');
16190:
16191: -- Check whether person is active
16192: IF (AP_WEB_DB_HR_INT_PKG.isPersonActive(l_person_id)='Y') THEN
16193: p_result := 'COMPLETE:Y';
16194: ELSE
16195: p_result := 'COMPLETE:N';
16196: END IF;