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.MSC_PQ_UTILS dependencies on MSC_PQ_UTILS

Line 1: PACKAGE BODY MSC_PQ_UTILS AS

1: PACKAGE BODY MSC_PQ_UTILS AS
2: /* $Header: MSCPQUTB.pls 120.14.12010000.2 2008/07/08 13:44:19 skakani ship $ */
3:
4: G_PQ_ERROR_MESSAGE VARCHAR2(2000);
5:

Line 1166: --KSA_DEBUG(SYSDATE,'l_field_name...'||l_field_name,'MSC_PQ_UTILS.build_order_where_clause');

1162:
1163: l_field_name := c_criteria_row.field_name ;
1164: l_data_set := c_criteria_row.data_set;
1165: l_data_type := c_criteria_row.field_type;
1166: --KSA_DEBUG(SYSDATE,'l_field_name...'||l_field_name,'MSC_PQ_UTILS.build_order_where_clause');
1167: l_where_clause_segment := MSC_PQ_UTILS.get_where_clause(c_criteria_row.sequence,
1168: c_criteria_row.object_sequence_id,
1169: l_field_name,
1170: c_criteria_row.condition,

Line 1167: l_where_clause_segment := MSC_PQ_UTILS.get_where_clause(c_criteria_row.sequence,

1163: l_field_name := c_criteria_row.field_name ;
1164: l_data_set := c_criteria_row.data_set;
1165: l_data_type := c_criteria_row.field_type;
1166: --KSA_DEBUG(SYSDATE,'l_field_name...'||l_field_name,'MSC_PQ_UTILS.build_order_where_clause');
1167: l_where_clause_segment := MSC_PQ_UTILS.get_where_clause(c_criteria_row.sequence,
1168: c_criteria_row.object_sequence_id,
1169: l_field_name,
1170: c_criteria_row.condition,
1171: c_criteria_row.low_value,

Line 1178: --KSA_DEBUG(SYSDATE,'l_where_clause_segment...'||l_where_clause_segment,'MSC_PQ_UTILS.build_order_where_clause');

1174: l_data_set,
1175: l_data_type,
1176: c_criteria_row.lov_type,
1177: l_temp_match_str, NULL);
1178: --KSA_DEBUG(SYSDATE,'l_where_clause_segment...'||l_where_clause_segment,'MSC_PQ_UTILS.build_order_where_clause');
1179: IF l_field_name = 'EXCEPTION_TYPE' THEN
1180: IF l_merge_criteria = 1 THEN
1181: l_build_Excp_where := 1;
1182: l_criteria_row_seq := c_criteria_row.sequence;

Line 1191: MSC_PQ_UTILS.build_Excp_where(p_query_id,

1187: l_temp_match_str||' ( '||
1188: l_where_clause_segment||' ) ';
1189: END IF;
1190: ELSE
1191: MSC_PQ_UTILS.build_Excp_where(p_query_id,
1192: c_ord_type_row.sequence_id,
1193: c_criteria_row.sequence,
1194: p_plan_id,
1195: l_where_clause_segment,

Line 1224: MSC_PQ_UTILS.build_Excp_where(p_query_id,

1220: END IF;
1221: END IF;
1222: END LOOP;
1223: IF l_build_Excp_where = 1 THEN
1224: MSC_PQ_UTILS.build_Excp_where(p_query_id,
1225: c_ord_type_row.sequence_id,
1226: l_criteria_row_seq,
1227: p_plan_id,
1228: l_excp_where_clause_segment,

Line 1248: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.build_order_where_clause');

1244: --KSA_DEBUG(SYSDATE,'Exiting...','build_order_where_clause');
1245: RETURN where_clause_segment;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.build_order_where_clause');
1249: RETURN (NULL);
1250: END build_order_where_clause;
1251:
1252: FUNCTION get_where_clause (sequence NUMBER,

Line 1413: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'MSC_PQ_UTILS.get_where_clause');

1409: data_set ||
1410: translated_op ||
1411: hidden_from ;
1412: ELSIF operator IN (11,14) THEN -- operator is AMONG
1413: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'MSC_PQ_UTILS.get_where_clause');
1414: where_clause_segment := where_clause_segment ||
1415: get_among_where_clause (sequence, obj_sequence,translated_op, field_name,
1416: operator, low, high, hidden_from, data_set, data_type)||' ';
1417:

Line 1429: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.get_where_clause');

1425: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'get_where_clause');
1426: RETURN where_clause_segment;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.get_where_clause');
1430: RAISE;
1431: END get_where_clause;
1432:
1433: PROCEDURE retrieve_values (p_folder_id number) IS

Line 1474: --KSA_DEBUG(SYSDATE,'inside...p_folder_id'||p_folder_id,'MSC_PQ_UTILS.retrieve_values');

1470:
1471: l_name varchar2(50);
1472:
1473: BEGIN
1474: --KSA_DEBUG(SYSDATE,'inside...p_folder_id'||p_folder_id,'MSC_PQ_UTILS.retrieve_values');
1475:
1476: /*OPEN c_delete;
1477: LOOP
1478: FETCH c_delete into l_name;

Line 1496: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.retrieve_values');

1492: among_values_rec.or_values,
1493: among_values_rec.hidden_values);
1494: END LOOP;
1495: CLOSE among_values;
1496: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.retrieve_values');
1497: END retrieve_values;
1498:
1499: FUNCTION get_among_where_clause (sequence NUMBER,
1500: obj_sequence NUMBER,

Line 1565: --KSA_DEBUG(SYSDATE,'Exiting, value_list is '||value_list,'MSC_PQ_UTILS.get_among_where_clause');

1561: value_list :=value_list || tmp_str ||current_value;
1562: tmp_str :=', ';
1563: END IF;
1564: END LOOP;
1565: --KSA_DEBUG(SYSDATE,'Exiting, value_list is '||value_list,'MSC_PQ_UTILS.get_among_where_clause');
1566: IF datatype IN ('ORG','MULTI') THEN
1567: RETURN ' (1=1 AND (' ||data_set || t_operator ||' ( '||value_list||'))) ';
1568: ELSE
1569: RETURN ' (1=1 AND (' ||field_name || t_operator ||' ( '||value_list||'))) ';

Line 1664: --KSA_DEBUG(SYSDATE,'inside...p_field_name'||p_field_name,'MSC_PQ_UTILS.store_values');

1660: p_or_values IN VARCHAR2,
1661: p_hidden_values IN VARCHAR2) IS
1662: l_count NUMBER;
1663: BEGIN
1664: --KSA_DEBUG(SYSDATE,'inside...p_field_name'||p_field_name,'MSC_PQ_UTILS.store_values');
1665: l_count := g_among_values.count;
1666: g_among_values(l_count+1).sequence := p_sequence;
1667: g_among_values(l_count+1).object_sequence := p_obj_sequence;
1668: g_among_values(l_count+1).field_name := p_field_name;

Line 1671: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.store_values');

1667: g_among_values(l_count+1).object_sequence := p_obj_sequence;
1668: g_among_values(l_count+1).field_name := p_field_name;
1669: g_among_values(l_count+1).or_values := p_or_values;
1670: g_among_values(l_count+1).hidden_values := p_hidden_values;
1671: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.store_values');
1672: END store_values;
1673:
1674: PROCEDURE clear_values IS
1675: BEGIN

Line 2016: msc_pq_utils.retrieve_values(p_query_id);

2012: where_clause_segment,
2013: p_execute_flag,
2014: l_master_query_id);
2015: ELSIF p_query_type = 9 then
2016: msc_pq_utils.retrieve_values(p_query_id);
2017: where_clause_segment := msc_pq_utils.build_order_where_clause
2018: (p_query_id,
2019: p_plan_id);
2020: IF (where_clause_segment IS NULL) THEN

Line 2017: where_clause_segment := msc_pq_utils.build_order_where_clause

2013: p_execute_flag,
2014: l_master_query_id);
2015: ELSIF p_query_type = 9 then
2016: msc_pq_utils.retrieve_values(p_query_id);
2017: where_clause_segment := msc_pq_utils.build_order_where_clause
2018: (p_query_id,
2019: p_plan_id);
2020: IF (where_clause_segment IS NULL) THEN
2021: where_clause_segment := ' ( -99 = -99 ) ';

Line 2309: END MSC_PQ_UTILS;

2305: errbuf := 'unknown error'||sqlerrm(sqlcode);
2306: retcode := 1;
2307: END execute_plan_worklists;
2308:
2309: END MSC_PQ_UTILS;