DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_SPACE_ASSIGN_EMP_PKG

Line 6396: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := emp_rec;

6392: EXIT WHEN get_emp_assgn%NOTFOUND;
6393: END IF;
6394: -- 102403 -- date track space assignment
6395:
6396: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := emp_rec;
6397: l_new_emp_alloc_area := ROUND(((NVL(emp_rec.allocated_area_pct,0)*p_assgn_area)/100),2);
6398:
6399: IF emp_rec.emp_assign_start_date >= p_str_dt AND
6400: NVL(emp_rec.emp_assign_end_date,g_end_of_time) <= p_end_dt THEN

Line 6414: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(

6410: l_assgn_str_dt := p_str_dt;
6411: END IF;
6412: END IF;
6413:
6414: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(
6415: X_EMP_SPACE_ASSIGN_ID => emp_rec.emp_space_assign_id,
6416: X_ATTRIBUTE1 => emp_rec.attribute1,
6417: X_ATTRIBUTE2 => emp_rec.attribute2,
6418: X_ATTRIBUTE3 => emp_rec.attribute3,