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.18.12020000.2 2012/10/19 09:07:46 skathera ship $ */
3:
4: G_PQ_ERROR_MESSAGE VARCHAR2(2000);
5: g_delimiter2 VARCHAR2(10) := fnd_global.local_chr(10);

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

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

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

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

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

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

Line 1195: MSC_PQ_UTILS.build_Excp_where(p_query_id,

1191: l_temp_match_str||' ( '||
1192: l_where_clause_segment||' ) ';
1193: END IF;
1194: ELSE
1195: MSC_PQ_UTILS.build_Excp_where(p_query_id,
1196: c_ord_type_row.sequence_id,
1197: c_criteria_row.sequence,
1198: p_plan_id,
1199: l_where_clause_segment,

Line 1228: MSC_PQ_UTILS.build_Excp_where(p_query_id,

1224: END IF;
1225: END IF;
1226: END LOOP;
1227: IF l_build_Excp_where = 1 THEN
1228: MSC_PQ_UTILS.build_Excp_where(p_query_id,
1229: c_ord_type_row.sequence_id,
1230: l_criteria_row_seq,
1231: p_plan_id,
1232: l_excp_where_clause_segment,

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

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

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

1426: data_set ||
1427: translated_op ||
1428: hidden_from ;
1429: ELSIF operator IN (11,14) THEN -- operator is AMONG
1430: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'MSC_PQ_UTILS.get_where_clause');
1431: where_clause_segment := where_clause_segment ||
1432: get_among_where_clause (sequence, obj_sequence,translated_op, field_name,
1433: operator, low, high, hidden_from, data_set, data_type)||' ';
1434:

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

1442: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'get_where_clause');
1443: RETURN where_clause_segment;
1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.get_where_clause');
1447: RAISE;
1448: END get_where_clause;
1449:
1450: PROCEDURE retrieve_values (p_folder_id number) IS

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

1487:
1488: l_name varchar2(50);
1489:
1490: BEGIN
1491: --KSA_DEBUG(SYSDATE,'inside...p_folder_id'||p_folder_id,'MSC_PQ_UTILS.retrieve_values');
1492:
1493: /*OPEN c_delete;
1494: LOOP
1495: FETCH c_delete into l_name;

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

1509: among_values_rec.or_values,
1510: among_values_rec.hidden_values);
1511: END LOOP;
1512: CLOSE among_values;
1513: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.retrieve_values');
1514: END retrieve_values;
1515:
1516: FUNCTION get_among_where_clause (sequence NUMBER,
1517: obj_sequence NUMBER,

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

1579: value_list :=value_list || tmp_str ||current_value;
1580: tmp_str :=', ';
1581: END IF;
1582: END LOOP;
1583: --KSA_DEBUG(SYSDATE,'Exiting, value_list is '||value_list,'MSC_PQ_UTILS.get_among_where_clause');
1584: IF datatype IN ('ORG','MULTI') THEN
1585: RETURN ' (1=1 AND (' ||data_set || t_operator ||' ( '||value_list||'))) ';
1586: ELSE
1587: RETURN ' (1=1 AND (' ||field_name || t_operator ||' ( '||value_list||'))) ';

Line 1617: --KSA_DEBUG(SYSDATE,'l_where_clause_segment...'||p_where_clause,'MSC_PQ_UTILS.build_Excp_where');

1613:
1614:
1615:
1616: l_where_clause := REPLACE(REPLACE(p_where_clause,'SOURCE_SR_INSTANCE_ID','SOURCE_ORG_INSTANCE_ID'),'VENDOR_ID','SUPPLIER_ID');
1617: --KSA_DEBUG(SYSDATE,'l_where_clause_segment...'||p_where_clause,'MSC_PQ_UTILS.build_Excp_where');
1618: /*if instr(p_where_clause, ' AND ') > 0 THEN
1619: FOR I IN 1..LENGTH(p_where_clause) LOOP
1620: l_pos := instr(p_where_clause, ' AND ')
1621: ---

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

1688: p_or_values IN VARCHAR2,
1689: p_hidden_values IN VARCHAR2) IS
1690: l_count NUMBER;
1691: BEGIN
1692: --KSA_DEBUG(SYSDATE,'inside...p_field_name'||p_field_name,'MSC_PQ_UTILS.store_values');
1693: l_count := g_among_values.count;
1694: g_among_values(l_count+1).sequence := p_sequence;
1695: g_among_values(l_count+1).object_sequence := p_obj_sequence;
1696: g_among_values(l_count+1).field_name := p_field_name;

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

1695: g_among_values(l_count+1).object_sequence := p_obj_sequence;
1696: g_among_values(l_count+1).field_name := p_field_name;
1697: g_among_values(l_count+1).or_values := p_or_values;
1698: g_among_values(l_count+1).hidden_values := p_hidden_values;
1699: --KSA_DEBUG(SYSDATE,'exiting...','MSC_PQ_UTILS.store_values');
1700: END store_values;
1701:
1702: PROCEDURE clear_values IS
1703: BEGIN

Line 2048: msc_pq_utils.retrieve_values(p_query_id);

2044: where_clause_segment,
2045: p_execute_flag,
2046: l_master_query_id);
2047: ELSIF p_query_type = 9 then
2048: msc_pq_utils.retrieve_values(p_query_id);
2049: where_clause_segment := msc_pq_utils.build_order_where_clause
2050: (p_query_id,
2051: p_plan_id);
2052: IF (where_clause_segment IS NULL) THEN

Line 2049: where_clause_segment := msc_pq_utils.build_order_where_clause

2045: p_execute_flag,
2046: l_master_query_id);
2047: ELSIF p_query_type = 9 then
2048: msc_pq_utils.retrieve_values(p_query_id);
2049: where_clause_segment := msc_pq_utils.build_order_where_clause
2050: (p_query_id,
2051: p_plan_id);
2052: IF (where_clause_segment IS NULL) THEN
2053: where_clause_segment := ' ( -99 = -99 ) ';

Line 2558: where_clause :=MSC_PQ_UTILS.build_where_clause_wrksh(p_query_id,0);

2554:
2555:
2556: BEGIN
2557: retrieve_values(p_query_id);
2558: where_clause :=MSC_PQ_UTILS.build_where_clause_wrksh(p_query_id,0);
2559: FOR c_f_criteria_row IN c_folder_criteria
2560: LOOP
2561: FOR c_criteria_row IN c_criteria(c_f_criteria_row.fOLDER_object)
2562: LOOP

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

3832: translated_op ||
3833: hidden_from ;
3834: ELSIF operator IN (11,14) THEN -- operator is AMONG
3835: --debug_plan_event('operator '||operator);
3836: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'MSC_PQ_UTILS.get_where_clause');
3837: where_clause_segment := where_clause_segment ||
3838: get_among_where_clause (sequence, obj_sequence,translated_op, field_name,
3839: operator, low, high, hidden_from, data_set, data_type)||' ';
3840: --debug_plan_event('operator '||operator||where_clause_segment);

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

3854: --KSA_DEBUG(SYSDATE,'where_clause_segment...'||where_clause_segment,'get_where_clause');
3855: RETURN where_clause_segment;
3856: EXCEPTION
3857: WHEN OTHERS THEN
3858: --KSA_DEBUG(SYSDATE,'Error...'||sqlerrm(sqlcode),'MSC_PQ_UTILS.get_where_clause');
3859: RAISE;
3860: END get_where_clause_wrksh;
3861:
3862: FUNCTION build_where_clause_wrksh(p_query_id IN NUMBER DEFAULT NULL,

Line 3962: END MSC_PQ_UTILS;

3958: -- debug_plan_event('2'||where_clause_segment);
3959: RETURN where_clause_segment;
3960: END build_where_clause_wrksh;
3961:
3962: END MSC_PQ_UTILS;