[Home] [Help]
23: ) IS
24:
25: CURSOR Cur_check_loop (V_tech_parm_id NUMBER) IS
26: SELECT max(level)
27: FROM gmd_parsed_expression p
28: WHERE expression_type <> -1
29: START WITH p.tech_parm_id = V_tech_parm_id
30: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id
31: AND (p.data_type <> 11 OR p.tech_parm_id <> p.expression_parm_id);
30: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id
31: AND (p.data_type <> 11 OR p.tech_parm_id <> p.expression_parm_id);
32:
33: /*SELECT max(level)
34: FROM gmd_parsed_expression p, gmd_tech_parameters_b b
35: WHERE expression_type <> -1
36: AND p.tech_parm_id = b.tech_parm_id (+)
37: START WITH p.tech_parm_id = V_tech_parm_id
38: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id
55: /* First let us assign the return status to success */
56: X_return_status := FND_API.g_ret_sts_success;
57:
58: /* Delete any parsed expression which was existing already */
59: DELETE FROM gmd_parsed_expression
60: WHERE tech_parm_id = p_tech_parm_id;
61:
62: L_length := LENGTH(P_expression);
63: FOR i IN 1..L_length LOOP
101: END IF;
102: END IF;
103:
104: /* Now let us update all the existing parsed expressions which are referrring to this parameter */
105: UPDATE gmd_parsed_expression a
106: SET expression_type = -1,
107: expression_parm_id = P_tech_parm_id
108: WHERE expression_type = 0
109: AND EXISTS (SELECT 1
355: BEGIN
356: /* First let us assign the return status to success */
357: X_return_status := FND_API.g_ret_sts_success;
358:
359: INSERT INTO GMD_PARSED_EXPRESSION (tech_exp_seq_id, tech_parm_id, expression_key, expression_type,
360: expression_parm_id, creation_date, created_by, last_updated_by,
361: last_update_date,data_type)
362: VALUES (gmd_tech_exp_seq_id_s.nextval, p_tech_parm_id, p_key, p_type, p_exp_parm_id, sysdate, l_user_id,
363: l_user_id, sysdate,p_data_type);
569: ) IS
570:
571: CURSOR Cur_get_expr (V_parm_id NUMBER) IS
572: SELECT expression_key, expression_type
573: FROM gmd_parsed_expression p
574: WHERE (expression_type <> -1 or
575: p.tech_parm_id = expression_parm_id)
576: START WITH p.tech_parm_id = V_parm_id
577: CONNECT BY PRIOR expression_parm_id = p.tech_parm_id