eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_SQL_EXPS_PVT dependencies on CN_CALC_EDGES

Line 315: -- 3) If there are embedded expressions, record the embedding relations in cn_calc_edges

311: --
312: -- Notes : Create SQL expressions that will be used in calculation.
313: -- 1) Validate the expression and return the result in x_status (Valid or Invalid)
314: -- 2) Classify expressions into sub types for formula validation and dynamic rate table validation
315: -- 3) If there are embedded expressions, record the embedding relations in cn_calc_edges
316: --
317: -- End of comments
318: PROCEDURE create_expression(
319: p_api_version IN NUMBER

Line 458: INSERT INTO cn_calc_edges

454: INSTR(p_piped_sql_select, '(', l_select_start, 1) = l_select_start
455: AND (l_select_end - l_select_start) > 1
456: ) THEN
457: -- insert calc edges (calc edges has no table handler)
458: INSERT INTO cn_calc_edges
459: (
460: org_id
461: , calc_edge_id
462: , parent_id

Line 472: , cn_calc_edges_s.NEXTVAL

468: , last_update_date
469: , last_updated_by
470: )
471: SELECT org_id
472: , cn_calc_edges_s.NEXTVAL
473: , x_calc_sql_exp_id
474: , calc_sql_exp_id
475: , 'EE'
476: , SYSDATE

Line 491: INSERT INTO cn_calc_edges

487: TO_NUMBER(
488: SUBSTR(p_piped_sql_select, l_dummy, INSTR(p_piped_sql_select, '_', l_dummy, 1) - l_dummy)
489: );
490:
491: INSERT INTO cn_calc_edges
492: (
493: org_id
494: , calc_edge_id
495: , parent_id

Line 506: , cn_calc_edges_s.NEXTVAL

502: , last_updated_by
503: )
504: VALUES (
505: p_org_id
506: , cn_calc_edges_s.NEXTVAL
507: , x_calc_sql_exp_id
508: , l_calc_formula_id
509: , 'FE'
510: , SYSDATE

Line 597: -- 3) adjust the corresponding embedding relations in cn_calc_edges

