[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
, x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
, x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
, x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
x_last_update_date := l_x_MODIFIERS_rec.last_update_date;
x_last_updated_by := l_x_MODIFIERS_rec.last_updated_by;
x_last_update_login := l_x_MODIFIERS_rec.last_update_login;
PROCEDURE Delete_Row
( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
, x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, p_list_line_id IN NUMBER
)
IS
l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
oe_debug_pub.add('BEGIN Delete_Row in QPXFMLLB');
l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_DELETE;
oe_debug_pub.add('END Delete_Row in QPXFMLLB');
, 'Delete_Row'
);
END Delete_Row;
, p_last_updated_by IN NUMBER
, p_last_update_date IN DATE
, p_last_update_login IN NUMBER
, p_list_header_id IN NUMBER
, p_list_line_id IN NUMBER
, p_list_line_type_code IN VARCHAR2
, p_list_price IN NUMBER
--, p_list_price_uom_code IN VARCHAR2
, p_modifier_level_code IN VARCHAR2
--, p_new_price IN NUMBER
, p_number_effective_periods IN NUMBER
, p_operand IN NUMBER
, p_organization_id IN NUMBER
, p_override_flag IN VARCHAR2
, p_percent_price IN NUMBER
, p_price_break_type_code IN VARCHAR2
, p_price_by_formula_id IN NUMBER
, p_primary_uom_flag IN VARCHAR2
, p_print_on_invoice_flag IN VARCHAR2
, p_program_application_id IN NUMBER
, p_program_id IN NUMBER
, p_program_update_date IN DATE
--, p_rebate_subtype_code IN VARCHAR2
, p_rebate_trxn_type_code IN VARCHAR2
, p_related_item_id IN NUMBER
, p_relationship_type_id IN NUMBER
, p_reprice_flag IN VARCHAR2
, p_request_id IN NUMBER
, p_revision IN VARCHAR2
, p_revision_date IN DATE
, p_revision_reason_code IN VARCHAR2
, p_start_date_active IN DATE
, p_substitution_attribute IN VARCHAR2
, p_substitution_context IN VARCHAR2
, p_substitution_value IN VARCHAR2
, p_accrual_flag IN VARCHAR2
, p_pricing_group_sequence IN NUMBER
, p_incompatibility_grp_code IN VARCHAR2
, p_list_line_no IN VARCHAR2
, p_product_precedence IN NUMBER
, p_expiration_period_start_date IN DATE
, p_number_expiration_periods IN NUMBER
, p_expiration_period_uom IN VARCHAR2
, p_expiration_date IN DATE
, p_estim_gl_value IN NUMBER
, p_benefit_price_list_line_id IN NUMBER
--, p_recurring_flag IN VARCHAR2
, p_benefit_limit IN NUMBER
, p_charge_type_code IN VARCHAR2
, p_charge_subtype_code IN VARCHAR2
, p_benefit_qty IN NUMBER
, p_benefit_uom_code IN VARCHAR2
, p_accrual_conversion_rate IN NUMBER
, p_proration_type_code IN VARCHAR2
, p_include_on_returns_flag IN VARCHAR2
, p_from_rltd_modifier_id IN NUMBER
, p_to_rltd_modifier_id IN NUMBER
, p_rltd_modifier_grp_no IN NUMBER
, p_rltd_modifier_grp_type IN VARCHAR2
, p_net_amount_flag IN VARCHAR2
, p_accum_attribute IN VARCHAR2
, p_continuous_price_break_flag IN VARCHAR2 --Continuous Price Breaks
, p_service_duration IN NUMBER -- service proj
, p_service_period IN VARCHAR2 -- service proj
)
IS
l_return_status VARCHAR2(1);
l_MODIFIERS_rec.last_updated_by := p_last_updated_by;
l_MODIFIERS_rec.last_update_date := p_last_update_date;
l_MODIFIERS_rec.last_update_login := p_last_update_login;
l_MODIFIERS_rec.program_update_date := p_program_update_date;
QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
,p_entity_id => p_list_line_id
,x_return_status => l_return_status);
SELECT
L.ACCRUAL_CONVERSION_RATE
, L.ACCRUAL_FLAG
, L.ACCRUAL_QTY
, L.ACCRUAL_UOM_CODE
, L.ARITHMETIC_OPERATOR
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, L.AUTOMATIC_FLAG
, L.BASE_QTY
, L.BASE_UOM_CODE
, L.BENEFIT_LIMIT
, L.BENEFIT_PRICE_LIST_LINE_ID
, L.BENEFIT_QTY
, L.BENEFIT_UOM_CODE
, L.CHARGE_SUBTYPE_CODE
, L.CHARGE_TYPE_CODE
, L.COMMENTS
, L.CONTEXT
, L.CREATED_BY
, L.CREATION_DATE
, L.EFFECTIVE_PERIOD_UOM
, L.END_DATE_ACTIVE
, L.ESTIM_ACCRUAL_RATE
, L.ESTIM_GL_VALUE
, L.EXPIRATION_DATE
, L.EXPIRATION_PERIOD_START_DATE
, L.EXPIRATION_PERIOD_UOM
, L.GENERATE_USING_FORMULA_ID
, L.GROUP_COUNT
, L.INCLUDE_ON_RETURNS_FLAG
, L.INCOMPATIBILITY_GRP_CODE
, L.INVENTORY_ITEM_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATE_LOGIN
, L.LAST_UPDATED_BY
, L.LIMIT_EXISTS_FLAG
, L.LIST_HEADER_ID
, L.LIST_LINE_ID
, L.LIST_LINE_NO
, L.LIST_LINE_TYPE_CODE
, L.LIST_PRICE
, L.LIST_PRICE_UOM_CODE
, L.MODIFIER_LEVEL_CODE
, L.NUMBER_EFFECTIVE_PERIODS
, L.NUMBER_EXPIRATION_PERIODS
, L.OPERAND
, L.ORGANIZATION_ID
, L.OVERRIDE_FLAG
, L.PERCENT_PRICE
, L.PRICE_BREAK_TYPE_CODE
, L.PRICE_BY_FORMULA_ID
, L.PRICING_GROUP_SEQUENCE
, L.PRICING_PHASE_ID
, L.PRIMARY_UOM_FLAG
, L.PRINT_ON_INVOICE_FLAG
, L.PRODUCT_PRECEDENCE
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.PRORATION_TYPE_CODE
, L.QUALIFICATION_IND
, L.REBATE_TRANSACTION_TYPE_CODE
, L.RECURRING_FLAG
, L.RELATED_ITEM_ID
, L.RELATIONSHIP_TYPE_ID
, L.REPRICE_FLAG
, L.REQUEST_ID
, L.REVISION
, L.REVISION_DATE
, L.REVISION_REASON_CODE
, L.START_DATE_ACTIVE
, L.SUBSTITUTION_ATTRIBUTE
, L.SUBSTITUTION_CONTEXT
, L.SUBSTITUTION_VALUE
, RM.RLTD_MODIFIER_GRP_NO
, RM.RLTD_MODIFIER_GRP_TYPE
, L.CONTINUOUS_PRICE_BREAK_FLAG
, L.SERVICE_DURATION
, L.SERVICE_PERIOD
FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM
WHERE L.LIST_LINE_ID = RM.TO_RLTD_MODIFIER_ID
AND RM.FROM_RLTD_MODIFIER_ID = p_list_line_id
AND L.LIST_HEADER_ID = p_list_header_id;
SELECT ACCUMULATE_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_GROUPING_NO
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EXCLUDER_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_LINE_ID
, LIST_HEADER_ID
, PRICING_PHASE_ID
, PRICING_ATTRIBUTE
, PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE_ID
, PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, COMPARISON_OPERATOR_CODE
, PRICING_ATTRIBUTE_DATATYPE
, PRODUCT_ATTRIBUTE_DATATYPE
, PRICING_ATTR_VALUE_FROM_NUMBER
, PRICING_ATTR_VALUE_TO_NUMBER
, QUALIFICATION_IND
FROM QP_PRICING_ATTRIBUTES
WHERE LIST_LINE_ID = p_list_line_id
AND (( PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
AND PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME')
OR EXCLUDER_FLAG = 'Y')
AND LIST_HEADER_ID = p_list_header_id;
SELECT ACCUMULATE_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_GROUPING_NO
, CONTEXT
, CREATED_BY
, CREATION_DATE
, EXCLUDER_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_LINE_ID
, LIST_HEADER_ID
, PRICING_PHASE_ID
, PRICING_ATTRIBUTE
, PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE_ID
, PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, COMPARISON_OPERATOR_CODE
, PRICING_ATTRIBUTE_DATATYPE
, PRODUCT_ATTRIBUTE_DATATYPE
, PRICING_ATTR_VALUE_FROM_NUMBER
, PRICING_ATTR_VALUE_TO_NUMBER
, QUALIFICATION_IND
FROM QP_PRICING_ATTRIBUTES
WHERE LIST_LINE_ID = p_list_line_id
AND LIST_HEADER_ID = p_list_header_id;
SELECT
ACTIVE_FLAG
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, COMPARISON_OPERATOR_CODE
, CONTEXT
, CREATED_BY
, CREATED_FROM_RULE_ID
, CREATION_DATE
, DISTINCT_ROW_COUNT
, END_DATE_ACTIVE
, EXCLUDER_FLAG
, HEADER_QUALS_EXIST_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_TYPE_CODE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUAL_ATTR_VALUE_FROM_NUMBER
, QUAL_ATTR_VALUE_TO_NUMBER
, QUALIFIER_ATTR_VALUE
, QUALIFIER_ATTR_VALUE_TO
, QUALIFIER_ATTRIBUTE
, QUALIFIER_CONTEXT
, QUALIFIER_DATATYPE
, QUALIFIER_GROUP_CNT
, QUALIFIER_GROUPING_NO
, QUALIFIER_ID
, QUALIFIER_PRECEDENCE
, QUALIFIER_RULE_ID
, REQUEST_ID
, SEARCH_IND
, START_DATE_ACTIVE
FROM QP_QUALIFIERS
WHERE LIST_LINE_ID = p_list_line_id
AND LIST_HEADER_ID = p_list_header_id;
SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
FROM dual;
l_PRICING_ATTR_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_PRICING_ATTR_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_PRICING_ATTR_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_PRICING_ATTR_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT continuous_price_break_flag INTO l_continuous_price_break_flag
FROM QP_LIST_LINES
WHERE list_line_id=p_old_list_line_id;
SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
FROM dual;
l_MODIFIERS_rec.LAST_UPDATE_DATE := l_implicit_rec.LAST_UPDATE_DATE;
l_MODIFIERS_rec.LAST_UPDATE_LOGIN := l_implicit_rec.LAST_UPDATE_LOGIN;
l_MODIFIERS_rec.LAST_UPDATED_BY := l_implicit_rec.LAST_UPDATED_BY;
l_MODIFIERS_rec.PROGRAM_UPDATE_DATE := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
FROM dual;
l_PRICING_ATTR_rec.last_updated_by := l_implicit_attr_rec.LAST_UPDATED_BY;
l_PRICING_ATTR_rec.last_update_date := l_implicit_attr_rec.LAST_UPDATE_DATE;
l_PRICING_ATTR_rec.last_update_login := l_implicit_attr_rec.LAST_UPDATE_LOGIN;
l_PRICING_ATTR_rec.program_update_date := l_implicit_attr_rec.PROGRAM_UPDATE_DATE;
SELECT qp_qualifiers_s.nextval INTO l_new_qualifier_id
FROM dual;
l_QUALIFIERS_rec.LAST_UPDATE_DATE := l_implicit_rec.LAST_UPDATE_DATE;
l_QUALIFIERS_rec.LAST_UPDATE_LOGIN := l_implicit_rec.LAST_UPDATE_LOGIN;
l_QUALIFIERS_rec.LAST_UPDATED_BY := l_implicit_rec.LAST_UPDATED_BY;
l_QUALIFIERS_rec.PROGRAM_UPDATE_DATE := l_implicit_rec.PROGRAM_UPDATE_DATE;