APPS.PN_SPACE_ASSIGN_CUST_PKG dependencies on PN_SPACE_ASSIGN_EMP_PKG

Line 943: -- 05-NOV-03 DThota o Initialized pn_space_assign_emp_pkg.tlempinfo

939: --
940: -- IN PARAM : Location Id.
941: -- History :
942: -- 20-OCT-03 DThota o Created. Fix for bug # 3234403
943: -- 05-NOV-03 DThota o Initialized pn_space_assign_emp_pkg.tlempinfo
944: -- := emp_split_rec
945: -- 06-NOV-03 DThota o Aliased assignable_area to allocated_area
946: -- in csr_main.
947: -- 07-NOV-03 DThota o Used min on active_start_date and max on

Line 1262: pn_space_assign_emp_pkg.tlempinfo := emp_split_rec;

1258: pnp_debug_pkg.debug('Update Emp Row Assign_Id: '|| emp_split_rec.emp_space_assign_id
1259: ||', Loc_Id: '|| emp_split_rec.location_id
1260: ||', Emp_Id: '|| emp_split_rec.person_id);
1261:
1262: pn_space_assign_emp_pkg.tlempinfo := emp_split_rec;
1263: ---------------------------------------------------------------------------------------
1264: -- Splits the existing assignment with the (date-1) passed from the date table returned
1265: -- by process vacancy and creates a new assignment with the split date
1266: ---------------------------------------------------------------------------------------

Line 1267: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(

1263: ---------------------------------------------------------------------------------------
1264: -- Splits the existing assignment with the (date-1) passed from the date table returned
1265: -- by process vacancy and creates a new assignment with the split date
1266: ---------------------------------------------------------------------------------------
1267: PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW(
1268: X_EMP_SPACE_ASSIGN_ID => emp_split_rec.EMP_SPACE_ASSIGN_ID
1269: ,X_ATTRIBUTE1 => emp_split_rec.ATTRIBUTE1
1270: ,X_ATTRIBUTE2 => emp_split_rec.ATTRIBUTE2
1271: ,X_ATTRIBUTE3 => emp_split_rec.ATTRIBUTE3

Line 2048: pn_space_assign_emp_pkg.delete_row(emp_tab(i).emp_space_assign_id);

2044: -- ....... update the (i+1) record with the start date of the ith record
2045: -- in the PL/SQL table as well and delete the ith record from the DB
2046: ---------------------------------------------------------------------------
2047: emp_tab(i+1).emp_assign_start_date := emp_tab(i).emp_assign_start_date;
2048: pn_space_assign_emp_pkg.delete_row(emp_tab(i).emp_space_assign_id);
2049:
2050: END IF;
2051: END IF;
2052: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 End_LOOP i= '||i);