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