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 1216: dbms_lob.substr(expression_disp),

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),
1217: dbms_lob.substr(sql_select),
1218: dbms_lob.substr(sql_from),
1219: dbms_lob.substr(piped_sql_select),
1220: dbms_lob.substr(piped_sql_from),

Line 1217: dbms_lob.substr(sql_select),

1213:
1214: CURSOR get_data IS
1215: select name, description, status, exp_type_code,
1216: dbms_lob.substr(expression_disp),
1217: dbms_lob.substr(sql_select),
1218: dbms_lob.substr(sql_from),
1219: dbms_lob.substr(piped_sql_select),
1220: dbms_lob.substr(piped_sql_from),
1221: dbms_lob.substr(piped_expression_disp),

Line 1218: dbms_lob.substr(sql_from),

1214: CURSOR get_data IS
1215: select name, description, status, exp_type_code,
1216: dbms_lob.substr(expression_disp),
1217: dbms_lob.substr(sql_select),
1218: dbms_lob.substr(sql_from),
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

Line 1219: dbms_lob.substr(piped_sql_select),

1215: select name, description, status, exp_type_code,
1216: dbms_lob.substr(expression_disp),
1217: dbms_lob.substr(sql_select),
1218: dbms_lob.substr(sql_from),
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;

Line 1220: dbms_lob.substr(piped_sql_from),

1216: dbms_lob.substr(expression_disp),
1217: dbms_lob.substr(sql_select),
1218: dbms_lob.substr(sql_from),
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

Line 1221: dbms_lob.substr(piped_expression_disp),

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

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

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

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

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

Line 1537: SELECT DBMS_LOB.SUBSTR(sql_select)

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

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

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

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

2524:
2525: CURSOR get_expressions IS
2526: SELECT NAME expression_name
2527: , description
2528: , DBMS_LOB.SUBSTR(sql_select, g_max_field_length) sql_select
2529: , attribute_category
2530: , attribute1
2531: , attribute2
2532: , attribute3

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

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

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