APPS.CSTPOYUT dependencies on WIP_OPERATION_YIELDS

Line 9: -- Use this function to update operation cost in WIP_OPERATION_YIELDS --

5: -- FUNCTION --
6: -- update_mat_cost --
7: -- --
8: -- DESCRIPTION --
9: -- Use this function to update operation cost in WIP_OPERATION_YIELDS --
10: -- from material cost manager. --
11: -- PURPOSE: --
12: -- Oracle Applications Rel 11i.1 --
13: -- --

Line 65: /* Update WIP_OPERATION_YIELDS */

61: RETURN 1;
62: END IF;
63:
64:
65: /* Update WIP_OPERATION_YIELDS */
66:
67: UPDATE wip_operation_yields woy
68: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
69: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,

Line 67: UPDATE wip_operation_yields woy

63:
64:
65: /* Update WIP_OPERATION_YIELDS */
66:
67: UPDATE wip_operation_yields woy
68: SET (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
69: REQUEST_ID,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,
70: operation_cost,
71: status )=

Line 125: -- Use this function to update operation cost in WIP_OPERATION_YIELDS --

121: -- FUNCTION --
122: -- update_wip_cost --
123: -- --
124: -- DESCRIPTION --
125: -- Use this function to update operation cost in WIP_OPERATION_YIELDS --
126: -- from WIP cost manager. --
127: -- --
128: -- PURPOSE: --
129: -- Oracle Applications Rel 11i.1 --

Line 165: /* Update Wip_operation_yields */

161:
162: BEGIN
163:
164: FOR c_we_rec IN c_wip_entities LOOP
165: /* Update Wip_operation_yields */
166:
167: /* Changes for Optional Scrap */
168: x_est_scrap_acct_flag := WSMPUTIL.WSM_ESA_ENABLED(c_we_rec.wip_entity_id, x_err_num, x_err_msg);
169: IF (x_est_scrap_acct_flag = 0) THEN

Line 174: UPDATE wip_operation_yields woy

170: RAISE WSM_ESA_PKG_ERROR;
171: END IF;
172:
173: IF(x_est_scrap_acct_flag = 1) THEN
174: UPDATE wip_operation_yields woy
175: SET (operation_cost,
176: status,
177: REQUEST_ID, PROGRAM_APPLICATION_ID,
178: PROGRAM_ID, PROGRAM_UPDATE_DATE,

Line 235: -- Use this function to update status of WIP_OPERATION_YIELDS when --

231: -- FUNCTION --
232: -- update_woy_status --
233: -- --
234: -- DESCRIPTION --
235: -- Use this function to update status of WIP_OPERATION_YIELDS when --
236: -- scrap transaction takes place. --
237: -- --
238: -- PURPOSE: --
239: -- Oracle Applications Rel 11i.1 --

Line 287: /* Update WIP_OPERATION_YIELDS */

283: IF x_est_scrap_acct_flag <> 1 THEN
284: RETURN 1;
285: END IF;
286:
287: /* Update WIP_OPERATION_YIELDS */
288:
289: UPDATE wip_operation_yields
290: SET LAST_UPDATE_DATE = SYSDATE,
291: LAST_UPDATED_BY = i_user_id,

Line 289: UPDATE wip_operation_yields

285: END IF;
286:
287: /* Update WIP_OPERATION_YIELDS */
288:
289: UPDATE wip_operation_yields
290: SET LAST_UPDATE_DATE = SYSDATE,
291: LAST_UPDATED_BY = i_user_id,
292: LAST_UPDATE_LOGIN = i_login_id,
293: REQUEST_ID = DECODE(i_req_id, -1, NULL, i_req_id),