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 1019: AP_WEB_DB_HR_INT_PKG.IsPersonCwk(p_employee_id) = 'N' AND

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

Line 1057: l_FNDUserID AP_WEB_DB_HR_INT_PKG.fndUser_userID;

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

Line 1058: l_userIdCursor AP_WEB_DB_HR_INT_PKG.UserIdRefCursor;

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

Line 1061: IF ( AP_WEB_DB_HR_INT_PKG.GetUserIdForEmpCursor(

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

Line 1198: AP_WEB_DB_HR_INT_PKG.GetEmpOrgId.

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

Line 1199: Since AP_WEB_DB_HR_INT_PKG.GetEmpOrgId return boolean

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

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

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