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.2 2008/12/08 10:23:18 venjayar ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';
4:
5: PROCEDURE get_usage_info(

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.2 2008/12/08 10:23:18 venjayar ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';
4:
5: PROCEDURE get_usage_info(
6: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
7: , x_usage_info OUT NOCOPY VARCHAR2

Line 6: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE

2: /*$Header: cnvcexpb.pls 120.10.12010000.2 2008/12/08 10:23:18 venjayar ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_CALC_SQL_EXPS_PVT';
4:
5: PROCEDURE get_usage_info(
6: p_exp_type_code IN cn_calc_sql_exps.exp_type_code%TYPE
7: , x_usage_info OUT NOCOPY VARCHAR2
8: ) IS
9: BEGIN
10: x_usage_info := fnd_message.get_string('CN', p_exp_type_code);

Line 17: p_org_id IN cn_calc_sql_exps.org_id%TYPE

13: x_usage_info := NULL;
14: END get_usage_info;
15:
16: PROCEDURE classify_expression(
17: p_org_id IN cn_calc_sql_exps.org_id%TYPE
18: , p_sql_select IN VARCHAR2
19: , -- CLOBs
20: p_sql_from IN VARCHAR2
21: , p_piped_sql_select IN VARCHAR2

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

19: , -- CLOBs
20: p_sql_from IN VARCHAR2
21: , p_piped_sql_select IN VARCHAR2
22: , p_piped_sql_from IN VARCHAR2
23: , x_status IN OUT NOCOPY cn_calc_sql_exps.status%TYPE
24: , x_exp_type_code IN OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
25: , x_msg_count OUT NOCOPY NUMBER
26: , x_msg_data OUT NOCOPY VARCHAR2
27: ) IS

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

20: p_sql_from IN VARCHAR2
21: , p_piped_sql_select IN VARCHAR2
22: , p_piped_sql_from IN VARCHAR2
23: , x_status IN OUT NOCOPY cn_calc_sql_exps.status%TYPE
24: , x_exp_type_code IN OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
25: , x_msg_count OUT NOCOPY NUMBER
26: , x_msg_data OUT NOCOPY VARCHAR2
27: ) IS
28: l_dummy PLS_INTEGER;

Line 317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

313: p_api_version IN NUMBER
314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE
319: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
320: , p_expression_disp IN VARCHAR2 := NULL
321: , -- CLOBs

Line 318: , p_name IN cn_calc_sql_exps.NAME%TYPE

314: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE
319: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
320: , p_expression_disp IN VARCHAR2 := NULL
321: , -- CLOBs
322: p_sql_select IN VARCHAR2 := NULL

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

315: , p_commit IN VARCHAR2 := fnd_api.g_false
316: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
317: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
318: , p_name IN cn_calc_sql_exps.NAME%TYPE
319: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
320: , p_expression_disp IN VARCHAR2 := NULL
321: , -- CLOBs
322: p_sql_select IN VARCHAR2 := NULL
323: , p_sql_from IN VARCHAR2 := NULL

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

323: , p_sql_from IN VARCHAR2 := NULL
324: , p_piped_expression_disp IN VARCHAR2 := NULL
325: , p_piped_sql_select IN VARCHAR2 := NULL
326: , p_piped_sql_from IN VARCHAR2 := NULL
327: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
328: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
329: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
330: , x_return_status OUT NOCOPY VARCHAR2
331: , x_msg_count OUT NOCOPY NUMBER

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

324: , p_piped_expression_disp IN VARCHAR2 := NULL
325: , p_piped_sql_select IN VARCHAR2 := NULL
326: , p_piped_sql_from IN VARCHAR2 := NULL
327: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
328: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
329: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
330: , x_return_status OUT NOCOPY VARCHAR2
331: , x_msg_count OUT NOCOPY NUMBER
332: , x_msg_data OUT NOCOPY VARCHAR2

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

325: , p_piped_sql_select IN VARCHAR2 := NULL
326: , p_piped_sql_from IN VARCHAR2 := NULL
327: , x_calc_sql_exp_id IN OUT NOCOPY cn_calc_sql_exps.calc_sql_exp_id%TYPE
328: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
329: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
330: , x_return_status OUT NOCOPY VARCHAR2
331: , x_msg_count OUT NOCOPY NUMBER
332: , x_msg_data OUT NOCOPY VARCHAR2
333: , x_object_version_number OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE

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

329: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
330: , x_return_status OUT NOCOPY VARCHAR2
331: , x_msg_count OUT NOCOPY NUMBER
332: , x_msg_data OUT NOCOPY VARCHAR2
333: , x_object_version_number OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
334: ) IS
335: l_api_name CONSTANT VARCHAR2(30) := 'Create_Expression';
336: l_api_version CONSTANT NUMBER := 1.0;
337: l_prompt cn_lookups.meaning%TYPE;

Line 348: FROM cn_calc_sql_exps

344: l_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
345:
346: CURSOR exp_exists IS
347: SELECT 1
348: FROM cn_calc_sql_exps
349: WHERE NAME = p_name AND org_id = p_org_id;
350: BEGIN
351: -- Standard Start of API savepoint
352: SAVEPOINT create_expression;

Line 416: cn_calc_sql_exps_pkg.insert_row(

412: , x_msg_count => x_msg_count
413: , x_msg_data => x_msg_data
414: );
415: -- call table handler to create the expression
416: cn_calc_sql_exps_pkg.insert_row(
417: x_org_id => p_org_id
418: , x_calc_sql_exp_id => x_calc_sql_exp_id
419: , x_name => p_name
420: , x_description => p_description

Line 475: FROM cn_calc_sql_exps

471: , fnd_global.user_id
472: , fnd_global.login_id
473: , SYSDATE
474: , fnd_global.user_id
475: FROM cn_calc_sql_exps
476: WHERE NAME = l_token;
477: ELSIF(INSTR(p_piped_sql_select, 'cn_formula', l_select_start, 1) = l_select_start) THEN
478: l_dummy := INSTR(p_piped_sql_select, '_', l_select_start, 2) + 1;
479: l_calc_formula_id :=

Line 600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE

596: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE
603: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
604: , p_expression_disp IN VARCHAR2 := NULL

Line 601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

597: , p_commit IN VARCHAR2 := fnd_api.g_false
598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE
603: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
604: , p_expression_disp IN VARCHAR2 := NULL
605: , -- CLOBs

Line 602: , p_name IN cn_calc_sql_exps.NAME%TYPE

598: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE
603: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
604: , p_expression_disp IN VARCHAR2 := NULL
605: , -- CLOBs
606: p_sql_select IN VARCHAR2 := NULL

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

599: , p_update_parent_also IN VARCHAR2 := fnd_api.g_false
600: , p_org_id IN cn_calc_sql_exps.org_id%TYPE
601: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
602: , p_name IN cn_calc_sql_exps.NAME%TYPE
603: , p_description IN cn_calc_sql_exps.description%TYPE := NULL
604: , p_expression_disp IN VARCHAR2 := NULL
605: , -- CLOBs
606: p_sql_select IN VARCHAR2 := NULL
607: , p_sql_from IN VARCHAR2 := NULL

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

607: , p_sql_from IN VARCHAR2 := NULL
608: , p_piped_expression_disp IN VARCHAR2 := NULL
609: , p_piped_sql_select IN VARCHAR2 := NULL
610: , p_piped_sql_from IN VARCHAR2 := NULL
611: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
612: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
613: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_msg_count OUT NOCOPY NUMBER

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

608: , p_piped_expression_disp IN VARCHAR2 := NULL
609: , p_piped_sql_select IN VARCHAR2 := NULL
610: , p_piped_sql_from IN VARCHAR2 := NULL
611: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
612: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
613: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_msg_count OUT NOCOPY NUMBER
616: , x_msg_data OUT NOCOPY VARCHAR2

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

609: , p_piped_sql_select IN VARCHAR2 := NULL
610: , p_piped_sql_from IN VARCHAR2 := NULL
611: , p_ovn IN OUT NOCOPY cn_calc_sql_exps.object_version_number%TYPE
612: , x_exp_type_code OUT NOCOPY cn_calc_sql_exps.exp_type_code%TYPE
613: , x_status OUT NOCOPY cn_calc_sql_exps.status%TYPE
614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_msg_count OUT NOCOPY NUMBER
616: , x_msg_data OUT NOCOPY VARCHAR2
617: ) IS

Line 655: FROM cn_calc_sql_exps

651: WHERE min_exp_id = p_calc_sql_exp_id OR max_exp_id = p_calc_sql_exp_id));
652:
653: CURSOR exp_exists IS
654: SELECT 1
655: FROM cn_calc_sql_exps
656: WHERE NAME = p_name AND org_id = p_org_id AND calc_sql_exp_id <> p_calc_sql_exp_id;
657: BEGIN
658: -- Standard Start of API savepoint
659: SAVEPOINT update_expression;

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

722: , x_msg_count => x_msg_count
723: , x_msg_data => x_msg_data
724: );
725: -- check ovn
726: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);
727: -- do update
728: cn_calc_sql_exps_pkg.update_row(
729: x_org_id => p_org_id
730: , x_calc_sql_exp_id => p_calc_sql_exp_id

Line 728: cn_calc_sql_exps_pkg.update_row(

724: );
725: -- check ovn
726: cn_calc_sql_exps_pkg.lock_row(p_calc_sql_exp_id, p_ovn);
727: -- do update
728: cn_calc_sql_exps_pkg.update_row(
729: x_org_id => p_org_id
730: , x_calc_sql_exp_id => p_calc_sql_exp_id
731: , x_name => p_name
732: , x_description => p_description

Line 788: FROM cn_calc_sql_exps

784: , fnd_global.user_id
785: , fnd_global.login_id
786: , SYSDATE
787: , fnd_global.user_id
788: FROM cn_calc_sql_exps
789: WHERE NAME = l_token
790: AND NOT EXISTS(
791: SELECT 1
792: FROM cn_calc_edges

Line 795: FROM cn_calc_sql_exps

791: SELECT 1
792: FROM cn_calc_edges
793: WHERE parent_id = p_calc_sql_exp_id
794: AND child_id = (SELECT calc_sql_exp_id
795: FROM cn_calc_sql_exps
796: WHERE NAME = l_token AND edge_type = 'EE'));
797: ELSIF(INSTR(p_piped_sql_select, 'cn_formula', l_select_start, 1) = l_select_start) THEN
798: l_dummy := INSTR(p_piped_sql_select, '_', l_select_start, 2) + 1;
799: l_calc_formula_id :=

Line 855: FROM cn_calc_sql_exps b

851: WHERE a.parent_id = p_calc_sql_exp_id
852: AND a.edge_type = 'EE'
853: AND NOT EXISTS(
854: SELECT 1
855: FROM cn_calc_sql_exps b
856: WHERE a.child_id = b.calc_sql_exp_id
857: AND INSTR(l_exp_names, '|' || b.NAME || '|', 1, 1) > 0);
858:
859: --END IF;

Line 929: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE

925: p_api_version IN NUMBER
926: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
927: , p_commit IN VARCHAR2 := fnd_api.g_false
928: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
929: , p_calc_sql_exp_id IN cn_calc_sql_exps.calc_sql_exp_id%TYPE
930: , x_return_status OUT NOCOPY VARCHAR2
931: , x_msg_count OUT NOCOPY NUMBER
932: , x_msg_data OUT NOCOPY VARCHAR2
933: ) IS

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

986:
987: RAISE fnd_api.g_exc_error;
988: END IF;
989:
990: cn_calc_sql_exps_pkg.delete_row(x_calc_sql_exp_id => p_calc_sql_exp_id);
991:
992: DELETE FROM cn_calc_edges e
993: WHERE edge_type IN('EE', 'FE') AND NOT EXISTS(SELECT 1
994: FROM cn_calc_sql_exps

Line 994: FROM cn_calc_sql_exps

990: cn_calc_sql_exps_pkg.delete_row(x_calc_sql_exp_id => p_calc_sql_exp_id);
991:
992: DELETE FROM cn_calc_edges e
993: WHERE edge_type IN('EE', 'FE') AND NOT EXISTS(SELECT 1
994: FROM cn_calc_sql_exps
995: WHERE calc_sql_exp_id = e.parent_id);
996:
997: -- End of API body.
998:

Line 1059: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,

1055: (p_api_version IN NUMBER ,
1056: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1057: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1058: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1059: p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1060: x_parents_tbl OUT NOCOPY parent_expression_tbl_type ,
1061: x_return_status OUT NOCOPY VARCHAR2 ,
1062: x_msg_count OUT NOCOPY NUMBER ,
1063: x_msg_data OUT NOCOPY VARCHAR2 )

Line 1073: FROM cn_calc_sql_exps

1069:
1070: -- names of parent performance measures and formulas and dimensions
1071: CURSOR parent_names IS
1072: SELECT name
1073: FROM cn_calc_sql_exps
1074: WHERE calc_sql_exp_id IN (SELECT parent_id
1075: FROM cn_calc_edges
1076: CONNECT BY child_id = PRIOR parent_id
1077: AND edge_type = 'EE'

Line 1171: from cn_calc_sql_exps

1167: l_srch_name varchar2(31) := upper(p_srch_name) || '%';
1168:
1169: CURSOR get_rows IS
1170: select calc_sql_exp_id, name, description, status, exp_type_code
1171: from cn_calc_sql_exps
1172: where upper(name) like l_srch_name
1173: order by 2;
1174: CURSOR count_rows IS select count(1) from cn_calc_sql_exps
1175: where upper(name) like l_srch_name;

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

1170: select calc_sql_exp_id, name, description, status, exp_type_code
1171: from cn_calc_sql_exps
1172: where upper(name) like l_srch_name
1173: order by 2;
1174: CURSOR count_rows IS select count(1) from cn_calc_sql_exps
1175: where upper(name) like l_srch_name;
1176:
1177: BEGIN
1178: open count_rows;

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

1189: end loop;
1190: END get_expr_summary; */
1191:
1192: /* PROCEDURE get_expr_detail
1193: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1194: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1195: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1196: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1197: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,

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

1190: END get_expr_summary; */
1191:
1192: /* PROCEDURE get_expr_detail
1193: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1194: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1195: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1196: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1197: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1198: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs

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

1191:
1192: /* PROCEDURE get_expr_detail
1193: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1194: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1195: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1196: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1197: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1198: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1199: x_sql_select OUT NOCOPY VARCHAR2,

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

1192: /* PROCEDURE get_expr_detail
1193: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1194: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1195: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1196: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1197: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1198: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1199: x_sql_select OUT NOCOPY VARCHAR2,
1200: x_sql_from OUT NOCOPY VARCHAR2,

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

1193: (p_calc_sql_exp_id IN CN_CALC_SQL_EXPS.CALC_SQL_EXP_ID%TYPE,
1194: x_name OUT NOCOPY CN_CALC_SQL_EXPS.NAME%TYPE,
1195: x_description OUT NOCOPY CN_CALC_SQL_EXPS.DESCRIPTION%TYPE,
1196: x_status OUT NOCOPY CN_CALC_SQL_EXPS.STATUS%TYPE,
1197: x_exp_type_code OUT NOCOPY CN_CALC_SQL_EXPS.EXP_TYPE_CODE%TYPE,
1198: x_expression_disp OUT NOCOPY VARCHAR2, -- CLOBs
1199: x_sql_select OUT NOCOPY VARCHAR2,
1200: x_sql_from OUT NOCOPY VARCHAR2,
1201: x_piped_sql_select OUT NOCOPY VARCHAR2,

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

1200: x_sql_from OUT NOCOPY VARCHAR2,
1201: x_piped_sql_select OUT NOCOPY VARCHAR2,
1202: x_piped_sql_from OUT NOCOPY VARCHAR2,
1203: x_piped_expression_disp OUT NOCOPY VARCHAR2,
1204: x_ovn OUT NOCOPY CN_CALC_SQL_EXPS.OBJECT_VERSION_NUMBER%TYPE) IS
1205:
1206: CURSOR get_data IS
1207: select name, description, status, exp_type_code,
1208: dbms_lob.substr(expression_disp),

Line 1215: from cn_calc_sql_exps where calc_sql_exp_id = p_calc_sql_exp_id;

1211: dbms_lob.substr(piped_sql_select),
1212: dbms_lob.substr(piped_sql_from),
1213: dbms_lob.substr(piped_expression_disp),
1214: object_version_number
1215: from cn_calc_sql_exps where calc_sql_exp_id = p_calc_sql_exp_id;
1216: BEGIN
1217: OPEN get_data;
1218: FETCH get_data INTO x_name, x_description, x_status, x_exp_type_code,
1219: x_expression_disp, x_sql_select, x_sql_from,

Line 1261: from cn_calc_sql_exps

1257: order by user_name;
1258:
1259: cursor calc_expressions is
1260: select calc_sql_exp_id, name, dbms_lob.substr(sql_select) node_value
1261: from cn_calc_sql_exps
1262: where status = 'VALID'
1263: and dbms_lob.getlength(sql_select) < 3999
1264: order by name;
1265:

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

1509: WHERE quota_id = p_current_id;
1510:
1511: CURSOR get_exp_ids IS
1512: SELECT ccse.calc_sql_exp_id
1513: FROM cn_calc_sql_exps ccse, cn_calc_formulas ccf, cn_formula_inputs cfi
1514: WHERE (
1515: (ccse.calc_sql_exp_id = ccf.perf_measure_id)
1516: OR (ccse.calc_sql_exp_id = ccf.output_exp_id)
1517: OR (ccse.calc_sql_exp_id = cfi.calc_sql_exp_id)

Line 1530: FROM cn_calc_sql_exps

1526: WHERE edge_type = 'FE' AND parent_id = p_current_id;
1527:
1528: CURSOR get_sql_sel IS
1529: SELECT DBMS_LOB.SUBSTR(sql_select)
1530: FROM cn_calc_sql_exps
1531: WHERE calc_sql_exp_id = p_current_id;
1532:
1533: l_current_id NUMBER;
1534: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 1534: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

1530: FROM cn_calc_sql_exps
1531: WHERE calc_sql_exp_id = p_current_id;
1532:
1533: l_current_id NUMBER;
1534: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1535: l_sql_sel VARCHAR2(4000);
1536: l_junk VARCHAR2(4000);
1537: BEGIN
1538: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN

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

1565: OPEN get_sql_sel;
1566: FETCH get_sql_sel INTO l_sql_sel;
1567: CLOSE get_sql_sel;
1568:
1569: cn_calc_sql_exps_pvt.parse_plan_elements(l_sql_sel, l_pe_tbl, l_junk);
1570:
1571: FOR x IN 1 .. l_pe_tbl.COUNT LOOP
1572: dfs(p_original_node_type, p_original_node_id, 'P', l_pe_tbl(x), p_level + 1, p_pe_arr);
1573: END LOOP;

Line 1658: FROM cn_calc_sql_exps

1654: WHERE calc_formula_id = p_current_id;
1655:
1656: CURSOR get_exp_ids IS
1657: SELECT calc_sql_exp_id
1658: FROM cn_calc_sql_exps
1659: WHERE DBMS_LOB.SUBSTR(sql_select) LIKE '%(' || p_current_id || 'PE.%';
1660:
1661: CURSOR get_formulas IS
1662: SELECT calc_formula_id

Line 1678: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

1674: FROM cn_calc_edges
1675: WHERE edge_type = 'FE' AND child_id = p_current_id;
1676:
1677: l_current_id NUMBER;
1678: l_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1679: BEGIN
1680: IF p_node_type = p_original_node_type AND p_current_id = p_original_node_id AND p_level > 0 THEN
1681: fnd_message.set_name('CN', 'CN_PE_CANNOT_REF_ITSEF');
1682: fnd_msg_pub.ADD;

Line 2145: l_type_code cn_calc_sql_exps.exp_type_code%TYPE;

2141: l_error_code VARCHAR2(4000);
2142: l_header_list VARCHAR2(4000);
2143: l_sql_stmt VARCHAR2(4000);
2144: l_return_status VARCHAR2(1);
2145: l_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2146: my_message VARCHAR2(4000);
2147: l_status VARCHAR2(30);
2148: l_sql_from VARCHAR2(4000);
2149: l_piped_sql_from VARCHAR2(4000);

Line 2153: l_object_version_number cn_calc_sql_exps.object_version_number%TYPE;

2149: l_piped_sql_from VARCHAR2(4000);
2150: l_piped_sql_select VARCHAR2(4000);
2151: l_piped_expr_disp VARCHAR2(4000);
2152: l_expr_disp VARCHAR2(4000);
2153: l_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2154:
2155: CURSOR get_api_recs IS
2156: SELECT *
2157: FROM cn_exp_api_imp_v

Line 2290: UPDATE cn_calc_sql_exps

2286:
2287: IF l_return_status = fnd_api.g_ret_sts_success THEN
2288: -- update attribute values appropriately since API doesn't
2289: -- handle flexfields
2290: UPDATE cn_calc_sql_exps
2291: SET attribute_category = l_api_rec.attribute_category
2292: , attribute1 = l_api_rec.attribute1
2293: , attribute2 = l_api_rec.attribute2
2294: , attribute3 = l_api_rec.attribute3

Line 2527: FROM cn_calc_sql_exps

2523: , attribute12
2524: , attribute13
2525: , attribute14
2526: , attribute15
2527: FROM cn_calc_sql_exps
2528: WHERE org_id = p_org_id
2529: ORDER BY 1;
2530:
2531: CURSOR get_rowcount IS

Line 2533: FROM cn_calc_sql_exps

2529: ORDER BY 1;
2530:
2531: CURSOR get_rowcount IS
2532: SELECT COUNT(1)
2533: FROM cn_calc_sql_exps
2534: WHERE org_id = p_org_id;
2535:
2536: CURSOR get_long_rowcount IS
2537: SELECT COUNT(1)

Line 2538: FROM cn_calc_sql_exps

2534: WHERE org_id = p_org_id;
2535:
2536: CURSOR get_long_rowcount IS
2537: SELECT COUNT(1)
2538: FROM cn_calc_sql_exps
2539: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length AND org_id = p_org_id;
2540: BEGIN
2541: retcode := 0;
2542:

Line 2667: FROM cn_calc_sql_exps

2663: SET status_code = 'FAIL'
2664: , error_msg = my_message
2665: WHERE imp_header_id = p_imp_header_id
2666: AND expression_name IN(SELECT NAME
2667: FROM cn_calc_sql_exps
2668: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length);
2669:
2670: cn_message_pkg.WRITE
2671: (

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

2712: , p_commit IN VARCHAR2 := fnd_api.g_false
2713: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2714: , p_old_expr_id IN NUMBER
2715: , x_new_expr_id OUT NOCOPY NUMBER
2716: , x_new_expr_name OUT NOCOPY cn_calc_sql_exps.NAME%TYPE
2717: , x_return_status OUT NOCOPY VARCHAR2
2718: , x_msg_count OUT NOCOPY NUMBER
2719: , x_msg_data OUT NOCOPY VARCHAR2
2720: ) IS

Line 2723: l_org_id cn_calc_sql_exps.org_id%TYPE;

2719: , x_msg_data OUT NOCOPY VARCHAR2
2720: ) IS
2721: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Expression';
2722: l_api_version CONSTANT NUMBER := 1.0;
2723: l_org_id cn_calc_sql_exps.org_id%TYPE;
2724: l_description cn_calc_sql_exps.description%TYPE;
2725: l_expression_disp VARCHAR2(32767);
2726: l_sql_select VARCHAR2(32767);
2727: l_sql_from VARCHAR2(32767);

Line 2724: l_description cn_calc_sql_exps.description%TYPE;

2720: ) IS
2721: l_api_name CONSTANT VARCHAR2(30) := 'Duplicate_Expression';
2722: l_api_version CONSTANT NUMBER := 1.0;
2723: l_org_id cn_calc_sql_exps.org_id%TYPE;
2724: l_description cn_calc_sql_exps.description%TYPE;
2725: l_expression_disp VARCHAR2(32767);
2726: l_sql_select VARCHAR2(32767);
2727: l_sql_from VARCHAR2(32767);
2728: l_piped_expression_disp VARCHAR2(32767);

Line 2731: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;

2727: l_sql_from VARCHAR2(32767);
2728: l_piped_expression_disp VARCHAR2(32767);
2729: l_piped_sql_select VARCHAR2(32767);
2730: l_piped_sql_from VARCHAR2(32767);
2731: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2732: x_status cn_calc_sql_exps.status%TYPE;
2733: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2734: l_suffix VARCHAR2(10) := NULL;
2735: l_prefix VARCHAR2(10) := NULL;

Line 2732: x_status cn_calc_sql_exps.status%TYPE;

2728: l_piped_expression_disp VARCHAR2(32767);
2729: l_piped_sql_select VARCHAR2(32767);
2730: l_piped_sql_from VARCHAR2(32767);
2731: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2732: x_status cn_calc_sql_exps.status%TYPE;
2733: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2734: l_suffix VARCHAR2(10) := NULL;
2735: l_prefix VARCHAR2(10) := NULL;
2736: BEGIN

Line 2733: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;

2729: l_piped_sql_select VARCHAR2(32767);
2730: l_piped_sql_from VARCHAR2(32767);
2731: x_exp_type_code cn_calc_sql_exps.exp_type_code%TYPE;
2732: x_status cn_calc_sql_exps.status%TYPE;
2733: x_object_version_number cn_calc_sql_exps.object_version_number%TYPE;
2734: l_suffix VARCHAR2(10) := NULL;
2735: l_prefix VARCHAR2(10) := NULL;
2736: BEGIN
2737: -- Standard Start of API savepoint

Line 2771: FROM cn_calc_sql_exps

2767: , l_sql_from
2768: , l_piped_expression_disp
2769: , l_piped_sql_select
2770: , l_piped_sql_from
2771: FROM cn_calc_sql_exps
2772: WHERE calc_sql_exp_id = p_old_expr_id;
2773:
2774: -- x_new_expr_name := x_new_expr_name || '_2';
2775: cn_plancopy_util_pvt.get_unique_name_for_component(

Line 2844: END cn_calc_sql_exps_pvt;

2840:
2841: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data
2842: , p_encoded => fnd_api.g_false);
2843: END duplicate_expression;
2844: END cn_calc_sql_exps_pvt;