APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 67: l_approver_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;

63: -- Preparer's user preference
64: l_userPrefs AP_WEB_DB_USER_PREF_PKG.UserPrefsInfoRec;
65:
66: -- Approver's employee info
67: l_approver_info_rec AP_WEB_DB_HR_INT_PKG.EmployeeInfoRec;
68:
69: BEGIN
70:
71: AP_WEB_UTILITIES_PKG.LogProcedure('AP_WEB_OA_MAINFLOW_PKG',

Line 99: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(l_userPrefs.default_approver_id, l_approver_info_rec)) THEN

95: END IF;
96:
97: -- Default approver name
98: IF (l_userPrefs.default_approver_id IS NOT NULL) THEN
99: IF (AP_WEB_DB_HR_INT_PKG.GetEmployeeInfo(l_userPrefs.default_approver_id, l_approver_info_rec)) THEN
100: p_default_approver_name := l_approver_info_rec.employee_name;
101: END IF;
102: END IF;
103:

Line 176: l_org_id AP_WEB_DB_HR_INT_PKG.empCurrent_orgID;

172: ) IS
173: -------------------------------------------------------------------
174: ExpReportHeaderInfo AP_WEB_DFLEX_PKG.ExpReportHeaderRec;
175: l_Error AP_WEB_UTILITIES_PKG.expError ;
176: l_org_id AP_WEB_DB_HR_INT_PKG.empCurrent_orgID;
177: l_user_id varchar2(20); -- 2242176, fnd user id
178: l_debug_info varchar2(200);
179: current_calling_sequence varchar2(100) := 'ValidateReportHeader';
180:

Line 205: IF (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(ExpReportHeaderInfo.employee_id, l_org_id)) THEN

201: ExpReportHeaderInfo.amt_due_employee := amt_due_employee;
202: ExpReportHeaderInfo.amt_due_ccCompany := amt_due_ccCompany;
203:
204: IF P_IsSessionProjectEnabled = 'Y' THEN
205: IF (AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(ExpReportHeaderInfo.employee_id, l_org_id)) THEN
206: ExpReportHeaderInfo.expenditure_organization_id := l_org_id;
207: END IF;
208: END IF;
209:

Line 1017: AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND

1013: p_apps_id => null);
1014:
1015:
1016: IF (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(p_employee_id, l_has) AND
1017: AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND
1018: l_has = 'Y' AND l_cCardEnabled = 'Y') THEN
1019: p_is_cc_enabled := 'Y';
1020: ELSE
1021: p_is_cc_enabled := 'N';

Line 1055: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;

1051: *----------------------------------------------------------------------------*/
1052: PROCEDURE GetUserID(p_employee_id IN VARCHAR2,
1053: p_user_id OUT NOCOPY VARCHAR2)
1054: IS
1055: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1056: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1057:
1058: BEGIN
1059: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

Line 1056: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

1052: PROCEDURE GetUserID(p_employee_id IN VARCHAR2,
1053: p_user_id OUT NOCOPY VARCHAR2)
1054: IS
1055: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1056: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1057:
1058: BEGIN
1059: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(
1060: p_Employee_id,

Line 1059: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

1055: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;
1056: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;
1057:
1058: BEGIN
1059: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(
1060: p_Employee_id,
1061: l_userIdCursor) = TRUE ) THEN
1062: LOOP
1063: FETCH l_userIdCursor INTO

Line 1196: AP_WEB_DB_HR_INT_PKG.GetEmpOrgId.

1192:
1193: /*------------------------------------------------------------+
1194: Created By: Amulya Mishra
1195: Bug 2751642:A wrapper function to get the org_id value from
1196: AP_WEB_DB_HR_INT_PKG.GetEmpOrgId.
1197: Since AP_WEB_DB_HR_INT_PKG.GetEmpOrgId return boolean
1198: it cannot be called directly from java files.
1199: +-------------------------------------------------------------*/
1200: -----------------------------------------------------------------

Line 1197: Since AP_WEB_DB_HR_INT_PKG.GetEmpOrgId return boolean

1193: /*------------------------------------------------------------+
1194: Created By: Amulya Mishra
1195: Bug 2751642:A wrapper function to get the org_id value from
1196: AP_WEB_DB_HR_INT_PKG.GetEmpOrgId.
1197: Since AP_WEB_DB_HR_INT_PKG.GetEmpOrgId return boolean
1198: it cannot be called directly from java files.
1199: +-------------------------------------------------------------*/
1200: -----------------------------------------------------------------
1201:

Line 1207: IF ( AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(P_Employee_id, p_effective_date, l_org_id) = TRUE ) THEN

1203: p_effective_date IN Date)
1204: RETURN NUMBER IS
1205: l_org_id HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
1206: BEGIN
1207: IF ( AP_WEB_DB_HR_INT_PKG.GetEmpOrgId(P_Employee_id, p_effective_date, l_org_id) = TRUE ) THEN
1208: return l_org_id;
1209: ELSE
1210: return NULL;
1211: END IF;