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 DBMS_LOB

Line 1208: dbms_lob.substr(expression_disp),

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),
1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
1211: dbms_lob.substr(piped_sql_select),
1212: dbms_lob.substr(piped_sql_from),

Line 1209: dbms_lob.substr(sql_select),

1205:
1206: CURSOR get_data IS
1207: select name, description, status, exp_type_code,
1208: dbms_lob.substr(expression_disp),
1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
1211: dbms_lob.substr(piped_sql_select),
1212: dbms_lob.substr(piped_sql_from),
1213: dbms_lob.substr(piped_expression_disp),

Line 1210: dbms_lob.substr(sql_from),

1206: CURSOR get_data IS
1207: select name, description, status, exp_type_code,
1208: dbms_lob.substr(expression_disp),
1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
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

Line 1211: dbms_lob.substr(piped_sql_select),

1207: select name, description, status, exp_type_code,
1208: dbms_lob.substr(expression_disp),
1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
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;

Line 1212: dbms_lob.substr(piped_sql_from),

1208: dbms_lob.substr(expression_disp),
1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
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

Line 1213: dbms_lob.substr(piped_expression_disp),

1209: dbms_lob.substr(sql_select),
1210: dbms_lob.substr(sql_from),
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;

Line 1260: select calc_sql_exp_id, name, dbms_lob.substr(sql_select) node_value

1256: and object_type = 'COL'
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;

Line 1263: and dbms_lob.getlength(sql_select) < 3999

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:
1266: cursor calc_formulas is
1267: select name, 'cn_formula_' || abs(calc_formula_id) || '_' || abs(org_id) ||

Line 1529: SELECT DBMS_LOB.SUBSTR(sql_select)

1525: FROM cn_calc_edges
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;

Line 1659: WHERE DBMS_LOB.SUBSTR(sql_select) LIKE '%(' || p_current_id || 'PE.%';

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
1663: FROM cn_formula_inputs

Line 2510: , DBMS_LOB.SUBSTR(sql_select, g_max_field_length) sql_select

2506:
2507: CURSOR get_expressions IS
2508: SELECT NAME expression_name
2509: , description
2510: , DBMS_LOB.SUBSTR(sql_select, g_max_field_length) sql_select
2511: , attribute_category
2512: , attribute1
2513: , attribute2
2514: , attribute3

Line 2539: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length AND 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:
2543: -- Get imp_header info

Line 2668: WHERE DBMS_LOB.getlength(sql_select) > g_max_field_length);

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: (
2672: p_message_text => 'CN_EXPCALCEXP: End Transfer Data. imp_header_id = '