APPS.EAM_ASSIGN_EMP_PUB dependencies on EAM_EMP_SEARCH_RESULT_TBL

Line 907: l_Emp_Search_Result_Rec Eam_Emp_Search_Result_Tbl%ROWTYPE;

903: --store the starting count of the table index from which the records for assigned and available hours needs to be populated
904: l_start_count BINARY_INTEGER;
905:
906:
907: l_Emp_Search_Result_Rec Eam_Emp_Search_Result_Tbl%ROWTYPE;
908: l_Emp_Search_Result_Tbl EAM_ASSIGN_EMP_PUB.Emp_Search_Result_Tbl_Type;
909:
910:
911:

Line 1198: DELETE FROM Eam_Emp_Search_Result_Tbl;

1194:
1195: -- Copy the contents of the search table into the global temporary table.
1196: --Bulk collect into global temporary table
1197:
1198: DELETE FROM Eam_Emp_Search_Result_Tbl;
1199: IF FND_API.TO_BOOLEAN(p_commit) THEN
1200: COMMIT WORK;
1201: end if;
1202: FORALL indx IN l_Emp_Search_Result_Tbl.FIRST..l_Emp_Search_Result_Tbl.LAST

Line 1203: INSERT INTO Eam_Emp_Search_Result_Tbl

1199: IF FND_API.TO_BOOLEAN(p_commit) THEN
1200: COMMIT WORK;
1201: end if;
1202: FORALL indx IN l_Emp_Search_Result_Tbl.FIRST..l_Emp_Search_Result_Tbl.LAST
1203: INSERT INTO Eam_Emp_Search_Result_Tbl
1204: VALUES l_Emp_Search_Result_Tbl(indx);
1205:
1206:
1207: EXCEPTION

Line 1268: Also, TRUNCATE cannot be used since it will do an implicit COMMIT and purge the Eam_Emp_Search_Result_Tbl .

1264: --copy the contents into the global temporary table
1265: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;
1266: /* Bug 4715069 :
1267: Removed code to COMMIT. Issuing a COMMIT will truncate the search results GTT too which is not desired.
1268: Also, TRUNCATE cannot be used since it will do an implicit COMMIT and purge the Eam_Emp_Search_Result_Tbl .
1269: Removed code that loops through the pl/sql table and then bulk binds using FORALL into Eam_Emp_Assignment_Details_Tbl. Instead
1270: using INSERT with SELECT
1271: */
1272: INSERT INTO Eam_Emp_Assignment_Details_Tbl (