[Home] [Help]
1201:
1202: FUNCTION GetOrgIDFromHR(p_employee_id IN NUMBER,
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
1225: P_NEW_HEADER_COST_CENTER IN AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE,
1226: P_NEW_PARAMETER_ID IN NUMBER,
1227: P_SEGMENTS IN AP_OIE_KFF_SEGMENTS_T,
1228: X_SEGMENTS OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
1229: x_combination_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE,
1230: X_MSG_COUNT OUT NOCOPY NUMBER,
1231: X_MSG_DATA OUT NOCOPY VARCHAR2,
1232: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1233: ----------------------------------------------------------------------
1322: P_REPORT_LINE_ID IN NUMBER,
1323: P_EMPLOYEE_ID IN NUMBER,
1324: P_SEGMENTS IN AP_OIE_KFF_SEGMENTS_T,
1325: X_SEGMENTS OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
1326: x_combination_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE,
1327: X_MSG_COUNT OUT NOCOPY NUMBER,
1328: X_MSG_DATA OUT NOCOPY VARCHAR2,
1329: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1330: ----------------------------------------------------------------------
1378: P_REPORT_LINE_ID IN NUMBER,
1379: P_EMPLOYEE_ID IN NUMBER,
1380: P_SEGMENTS IN AP_OIE_KFF_SEGMENTS_T,
1381: X_SEGMENTS OUT NOCOPY AP_OIE_KFF_SEGMENTS_T,
1382: x_combination_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE,
1383: X_MSG_COUNT OUT NOCOPY NUMBER,
1384: X_MSG_DATA OUT NOCOPY VARCHAR2,
1385: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
1386: ----------------------------------------------------------------------