DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_SPRD_FLS

Line 1242: UPDATE lm_sprd_fls

1238: /* saving the data to spreadsheet tables from temp tables*/
1239: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
1240: IF (V_sprd_id IS NOT NULL) THEN
1241: X_sprd_id := V_sprd_id;
1242: UPDATE lm_sprd_fls
1243: SET lab_organization_id = V_orgn_id,
1244: formula_id = V_formula_id,
1245: batch_id = V_batch_id,
1246: move_order_header_id = V_move_order_header_id,

Line 1262: INSERT INTO lm_sprd_fls (sprd_id, sprd_name, formula_id,batch_id, lab_organization_id, maintain_type,

1258: ELSE
1259: OPEN Cur_sprd_id;
1260: FETCH Cur_sprd_id INTO X_sprd_id;
1261: CLOSE Cur_sprd_id;
1262: INSERT INTO lm_sprd_fls (sprd_id, sprd_name, formula_id,batch_id, lab_organization_id, maintain_type,
1263: active_ind, delete_mark, creation_date,
1264: last_update_date, created_by,
1265: last_updated_by, text_code, in_use,move_order_header_id)
1266: VALUES (X_sprd_id, V_spread_name,