[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Request IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
qp_debug_req( REQUEST_ID,
REQUEST_NAME,
ORDER_NUMBER, -- sfiresto 2374448
CREATED_BY,
CREATION_DATE,
PRICING_EVENT,
CALCULATE_FLAG,
SIMULATION_FLAG,
REQUEST_TYPE_CODE,
VIEW_CODE,
ROUNDING_FLAG,
GSA_CHECK_FLAG,
GSA_DUP_CHECK_FLAG,
TEMP_TABLE_INSERT_FLAG,
MANUAL_DISCOUNT_FLAG,
DEBUG_FLAG,
SOURCE_ORDER_AMOUNT_FLAG,
PUBLIC_API_CALL_FLAG,
MANUAL_ADJUSTMENTS_CALL_FLAG,
CHECK_CUST_VIEW_FLAG,
CURRENCY_CODE
)
VALUES
( g_control_rec.REQUEST_ID,
g_control_rec.REQUEST_NAME,
g_control_rec.ORDER_NUMBER, -- sfiresto 2374448
g_control_rec.CREATED_BY,
g_control_rec.CREATION_DATE,
g_control_rec.PRICING_EVENT,
g_control_rec.CALCULATE_FLAG,
nvl(g_control_rec.SIMULATION_FLAG,'N'),
g_control_rec.REQUEST_TYPE_CODE,
g_control_rec.VIEW_CODE,
nvl(g_control_rec.ROUNDING_FLAG,'N'),
nvl(g_control_rec.GSA_CHECK_FLAG,'N'),
nvl(g_control_rec.GSA_DUP_CHECK_FLAG,'N'),
nvl(g_control_rec.TEMP_TABLE_INSERT_FLAG,'N'),
nvl(g_control_rec.MANUAL_DISCOUNT_FLAG,'N'),
nvl(g_control_rec.DEBUG_FLAG,'N'),
nvl(g_control_rec.SOURCE_ORDER_AMOUNT_FLAG,'N'),
nvl(g_control_rec.PUBLIC_API_CALL_FLAG,'N'),
nvl(g_control_rec.MANUAL_ADJUSTMENTS_CALL_FLAG,'N'),
nvl(g_control_rec.CHECK_CUST_VIEW_FLAG,'N'),
g_control_rec.currency_code
);
QP_PREQ_GRP.engine_debug('***Inserted 1 Record into QP_DEBUG_REQ***');
END Insert_Request;
PROCEDURE Insert_Line IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
QP_DEBUG_REQ_LINES( REQUEST_ID,
REQUEST_TYPE_CODE,
LINE_NUMBER, -- sfiresto 2374448
LINE_ID,
LINE_INDEX,
LINE_TYPE_CODE,
PRICING_EFFECTIVE_DATE,
LINE_QUANTITY,
LINE_UOM_CODE,
PRICED_QUANTITY,
PRICED_UOM_CODE,
UOM_QUANTITY,
CURRENCY_CODE,
UNIT_PRICE,
PERCENT_PRICE,
ADJUSTED_UNIT_PRICE,
PARENT_PRICE,
PARENT_QUANTITY,
PARENT_UOM_CODE,
PROCESSING_ORDER,
PROCESSED_FLAG,
PROCESSED_CODE,
PRICE_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
START_DATE_ACTIVE_FIRST,
ACTIVE_DATE_FIRST_TYPE,
START_DATE_ACTIVE_SECOND,
ACTIVE_DATE_SECOND_TYPE,
GROUP_QUANTITY,
GROUP_AMOUNT,
LINE_AMOUNT,
ROUNDING_FLAG,
ROUNDING_FACTOR,
UPDATED_ADJUSTED_UNIT_PRICE,
PRICE_REQUEST_CODE,
HOLD_CODE,
HOLD_TEXT,
PRICE_LIST_HEADER_ID,
VALIDATED_FLAG,
QUALIFIERS_EXIST_FLAG,
PRICING_ATTRS_EXIST_FLAG,
PRIMARY_QUALIFIERS_MATCH_FLAG,
USAGE_PRICING_TYPE
)
VALUES
( REQUEST_ID_T(Tbl_Index),
REQUEST_TYPE_CODE_T(Tbl_Index),
LINE_NUMBER_T(Tbl_Index), -- sfiresto 2374448
LINE_ID_T(Tbl_Index),
LINE_INDEX_T(Tbl_Index),
LINE_TYPE_CODE_T(Tbl_Index),
PRICING_EFFECTIVE_DATE_T(Tbl_Index),
LINE_QUANTITY_T(Tbl_Index),
LINE_UOM_CODE_T(Tbl_Index),
PRICED_QUANTITY_T(Tbl_Index),
PRICED_UOM_CODE_T(Tbl_Index),
UOM_QUANTITY_T(Tbl_Index),
CURRENCY_CODE_T(Tbl_Index),
UNIT_PRICE_T(Tbl_Index),
PERCENT_PRICE_T(Tbl_Index),
ADJUSTED_UNIT_PRICE_T(Tbl_Index),
PARENT_PRICE_T(Tbl_Index),
PARENT_QUANTITY_T(Tbl_Index),
PARENT_UOM_CODE_T(Tbl_Index),
PROCESSING_ORDER_T(Tbl_Index),
nvl(PROCESSED_FLAG_T(Tbl_Index),'N'),
PROCESSED_CODE_T(Tbl_Index),
PRICE_FLAG_T(Tbl_Index),
PRICING_STATUS_CODE_T(Tbl_Index),
PRICING_STATUS_TEXT_T(Tbl_Index),
START_DATE_ACTIVE_FIRST_T(Tbl_Index),
ACTIVE_DATE_FIRST_TYPE_T(Tbl_Index),
START_DATE_ACTIVE_SECOND_T(Tbl_Index),
ACTIVE_DATE_SECOND_TYPE_T(Tbl_Index),
GROUP_QUANTITY_T(Tbl_Index),
GROUP_AMOUNT_T(Tbl_Index),
LINE_AMOUNT_T(Tbl_Index),
nvl(ROUNDING_FLAG_T(Tbl_Index),'N'),
ROUNDING_FACTOR_T(Tbl_Index),
UPDATED_ADJUSTED_UNIT_PRICE_T(Tbl_Index),
PRICE_REQUEST_CODE_T(Tbl_Index),
HOLD_CODE_T(Tbl_Index),
HOLD_TEXT_T(Tbl_Index),
PRICE_LIST_HEADER_ID_T(Tbl_Index),
nvl(VALIDATED_FLAG_T(Tbl_Index),'N'),
nvl(QUALIFIERS_EXIST_FLAG_T(Tbl_Index),'N'),
nvl(PRICING_ATTRS_EXIST_FLAG_T(Tbl_Index),'N'),
nvl(PRIMARY_QUAL_MATCH_FLAG_T(Tbl_Index),'N'),
USAGE_PRICING_TYPE_T(Tbl_Index)
);
QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_ID_T.COUNT || ' Records into QP_DEBUG_REQ_LINES***');
REQUEST_ID_T.delete;
REQUEST_TYPE_CODE_T.delete;
LINE_ID_T.delete;
LINE_INDEX_T.delete;
LINE_TYPE_CODE_T.delete;
PRICING_EFFECTIVE_DATE_T.delete;
LINE_QUANTITY_T.delete;
LINE_UOM_CODE_T.delete;
PRICED_QUANTITY_T.delete;
PRICED_UOM_CODE_T.delete;
UOM_QUANTITY_T.delete;
CURRENCY_CODE_T.delete;
UNIT_PRICE_T.delete;
PERCENT_PRICE_T.delete;
ADJUSTED_UNIT_PRICE_T.delete;
PARENT_PRICE_T.delete;
PARENT_QUANTITY_T.delete;
PARENT_UOM_CODE_T.delete;
PROCESSING_ORDER_T.delete;
PROCESSED_FLAG_T.delete;
PROCESSED_CODE_T.delete;
PRICE_FLAG_T.delete;
PRICING_STATUS_CODE_T.delete;
PRICING_STATUS_TEXT_T.delete;
START_DATE_ACTIVE_FIRST_T.delete;
ACTIVE_DATE_FIRST_TYPE_T.delete;
START_DATE_ACTIVE_SECOND_T.delete;
ACTIVE_DATE_SECOND_TYPE_T.delete;
GROUP_QUANTITY_T.delete;
GROUP_AMOUNT_T.delete;
LINE_AMOUNT_T.delete;
ROUNDING_FLAG_T.delete;
ROUNDING_FACTOR_T.delete;
UPDATED_ADJUSTED_UNIT_PRICE_T.delete;
PRICE_REQUEST_CODE_T.delete;
HOLD_CODE_T.delete;
HOLD_TEXT_T.delete;
PRICE_LIST_HEADER_ID_T.delete;
VALIDATED_FLAG_T.delete;
QUALIFIERS_EXIST_FLAG_T.delete;
PRICING_ATTRS_EXIST_FLAG_T.delete;
PRIMARY_QUAL_MATCH_FLAG_T.delete;
USAGE_PRICING_TYPE_T.delete;
END Insert_Line;
PROCEDURE Insert_LDet IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
QP_DEBUG_REQ_LDETS( REQUEST_ID,
LINE_DETAIL_INDEX,
LINE_DETAIL_TYPE_CODE,
PRICE_BREAK_TYPE_CODE,
LINE_INDEX,
CREATED_FROM_LIST_HEADER_ID,
CREATED_FROM_LIST_LINE_ID,
CREATED_FROM_LIST_LINE_TYPE,
CREATED_FROM_LIST_TYPE_CODE,
MODIFIER_LEVEL_CODE,
CREATED_FROM_SQL,
PRICING_GROUP_SEQUENCE,
OPERAND_CALCULATION_CODE,
OPERAND_VALUE,
ADJUSTMENT_AMOUNT,
LINE_QUANTITY,
SUBSTITUTION_TYPE_CODE,
SUBSTITUTION_VALUE_FROM,
SUBSTITUTION_VALUE_TO,
ASK_FOR_FLAG,
PRICE_FORMULA_ID,
PROCESSED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
PRODUCT_PRECEDENCE,
INCOMPATABILITY_GRP_CODE,
BEST_PERCENT,
PRICING_PHASE_ID,
APPLIED_FLAG,
AUTOMATIC_FLAG,
OVERRIDE_FLAG,
PRINT_ON_INVOICE_FLAG,
PRIMARY_UOM_FLAG,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
LIST_LINE_NO,
ACCRUAL_FLAG,
ACCRUAL_CONVERSION_RATE,
ESTIM_ACCRUAL_RATE,
RECURRING_FLAG,
SELECTED_VOLUME_ATTR,
ROUNDING_FACTOR,
SECONDARY_PRICELIST_IND,
GROUP_QUANTITY,
GROUP_AMOUNT,
PROCESS_CODE,
UPDATED_FLAG,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
LIMIT_CODE,
LIMIT_TEXT,
HEADER_LIMIT_EXISTS,
LINE_LIMIT_EXISTS
)
VALUES
( REQUEST_ID_T(Tbl_Index),
LINE_DETAIL_INDEX_T(Tbl_Index),
LINE_DETAIL_TYPE_CODE_T(Tbl_Index),
PRICE_BREAK_TYPE_CODE_T(Tbl_Index),
LINE_INDEX_T(Tbl_Index),
LIST_HEADER_ID_T(Tbl_Index),
LIST_LINE_ID_T(Tbl_Index),
LIST_LINE_TYPE_T(Tbl_Index),
LIST_TYPE_CODE_T(Tbl_Index),
MODIFIER_LEVEL_CODE_T(Tbl_Index),
CREATED_FROM_SQL_T(Tbl_Index),
PRICING_GROUP_SEQUENCE_T(Tbl_Index),
OPERAND_CALCULATION_CODE_T(Tbl_Index),
OPERAND_VALUE_T(Tbl_Index),
ADJUSTMENT_AMOUNT_T(Tbl_Index),
LINE_QUANTITY_T(Tbl_Index),
SUBSTITUTION_TYPE_CODE_T(Tbl_Index),
SUBSTITUTION_VALUE_FROM_T(Tbl_Index),
SUBSTITUTION_VALUE_TO_T(Tbl_Index),
nvl(ASK_FOR_FLAG_T(Tbl_Index),'N'),
PRICE_FORMULA_ID_T(Tbl_Index),
nvl(PROCESSED_FLAG_T(Tbl_Index),'N'),
PRICING_STATUS_CODE_T(Tbl_Index),
PRICING_STATUS_TEXT_T(Tbl_Index),
PRODUCT_PRECEDENCE_T(Tbl_Index),
INCOMPATABILITY_GRP_CODE_T(Tbl_Index),
BEST_PERCENT_T(Tbl_Index),
PRICING_PHASE_ID_T(Tbl_Index),
nvl(APPLIED_FLAG_T(Tbl_Index),'N'),
nvl(AUTOMATIC_FLAG_T(Tbl_Index),'N'),
nvl(OVERRIDE_FLAG_T(Tbl_Index),'N'),
nvl(PRINT_ON_INVOICE_FLAG_T(Tbl_Index),'N'),
nvl(PRIMARY_UOM_FLAG_T(Tbl_Index),'N'),
BENEFIT_QTY_T(Tbl_Index),
BENEFIT_UOM_CODE_T(Tbl_Index),
LIST_LINE_NO_T(Tbl_Index),
nvl(ACCRUAL_FLAG_T(Tbl_Index),'N'),
ACCRUAL_CONVERSION_RATE_T(Tbl_Index),
ESTIM_ACCRUAL_RATE_T(Tbl_Index),
RECURRING_FLAG_T(Tbl_Index),
SELECTED_VOLUME_ATTR_T(Tbl_Index),
ROUNDING_FACTOR_T(Tbl_Index),
SECONDARY_PRICELIST_IND_T(Tbl_Index),
GROUP_QUANTITY_T(Tbl_Index),
GROUP_AMOUNT_T(Tbl_Index),
PROCESS_CODE_T(Tbl_Index),
nvl(UPDATED_FLAG_T(Tbl_Index),'N'),
CHARGE_TYPE_CODE_T(Tbl_Index),
CHARGE_SUBTYPE_CODE_T(Tbl_Index),
LIMIT_CODE_T(Tbl_Index),
LIMIT_TEXT_T(Tbl_Index),
nvl(HEADER_LIMIT_EXISTS_T(Tbl_Index),'N'),
nvl(LINE_LIMIT_EXISTS_T(Tbl_Index),'N')
);
QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_DETAIL_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LDETS***');
REQUEST_ID_T.delete;
LINE_DETAIL_INDEX_T.delete;
LINE_DETAIL_TYPE_CODE_T.delete;
PRICE_BREAK_TYPE_CODE_T.delete;
LINE_INDEX_T.delete;
LIST_HEADER_ID_T.delete;
LIST_LINE_ID_T.delete;
LIST_LINE_TYPE_T.delete;
LIST_TYPE_CODE_T.delete;
MODIFIER_LEVEL_CODE_T.delete;
CREATED_FROM_SQL_T.delete;
PRICING_GROUP_SEQUENCE_T.delete;
OPERAND_CALCULATION_CODE_T.delete;
OPERAND_VALUE_T.delete;
ADJUSTMENT_AMOUNT_T.delete;
LINE_QUANTITY_T.delete;
SUBSTITUTION_TYPE_CODE_T.delete;
SUBSTITUTION_VALUE_FROM_T.delete;
SUBSTITUTION_VALUE_TO_T.delete;
ASK_FOR_FLAG_T.delete;
PRICE_FORMULA_ID_T.delete;
PROCESSED_FLAG_T.delete;
PRICING_STATUS_CODE_T.delete;
PRICING_STATUS_TEXT_T.delete;
PRODUCT_PRECEDENCE_T.delete;
INCOMPATABILITY_GRP_CODE_T.delete;
BEST_PERCENT_T.delete;
PRICING_PHASE_ID_T.delete;
APPLIED_FLAG_T.delete;
AUTOMATIC_FLAG_T.delete;
OVERRIDE_FLAG_T.delete;
PRINT_ON_INVOICE_FLAG_T.delete;
PRIMARY_UOM_FLAG_T.delete;
BENEFIT_QTY_T.delete;
BENEFIT_UOM_CODE_T.delete;
LIST_LINE_NO_T.delete;
ACCRUAL_FLAG_T.delete;
ACCRUAL_CONVERSION_RATE_T.delete;
ESTIM_ACCRUAL_RATE_T.delete;
RECURRING_FLAG_T.delete;
SELECTED_VOLUME_ATTR_T.delete;
ROUNDING_FACTOR_T.delete;
SECONDARY_PRICELIST_IND_T.delete;
GROUP_QUANTITY_T.delete;
GROUP_AMOUNT_T.delete;
PROCESS_CODE_T.delete;
UPDATED_FLAG_T.delete;
CHARGE_TYPE_CODE_T.delete;
CHARGE_SUBTYPE_CODE_T.delete;
LIMIT_CODE_T.delete;
LIMIT_TEXT_T.delete;
HEADER_LIMIT_EXISTS_T.delete;
LINE_LIMIT_EXISTS_T.delete;
END Insert_LDet;
PROCEDURE Insert_Line_Attr IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
QP_DEBUG_REQ_LINE_ATTRS( REQUEST_ID,
LINE_INDEX,
LINE_DETAIL_INDEX,
LINE_ATTRIBUTE_ID,
ATTRIBUTE_LEVEL,
ATTRIBUTE_TYPE,
LIST_HEADER_ID,
LIST_LINE_ID,
CONTEXT,
ATTRIBUTE,
VALUE_FROM,
SETUP_VALUE_FROM,
VALUE_TO,
SETUP_VALUE_TO,
GROUPING_NUMBER,
NO_QUALIFIERS_IN_GRP,
COMPARISON_OPERATOR_TYPE_CODE,
VALIDATED_FLAG,
APPLIED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
QUALIFIER_PRECEDENCE,
PRICING_ATTR_FLAG,
QUALIFIER_TYPE,
DATATYPE,
PRODUCT_UOM_CODE,
PROCESSED_CODE,
EXCLUDER_FLAG,
GROUP_QUANTITY,
GROUP_AMOUNT,
DISTINCT_QUALIFIER_FLAG,
PRICING_PHASE_ID,
INCOMPATABILITY_GRP_CODE,
LINE_DETAIL_TYPE_CODE,
MODIFIER_LEVEL_CODE,
PRIMARY_UOM_FLAG
)
VALUES
( REQUEST_ID_T(Tbl_Index),
LINE_INDEX_T(Tbl_Index),
LINE_DETAIL_INDEX_T(Tbl_Index),
LINE_ATTRIBUTE_ID_T(Tbl_Index),
ATTRIBUTE_LEVEL_T(Tbl_Index),
ATTRIBUTE_TYPE_T(Tbl_Index),
LIST_HEADER_ID_T(Tbl_Index),
LIST_LINE_ID_T(Tbl_Index),
CONTEXT_T(Tbl_Index),
ATTRIBUTE_T(Tbl_Index),
VALUE_FROM_T(Tbl_Index),
SETUP_VALUE_FROM_T(Tbl_Index),
VALUE_TO_T(Tbl_Index),
SETUP_VALUE_TO_T(Tbl_Index),
GROUPING_NUMBER_T(Tbl_Index),
NO_QUALIFIERS_IN_GRP_T(Tbl_Index),
COMP_OPERATOR_TYPE_CODE_T(Tbl_Index),
nvl(VALIDATED_FLAG_T(Tbl_Index),'N'),
nvl(APPLIED_FLAG_T(Tbl_Index),'N'),
PRICING_STATUS_CODE_T(Tbl_Index),
PRICING_STATUS_TEXT_T(Tbl_Index),
QUALIFIER_PRECEDENCE_T(Tbl_Index),
nvl(PRICING_ATTR_FLAG_T(Tbl_Index),'N'),
QUALIFIER_TYPE_T(Tbl_Index),
DATATYPE_T(Tbl_Index),
PRODUCT_UOM_CODE_T(Tbl_Index),
ATTR_PROCESSED_CODE_T(Tbl_Index),
nvl(EXCLUDER_FLAG_T(Tbl_Index),'N'),
GROUP_QUANTITY_T(Tbl_Index),
GROUP_AMOUNT_T(Tbl_Index),
nvl(DISTINCT_QUALIFIER_FLAG_T(Tbl_Index),'N'),
PRICING_PHASE_ID_T(Tbl_Index),
INCOMPATABILITY_GRP_CODE_T(Tbl_Index),
LINE_DETAIL_TYPE_CODE_T(Tbl_Index),
MODIFIER_LEVEL_CODE_T(Tbl_Index),
nvl(PRIMARY_UOM_FLAG_T(Tbl_Index),'N')
);
QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Records into QP_DEBUG_REQ_LINE_ATTRS***');
REQUEST_ID_T.delete;
LINE_INDEX_T.delete;
LINE_DETAIL_INDEX_T.delete;
LINE_ATTRIBUTE_ID_T.delete;
ATTRIBUTE_LEVEL_T.delete;
ATTRIBUTE_TYPE_T.delete;
LIST_HEADER_ID_T.delete;
LIST_LINE_ID_T.delete;
CONTEXT_T.delete;
ATTRIBUTE_T.delete;
VALUE_FROM_T.delete;
SETUP_VALUE_FROM_T.delete;
VALUE_TO_T.delete;
SETUP_VALUE_TO_T.delete;
GROUPING_NUMBER_T.delete;
NO_QUALIFIERS_IN_GRP_T.delete;
COMP_OPERATOR_TYPE_CODE_T.delete;
VALIDATED_FLAG_T.delete;
APPLIED_FLAG_T.delete;
PRICING_STATUS_CODE_T.delete;
PRICING_STATUS_TEXT_T.delete;
QUALIFIER_PRECEDENCE_T.delete;
PRICING_ATTR_FLAG_T.delete;
QUALIFIER_TYPE_T.delete;
DATATYPE_T.delete;
PRODUCT_UOM_CODE_T.delete;
PROCESSED_CODE_T.delete;
EXCLUDER_FLAG_T.delete;
GROUP_QUANTITY_T.delete;
GROUP_AMOUNT_T.delete;
DISTINCT_QUALIFIER_FLAG_T.delete;
PRICING_PHASE_ID_T.delete;
INCOMPATABILITY_GRP_CODE_T.delete;
LINE_DETAIL_TYPE_CODE_T.delete;
MODIFIER_LEVEL_CODE_T.delete;
PRIMARY_UOM_FLAG_T.delete;
END Insert_Line_Attr;
PROCEDURE Insert_RLTD_Line IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
QP_DEBUG_REQ_RLTD_LINES( REQUEST_ID,
REQUEST_TYPE_CODE,
LINE_INDEX,
LINE_DETAIL_INDEX,
RELATIONSHIP_TYPE_CODE,
RELATED_LINE_INDEX,
RELATED_LINE_DETAIL_INDEX,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
LIST_LINE_ID,
RELATED_LIST_LINE_ID,
RELATED_LIST_LINE_TYPE,
OPERAND_CALCULATION_CODE,
OPERAND,
PRICING_GROUP_SEQUENCE,
RELATIONSHIP_TYPE_DETAIL,
SETUP_VALUE_FROM,
SETUP_VALUE_TO,
QUALIFIER_VALUE,
ADJUSTMENT_AMOUNT,
SATISFIED_RANGE_VALUE
)
VALUES
( REQUEST_ID_T(Tbl_Index),
REQUEST_TYPE_CODE_T(Tbl_Index),
LINE_INDEX_T(Tbl_Index),
LINE_DETAIL_INDEX_T(Tbl_Index),
RELATIONSHIP_TYPE_CODE_T(Tbl_Index),
RELATED_LINE_INDEX_T(Tbl_Index),
RELATED_LINE_DETAIL_INDEX_T(Tbl_Index),
PRICING_STATUS_CODE_T(Tbl_Index),
PRICING_STATUS_TEXT_T(Tbl_Index),
LIST_LINE_ID_T(Tbl_Index),
RELATED_LIST_LINE_ID_T(Tbl_Index),
LIST_LINE_TYPE_T(Tbl_Index),
OPERAND_CALCULATION_CODE_T(Tbl_Index),
OPERAND_T(Tbl_Index),
PRICING_GROUP_SEQUENCE_T(Tbl_Index),
RELATIONSHIP_TYPE_DETAIL_T(Tbl_Index),
SETUP_VALUE_FROM_T(Tbl_Index),
SETUP_VALUE_TO_T(Tbl_Index),
QUALIFIER_VALUE_T(Tbl_Index),
ADJUSTMENT_AMOUNT_T(Tbl_Index),
SATISFIED_RANGE_VALUE_T(Tbl_Index)
);
QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_REQ_RLTD_LINES***');
REQUEST_ID_T.delete;
REQUEST_TYPE_CODE_T.delete;
LINE_INDEX_T.delete;
LINE_DETAIL_INDEX_T.delete;
RELATIONSHIP_TYPE_CODE_T.delete;
LINE_INDEX_T.delete;
LINE_DETAIL_INDEX_T.delete;
PRICING_STATUS_CODE_T.delete;
PRICING_STATUS_TEXT_T.delete;
LIST_LINE_ID_T.delete;
LIST_LINE_ID_T.delete;
LIST_LINE_TYPE_T.delete;
OPERAND_CALCULATION_CODE_T.delete;
OPERAND_T.delete;
PRICING_GROUP_SEQUENCE_T.delete;
RELATIONSHIP_TYPE_DETAIL_T.delete;
SETUP_VALUE_FROM_T.delete;
SETUP_VALUE_TO_T.delete;
QUALIFIER_VALUE_T.delete;
ADJUSTMENT_AMOUNT_T.delete;
SATISFIED_RANGE_VALUE_T.delete;
END Insert_RLTD_Line;
PROCEDURE Insert_Step_Values IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO
QP_DEBUG_FORMULA_STEP_VALUES( REQUEST_ID,
PRICE_FORMULA_ID,
STEP_NUMBER,
COMPONENT_VALUE,
PRICE_FORMULA_LINE_TYPE_CODE,
LINE_INDEX,
LIST_LINE_TYPE_CODE,
LIST_HEADER_ID,
LIST_LINE_ID
)
VALUES
( REQUEST_ID_T(Tbl_Index),
PRICE_FORMULA_ID_T(Tbl_Index),
STEP_NUMBER_T(Tbl_Index),
COMPONENT_VALUE_T(Tbl_Index),
PRICE_FORM_LINE_TYPE_CODE_T(Tbl_Index),
LINE_INDEX_T(Tbl_Index),
LIST_LINE_TYPE_T(Tbl_Index),
LIST_HEADER_ID_T(Tbl_Index),
LIST_LINE_ID_T(Tbl_Index)
);
QP_PREQ_GRP.engine_debug('***Inserted ' || LINE_INDEX_T.COUNT || ' Record into QP_DEBUG_FORMULA_STEP_VALUES***');
REQUEST_ID_T.delete;
PRICE_FORMULA_ID_T.delete;
STEP_NUMBER_T.delete;
COMPONENT_VALUE_T.delete;
PRICE_FORM_LINE_TYPE_CODE_T.delete;
LINE_INDEX_T.delete;
LIST_LINE_TYPE_T.delete;
LIST_HEADER_ID_T.delete;
LIST_LINE_ID_T.delete;
END Insert_Step_Values;
PROCEDURE INSERT_DEBUG_LINE(p_text IN VARCHAR2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
INSERT INTO qp_debug_text(REQUEST_ID,MESSAGE_LINE_NO,MESSAGE_TEXT)
VALUES (G_DEBUG_REQUEST_ID, G_DEBUG_TEXT_LINE_NO, p_text);
END INSERT_DEBUG_LINE;
SELECT qp_debug_req_s.nextval FROM dual;
SELECT REQUEST_TYPE_CODE,
LINE_ID,
LINE_INDEX,
LINE_TYPE_CODE,
PRICING_EFFECTIVE_DATE,
LINE_QUANTITY,
LINE_UOM_CODE,
PRICED_QUANTITY,
PRICED_UOM_CODE,
UOM_QUANTITY,
CURRENCY_CODE,
UNIT_PRICE,
PERCENT_PRICE,
ADJUSTED_UNIT_PRICE,
PARENT_PRICE,
PARENT_QUANTITY,
PARENT_UOM_CODE,
PROCESSING_ORDER,
PROCESSED_FLAG,
PROCESSED_CODE,
PRICE_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
START_DATE_ACTIVE_FIRST,
ACTIVE_DATE_FIRST_TYPE,
START_DATE_ACTIVE_SECOND,
ACTIVE_DATE_SECOND_TYPE,
GROUP_QUANTITY,
GROUP_AMOUNT,
LINE_AMOUNT,
ROUNDING_FLAG,
ROUNDING_FACTOR,
UPDATED_ADJUSTED_UNIT_PRICE,
PRICE_REQUEST_CODE,
HOLD_CODE,
HOLD_TEXT,
PRICE_LIST_HEADER_ID,
VALIDATED_FLAG,
QUALIFIERS_EXIST_FLAG,
PRICING_ATTRS_EXIST_FLAG,
PRIMARY_QUALIFIERS_MATCH_FLAG,
USAGE_PRICING_TYPE,
LINE_CATEGORY,
CONTRACT_START_DATE,
CONTRACT_END_DATE,
NULL -- sfiresto 2374448
FROM qp_npreq_lines_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
--added by yangli for Java Engine 3086881
UNION ALL
SELECT REQUEST_TYPE_CODE,
LINE_ID,
LINE_INDEX,
LINE_TYPE_CODE,
PRICING_EFFECTIVE_DATE,
LINE_QUANTITY,
LINE_UOM_CODE,
PRICED_QUANTITY,
PRICED_UOM_CODE,
UOM_QUANTITY,
CURRENCY_CODE,
UNIT_PRICE,
PERCENT_PRICE,
ADJUSTED_UNIT_PRICE,
PARENT_PRICE,
PARENT_QUANTITY,
PARENT_UOM_CODE,
PROCESSING_ORDER,
PROCESSED_FLAG,
PROCESSED_CODE,
PRICE_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
START_DATE_ACTIVE_FIRST,
ACTIVE_DATE_FIRST_TYPE,
START_DATE_ACTIVE_SECOND,
ACTIVE_DATE_SECOND_TYPE,
GROUP_QUANTITY,
GROUP_AMOUNT,
LINE_AMOUNT,
ROUNDING_FLAG,
ROUNDING_FACTOR,
UPDATED_ADJUSTED_UNIT_PRICE,
PRICE_REQUEST_CODE,
HOLD_CODE,
HOLD_TEXT,
PRICE_LIST_HEADER_ID,
VALIDATED_FLAG,
QUALIFIERS_EXIST_FLAG,
PRICING_ATTRS_EXIST_FLAG,
PRIMARY_QUALIFIERS_MATCH_FLAG,
USAGE_PRICING_TYPE,
LINE_CATEGORY,
CONTRACT_START_DATE,
CONTRACT_END_DATE,
NULL -- sfiresto 2374448
FROM qp_int_lines
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
--added by yangli for Java Engine 3086881
ORDER BY line_index;
SELECT LINE_DETAIL_INDEX,
LINE_DETAIL_TYPE_CODE,
PRICE_BREAK_TYPE_CODE,
LINE_INDEX,
CREATED_FROM_LIST_HEADER_ID,
CREATED_FROM_LIST_LINE_ID,
CREATED_FROM_LIST_LINE_TYPE,
CREATED_FROM_LIST_TYPE_CODE,
MODIFIER_LEVEL_CODE,
CREATED_FROM_SQL,
PRICING_GROUP_SEQUENCE,
OPERAND_CALCULATION_CODE,
OPERAND_VALUE,
ADJUSTMENT_AMOUNT,
LINE_QUANTITY,
SUBSTITUTION_TYPE_CODE,
SUBSTITUTION_VALUE_FROM,
SUBSTITUTION_VALUE_TO,
ASK_FOR_FLAG,
PRICE_FORMULA_ID,
PROCESSED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
PRODUCT_PRECEDENCE,
INCOMPATABILITY_GRP_CODE,
BEST_PERCENT,
PRICING_PHASE_ID,
APPLIED_FLAG,
AUTOMATIC_FLAG,
OVERRIDE_FLAG,
PRINT_ON_INVOICE_FLAG,
PRIMARY_UOM_FLAG,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
LIST_LINE_NO,
ACCRUAL_FLAG,
ACCRUAL_CONVERSION_RATE,
ESTIM_ACCRUAL_RATE,
RECURRING_FLAG,
SELECTED_VOLUME_ATTR,
ROUNDING_FACTOR,
SECONDARY_PRICELIST_IND,
GROUP_QUANTITY,
GROUP_AMOUNT,
PROCESS_CODE,
UPDATED_FLAG,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
LIMIT_CODE,
LIMIT_TEXT,
HEADER_LIMIT_EXISTS,
LINE_LIMIT_EXISTS,
CALCULATION_CODE,
CURRENCY_HEADER_ID,
PRICING_EFFECTIVE_DATE,
BASE_CURRENCY_CODE,
ORDER_CURRENCY,
CURRENCY_DETAIL_ID
FROM qp_npreq_ldets_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
--added by yangli for Java Engine 3086881
UNION ALL
SELECT LINE_DETAIL_INDEX,
LINE_DETAIL_TYPE_CODE,
PRICE_BREAK_TYPE_CODE,
LINE_INDEX,
CREATED_FROM_LIST_HEADER_ID,
CREATED_FROM_LIST_LINE_ID,
CREATED_FROM_LIST_LINE_TYPE,
CREATED_FROM_LIST_TYPE_CODE,
MODIFIER_LEVEL_CODE,
CREATED_FROM_SQL,
PRICING_GROUP_SEQUENCE,
OPERAND_CALCULATION_CODE,
OPERAND_VALUE,
ADJUSTMENT_AMOUNT,
LINE_QUANTITY,
SUBSTITUTION_TYPE_CODE,
SUBSTITUTION_VALUE_FROM,
SUBSTITUTION_VALUE_TO,
ASK_FOR_FLAG,
PRICE_FORMULA_ID,
PROCESSED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
PRODUCT_PRECEDENCE,
INCOMPATABILITY_GRP_CODE,
BEST_PERCENT,
PRICING_PHASE_ID,
APPLIED_FLAG,
AUTOMATIC_FLAG,
OVERRIDE_FLAG,
PRINT_ON_INVOICE_FLAG,
PRIMARY_UOM_FLAG,
BENEFIT_QTY,
BENEFIT_UOM_CODE,
LIST_LINE_NO,
ACCRUAL_FLAG,
ACCRUAL_CONVERSION_RATE,
ESTIM_ACCRUAL_RATE,
RECURRING_FLAG,
SELECTED_VOLUME_ATTR,
ROUNDING_FACTOR,
SECONDARY_PRICELIST_IND,
GROUP_QUANTITY,
GROUP_AMOUNT,
PROCESS_CODE,
UPDATED_FLAG,
CHARGE_TYPE_CODE,
CHARGE_SUBTYPE_CODE,
LIMIT_CODE,
LIMIT_TEXT,
HEADER_LIMIT_EXISTS,
LINE_LIMIT_EXISTS,
CALCULATION_CODE,
CURRENCY_HEADER_ID,
PRICING_EFFECTIVE_DATE,
BASE_CURRENCY_CODE,
ORDER_CURRENCY,
CURRENCY_DETAIL_ID
FROM qp_int_ldets
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
--added by yangli for Java Engine 3086881
ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
SELECT LINE_INDEX,
LINE_DETAIL_INDEX,
ATTRIBUTE_LEVEL,
ATTRIBUTE_TYPE,
LIST_HEADER_ID,
LIST_LINE_ID,
CONTEXT,
ATTRIBUTE,
VALUE_FROM,
SETUP_VALUE_FROM,
VALUE_TO,
SETUP_VALUE_TO,
GROUPING_NUMBER,
NO_QUALIFIERS_IN_GRP,
COMPARISON_OPERATOR_TYPE_CODE,
VALIDATED_FLAG,
APPLIED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
QUALIFIER_PRECEDENCE,
PRICING_ATTR_FLAG,
QUALIFIER_TYPE,
DATATYPE,
PRODUCT_UOM_CODE,
PROCESSED_CODE,
EXCLUDER_FLAG,
GROUP_QUANTITY,
GROUP_AMOUNT,
DISTINCT_QUALIFIER_FLAG,
PRICING_PHASE_ID,
INCOMPATABILITY_GRP_CODE,
LINE_DETAIL_TYPE_CODE,
MODIFIER_LEVEL_CODE,
PRIMARY_UOM_FLAG
FROM qp_npreq_line_attrs_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
--added by yangli for Java Engine 3086881
UNION ALL
SELECT LINE_INDEX,
LINE_DETAIL_INDEX,
ATTRIBUTE_LEVEL,
ATTRIBUTE_TYPE,
LIST_HEADER_ID,
LIST_LINE_ID,
CONTEXT,
ATTRIBUTE,
VALUE_FROM,
SETUP_VALUE_FROM,
VALUE_TO,
SETUP_VALUE_TO,
GROUPING_NUMBER,
NO_QUALIFIERS_IN_GRP,
COMPARISON_OPERATOR_TYPE_CODE,
VALIDATED_FLAG,
APPLIED_FLAG,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
QUALIFIER_PRECEDENCE,
PRICING_ATTR_FLAG,
QUALIFIER_TYPE,
DATATYPE,
PRODUCT_UOM_CODE,
PROCESSED_CODE,
EXCLUDER_FLAG,
GROUP_QUANTITY,
GROUP_AMOUNT,
DISTINCT_QUALIFIER_FLAG,
PRICING_PHASE_ID,
INCOMPATABILITY_GRP_CODE,
LINE_DETAIL_TYPE_CODE,
MODIFIER_LEVEL_CODE,
PRIMARY_UOM_FLAG
FROM qp_int_line_attrs
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
--added by yangli for Java Engine 3086881
ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
SELECT REQUEST_TYPE_CODE,
LINE_INDEX,
LINE_DETAIL_INDEX,
RELATIONSHIP_TYPE_CODE,
RELATED_LINE_INDEX,
RELATED_LINE_DETAIL_INDEX,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
LIST_LINE_ID,
RELATED_LIST_LINE_ID,
RELATED_LIST_LINE_TYPE,
OPERAND_CALCULATION_CODE,
OPERAND,
PRICING_GROUP_SEQUENCE,
RELATIONSHIP_TYPE_DETAIL,
SETUP_VALUE_FROM,
SETUP_VALUE_TO,
QUALIFIER_VALUE,
ADJUSTMENT_AMOUNT,
SATISFIED_RANGE_VALUE
FROM qp_npreq_rltd_lines_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
--added by yangli for Java Engine 3086881
UNION ALL
SELECT REQUEST_TYPE_CODE,
LINE_INDEX,
LINE_DETAIL_INDEX,
RELATIONSHIP_TYPE_CODE,
RELATED_LINE_INDEX,
RELATED_LINE_DETAIL_INDEX,
PRICING_STATUS_CODE,
PRICING_STATUS_TEXT,
LIST_LINE_ID,
RELATED_LIST_LINE_ID,
RELATED_LIST_LINE_TYPE,
OPERAND_CALCULATION_CODE,
OPERAND,
PRICING_GROUP_SEQUENCE,
RELATIONSHIP_TYPE_DETAIL,
SETUP_VALUE_FROM,
SETUP_VALUE_TO,
QUALIFIER_VALUE,
ADJUSTMENT_AMOUNT,
SATISFIED_RANGE_VALUE
FROM qp_int_rltd_lines
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
--added by yangli for Java Engine 3086881
ORDER BY LINE_INDEX, LINE_DETAIL_INDEX;
SELECT PRICE_FORMULA_ID,
STEP_NUMBER,
COMPONENT_VALUE,
PRICE_FORMULA_LINE_TYPE_CODE,
LINE_INDEX,
LIST_LINE_TYPE_CODE,
LIST_HEADER_ID,
LIST_LINE_ID
FROM qp_nformula_step_values_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
--added by yangli for Java Engine 3086881
UNION ALL
SELECT PRICE_FORMULA_ID,
STEP_NUMBER,
COMPONENT_VALUE,
PRICE_FORMULA_LINE_TYPE_CODE,
LINE_INDEX,
LIST_LINE_TYPE_CODE,
LIST_HEADER_ID,
LIST_LINE_ID
FROM qp_int_formula_step_values
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
--added by yangli for Java Engine 3086881
ORDER BY LINE_INDEX, PRICE_FORMULA_ID, STEP_NUMBER;
SELECT LINE_ID FROM qp_npreq_lines_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
AND LINE_TYPE_CODE = 'ORDER'
AND ROWNUM = 1
UNION ALL
SELECT LINE_ID FROM qp_int_lines
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
AND LINE_TYPE_CODE = 'ORDER'
AND ROWNUM = 1;
SELECT REQUEST_TYPE_CODE FROM qp_npreq_lines_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
AND ROWNUM = 1
UNION ALL
SELECT REQUEST_TYPE_CODE FROM qp_int_lines
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
AND ROWNUM = 1;
SELECT CURRENCY_CODE FROM qp_npreq_lines_tmp
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N'
AND ROWNUM = 1
UNION ALL
SELECT CURRENCY_CODE FROM qp_int_lines
WHERE QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'Y'
AND ROWNUM = 1;
SELECT qp_line_attr_s.nextval FROM dual;
SELECT ORDER_NUMBER FROM OE_ORDER_HEADERS_ALL
WHERE header_id = p_line_id;
g_control_rec.TEMP_TABLE_INSERT_FLAG := p_control_rec.TEMP_TABLE_INSERT_FLAG;
Insert_Request;
UPDATED_ADJUSTED_UNIT_PRICE_T,
PRICE_REQUEST_CODE_T,
HOLD_CODE_T,
HOLD_TEXT_T,
PRICE_LIST_HEADER_ID_T,
VALIDATED_FLAG_T,
QUALIFIERS_EXIST_FLAG_T,
PRICING_ATTRS_EXIST_FLAG_T,
PRIMARY_QUAL_MATCH_FLAG_T,
USAGE_PRICING_TYPE_T,
LINE_CATEGORY_T,
CONTRACT_START_DATE_T,
CONTRACT_END_DATE_T,
LINE_NUMBER_T -- sfiresto 2374448
LIMIT 1000;
SELECT LINE_NUMBER INTO LINE_NUMBER_T(Tbl_Index)
FROM OE_ORDER_LINES_ALL WHERE LINE_ID = LINE_ID_T(Tbl_Index);
Insert_Line;
SELECTED_VOLUME_ATTR_T,
ROUNDING_FACTOR_T,
SECONDARY_PRICELIST_IND_T,
GROUP_QUANTITY_T,
GROUP_AMOUNT_T,
PROCESS_CODE_T,
UPDATED_FLAG_T,
CHARGE_TYPE_CODE_T,
CHARGE_SUBTYPE_CODE_T,
LIMIT_CODE_T,
LIMIT_TEXT_T,
HEADER_LIMIT_EXISTS_T,
LINE_LIMIT_EXISTS_T,
CALCULATION_CODE_T,
CURRENCY_HEADER_ID_T,
PRICING_EFFECTIVE_DATE_T,
BASE_CURRENCY_CODE_T,
ORDER_CURRENCY_T,
CURRENCY_DETAIL_ID_T
LIMIT 1000;
Insert_LDet;
select QP_LINE_ATTR_S.nextval into l_LINE_ATTRIBUTE_ID from dual;
Insert_Line_Attr;
select count(*) into l_Rec_Count from qp_npreq_rltd_lines_tmp;
select count(*) into l_Rec_Count from qp_int_rltd_lines;
Insert_RLTD_Line;
Insert_Step_Values;