APPS.EAM_ASSIGN_EMP_PUB dependencies on EAM_EMP_ASSIGNMENT_DETAILS_TBL

Line 1262: DELETE FROM Eam_Emp_Assignment_Details_Tbl ;

1258: FND_MSG_PUB.initialize;
1259: END IF;
1260: x_return_status := FND_API.g_ret_sts_success;
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

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

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

Line 1269: INSERT INTO Eam_Emp_Assignment_Details_Tbl (

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 (
1270: wip_entity_id,
1271: wo_end_dt,
1272: wo_st_dt ,
1273: workordername ,