APPS.GMD_SPREAD_CALCULATE_PKG dependencies on GMD_TECHNICAL_DATA_GTMP

Line 116: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t

112: CURSOR Cur_get_line (V_line_type NUMBER) IS
113: SELECT NVL(SUM(weight), 0), NVL(SUM(weightpct), 0)
114: FROM
115: (SELECT qty_mass weight, qty_mass * value weightpct
116: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t
117: WHERE line_type <> 1
118: AND (line_type = V_line_type OR line_type = 3)
119: AND d.line_id = t.line_id (+)
120: AND d.entity_id = t.entity_id (+)

Line 149: UPDATE gmd_technical_data_gtmp

145: X_rollup := (X_ingred_wtpct - X_byprod_wtpct) / (X_ingred_wt - X_byprod_wt);
146: END IF;
147:
148:
149: UPDATE gmd_technical_data_gtmp
150: SET value = X_rollup, num_data = X_rollup
151: WHERE line_id = V_line_id
152: AND tech_parm_id = V_parm_id;
153:

Line 155: INSERT INTO GMD_TECHNICAL_DATA_GTMP

151: WHERE line_id = V_line_id
152: AND tech_parm_id = V_parm_id;
153:
154: IF SQL%NOTFOUND THEN
155: INSERT INTO GMD_TECHNICAL_DATA_GTMP
156: (ENTITY_ID,
157: LINE_ID,
158: SORT_SEQ,
159: TECH_PARM_NAME,

Line 213: UPDATE gmd_technical_data_gtmp

209: X_value => l_value,
210: X_expression => X_expression,
211: x_return_status => x_return_status);
212:
213: UPDATE gmd_technical_data_gtmp
214: SET value = l_value, num_data = l_value
215: WHERE line_id = V_line_id
216: AND tech_parm_id = V_parm_id;
217:

Line 219: INSERT INTO GMD_TECHNICAL_DATA_GTMP

215: WHERE line_id = V_line_id
216: AND tech_parm_id = V_parm_id;
217:
218: IF SQL%NOTFOUND THEN
219: INSERT INTO GMD_TECHNICAL_DATA_GTMP
220: (ENTITY_ID,
221: LINE_ID,
222: SORT_SEQ,
223: TECH_PARM_NAME,

Line 270: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t

266: CURSOR Cur_get_line1 (V_line_type NUMBER) IS
267: SELECT SUM(volume), SUM(volumepct)
268: FROM
269: (SELECT qty_vol volume, qty_vol * value volumepct
270: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t
271: WHERE line_type <> 1
272: AND (line_type = V_line_type OR line_type = 3)
273: AND d.line_id = t.line_id (+)
274: AND d.entity_id = t.entity_id (+)

Line 314: UPDATE gmd_technical_data_gtmp

310: IF (NVL(X_ingred_vol,0) - NVL(X_byprod_vol,0)) <> 0 THEN
311: X_rollup := (NVL(X_ingred_volpct,0) - NVL(X_byprod_volpct,0)) / (NVL(X_ingred_vol,0) - NVL(X_byprod_vol,0));
312: END IF;
313:
314: UPDATE gmd_technical_data_gtmp
315: SET value = X_rollup,
316: num_data = X_rollup
317: WHERE line_id = V_line_id
318: AND tech_parm_id = V_parm_id;

Line 321: INSERT INTO GMD_TECHNICAL_DATA_GTMP

317: WHERE line_id = V_line_id
318: AND tech_parm_id = V_parm_id;
319:
320: IF SQL%NOTFOUND THEN
321: INSERT INTO GMD_TECHNICAL_DATA_GTMP
322: (ENTITY_ID,
323: LINE_ID,
324: SORT_SEQ,
325: TECH_PARM_NAME,

Line 413: UPDATE gmd_technical_data_gtmp

409: X_rollup_cost := X_rollup_cost / V_primary_qty;
410: ELSE
411: X_rollup_cost := 0;
412: END IF;
413: UPDATE gmd_technical_data_gtmp
414: SET value = X_rollup_cost,
415: num_data = X_rollup_cost
416: WHERE line_id = V_line_id
417: AND tech_parm_id = V_parm_id;

Line 420: INSERT INTO GMD_TECHNICAL_DATA_GTMP

416: WHERE line_id = V_line_id
417: AND tech_parm_id = V_parm_id;
418:
419: IF SQL%NOTFOUND THEN
420: INSERT INTO GMD_TECHNICAL_DATA_GTMP
421: (ENTITY_ID,
422: LINE_ID,
423: SORT_SEQ,
424: TECH_PARM_NAME,

Line 459: UPDATE gmd_technical_data_gtmp

455: X_rollup_cost NUMBER;
456: BEGIN
457: X_rollup_cost := rollup_cost_units(V_entity_id,V_line_id,V_parm_name,V_parm_id,X_return_status);
458:
459: UPDATE gmd_technical_data_gtmp
460: SET value = X_rollup_cost,
461: num_data = X_rollup_cost
462: WHERE line_id = V_line_id
463: AND tech_parm_id = V_parm_id;

Line 466: INSERT INTO GMD_TECHNICAL_DATA_GTMP

462: WHERE line_id = V_line_id
463: AND tech_parm_id = V_parm_id;
464:
465: IF SQL%NOTFOUND THEN
466: INSERT INTO GMD_TECHNICAL_DATA_GTMP
467: (ENTITY_ID,
468: LINE_ID,
469: SORT_SEQ,
470: TECH_PARM_NAME,

Line 505: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t

501: CURSOR Cur_get_line2 (V_line_type NUMBER) IS
502: SELECT NVL(SUM(volumepct), 0)
503: FROM
504: (SELECT primary_qty * value volumepct
505: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t
506: WHERE line_type <> 1
507: AND (line_type = V_line_type OR line_type = 3)
508: AND d.line_id = t.line_id (+)
509: AND d.entity_id = t.entity_id (+)

Line 568: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t

564: X_return_status OUT NOCOPY VARCHAR2) IS
565:
566: CURSOR Cur_get_line3 (V_line_type NUMBER) IS
567: SELECT qty,detail_uom,value,inventory_item_id,lot_number,tpformula_id
568: FROM gmd_material_details_gtmp d, gmd_technical_data_gtmp t
569: WHERE line_type <> 1
570: AND (line_type = V_line_type OR line_type = 3)
571: AND d.line_id = t.line_id (+)
572: AND d.entity_id = t.entity_id (+)

Line 635: UPDATE gmd_technical_data_gtmp

631: X_byprod_mass := X_byprod_mass + l_equiv_qty;
632: END LOOP;
633: END IF;
634: IF(l_error = 1) THEN
635: UPDATE gmd_technical_data_gtmp
636: SET value = NULL,
637: num_data = NULL
638: WHERE line_id = V_line_id
639: AND tech_parm_id = V_parm_id;

Line 645: UPDATE gmd_technical_data_gtmp

641: ELSE
642: IF (X_ingred_mass - X_byprod_mass) <> 0 THEN
643: X_rollup := (X_ingred_equiv - X_byprod_equiv) / (X_ingred_mass - X_byprod_mass);
644: END IF;
645: UPDATE gmd_technical_data_gtmp
646: SET value = X_rollup,
647: num_data = X_rollup
648: WHERE line_id = V_line_id
649: AND tech_parm_id = V_parm_id;

Line 652: INSERT INTO GMD_TECHNICAL_DATA_GTMP

648: WHERE line_id = V_line_id
649: AND tech_parm_id = V_parm_id;
650:
651: IF SQL%NOTFOUND THEN
652: INSERT INTO GMD_TECHNICAL_DATA_GTMP
653: (ENTITY_ID,
654: LINE_ID,
655: SORT_SEQ,
656: TECH_PARM_NAME,

Line 708: from gmd_technical_data_gtmp a, gmd_material_details_gtmp b

704:
705: procedure temp_param (V_entity_id IN NUMBER,V_line_id IN NUMBER) IS
706: cursor cur_rec1 IS
707: select a.*,b.concatenated_segments,b.lot_number,b.qty
708: from gmd_technical_data_gtmp a, gmd_material_details_gtmp b
709: where a.entity_id = V_entity_id
710: AND a.line_id= b.line_id
711: and (v_line_id is null or a.line_id = v_line_id);
712: begin