DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on LM_SPRD_FLS

Line 1276: UPDATE lm_sprd_fls

1272: /* saving the data to spreadsheet tables from temp tables*/
1273: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
1274: IF (V_sprd_id IS NOT NULL) THEN
1275: X_sprd_id := V_sprd_id;
1276: UPDATE lm_sprd_fls
1277: SET lab_organization_id = V_orgn_id,
1278: formula_id = V_formula_id,
1279: batch_id = V_batch_id,
1280: move_order_header_id = V_move_order_header_id,

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

1292: ELSE
1293: OPEN Cur_sprd_id;
1294: FETCH Cur_sprd_id INTO X_sprd_id;
1295: CLOSE Cur_sprd_id;
1296: INSERT INTO lm_sprd_fls (sprd_id, sprd_name, formula_id,batch_id, lab_organization_id, maintain_type,
1297: active_ind, delete_mark, creation_date,
1298: last_update_date, created_by,
1299: last_updated_by, text_code, in_use,move_order_header_id)
1300: VALUES (X_sprd_id, V_spread_name,