The following lines contain the word 'select', 'insert', 'update' or 'delete':
OR g_TimeStack(v_Position).Deleted
THEN
v_Position := g_TimeStack.COUNT + 1;
g_TimeStack(v_Position).Deleted := false;
IF NOT g_TimeStack(g_curr_parent).Deleted THEN
IF g_TimeStack(g_curr_parent).Description IS NULL
THEN
msg := g_TimeStack(g_curr_parent).Marker;
IF g_curr_parent = 0 OR NOT g_TimeStack(g_curr_parent).Deleted THEN
FOR v_Count IN 1..g_TimeStack.COUNT LOOP
IF g_TimeStack(v_count).ParentId = g_curr_parent
AND NOT g_TimeStack(v_count).Deleted
THEN
tempParentId := g_curr_parent;
g_TimeStack(g_curr_parent).Deleted := true;
g_TimeStack.DELETE;
select fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')
into filePath
from dual;
l_query := 'select * from ' || p_table_name;
SELECT fnd_profile.value('OE_DEBUG_LOG_DIRECTORY')
INTO filePath
FROM dual;
l_sql_stmt := 'SELECT REQUEST_ID,'''
|| REPLACE(G_CURR_PRICE_EVENT,',','-')
|| ''' PRICING_EVENT, PATTERN_ID, LINE_INDEX, HASH_KEY'
|| ' FROM qp_npreq_line_patrns_tmp';
||'SELECT request_id , '
|| '''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT,'
||' line_index , '
||' pricing_phase_id , '
||' list_header_id , '
||' list_line_id , '
||' stage , '
||' pricing_status_code , '
||' matched_pattrn_id , '
||' matched_hash_key , '
||' grouping_no , '
||' source_system_code , '
||' header_quals_exist_flag , '
||' eq_flag , '
||' other_oprt_count , '
||' null_other_oprt_count , '
||' list_type_code , '
||' pricing_effective_date , '
||' modifier_level_code , '
||' currency_detail_id , '
||' currency_header_id , '
||' qualifier_precedence , '
||' validated_flag , '
||' ask_for_flag , '
||' header_limit_exists , '
||' line_limit_exists , '
||' selling_rounding_factor , '
||' order_currency , '
||' base_currency_code , '
||' break_uom_code , '
||' break_uom_context , '
||' break_uom_attribute , '
||' pricing_status_text '
||'FROM QP_PREQ_PATRN_QUAL_TMP';
||' SELECT request_id , '
|| '''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT,'
||' pricing_phase_id , '
||' line_index , '
||' line_detail_index , '
||' line_detail_type_code , '
||' list_header_id , '
||' list_line_id , '
||' attribute_level , '
||' attribute_type , '
||' context , '
||' attribute , '
||' value_from , '
||' setup_value_from , '
||' value_to , '
||' setup_value_to , '
||' grouping_number , '
||' comparison_operator_type_code, '
||' datatype , '
||' product_uom_code , '
||' group_quantity , '
||' group_amount , '
||' incompatability_grp_code , '
||' modifier_level_code , '
||' primary_uom_flag , '
||' no_qualifiers_in_grp , '
||' validated_flag , '
||' applied_flag , '
||' pricing_status_code , '
||' pricing_status_text , '
||' qualifier_precedence , '
||' pricing_attr_flag , '
||' qualifier_type , '
||' processed_code , '
||' excluder_flag , '
||' distinct_qualifier_flag , '
||' segment_id '
||' FROM qp_npreq_line_attrs_tmp ';
l_lines_stmt := 'select ' ||
' nlines.REQUEST_ID , ' ||
'''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT, ' ||
' nlines.LINE_INDEX , ' ||
' nlines.REQUEST_TYPE_CODE , ' ||
' nlines.LINE_ID , ' ||
' nlines.LINE_TYPE_CODE , ' ||
' nlines.PRICING_EFFECTIVE_DATE , ' ||
' nlines.LINE_QUANTITY , ' ||
' nlines.LINE_UOM_CODE , ' ||
' nlines.LINE_UNIT_PRICE , ' ||
' nlines.ORDER_UOM_SELLING_PRICE , ' ||
' nlines.PRICED_QUANTITY , ' ||
' nlines.PRICED_UOM_CODE , ' ||
' nlines.UNIT_PRICE , ' ||
' nlines.ADJUSTED_UNIT_PRICE , ' ||
' nlines.PRICE_LIST_HEADER_ID , ' ||
' list.NAME PRICE_LIST_NAME , ' ||
' nlines.UOM_QUANTITY , ' ||
' nlines.CURRENCY_CODE , ' ||
' nlines.PERCENT_PRICE , ' ||
' nlines.PARENT_PRICE , ' ||
' nlines.PARENT_QUANTITY , ' ||
' nlines.PARENT_UOM_CODE , ' ||
' nlines.PROCESSING_ORDER , ' ||
' nlines.PROCESSED_FLAG , ' ||
' nlines.PROCESSED_CODE , ' ||
' nlines.PRICE_FLAG , ' ||
' nlines.PRICING_STATUS_CODE , ' ||
' nlines.PRICING_STATUS_TEXT , ' ||
' nlines.START_DATE_ACTIVE_FIRST , ' ||
' nlines.ACTIVE_DATE_FIRST_TYPE , ' ||
' nlines.START_DATE_ACTIVE_SECOND , ' ||
' nlines.ACTIVE_DATE_SECOND_TYPE , ' ||
' nlines.GROUP_QUANTITY , ' ||
' nlines.GROUP_AMOUNT , ' ||
' nlines.LINE_AMOUNT , ' ||
' nlines.ROUNDING_FLAG , ' ||
' nlines.ROUNDING_FACTOR , ' ||
' nlines.UPDATED_ADJUSTED_UNIT_PRICE , ' ||
' nlines.PRICE_REQUEST_CODE , ' ||
' nlines.HOLD_CODE , ' ||
' nlines.HOLD_TEXT , ' ||
' nlines.VALIDATED_FLAG , ' ||
' nlines.QUALIFIERS_EXIST_FLAG , ' ||
' nlines.PRICING_ATTRS_EXIST_FLAG , ' ||
' nlines.PRIMARY_QUALIFIERS_MATCH_FLAG , ' ||
' nlines.USAGE_PRICING_TYPE , ' ||
' nlines.LINE_CATEGORY , ' ||
' nlines.CONTRACT_START_DATE , ' ||
' nlines.CONTRACT_END_DATE , ' ||
' nlines.PROCESS_STATUS , ' ||
' nlines.EXTENDED_PRICE , ' ||
' nlines.CATCHWEIGHT_QTY , ' ||
' nlines.ACTUAL_ORDER_QUANTITY , ' ||
' nlines.HEADER_ID , ' ||
' nlines.LIST_PRICE_OVERRIDE_FLAG , ' ||
' nlines.SERVICE_DURATION , ' ||
' nlines.SERVICE_PERIOD ' ||
' FROM QP_NPREQ_LINES_TMP nlines, qp_list_headers_vl list ' ||
' where list.list_header_id (+) = nlines.PRICE_LIST_HEADER_ID ' ||
' order by nlines.line_index';
l_ldets_stmt := 'select ' ||
' nldets.REQUEST_ID , ' ||
'''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT, ' ||
' nldets.LINE_INDEX , ' ||
' nldets.LINE_DETAIL_INDEX , ' ||
' nldets.CREATED_FROM_LIST_HEADER_ID , ' ||
' list.NAME LIST_NAME , ' ||
' nldets.CREATED_FROM_LIST_LINE_ID , ' ||
' nldets.CREATED_FROM_LIST_TYPE_CODE , ' ||
' nldets.CREATED_FROM_LIST_LINE_TYPE , ' ||
' nldets.MODIFIER_LEVEL_CODE , ' ||
' nldets.PRICING_PHASE_ID , ' ||
' nldets.APPLIED_FLAG , ' ||
' nldets.AUTOMATIC_FLAG , ' ||
' nldets.OPERAND_CALCULATION_CODE , ' ||
' nldets.OPERAND_VALUE , ' ||
' nldets.ADJUSTMENT_AMOUNT , ' ||
' nldets.LINE_DETAIL_TYPE_CODE , ' ||
' nldets.LINE_DETAIL_PBH_TYPE , ' ||
' nldets.PRICE_BREAK_TYPE_CODE , ' ||
' nldets.CREATED_FROM_SQL , ' ||
' nldets.PRICING_GROUP_SEQUENCE , ' ||
' nldets.LINE_QUANTITY , ' ||
' nldets.SUBSTITUTION_TYPE_CODE , ' ||
' nldets.SUBSTITUTION_VALUE_FROM , ' ||
' nldets.SUBSTITUTION_VALUE_TO , ' ||
' nldets.ASK_FOR_FLAG , ' ||
' nldets.PRICE_FORMULA_ID , ' ||
' nldets.PROCESSED_FLAG , ' ||
' nldets.PRICING_STATUS_CODE , ' ||
' nldets.PRICING_STATUS_TEXT , ' ||
' nldets.PRODUCT_PRECEDENCE , ' ||
' nldets.INCOMPATABILITY_GRP_CODE , ' ||
' nldets.BEST_PERCENT , ' ||
' nldets.OVERRIDE_FLAG , ' ||
' nldets.PRINT_ON_INVOICE_FLAG , ' ||
' nldets.PRIMARY_UOM_FLAG , ' ||
' nldets.BENEFIT_QTY , ' ||
' nldets.BENEFIT_UOM_CODE , ' ||
' nldets.LIST_LINE_NO , ' ||
' nldets.ACCRUAL_FLAG , ' ||
' nldets.ACCRUAL_CONVERSION_RATE , ' ||
' nldets.ESTIM_ACCRUAL_RATE , ' ||
' nldets.RECURRING_FLAG , ' ||
' nldets.SELECTED_VOLUME_ATTR , ' ||
' nldets.ROUNDING_FACTOR , ' ||
' nldets.SECONDARY_PRICELIST_IND , ' ||
' nldets.GROUP_QUANTITY , ' ||
' nldets.GROUP_AMOUNT , ' ||
' nldets.PROCESS_CODE , ' ||
' nldets.UPDATED_FLAG , ' ||
' nldets.CHARGE_TYPE_CODE , ' ||
' nldets.CHARGE_SUBTYPE_CODE , ' ||
' nldets.LIMIT_CODE , ' ||
' nldets.LIMIT_TEXT , ' ||
' nldets.HEADER_LIMIT_EXISTS , ' ||
' nldets.LINE_LIMIT_EXISTS , ' ||
' nldets.CALCULATION_CODE , ' ||
' nldets.CURRENCY_HEADER_ID , ' ||
' nldets.PRICING_EFFECTIVE_DATE , ' ||
' nldets.BASE_CURRENCY_CODE , ' ||
' nldets.ORDER_CURRENCY , ' ||
' nldets.CURRENCY_DETAIL_ID , ' ||
' nldets.SELLING_ROUNDING_FACTOR , ' ||
' nldets.CHANGE_REASON_CODE , ' ||
' nldets.CHANGE_REASON_TEXT , ' ||
' nldets.REQUEST_ID , ' ||
' nldets.PRICE_ADJUSTMENT_ID , ' ||
' nldets.RECURRING_VALUE , ' ||
' nldets.NET_AMOUNT_FLAG , ' ||
' nldets.ORDER_QTY_OPERAND , ' ||
' nldets.ORDER_QTY_ADJ_AMT , ' ||
' nldets.ACCUM_CONTEXT , ' ||
' nldets.ACCUM_ATTRIBUTE , ' ||
' nldets.ACCUM_ATTR_RUN_SRC_FLAG , ' ||
' nldets.BREAK_UOM_CODE , ' ||
' nldets.BREAK_UOM_CONTEXT , ' ||
' nldets.BREAK_UOM_ATTRIBUTE , ' ||
' nldets.SERVICE_DURATION , ' ||
' nldets.SERVICE_PERIOD ' ||
' FROM QP_NPREQ_LDETS_TMP nldets, qp_list_headers_vl list ' ||
' where list.list_header_id = nldets.CREATED_FROM_LIST_HEADER_ID ' ||
' order by nldets.line_index,nldets.LINE_DETAIL_INDEX';
l_attrs_stmt := 'select ' ||
' lattrs.REQUEST_ID , ' ||
'''' || REPLACE(G_CURR_PRICE_EVENT,',','-') || ''' PRICING_EVENT, ' ||
' lattrs.LINE_INDEX , ' ||
' lattrs.LINE_DETAIL_INDEX , ' ||
' lattrs.ATTRIBUTE_LEVEL , ' ||
' lattrs.ATTRIBUTE_TYPE , ' ||
' lattrs.CONTEXT , ' ||
' qpc.USER_PRC_CONTEXT_NAME , ' ||
' lattrs.ATTRIBUTE , ' ||
' qps.USER_SEGMENT_NAME , ' ||
' lattrs.COMPARISON_OPERATOR_TYPE_CODE , ' ||
' lattrs.VALUE_FROM , ' ||
' lattrs.SETUP_VALUE_FROM , ' ||
' lattrs.VALUE_TO , ' ||
' lattrs.SETUP_VALUE_TO , ' ||
' lattrs.LIST_HEADER_ID , ' ||
' lattrs.LIST_LINE_ID , ' ||
' lattrs.GROUPING_NUMBER , ' ||
' lattrs.NO_QUALIFIERS_IN_GRP , ' ||
' lattrs.VALIDATED_FLAG , ' ||
' lattrs.APPLIED_FLAG , ' ||
' lattrs.PRICING_STATUS_CODE , ' ||
' lattrs.PRICING_STATUS_TEXT , ' ||
' lattrs.QUALIFIER_PRECEDENCE , ' ||
' lattrs.PRICING_ATTR_FLAG , ' ||
' lattrs.QUALIFIER_TYPE , ' ||
' lattrs.DATATYPE , ' ||
' lattrs.PRODUCT_UOM_CODE , ' ||
' lattrs.PROCESSED_CODE , ' ||
' lattrs.EXCLUDER_FLAG , ' ||
' lattrs.GROUP_QUANTITY , ' ||
' lattrs.GROUP_AMOUNT , ' ||
' lattrs.DISTINCT_QUALIFIER_FLAG , ' ||
' lattrs.PRICING_PHASE_ID , ' ||
' lattrs.INCOMPATABILITY_GRP_CODE , ' ||
' lattrs.LINE_DETAIL_TYPE_CODE , ' ||
' lattrs.MODIFIER_LEVEL_CODE , ' ||
' lattrs.PRIMARY_UOM_FLAG ' ||
' FROM QP_NPREQ_LINE_ATTRS_TMP lattrs, qp_prc_contexts_v qpc, qp_segments_v qps ' ||
' WHERE qpc.prc_context_code = lattrs.CONTEXT ' ||
' AND decode(QPC.prc_context_type,''PRICING_ATTRIBUTE'',''PRICING'',QPC.prc_context_type) = lattrs.ATTRIBUTE_TYPE ' ||
' AND qps.prc_context_id = qpc.prc_context_id' ||
' AND qps.segment_mapping_column = lattrs.ATTRIBUTE ';
paddingTop : Number of blank lines to be inserted before the message
paddingLeft : Left indentation (number of tabs)
paddingBottom : Number of blank lines to be inserted after the message
Output Parameters :
None
*/
PROCEDURE addSummaryTimeLog(logMessage varchar2,
paddingTop NUMBER := 0,
paddingLeft NUMBER := 0,
paddingBottom NUMBER := 0)
AS
v_posi NUMBER := 0;
g_summaryLog.DELETE;
g_summaryLog.DELETE;