593: --
594: -- Notes : Update SQL expressions that will be used in calculation.
595: -- 1) validate the expression and return the result in x_status (Valid or Invalid)
596: -- 2) re-classify expressions into sub types for formula validation and dynamic rate table validation
597: -- 3) adjust the corresponding embedding relations in cn_calc_edges
598: -- 4) if the expression is used, update the parent expressions, formulas accordingly
599: --
600: -- End of comments
601: PROCEDURE update_expression(

Line 642: FROM cn_calc_edges

638: CURSOR parent_exist IS
639: SELECT 1
640: FROM DUAL
641: WHERE (EXISTS(SELECT 1
642: FROM cn_calc_edges
643: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
644: OR (
645: EXISTS(SELECT 1
646: FROM cn_calc_formulas

Line 772: INSERT INTO cn_calc_edges

768: AND (l_select_end - l_select_start) > 1
769: ) THEN
770: l_exp_names := l_exp_names || l_token || '|';
771:
772: INSERT INTO cn_calc_edges
773: (
774: org_id
775: , calc_edge_id
776: , parent_id

Line 786: , cn_calc_edges_s.NEXTVAL

782: , last_update_date
783: , last_updated_by
784: )
785: SELECT org_id
786: , cn_calc_edges_s.NEXTVAL
787: , p_calc_sql_exp_id
788: , calc_sql_exp_id
789: , 'EE'
790: , SYSDATE

Line 800: FROM cn_calc_edges

796: WHERE NAME = l_token
797: AND org_id= p_org_id
798: AND NOT EXISTS(
799: SELECT 1
800: FROM cn_calc_edges
801: WHERE parent_id = p_calc_sql_exp_id
802: AND child_id = (SELECT calc_sql_exp_id
803: FROM cn_calc_sql_exps
804: WHERE NAME = l_token AND org_id = p_org_id AND edge_type = 'EE'));

Line 813: INSERT INTO cn_calc_edges

809: SUBSTR(p_piped_sql_select, l_dummy, INSTR(p_piped_sql_select, '_', l_dummy, 1) - l_dummy)
810: );
811: l_formula_ids := l_formula_ids || l_calc_formula_id || '|';
812:
813: INSERT INTO cn_calc_edges
814: (
815: org_id
816: , calc_edge_id
817: , parent_id

Line 827: , cn_calc_edges_s.NEXTVAL

823: , last_update_date
824: , last_updated_by
825: )
826: SELECT p_org_id
827: , cn_calc_edges_s.NEXTVAL
828: , p_calc_sql_exp_id
829: , l_calc_formula_id
830: , 'FE'
831: , SYSDATE

Line 839: FROM cn_calc_edges

835: , fnd_global.user_id
836: FROM DUAL
837: WHERE NOT EXISTS(
838: SELECT 1
839: FROM cn_calc_edges
840: WHERE parent_id = p_calc_sql_exp_id
841: AND child_id = l_calc_formula_id
842: AND edge_type = 'FE');
843: END IF;

Line 850: DELETE FROM cn_calc_edges

846: END LOOP;
847:
848: -- delete obsolete calc edges
849: --IF (l_formula_ids <> '|') THEN
850: DELETE FROM cn_calc_edges
851: WHERE parent_id = p_calc_sql_exp_id
852: AND INSTR(l_formula_ids, '|' || child_id || '|', 1, 1) = 0
853: AND edge_type = 'FE';
854:

Line 858: DELETE FROM cn_calc_edges a

854:
855: --END IF;
856:
857: --IF (l_exp_names <> '|') THEN
858: DELETE FROM cn_calc_edges a
859: WHERE a.parent_id = p_calc_sql_exp_id
860: AND a.edge_type = 'EE'
861: AND NOT EXISTS(
862: SELECT 1

Line 929: -- 2) delete the embedding relations in cn_calc_edges if there is any

925: -- Initial version 1.0
926: --
927: -- Notes : Delete an expression
928: -- 1) if it is used, it can not be deleted
929: -- 2) delete the embedding relations in cn_calc_edges if there is any
930: --
931: -- End of comments
932: PROCEDURE delete_expression(
933: p_api_version IN NUMBER

Line 950: FROM cn_calc_edges

946: CURSOR parent_exist IS
947: SELECT 1
948: FROM DUAL
949: WHERE (EXISTS(SELECT 1
950: FROM cn_calc_edges
951: WHERE child_id = p_calc_sql_exp_id AND edge_type = 'EE'))
952: OR (
953: EXISTS(SELECT 1
954: FROM cn_calc_formulas

Line 1000: DELETE FROM cn_calc_edges e

996: END IF;
997:
998: cn_calc_sql_exps_pkg.delete_row(x_calc_sql_exp_id => p_calc_sql_exp_id);
999:
1000: DELETE FROM cn_calc_edges e
1001: WHERE edge_type IN('EE', 'FE') AND NOT EXISTS(SELECT 1
1002: FROM cn_calc_sql_exps
1003: WHERE calc_sql_exp_id = e.parent_id);
1004:

Line 1083: FROM cn_calc_edges

1079: CURSOR parent_names IS
1080: SELECT name
1081: FROM cn_calc_sql_exps
1082: WHERE calc_sql_exp_id IN (SELECT parent_id
1083: FROM cn_calc_edges
1084: CONNECT BY child_id = PRIOR parent_id
1085: AND edge_type = 'EE'
1086: START WITH child_id = p_calc_sql_exp_id
1087: AND edge_type = 'EE')

Line 1533: FROM cn_calc_edges

1529: AND ccf.calc_formula_id = p_current_id;
1530:
1531: CURSOR get_child_edges IS
1532: SELECT child_id
1533: FROM cn_calc_edges
1534: WHERE edge_type = 'FE' AND parent_id = p_current_id;
1535:
1536: CURSOR get_sql_sel IS
1537: SELECT DBMS_LOB.SUBSTR(sql_select)

Line 1681: FROM cn_calc_edges

1677: OR perf_measure_id = p_current_id;
1678:
1679: CURSOR get_parent_exps IS
1680: SELECT parent_id exp_id
1681: FROM cn_calc_edges
1682: WHERE edge_type = 'FE' AND child_id = p_current_id;
1683:
1684: l_current_id NUMBER;
1685: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;