[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select QP_LIST_LINES_S.nextval
into l_list_line_id
from dual;
IF g_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
g_MODIFIERS_rec.last_updated_by := NULL;
IF g_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE THEN
g_MODIFIERS_rec.last_update_date := NULL;
IF g_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM THEN
g_MODIFIERS_rec.last_update_login := NULL;
IF g_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE THEN
g_MODIFIERS_rec.program_update_date := NULL;
OR g_MODIFIERS_rec.last_updated_by = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.last_update_date = FND_API.G_MISS_DATE
OR g_MODIFIERS_rec.last_update_login = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.list_header_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.list_line_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.list_line_type_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.list_price = FND_API.G_MISS_NUM
-- OR g_MODIFIERS_rec.list_price_uom_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.modifier_level_code = FND_API.G_MISS_CHAR
-- OR g_MODIFIERS_rec.new_price = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.number_effective_periods = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.operand = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.organization_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.override_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.percent_price = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.price_break_type_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.price_by_formula_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.primary_uom_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.print_on_invoice_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.program_application_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.program_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.program_update_date = FND_API.G_MISS_DATE
-- OR g_MODIFIERS_rec.rebate_subtype_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.rebate_trxn_type_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.related_item_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.relationship_type_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.reprice_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.request_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.revision = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.revision_date = FND_API.G_MISS_DATE
OR g_MODIFIERS_rec.revision_reason_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.start_date_active = FND_API.G_MISS_DATE
OR g_MODIFIERS_rec.substitution_attribute = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.substitution_context = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.substitution_value = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.product_precedence = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.expiration_period_start_date = FND_API.G_MISS_DATE
OR g_MODIFIERS_rec.number_expiration_periods = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.expiration_period_uom = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.expiration_date = FND_API.G_MISS_DATE
OR g_MODIFIERS_rec.estim_gl_value = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.benefit_price_list_line_id = FND_API.G_MISS_NUM
-- OR g_MODIFIERS_rec.recurring_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.benefit_limit = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.charge_type_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.charge_subtype_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.benefit_qty = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.benefit_uom_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.accrual_conversion_rate = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.include_on_returns_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.proration_type_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.accrual_flag = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.pricing_group_sequence = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.incompatibility_grp_code = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.list_line_no = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.to_rltd_modifier_id = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.rltd_modifier_grp_no = FND_API.G_MISS_NUM
OR g_MODIFIERS_rec.rltd_modifier_grp_type = FND_API.G_MISS_CHAR
OR g_MODIFIERS_rec.net_amount_flag = FND_API.G_MISS_CHAR
THEN
QP_Default_Modifiers.Attributes
( p_MODIFIERS_rec => g_MODIFIERS_rec
, p_iteration => p_iteration + 1
, x_MODIFIERS_rec => x_MODIFIERS_rec
);