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_SQL_EXPS

Line 1: PACKAGE BODY cn_calc_sql_exps_pvt AS

1: PACKAGE BODY cn_calc_sql_exps_pvt AS
2: /*$Header: cnvcexpb.pls 120.10.12010000.4 2010/03/15 18:36:42 rnagired ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';
4:
5: g_original_node_type VARCHAR2(2000);

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';

1: PACKAGE BODY cn_calc_sql_exps_pvt AS
2: /*$Header: cnvcexpb.pls 120.10.12010000.4 2010/03/15 18:36:42 rnagired ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';
4:
5: g_original_node_type VARCHAR2(2000);
6: g_original_node_id NUMBER;
7: g_node_type VARCHAR2(2000);

Line 13: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE

9: g_level NUMBER;
10: g_pe_arr num_tbl_type;
11:
12: PROCEDURE get_usage_info(
13: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
14: , x_usage_info OUT NOCOPY VARCHAR2
15: ) IS
16: BEGIN
17: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);

Line 24: p_org_id IN cn_calc_sql_exps.org_id%TYPE

20: x_usage_info := NULL;
21: END get_usage_info;
22:
23: PROCEDURE classify_expression(
24: p_org_id IN cn_calc_sql_exps.org_id%TYPE
25: , p_sql_select IN VARCHAR2
26: , p_sql_from IN VARCHAR2
27: , p_piped_sql_select IN VARCHAR2
28: , p_piped_sql_from IN VARCHAR2

Line 29: , x_status IN OUT NOCOPY cn_calc_sql_exps.status%TYPE

25: , p_sql_select IN VARCHAR2
26: , p_sql_from IN VARCHAR2
27: , p_piped_sql_select IN VARCHAR2
28: , p_piped_sql_from IN VARCHAR2
29: , x_status IN OUT NOCOPY cn_calc_sql_exps.status%TYPE
30: , x_exp_type_code IN OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
33: ) IS

Line 30: , x_exp_type_code IN OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE

26: , p_sql_from IN VARCHAR2
27: , p_piped_sql_select IN VARCHAR2
28: , p_piped_sql_from IN VARCHAR2
29: , x_status IN OUT NOCOPY cn_calc_sql_exps.status%TYPE
30: , x_exp_type_code IN OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
33: ) IS
34: l_dummy PLS_INTEGER;

Line 323: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

319: p_api_version IN NUMBER
320: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
321: , p_commit IN VARCHAR2 := fnd_api.g_false
322: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
323: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
324: , p_name IN cn_calc_sql_exps.NAME%TYPE
325: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
326: , p_expression_disp IN VARCHAR2 := NULL
327: , -- CLOBs

Line 324: , p_name IN cn_calc_sql_exps.NAME%TYPE

320: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
321: , p_commit IN VARCHAR2 := fnd_api.g_false
322: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
323: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
324: , p_name IN cn_calc_sql_exps.NAME%TYPE
325: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
326: , p_expression_disp IN VARCHAR2 := NULL
327: , -- CLOBs
328: p_sql_select IN VARCHAR2 := NULL

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

321: , p_commit IN VARCHAR2 := fnd_api.g_false
322: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
323: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
324: , p_name IN cn_calc_sql_exps.NAME%TYPE
325: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
326: , p_expression_disp IN VARCHAR2 := NULL
327: , -- CLOBs
328: p_sql_select IN VARCHAR2 := NULL
329: , p_sql_from IN VARCHAR2 := NULL

Line 333: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE

329: , p_sql_from IN VARCHAR2 := NULL
330: , p_piped_expression_disp IN VARCHAR2 := NULL
331: , p_piped_sql_select IN VARCHAR2 := NULL
332: , p_piped_sql_from IN VARCHAR2 := NULL
333: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
334: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
335: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
336: , x_return_status OUT NOCOPY VARCHAR2
337: , x_msg_count OUT NOCOPY NUMBER

Line 334: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE

330: , p_piped_expression_disp IN VARCHAR2 := NULL
331: , p_piped_sql_select IN VARCHAR2 := NULL
332: , p_piped_sql_from IN VARCHAR2 := NULL
333: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
334: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
335: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
336: , x_return_status OUT NOCOPY VARCHAR2
337: , x_msg_count OUT NOCOPY NUMBER
338: , x_msg_data OUT NOCOPY VARCHAR2

Line 335: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE

331: , p_piped_sql_select IN VARCHAR2 := NULL
332: , p_piped_sql_from IN VARCHAR2 := NULL
333: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
334: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
335: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
336: , x_return_status OUT NOCOPY VARCHAR2
337: , x_msg_count OUT NOCOPY NUMBER
338: , x_msg_data OUT NOCOPY VARCHAR2
339: , x_object_version_number OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE

Line 339: , x_object_version_number OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE

335: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
336: , x_return_status OUT NOCOPY VARCHAR2
337: , x_msg_count OUT NOCOPY NUMBER
338: , x_msg_data OUT NOCOPY VARCHAR2
339: , x_object_version_number OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
340: ) IS
341: l_api_name CONSTANT VARCHAR2(30) := 'Create_Expression';
342: l_api_version CONSTANT NUMBER := 1.0;
343: l_prompt cn_lookups.meaning%TYPE;

Line 354: FROM cn_calc_sql_exps

350: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
351:
352: CURSOR exp_exists IS
353: SELECT 1
354: FROM cn_calc_sql_exps
355: WHERE NAME = p_name AND org_id = p_org_id;
356: BEGIN
357: -- Standard Start of API savepoint
358: SAVEPOINT create_expression;

Line 422: cn_calc_sql_exps_pkg.insert_row(

418: , x_msg_count => x_msg_count
419: , x_msg_data => x_msg_data
420: );
421: -- call table handler to create the expression
422: cn_calc_sql_exps_pkg.insert_row(
423: x_org_id => p_org_id
424: , x_calc_sql_exp_id => x_calc_sql_exp_id
425: , x_name => p_name
426: , x_description => p_description

Line 481: FROM cn_calc_sql_exps

477: , fnd_global.user_id
478: , fnd_global.login_id
479: , SYSDATE
480: , fnd_global.user_id
481: FROM cn_calc_sql_exps
482: WHERE NAME = l_token
483: AND org_id=p_org_id;
484: ELSIF(INSTR(p_piped_sql_select, 'cn_formula', l_select_start, 1) = l_select_start) THEN
485: l_dummy := INSTR(p_piped_sql_select, '_', l_select_start, 2) + 1;

Line 607: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

603: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
604: , p_commit IN VARCHAR2 := fnd_api.g_false
605: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
606: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
607: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
608: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
609: , p_name IN cn_calc_sql_exps.NAME%TYPE
610: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
611: , p_expression_disp IN VARCHAR2 := NULL

Line 608: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

604: , p_commit IN VARCHAR2 := fnd_api.g_false
605: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
606: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
607: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
608: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
609: , p_name IN cn_calc_sql_exps.NAME%TYPE
610: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
611: , p_expression_disp IN VARCHAR2 := NULL
612: , -- CLOBs

Line 609: , p_name IN cn_calc_sql_exps.NAME%TYPE

605: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
606: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
607: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
608: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
609: , p_name IN cn_calc_sql_exps.NAME%TYPE
610: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
611: , p_expression_disp IN VARCHAR2 := NULL
612: , -- CLOBs
613: p_sql_select IN VARCHAR2 := NULL

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

606: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
607: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
608: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
609: , p_name IN cn_calc_sql_exps.NAME%TYPE
610: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
611: , p_expression_disp IN VARCHAR2 := NULL
612: , -- CLOBs
613: p_sql_select IN VARCHAR2 := NULL
614: , p_sql_from IN VARCHAR2 := NULL

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

614: , p_sql_from IN VARCHAR2 := NULL
615: , p_piped_expression_disp IN VARCHAR2 := NULL
616: , p_piped_sql_select IN VARCHAR2 := NULL
617: , p_piped_sql_from IN VARCHAR2 := NULL
618: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
619: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
620: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
621: , x_return_status OUT NOCOPY VARCHAR2
622: , x_msg_count OUT NOCOPY NUMBER

Line 619: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE

615: , p_piped_expression_disp IN VARCHAR2 := NULL
616: , p_piped_sql_select IN VARCHAR2 := NULL
617: , p_piped_sql_from IN VARCHAR2 := NULL
618: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
619: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
620: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
621: , x_return_status OUT NOCOPY VARCHAR2
622: , x_msg_count OUT NOCOPY NUMBER
623: , x_msg_data OUT NOCOPY VARCHAR2

Line 620: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE

616: , p_piped_sql_select IN VARCHAR2 := NULL
617: , p_piped_sql_from IN VARCHAR2 := NULL
618: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
619: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
620: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
621: , x_return_status OUT NOCOPY VARCHAR2
622: , x_msg_count OUT NOCOPY NUMBER
623: , x_msg_data OUT NOCOPY VARCHAR2
624: ) IS

Line 662: FROM cn_calc_sql_exps

658: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
659:
660: CURSOR exp_exists IS
661: SELECT 1
662: FROM cn_calc_sql_exps
663: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
664: BEGIN
665: -- Standard Start of API savepoint
666: SAVEPOINT update_expression;

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

729: , x_msg_count => x_msg_count
730: , x_msg_data => x_msg_data
731: );
732: -- check ovn
733: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);
734: -- do update
735: cn_calc_sql_exps_pkg.update_row(
736: x_org_id => p_org_id
737: , x_calc_sql_exp_id => p_calc_sql_exp_id

Line 735: cn_calc_sql_exps_pkg.update_row(

731: );
732: -- check ovn
733: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);
734: -- do update
735: cn_calc_sql_exps_pkg.update_row(
736: x_org_id => p_org_id
737: , x_calc_sql_exp_id => p_calc_sql_exp_id
738: , x_name => p_name
739: , x_description => p_description

Line 795: FROM cn_calc_sql_exps

791: , fnd_global.user_id
792: , fnd_global.login_id
793: , SYSDATE
794: , fnd_global.user_id
795: FROM cn_calc_sql_exps
796: WHERE NAME = l_token
797: AND org_id= p_org_id
798: AND NOT EXISTS(
799: SELECT 1

Line 803: FROM cn_calc_sql_exps

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

Line 863: FROM cn_calc_sql_exps b

859: WHERE a.parent_id = p_calc_sql_exp_id
860: AND a.edge_type = 'EE'
861: AND NOT EXISTS(
862: SELECT 1
863: FROM cn_calc_sql_exps b
864: WHERE a.child_id = b.calc_sql_exp_id
865: AND INSTR(l_exp_names, '|' || b.NAME || '|', 1, 1) > 0);
866:
867: --END IF;

Line 937: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

933: p_api_version IN NUMBER
934: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
935: , p_commit IN VARCHAR2 := fnd_api.g_false
936: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
937: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
938: , x_return_status OUT NOCOPY VARCHAR2
939: , x_msg_count OUT NOCOPY NUMBER
940: , x_msg_data OUT NOCOPY VARCHAR2
941: ) IS

Line 998: cn_calc_sql_exps_pkg.delete_row(x_calc_sql_exp_id => p_calc_sql_exp_id);

994:
995: RAISE fnd_api.g_exc_error;
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

Line 1002: FROM cn_calc_sql_exps

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:
1005: -- End of API body.
1006:

Line 1067: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

1063: (p_api_version IN NUMBER ,
1064: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1065: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1066: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1067: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1068: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,
1069: x_return_status OUT NOCOPY VARCHAR2 ,
1070: x_msg_count OUT NOCOPY NUMBER ,
1071: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1081: FROM cn_calc_sql_exps

1077:
1078: -- names of parent performance measures and formulas and dimensions
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'

Line 1179: from cn_calc_sql_exps

1175: l_srch_name varchar2(31) := upper(p_srch_name) || '%';
1176:
1177: CURSOR get_rows IS
1178: select calc_sql_exp_id, name, description, status, exp_type_code
1179: from cn_calc_sql_exps
1180: where upper(name) like l_srch_name
1181: order by 2;
1182: CURSOR count_rows IS select count(1) from cn_calc_sql_exps
1183: where upper(name) like l_srch_name;

Line 1182: CURSOR count_rows IS select count(1) from cn_calc_sql_exps

1178: select calc_sql_exp_id, name, description, status, exp_type_code
1179: from cn_calc_sql_exps
1180: where upper(name) like l_srch_name
1181: order by 2;
1182: CURSOR count_rows IS select count(1) from cn_calc_sql_exps
1183: where upper(name) like l_srch_name;
1184:
1185: BEGIN
1186: open count_rows;

Line 1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

1197: end loop;
1198: END get_expr_summary; */
1199:
1200: /* PROCEDURE get_expr_detail
1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

Line 1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,

1198: END get_expr_summary; */
1199:
1200: /* PROCEDURE get_expr_detail
1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1206: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs

Line 1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,

1199:
1200: /* PROCEDURE get_expr_detail
1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1206: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1207: x_sql_select OUT NOCOPY VARCHAR2,

Line 1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,

1200: /* PROCEDURE get_expr_detail
1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1206: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1207: x_sql_select OUT NOCOPY VARCHAR2,
1208: x_sql_from OUT NOCOPY VARCHAR2,

Line 1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

1201: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1202: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1203: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1204: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1205: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1206: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1207: x_sql_select OUT NOCOPY VARCHAR2,
1208: x_sql_from OUT NOCOPY VARCHAR2,
1209: x_piped_sql_select OUT NOCOPY VARCHAR2,

Line 1212: x_ovn OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS

1208: x_sql_from OUT NOCOPY VARCHAR2,
1209: x_piped_sql_select OUT NOCOPY VARCHAR2,
1210: x_piped_sql_from OUT NOCOPY VARCHAR2,
1211: x_piped_expression_disp OUT NOCOPY VARCHAR2,
1212: x_ovn OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
1213:
1214: CURSOR get_data IS
1215: select name, description, status, exp_type_code,
1216: dbms_lob.substr(expression_disp),

Line 1223: from cn_calc_sql_exps where calc_sql_exp_id = p_calc_sql_exp_id;

1219: dbms_lob.substr(piped_sql_select),
1220: dbms_lob.substr(piped_sql_from),
1221: dbms_lob.substr(piped_expression_disp),
1222: object_version_number
1223: from cn_calc_sql_exps where calc_sql_exp_id = p_calc_sql_exp_id;
1224: BEGIN
1225: OPEN get_data;
1226: FETCH get_data INTO x_name, x_description, x_status, x_exp_type_code,
1227: x_expression_disp, x_sql_select, x_sql_from,

Line 1269: from cn_calc_sql_exps

1265: order by user_name;
1266:
1267: cursor calc_expressions is
1268: select calc_sql_exp_id, name, dbms_lob.substr(sql_select) node_value
1269: from cn_calc_sql_exps
1270: where status = 'VALID'
1271: and dbms_lob.getlength(sql_select) < 3999
1272: order by name;
1273:

Line 1521: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi

1517: WHERE quota_id = p_current_id;
1518:
1519: CURSOR get_exp_ids IS
1520: SELECT ccse.calc_sql_exp_id
1521: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi
1522: WHERE (
1523: (ccse.calc_sql_exp_id = ccf.perf_measure_id)
1524: OR (ccse.calc_sql_exp_id = ccf.output_exp_id)
1525: OR (ccse.calc_sql_exp_id = cfi.calc_sql_exp_id)

Line 1538: FROM cn_calc_sql_exps

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)
1538: FROM cn_calc_sql_exps
1539: WHERE calc_sql_exp_id = p_current_id;
1540:
1541: l_current_id NUMBER;
1542: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 1542: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

1538: FROM cn_calc_sql_exps
1539: WHERE calc_sql_exp_id = p_current_id;
1540:
1541: l_current_id NUMBER;
1542: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1543: l_sql_sel VARCHAR2(4000);
1544: l_junk VARCHAR2(4000);
1545: BEGIN
1546: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN

Line 1576: cn_calc_sql_exps_pvt.parse_plan_elements(l_sql_sel, l_pe_tbl, l_junk);

1572: OPEN get_sql_sel;
1573: FETCH get_sql_sel INTO l_sql_sel;
1574: CLOSE get_sql_sel;
1575:
1576: cn_calc_sql_exps_pvt.parse_plan_elements(l_sql_sel, l_pe_tbl, l_junk);
1577:
1578: FOR x IN 1 .. l_pe_tbl.COUNT LOOP
1579: dfs(p_original_node_type, p_original_node_id, 'P', l_pe_tbl(x), p_level + 1, p_pe_arr);
1580: END LOOP;

Line 1665: FROM cn_calc_sql_exps

1661: WHERE calc_formula_id = p_current_id;
1662:
1663: CURSOR get_exp_ids IS
1664: SELECT calc_sql_exp_id
1665: FROM cn_calc_sql_exps
1666: WHERE DBMS_LOB.SUBSTR(sql_select) LIKE '%(' || p_current_id || 'PE.%';
1667:
1668: CURSOR get_formulas IS
1669: SELECT calc_formula_id

Line 1685: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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;
1686: BEGIN
1687: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1688: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1689: fnd_msg_pub.ADD;

Line 2164: l_type_code cn_calc_sql_exps.exp_type_code%TYPE;

2160: l_error_code VARCHAR2(4000);
2161: l_header_list VARCHAR2(4000);
2162: l_sql_stmt VARCHAR2(4000);
2163: l_return_status VARCHAR2(1);
2164: l_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2165: my_message VARCHAR2(4000);
2166: l_status VARCHAR2(30);
2167: l_sql_from VARCHAR2(4000);
2168: l_piped_sql_from VARCHAR2(4000);

Line 2172: l_object_version_number cn_calc_sql_exps.object_version_number%TYPE;

2168: l_piped_sql_from VARCHAR2(4000);
2169: l_piped_sql_select VARCHAR2(4000);
2170: l_piped_expr_disp VARCHAR2(4000);
2171: l_expr_disp VARCHAR2(4000);
2172: l_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2173:
2174: CURSOR get_api_recs IS
2175: SELECT *
2176: FROM cn_exp_api_imp_v

Line 2308: UPDATE cn_calc_sql_exps

2304:
2305: IF l_return_status = fnd_api.g_ret_sts_success THEN
2306: -- update attribute values appropriately since API doesn't
2307: -- handle flexfields
2308: UPDATE cn_calc_sql_exps
2309: SET attribute_category = l_api_rec.attribute_category
2310: , attribute1 = l_api_rec.attribute1
2311: , attribute2 = l_api_rec.attribute2
2312: , attribute3 = l_api_rec.attribute3

Line 2545: FROM cn_calc_sql_exps

2541: , attribute12
2542: , attribute13
2543: , attribute14
2544: , attribute15
2545: FROM cn_calc_sql_exps
2546: WHERE org_id = p_org_id
2547: ORDER BY 1;
2548:
2549: CURSOR get_rowcount IS

Line 2551: FROM cn_calc_sql_exps

2547: ORDER BY 1;
2548:
2549: CURSOR get_rowcount IS
2550: SELECT COUNT(1)
2551: FROM cn_calc_sql_exps
2552: WHERE org_id = p_org_id;
2553:
2554: CURSOR get_long_rowcount IS
2555: SELECT COUNT(1)

Line 2556: FROM cn_calc_sql_exps

2552: WHERE org_id = p_org_id;
2553:
2554: CURSOR get_long_rowcount IS
2555: SELECT COUNT(1)
2556: FROM cn_calc_sql_exps
2557: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length AND org_id = p_org_id;
2558: BEGIN
2559: retcode := 0;
2560:

Line 2685: FROM cn_calc_sql_exps

2681: SET status_code = 'FAIL'
2682: , error_msg = my_message
2683: WHERE imp_header_id = p_imp_header_id
2684: AND expression_name IN(SELECT NAME
2685: FROM cn_calc_sql_exps
2686: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length);
2687:
2688: cn_message_pkg.WRITE
2689: (

Line 2734: , x_new_expr_name OUT NOCOPY cn_calc_sql_exps.NAME%TYPE

2730: , p_commit IN VARCHAR2 := fnd_api.g_false
2731: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2732: , p_old_expr_id IN NUMBER
2733: , x_new_expr_id OUT NOCOPY NUMBER
2734: , x_new_expr_name OUT NOCOPY cn_calc_sql_exps.NAME%TYPE
2735: , x_return_status OUT NOCOPY VARCHAR2
2736: , x_msg_count OUT NOCOPY NUMBER
2737: , x_msg_data OUT NOCOPY VARCHAR2
2738: ) IS

Line 2741: l_org_id cn_calc_sql_exps.org_id%TYPE;

2737: , x_msg_data OUT NOCOPY VARCHAR2
2738: ) IS
2739: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Expression';
2740: l_api_version CONSTANT NUMBER := 1.0;
2741: l_org_id cn_calc_sql_exps.org_id%TYPE;
2742: l_description cn_calc_sql_exps.description%TYPE;
2743: l_expression_disp VARCHAR2(32767);
2744: l_sql_select VARCHAR2(32767);
2745: l_sql_from VARCHAR2(32767);

Line 2742: l_description cn_calc_sql_exps.description%TYPE;

2738: ) IS
2739: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Expression';
2740: l_api_version CONSTANT NUMBER := 1.0;
2741: l_org_id cn_calc_sql_exps.org_id%TYPE;
2742: l_description cn_calc_sql_exps.description%TYPE;
2743: l_expression_disp VARCHAR2(32767);
2744: l_sql_select VARCHAR2(32767);
2745: l_sql_from VARCHAR2(32767);
2746: l_piped_expression_disp VARCHAR2(32767);

Line 2749: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;

2745: l_sql_from VARCHAR2(32767);
2746: l_piped_expression_disp VARCHAR2(32767);
2747: l_piped_sql_select VARCHAR2(32767);
2748: l_piped_sql_from VARCHAR2(32767);
2749: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2750: x_status cn_calc_sql_exps.status%TYPE;
2751: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2752: l_suffix VARCHAR2(10) := NULL;
2753: l_prefix VARCHAR2(10) := NULL;

Line 2750: x_status cn_calc_sql_exps.status%TYPE;

2746: l_piped_expression_disp VARCHAR2(32767);
2747: l_piped_sql_select VARCHAR2(32767);
2748: l_piped_sql_from VARCHAR2(32767);
2749: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2750: x_status cn_calc_sql_exps.status%TYPE;
2751: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2752: l_suffix VARCHAR2(10) := NULL;
2753: l_prefix VARCHAR2(10) := NULL;
2754: BEGIN

Line 2751: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;

2747: l_piped_sql_select VARCHAR2(32767);
2748: l_piped_sql_from VARCHAR2(32767);
2749: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2750: x_status cn_calc_sql_exps.status%TYPE;
2751: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2752: l_suffix VARCHAR2(10) := NULL;
2753: l_prefix VARCHAR2(10) := NULL;
2754: BEGIN
2755: -- Standard Start of API savepoint

Line 2789: FROM cn_calc_sql_exps

2785: , l_sql_from
2786: , l_piped_expression_disp
2787: , l_piped_sql_select
2788: , l_piped_sql_from
2789: FROM cn_calc_sql_exps
2790: WHERE calc_sql_exp_id = p_old_expr_id;
2791:
2792: -- x_new_expr_name := x_new_expr_name || '_2';
2793: cn_plancopy_util_pvt.get_unique_name_for_component(

Line 2862: END cn_calc_sql_exps_pvt;

2858:
2859: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2860: , p_encoded => fnd_api.g_false);
2861: END duplicate_expression;
2862: END cn_calc_sql_exps_pvt;