APPS.CN_PLANCOPY_UTIL_PVT dependencies on CN_CALC_EDGES

Line 691: INSERT INTO cn_calc_edges

687: AND (l_select_end - l_select_start) > 1
688: ) THEN
689: l_exp_names := l_exp_names || l_token || '|';
690:
691: INSERT INTO cn_calc_edges
692: (
693: org_id
694: , calc_edge_id
695: , parent_id

Line 705: , cn_calc_edges_s.NEXTVAL

701: , last_update_date
702: , last_updated_by
703: )
704: SELECT org_id
705: , cn_calc_edges_s.NEXTVAL
706: , p_calc_sql_exp_id
707: , calc_sql_exp_id
708: , 'EE'
709: , SYSDATE

Line 719: FROM cn_calc_edges

715: WHERE NAME = l_token
716: AND org_id= p_org_id
717: AND NOT EXISTS(
718: SELECT 1
719: FROM cn_calc_edges
720: WHERE parent_id = p_calc_sql_exp_id
721: AND child_id = (SELECT calc_sql_exp_id
722: FROM cn_calc_sql_exps
723: WHERE NAME = l_token AND org_id = p_org_id AND edge_type = 'EE'));

Line 732: INSERT INTO cn_calc_edges

728: SUBSTR(p_piped_sql_select, l_dummy, INSTR(p_piped_sql_select, '_', l_dummy, 1) - l_dummy)
729: );
730: l_formula_ids := l_formula_ids || l_calc_formula_id || '|';
731:
732: INSERT INTO cn_calc_edges
733: (
734: org_id
735: , calc_edge_id
736: , parent_id

Line 746: , cn_calc_edges_s.NEXTVAL

742: , last_update_date
743: , last_updated_by
744: )
745: SELECT p_org_id
746: , cn_calc_edges_s.NEXTVAL
747: , p_calc_sql_exp_id
748: , l_calc_formula_id
749: , 'FE'
750: , SYSDATE

Line 758: FROM cn_calc_edges

754: , fnd_global.user_id
755: FROM DUAL
756: WHERE NOT EXISTS(
757: SELECT 1
758: FROM cn_calc_edges
759: WHERE parent_id = p_calc_sql_exp_id
760: AND child_id = l_calc_formula_id
761: AND edge_type = 'FE');
762: END IF;

Line 769: DELETE FROM cn_calc_edges

765: END LOOP;
766:
767: -- delete obsolete calc edges
768: --IF (l_formula_ids <> '|') THEN
769: DELETE FROM cn_calc_edges
770: WHERE parent_id = p_calc_sql_exp_id
771: AND INSTR(l_formula_ids, '|' || child_id || '|', 1, 1) = 0
772: AND edge_type = 'FE';
773:

Line 777: DELETE FROM cn_calc_edges a

773:
774: --END IF;
775:
776: --IF (l_exp_names <> '|') THEN
777: DELETE FROM cn_calc_edges a
778: WHERE a.parent_id = p_calc_sql_exp_id
779: AND a.edge_type = 'EE'
780: AND NOT EXISTS(
781: SELECT 1