APPS.EAM_ASSIGN_EMP_PUB dependencies on EAM_EMP_SEARCH_RESULT_TBL

Line 906: l_Emp_Search_Result_Rec Eam_Emp_Search_Result_Tbl%ROWTYPE;

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

Line 1195: DELETE FROM Eam_Emp_Search_Result_Tbl;

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

Line 1200: INSERT INTO Eam_Emp_Search_Result_Tbl

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

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

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