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_PLANCOPY_UTIL_PVT dependencies on CN_CALC_SQL_EXPS

Line 63: SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_calc_sql_exps_all where org_id = p_org_id and CALC_SQL_EXP_ID = p_id;

59: SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_comp_plans_all where org_id = p_org_id and comp_plan_id = p_id;
60: ELSIF (p_type = 'PLANELEMENT') THEN
61: SELECT SUBSTRB(NAME,1,(80-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_quotas_all where org_id = p_org_id and quota_id = p_id;
62: ELSIF (p_type = 'EXPRESSION') THEN
63: SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_calc_sql_exps_all where org_id = p_org_id and CALC_SQL_EXP_ID = p_id;
64: ELSIF (p_type = 'RATETABLE') THEN
65: SELECT SUBSTRB(NAME,1,(80-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_rate_schedules_all where org_id = p_org_id and RATE_SCHEDULE_ID = p_id;
66: ELSIF (p_type = 'RATEDIMENSION') THEN
67: SELECT SUBSTRB(NAME,1,(30-l_length)),LENGTHB(NAME) into l_obj_name,l_obj_length from cn_rate_dimensions_all where org_id = p_org_id and RATE_DIMENSION_ID = p_id;

Line 568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

564: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE
571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
572: , p_expression_disp IN VARCHAR2 := NULL

Line 569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

565: , p_commit IN VARCHAR2 := fnd_api.g_false
566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE
571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
572: , p_expression_disp IN VARCHAR2 := NULL
573: , -- CLOBs

Line 570: , p_name IN cn_calc_sql_exps.NAME%TYPE

566: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE
571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
572: , p_expression_disp IN VARCHAR2 := NULL
573: , -- CLOBs
574: p_sql_select IN VARCHAR2 := NULL

Line 571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL

567: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
568: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
569: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
570: , p_name IN cn_calc_sql_exps.NAME%TYPE
571: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
572: , p_expression_disp IN VARCHAR2 := NULL
573: , -- CLOBs
574: p_sql_select IN VARCHAR2 := NULL
575: , p_sql_from IN VARCHAR2 := NULL

Line 579: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE

575: , p_sql_from IN VARCHAR2 := NULL
576: , p_piped_expression_disp IN VARCHAR2 := NULL
577: , p_piped_sql_select IN VARCHAR2 := NULL
578: , p_piped_sql_from IN VARCHAR2 := NULL
579: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
580: , p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
581: , p_status IN cn_calc_sql_exps.status%TYPE
582: , x_return_status OUT NOCOPY VARCHAR2
583: , x_msg_count OUT NOCOPY NUMBER

Line 580: , p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE

576: , p_piped_expression_disp IN VARCHAR2 := NULL
577: , p_piped_sql_select IN VARCHAR2 := NULL
578: , p_piped_sql_from IN VARCHAR2 := NULL
579: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
580: , p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
581: , p_status IN cn_calc_sql_exps.status%TYPE
582: , x_return_status OUT NOCOPY VARCHAR2
583: , x_msg_count OUT NOCOPY NUMBER
584: , x_msg_data OUT NOCOPY VARCHAR2

Line 581: , p_status IN cn_calc_sql_exps.status%TYPE

577: , p_piped_sql_select IN VARCHAR2 := NULL
578: , p_piped_sql_from IN VARCHAR2 := NULL
579: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
580: , p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
581: , p_status IN cn_calc_sql_exps.status%TYPE
582: , x_return_status OUT NOCOPY VARCHAR2
583: , x_msg_count OUT NOCOPY NUMBER
584: , x_msg_data OUT NOCOPY VARCHAR2
585: ) IS

Line 602: FROM cn_calc_sql_exps

598:
599:
600: CURSOR exp_exists IS
601: SELECT 1
602: FROM cn_calc_sql_exps
603: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT update_expression;

Line 647: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);

643: RAISE fnd_api.g_exc_error;
644: END IF;
645:
646: -- check ovn
647: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);
648: -- do update
649:
650: fnd_file.put_line(fnd_file.Log, ' update_existing_expression: x_exp_type_code ' || p_exp_type_code || ' x_status :' || p_status);
651:

Line 652: cn_calc_sql_exps_pkg.update_row(

648: -- do update
649:
650: fnd_file.put_line(fnd_file.Log, ' update_existing_expression: x_exp_type_code ' || p_exp_type_code || ' x_status :' || p_status);
651:
652: cn_calc_sql_exps_pkg.update_row(
653: x_org_id => p_org_id
654: , x_calc_sql_exp_id => p_calc_sql_exp_id
655: , x_name => p_name
656: , x_description => p_description

Line 714: FROM cn_calc_sql_exps

710: , fnd_global.user_id
711: , fnd_global.login_id
712: , SYSDATE
713: , fnd_global.user_id
714: FROM cn_calc_sql_exps
715: WHERE NAME = l_token
716: AND org_id= p_org_id
717: AND NOT EXISTS(
718: SELECT 1

Line 722: FROM cn_calc_sql_exps

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'));
724: ELSIF(INSTR(p_piped_sql_select, 'cn_formula', l_select_start, 1) = l_select_start) THEN
725: l_dummy := INSTR(p_piped_sql_select, '_', l_select_start, 2) + 1;
726: l_calc_formula_id :=

Line 782: FROM cn_calc_sql_exps b

778: WHERE a.parent_id = p_calc_sql_exp_id
779: AND a.edge_type = 'EE'
780: AND NOT EXISTS(
781: SELECT 1
782: FROM cn_calc_sql_exps b
783: WHERE a.child_id = b.calc_sql_exp_id
784: AND INSTR(l_exp_names, '|' || b.NAME || '|', 1, 1) > 0);
785:
786: --END IF;