DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_SPACE_ASSIGN_EMP_PKG

Line 6557: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := emp_rec;

6553: EXIT WHEN get_emp_assgn%NOTFOUND;
6554: END IF;
6555: -- 102403 -- date track space assignment
6556:
6557: PN_SPACE_ASSIGN_EMP_PKG.tlempinfo := emp_rec;
6558: l_new_emp_alloc_area := ROUND(((NVL(emp_rec.allocated_area_pct,0)*p_assgn_area)/100),4);
6559:
6560: IF emp_rec.emp_assign_start_date >= p_str_dt AND
6561: NVL(emp_rec.emp_assign_end_date,g_end_of_time) <= p_end_dt THEN

Line 6575: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(

6571: l_assgn_str_dt := p_str_dt;
6572: END IF;
6573: END IF;
6574:
6575: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(
6576: X_EMP_SPACE_ASSIGN_ID => emp_rec.emp_space_assign_id,
6577: X_ATTRIBUTE1 => emp_rec.attribute1,
6578: X_ATTRIBUTE2 => emp_rec.attribute2,
6579: X_ATTRIBUTE3 => emp_rec.attribute3,