APPS.EAM_ASSIGN_EMP_PUB dependencies on EAM_EMP_ASSIGNMENT_DETAILS_TBL

Line 1265: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;

1261: FND_MSG_PUB.initialize;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_success;
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

Line 1269: Removed code that loops through the pl/sql table and then bulk binds using FORALL into Eam_Emp_Assignment_Details_Tbl. Instead

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 (
1273: wip_entity_id,

Line 1272: INSERT INTO Eam_Emp_Assignment_Details_Tbl (

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 (
1273: wip_entity_id,
1274: wo_end_dt,
1275: wo_st_dt ,
1276: workordername ,