DBA Data[Home] [Help]

APPS.GMD_SPREAD_CALCULATE_PKG dependencies on GMD_SPREAD_ERRORS_GTMP

Line 28: DELETE FROM GMD_SPREAD_ERRORS_GTMP;

24: l_data VARCHAR2(2000);
25: l_expression VARCHAR2(2000);
26: l_density VARCHAR2(2000);
27: BEGIN
28: DELETE FROM GMD_SPREAD_ERRORS_GTMP;
29: FOR l_rec IN Cur_get_prod LOOP
30: FND_MSG_PUB.INITIALIZE;
31: IF ((l_rec.data_type = 4) OR (l_rec.line_type = 1 AND l_rec.data_type = 11)) THEN
32: evaluate_expression (V_entity_id => V_entity_id,

Line 84: INSERT INTO GMD_SPREAD_ERRORS_GTMP

80: END IF;
81: l_count := FND_MSG_PUB.COUNT_MSG;
82: FOR i IN 1 .. l_count LOOP
83: FND_MSG_PUB.GET(P_msg_index => i, P_data => l_data, p_msg_index_out => j, P_encoded => 'F');
84: INSERT INTO GMD_SPREAD_ERRORS_GTMP
85: (ENTITY_ID,LINE_ID,LINE_TYPE,INVENTORY_ITEM_ID,CONCATENATED_SEGMENTS,LOT_NUMBER,
86: TECH_PARM_ID,TECH_PARM_NAME,ERROR_MESSAGE,EXPRESSION_TYPE)
87: VALUES
88: (V_entity_id,l_rec.line_id,l_rec.line_type,l_rec.inventory_item_id,