APPS.GMD_LCF_FETCH_PKG dependencies on GMD_LCF_CATEGORY_DTL_GTMP

Line 827: INSERT INTO GMD_LCF_CATEGORY_DTL_GTMP (LINE_ID,VALUE_IND,CATEGORY_ID)

823: ELSE
824: l_value_ind := 0;
825: END IF;
826: CLOSE Cur_check_item_category;
827: INSERT INTO GMD_LCF_CATEGORY_DTL_GTMP (LINE_ID,VALUE_IND,CATEGORY_ID)
828: VALUES (V_line_id,l_value_ind,l_rec.category_id);
829: END LOOP;
830: EXCEPTION
831: WHEN OTHERS THEN

Line 961: FROM gmd_lcf_category_dtl_gtmp

957: --Get the line id(number like 3 or 4 etc) for the category id passed from
958: --the above requirement cursor
959: CURSOR Cur_get_category (V_category_id NUMBER) IS
960: SELECT line_id
961: FROM gmd_lcf_category_dtl_gtmp
962: WHERE category_id = V_category_id
963: AND value_ind = 1;
964:
965: --Get the technical requirements defined for particular formulation specification.

Line 1298: UPDATE gmd_lcf_category_dtl_gtmp

1294: FETCH Cur_get_line_dtl INTO l_dtl_lineid,l_inv_item_id,l_detail_uom,l_conv_factor;
1295: CLOSE Cur_get_line_dtl;
1296:
1297: --Update the qty for each category line id returned from above cursor.
1298: UPDATE gmd_lcf_category_dtl_gtmp
1299: SET qty = l_solved_tab(i).qty
1300: WHERE line_id = l_dtl_lineid;
1301:
1302: l_new_qty := l_solved_tab(i).qty;

Line 1362: from gmd_lcf_category_dtl_gtmp;

1358:
1359: procedure temp_category IS
1360: cursor cur_rec1 IS
1361: select *
1362: from gmd_lcf_category_dtl_gtmp;
1363: begin
1364: FOR L_REC IN CUR_REC1 LOOP
1365: gmd_debug.put_line('category lineid value_ind');
1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);