DBA Data[Home] [Help]

APPS.AP_WEB_AMOUNT_UTIL dependencies on AP_WEB_DB_HR_INT_PKG

Line 362: IF NOT (AP_WEB_DB_HR_INT_PKG.GetEmpIdForUser(p_userid, l_employee_id)) THEN

358: -- arp_standard.debug('org_id = ' || to_char(l_org_id));
359: -- arp_standard.debug('success = ' || l_success_flag);
360: */
361: BEGIN
362: IF NOT (AP_WEB_DB_HR_INT_PKG.GetEmpIdForUser(p_userid, l_employee_id)) THEN
363: p_success_flag := 'N';
364: return;
365: END IF;
366: SELECT set_of_books_id

Line 372: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'

368: FROM
369: (SELECT set_of_books_id
370: FROM per_employees_x emp
371: WHERE employee_id = l_employee_id
372: AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'
373:
374: UNION ALL
375:
376: SELECT set_of_books_id

Line 401: IF NOT (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(l_employee_id, l_org_id)) THEN

397: return;
398: end if;*/
399:
400: IF (l_sob_id IS NULL OR l_func_curr_code IS NULL OR l_exchange_rate_type IS NULL) THEN
401: IF NOT (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(l_employee_id, l_org_id)) THEN
402: p_success_flag := 'N';
403: return;
404: END IF;
405: