APPS.GMICDEP dependencies on IC_PERD_BAL

Line 32: -252 Cost update to ic_perd_bal error.

28: pop_code - Operators identifier number.
29: RETURNS:
30: 0 Success.
31: -251 Fiscal Policy Error.
32: -252 Cost update to ic_perd_bal error.
33: <-252 Oracle RDBMS Error.
34: ============================================= */
35: FUNCTION calc_costs(pwhse_code VARCHAR2,
36: pprd_end_date DATE,

Line 58: FROM ic_perd_bal

54: /* Cursor Definitions:
55: =================== */
56: CURSOR item_selection IS
57: SELECT DISTINCT(item_id)
58: FROM ic_perd_bal
59: WHERE fiscal_year = UPPER(pfiscal_year)
60: AND period = pperiod
61: AND whse_code = UPPER(pwhse_code)
62: AND loct_usage <> 0;

Line 119: UPDATE ic_perd_bal

115:
116: /* Now let's update the perpetual balance
117: table for all occurances of the item.
118: ====================================== */
119: UPDATE ic_perd_bal
120: SET loct_value = (loct_usage * l_cost),
121: last_update_date = SYSDATE,
122: last_updated_by = pop_code
123: WHERE fiscal_year = pfiscal_year