APPS.EAM_AUTOMATICEST dependencies on WIP_DISCRETE_JOBS

Line 11: the estimation_status to reestimate in wip_discrete_jobs.

7: DESCRIPTION
8: This procedure expects wip_entity_id as input parameter and finds out NOCOPY
9: whether that job qualifies for reestimation or not by calling procedure
10: CST_eamCost_PUB.validate_for_reestimation. If it does it update
11: the estimation_status to reestimate in wip_discrete_jobs.
12: *----------------------------------------------------------------------------*/
13:
14:
15: PROCEDURE Call_Validate_for_Reestimation(

Line 35: FROM WIP_DISCRETE_JOBS

31: l_stmt_num := 10;
32:
33: SELECT estimation_status , status_type
34: INTO l_est_status , l_job_status
35: FROM WIP_DISCRETE_JOBS
36: WHERE wip_entity_id = p_wip_entity_id;
37:
38: l_stmt_num := 20;
39:

Line 71: UPDATE WIP_DISCRETE_JOBS

67: IF (l_est_status = EAM_CONSTANTS.COMPLETE) THEN
68:
69: l_stmt_num := 60;
70:
71: UPDATE WIP_DISCRETE_JOBS
72: SET estimation_status = EAM_CONSTANTS.REESTIMATE
73: WHERE wip_entity_id = p_wip_entity_id;
74:
75: ELSIF (l_est_status = EAM_CONSTANTS.RUNNING) THEN

Line 79: UPDATE WIP_DISCRETE_JOBS

75: ELSIF (l_est_status = EAM_CONSTANTS.RUNNING) THEN
76:
77: l_stmt_num := 70;
78:
79: UPDATE WIP_DISCRETE_JOBS
80: SET estimation_status = EAM_CONSTANTS.RUNREEST
81: WHERE wip_entity_id = p_wip_entity_id;
82:
83: END IF; /* ENDIF for l_est_status IF */

Line 124: FROM WIP_REQUIREMENT_OPERATIONS wro , WIP_DISCRETE_JOBS wdj

120: l_stmt_num := 10;
121:
122: SELECT wro.wip_entity_id BULK COLLECT
123: INTO l_wip_entity_tbl
124: FROM WIP_REQUIREMENT_OPERATIONS wro , WIP_DISCRETE_JOBS wdj
125: WHERE wdj.wip_entity_id = wro.wip_entity_id
126: AND wdj.status_type
127: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
128: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,

Line 191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj

187: l_stmt_num := 10;
188:
189: SELECT wor.wip_entity_id BULK COLLECT
190: INTO l_wip_entity_tbl
191: FROM WIP_OPERATION_RESOURCES wor , WIP_DISCRETE_JOBS wdj
192: WHERE wdj.wip_entity_id = wor.wip_entity_id
193: AND wdj.status_type
194: IN ( WIP_CONSTANTS.UNRELEASED , WIP_CONSTANTS.RELEASED ,
195: WIP_CONSTANTS.COMP_CHRG , WIP_CONSTANTS.HOLD ,