[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
X_LIST_LINE_ID IN OUT NUMBER
, X_CREATION_DATE DATE
, X_CREATED_BY NUMBER
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_HEADER_ID NUMBER
, X_LIST_LINE_TYPE_CODE VARCHAR2
, X_START_DATE_ACTIVE DATE
, X_END_DATE_ACTIVE DATE
, X_AUTOMATIC_FLAG VARCHAR2
, X_MODIFIER_LEVEL_CODE VARCHAR2
, X_LIST_PRICE NUMBER
, X_LIST_PRICE_UOM_CODE VARCHAR2
, X_PRIMARY_UOM_FLAG VARCHAR2
, X_INVENTORY_ITEM_ID NUMBER
, X_ORGANIZATION_ID NUMBER
, X_RELATED_ITEM_ID NUMBER
, X_RELATIONSHIP_TYPE_ID NUMBER
, X_SUBSTITUTION_CONTEXT VARCHAR2
, X_SUBSTITUTION_ATTRIBUTE VARCHAR2
, X_SUBSTITUTION_VALUE VARCHAR2
, X_REVISION VARCHAR2
, X_REVISION_DATE DATE
, X_REVISION_REASON_CODE VARCHAR2
, X_COMMENTS VARCHAR2
, X_CONTEXT VARCHAR2
, X_ATTRIBUTE1 VARCHAR2
, X_ATTRIBUTE2 VARCHAR2
, X_ATTRIBUTE3 VARCHAR2
, X_ATTRIBUTE4 VARCHAR2
, X_ATTRIBUTE5 VARCHAR2
, X_ATTRIBUTE6 VARCHAR2
, X_ATTRIBUTE7 VARCHAR2
, X_ATTRIBUTE8 VARCHAR2
, X_ATTRIBUTE9 VARCHAR2
, X_ATTRIBUTE10 VARCHAR2
, X_ATTRIBUTE11 VARCHAR2
, X_ATTRIBUTE12 VARCHAR2
, X_ATTRIBUTE13 VARCHAR2
, X_ATTRIBUTE14 VARCHAR2
, X_ATTRIBUTE15 VARCHAR2
,X_PRICE_BREAK_TYPE_CODE VARCHAR2
, X_PERCENT_PRICE NUMBER
, X_PRICE_BY_FORMULA_ID NUMBER
, X_NUMBER_EFFECTIVE_PERIODS NUMBER
, X_EFFECTIVE_PERIOD_UOM VARCHAR2
, X_ARITHMETIC_OPERATOR VARCHAR2
, X_OPERAND NUMBER
, X_NEW_PRICE NUMBER
, X_OVERRIDE_FLAG VARCHAR2
, X_PRINT_ON_INVOICE_FLAG VARCHAR2
, X_GL_CLASS_ID NUMBER
, X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
, X_REBATE_SUBTYPE_CODE VARCHAR2
, X_BASE_QTY NUMBER
, X_BASE_UOM_CODE VARCHAR2
, X_ACCRUAL_TYPE_CODE VARCHAR2
, X_ACCRUAL_QTY NUMBER
, X_ACCRUAL_UOM_CODE VARCHAR2
, X_ESTIM_ACCRUAL_RATE NUMBER
, X_ACCUM_TO_ACCR_CONV_RATE NUMBER
, X_GENERATE_USING_FORMULA_ID NUMBER
) IS
cursor C is select LIST_LINE_ID from QP_LIST_LINES
where LIST_LINE_ID = X_LIST_LINE_ID;
insert into QP_LIST_LINES
(LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_HEADER_ID
, LIST_LINE_TYPE_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, AUTOMATIC_FLAG
, MODIFIER_LEVEL_CODE
, LIST_PRICE
, LIST_PRICE_UOM_CODE
, PRIMARY_UOM_FLAG
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID
, SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_VALUE
, REVISION
, REVISION_DATE
, REVISION_REASON_CODE
, COMMENTS
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
,PRICE_BREAK_TYPE_CODE
,PERCENT_PRICE
,PRICE_BY_FORMULA_ID
,NUMBER_EFFECTIVE_PERIODS
,EFFECTIVE_PERIOD_UOM
,ARITHMETIC_OPERATOR
,OPERAND
--,NEW_PRICE
,OVERRIDE_FLAG
,PRINT_ON_INVOICE_FLAG
--,GL_CLASS_ID
,REBATE_TRANSACTION_TYPE_CODE
--,REBATE_SUBTYPE_CODE
,BASE_QTY
,BASE_UOM_CODE
--,ACCRUAL_TYPE_CODE
,ACCRUAL_QTY
,ACCRUAL_UOM_CODE
,ESTIM_ACCRUAL_RATE
--,ACCUM_TO_ACCR_CONV_RATE
,GENERATE_USING_FORMULA_ID
)
values
(X_LIST_LINE_ID
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_PROGRAM_APPLICATION_ID
, X_PROGRAM_ID
, X_PROGRAM_UPDATE_DATE
, X_REQUEST_ID
, X_LIST_HEADER_ID
, X_LIST_LINE_TYPE_CODE
, X_START_DATE_ACTIVE
, X_END_DATE_ACTIVE
, X_AUTOMATIC_FLAG
, X_MODIFIER_LEVEL_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, X_CONTEXT
, X_ATTRIBUTE1
, X_ATTRIBUTE2
, X_ATTRIBUTE3
, X_ATTRIBUTE4
, X_ATTRIBUTE5
, X_ATTRIBUTE6
, X_ATTRIBUTE7
, X_ATTRIBUTE8
, X_ATTRIBUTE9
, X_ATTRIBUTE10
, X_ATTRIBUTE11
, X_ATTRIBUTE12
, X_ATTRIBUTE13
, X_ATTRIBUTE14
, X_ATTRIBUTE15
,X_PRICE_BREAK_TYPE_CODE
,X_PERCENT_PRICE
,X_PRICE_BY_FORMULA_ID
,X_NUMBER_EFFECTIVE_PERIODS
,X_EFFECTIVE_PERIOD_UOM
,X_ARITHMETIC_OPERATOR
,X_OPERAND
--,X_NEW_PRICE
,X_OVERRIDE_FLAG
,X_PRINT_ON_INVOICE_FLAG
--,X_GL_CLASS_ID
,X_REBATE_TRANSACTION_TYPE_CODE
--,X_REBATE_SUBTYPE_CODE
,X_BASE_QTY
,X_BASE_UOM_CODE
--,X_ACCRUAL_TYPE_CODE
,X_ACCRUAL_QTY
,X_ACCRUAL_UOM_CODE
,X_ESTIM_ACCRUAL_RATE
--,X_ACCUM_TO_ACCR_CONV_RATE
,X_GENERATE_USING_FORMULA_ID
);
end Insert_Row;
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_HEADER_ID NUMBER
, X_LIST_LINE_TYPE_CODE VARCHAR2
, X_START_DATE_ACTIVE DATE
, X_END_DATE_ACTIVE DATE
, X_AUTOMATIC_FLAG VARCHAR2
, X_MODIFIER_LEVEL_CODE VARCHAR2
, X_LIST_PRICE NUMBER
, X_LIST_PRICE_UOM_CODE VARCHAR2
, X_PRIMARY_UOM_FLAG VARCHAR2
, X_INVENTORY_ITEM_ID NUMBER
, X_ORGANIZATION_ID NUMBER
, X_RELATED_ITEM_ID NUMBER
, X_RELATIONSHIP_TYPE_ID NUMBER
, X_SUBSTITUTION_CONTEXT VARCHAR2
, X_SUBSTITUTION_ATTRIBUTE VARCHAR2
, X_SUBSTITUTION_VALUE VARCHAR2
, X_REVISION VARCHAR2
, X_REVISION_DATE DATE
, X_REVISION_REASON_CODE VARCHAR2
, X_COMMENTS VARCHAR2
, X_CONTEXT VARCHAR2
, X_ATTRIBUTE1 VARCHAR2
, X_ATTRIBUTE2 VARCHAR2
, X_ATTRIBUTE3 VARCHAR2
, X_ATTRIBUTE4 VARCHAR2
, X_ATTRIBUTE5 VARCHAR2
, X_ATTRIBUTE6 VARCHAR2
, X_ATTRIBUTE7 VARCHAR2
, X_ATTRIBUTE8 VARCHAR2
, X_ATTRIBUTE9 VARCHAR2
, X_ATTRIBUTE10 VARCHAR2
, X_ATTRIBUTE11 VARCHAR2
, X_ATTRIBUTE12 VARCHAR2
, X_ATTRIBUTE13 VARCHAR2
, X_ATTRIBUTE14 VARCHAR2
, X_ATTRIBUTE15 VARCHAR2
,X_PRICE_BREAK_TYPE_CODE VARCHAR2
, X_PERCENT_PRICE NUMBER
, X_PRICE_BY_FORMULA_ID NUMBER
, X_NUMBER_EFFECTIVE_PERIODS NUMBER
, X_EFFECTIVE_PERIOD_UOM VARCHAR2
, X_ARITHMETIC_OPERATOR VARCHAR2
, X_OPERAND NUMBER
, X_NEW_PRICE NUMBER
, X_OVERRIDE_FLAG VARCHAR2
, X_PRINT_ON_INVOICE_FLAG VARCHAR2
, X_GL_CLASS_ID NUMBER
, X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
, X_REBATE_SUBTYPE_CODE VARCHAR2
, X_BASE_QTY NUMBER
, X_BASE_UOM_CODE VARCHAR2
, X_ACCRUAL_TYPE_CODE VARCHAR2
, X_ACCRUAL_QTY NUMBER
, X_ACCRUAL_UOM_CODE VARCHAR2
, X_ESTIM_ACCRUAL_RATE NUMBER
, X_ACCUM_TO_ACCR_CONV_RATE NUMBER
, X_GENERATE_USING_FORMULA_ID NUMBER
) IS
cursor C is select * from QP_LIST_LINES
where LIST_LINE_ID = X_LIST_LINE_ID
for update of LIST_LINE_ID nowait;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE)
OR ( (Recinfo.LAST_UPDATE_DATE IS NULL)
AND (X_LAST_UPDATE_DATE IS NULL)))
AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY)
OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
AND (X_LAST_UPDATED_BY IS NULL)))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN)
OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
AND (X_LAST_UPDATE_LOGIN IS NULL)))
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID)
OR ( (Recinfo.PROGRAM_APPLICATION_ID IS NULL)
AND (X_PROGRAM_APPLICATION_ID IS NULL)))
AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID)
OR ( (Recinfo.PROGRAM_ID IS NULL)
AND (X_PROGRAM_ID IS NULL)))
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE)
OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
AND (X_PROGRAM_UPDATE_DATE IS NULL)))
AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
OR ( (Recinfo.REQUEST_ID IS NULL)
AND (X_REQUEST_ID IS NULL)))
AND ( ( Recinfo.LIST_LINE_TYPE_CODE = X_LIST_LINE_TYPE_CODE )
OR ( (Recinfo.LIST_LINE_TYPE_CODE IS NULL)
AND (X_LIST_LINE_TYPE_CODE IS NULL)))
AND ( ( Recinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE )
OR ( (Recinfo.START_DATE_ACTIVE IS NULL)
AND (X_START_DATE_ACTIVE IS NULL)))
AND ( ( Recinfo.END_DATE_ACTIVE = X_END_DATE_ACTIVE )
OR ( (Recinfo.END_DATE_ACTIVE IS NULL)
AND (X_END_DATE_ACTIVE IS NULL)))
AND ( ( Recinfo.AUTOMATIC_FLAG = X_AUTOMATIC_FLAG )
OR ( (Recinfo.AUTOMATIC_FLAG IS NULL)
AND (X_AUTOMATIC_FLAG IS NULL)))
AND ( ( Recinfo.MODIFIER_LEVEL_CODE = X_MODIFIER_LEVEL_CODE )
OR ( (Recinfo.MODIFIER_LEVEL_CODE IS NULL)
AND (X_MODIFIER_LEVEL_CODE IS NULL)))
AND ( ( Recinfo.LIST_PRICE = X_LIST_PRICE )
OR ( (Recinfo.LIST_PRICE IS NULL)
AND (X_LIST_PRICE IS NULL)))
AND ( ( Recinfo.LIST_PRICE_UOM_CODE = X_LIST_PRICE_UOM_CODE )
OR ( (Recinfo.LIST_PRICE_UOM_CODE IS NULL)
AND (X_LIST_PRICE_UOM_CODE IS NULL)))
AND ( ( Recinfo.PRIMARY_UOM_FLAG= X_PRIMARY_UOM_FLAG )
OR ( (Recinfo.PRIMARY_UOM_FLAG IS NULL)
AND (X_PRIMARY_UOM_FLAG IS NULL)))
AND ( ( Recinfo.INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID )
OR ( (Recinfo.INVENTORY_ITEM_ID IS NULL)
AND (X_INVENTORY_ITEM_ID IS NULL)))
AND ( ( Recinfo.ORGANIZATION_ID = X_ORGANIZATION_ID )
OR ( (Recinfo.ORGANIZATION_ID IS NULL)
AND (X_ORGANIZATION_ID IS NULL)))
AND ( ( Recinfo.RELATED_ITEM_ID = X_RELATED_ITEM_ID )
OR ( (Recinfo.RELATED_ITEM_ID IS NULL)
AND (X_RELATED_ITEM_ID IS NULL)))
AND ( ( Recinfo.RELATIONSHIP_TYPE_ID = X_RELATIONSHIP_TYPE_ID )
OR ( (Recinfo.RELATIONSHIP_TYPE_ID IS NULL)
AND (X_RELATIONSHIP_TYPE_ID IS NULL)))
AND ( ( Recinfo.SUBSTITUTION_CONTEXT = X_SUBSTITUTION_CONTEXT )
OR ( (Recinfo.SUBSTITUTION_CONTEXT IS NULL)
AND (X_SUBSTITUTION_CONTEXT IS NULL)))
AND ( ( Recinfo.SUBSTITUTION_ATTRIBUTE = X_SUBSTITUTION_ATTRIBUTE )
OR ( (Recinfo.SUBSTITUTION_ATTRIBUTE IS NULL)
AND (X_SUBSTITUTION_ATTRIBUTE IS NULL)))
AND ( ( Recinfo.SUBSTITUTION_VALUE = X_SUBSTITUTION_VALUE )
OR ( (Recinfo.SUBSTITUTION_VALUE IS NULL)
AND (X_SUBSTITUTION_VALUE IS NULL)))
AND ( ( Recinfo.REVISION = X_REVISION )
OR ( (Recinfo.REVISION IS NULL)
AND (X_REVISION IS NULL)))
AND ( ( Recinfo.REVISION_DATE = X_REVISION_DATE )
OR ( (Recinfo.REVISION_DATE IS NULL)
AND (X_REVISION_DATE IS NULL)))
AND ( ( Recinfo.REVISION_REASON_CODE = X_REVISION_REASON_CODE )
OR ( (Recinfo.REVISION_REASON_CODE IS NULL)
AND (X_REVISION_REASON_CODE IS NULL)))
AND ( ( Recinfo.COMMENTS = X_COMMENTS )
OR ( (Recinfo.COMMENTS IS NULL)
AND (X_COMMENTS IS NULL)))
AND ( ( Recinfo.CONTEXT = X_CONTEXT )
OR ( (Recinfo.CONTEXT IS NULL)
AND (X_CONTEXT IS NULL)))
AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
OR ( (Recinfo.ATTRIBUTE1 IS NULL)
AND (X_ATTRIBUTE1 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
OR ( (Recinfo.ATTRIBUTE2 IS NULL)
AND (X_ATTRIBUTE2 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
OR ( (Recinfo.ATTRIBUTE3 IS NULL)
AND (X_ATTRIBUTE3 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
OR ( (Recinfo.ATTRIBUTE4 IS NULL)
AND (X_ATTRIBUTE4 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
OR ( (Recinfo.ATTRIBUTE5 IS NULL)
AND (X_ATTRIBUTE5 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
OR ( (Recinfo.ATTRIBUTE6 IS NULL)
AND (X_ATTRIBUTE6 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
OR ( (Recinfo.ATTRIBUTE7 IS NULL)
AND (X_ATTRIBUTE7 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
OR ( (Recinfo.ATTRIBUTE8 IS NULL)
AND (X_ATTRIBUTE8 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
OR ( (Recinfo.ATTRIBUTE9 IS NULL)
AND (X_ATTRIBUTE9 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
OR ( (Recinfo.ATTRIBUTE10 IS NULL)
AND (X_ATTRIBUTE10 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
OR ( (Recinfo.ATTRIBUTE11 IS NULL)
AND (X_ATTRIBUTE11 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
OR ( (Recinfo.ATTRIBUTE12 IS NULL)
AND (X_ATTRIBUTE12 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
OR ( (Recinfo.ATTRIBUTE13 IS NULL)
AND (X_ATTRIBUTE13 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
OR ( (Recinfo.ATTRIBUTE14 IS NULL)
AND (X_ATTRIBUTE14 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
OR ( (Recinfo.ATTRIBUTE15 IS NULL)
AND (X_ATTRIBUTE15 IS NULL)))
AND ( ( Recinfo.PRICE_BREAK_TYPE_CODE= X_PRICE_BREAK_TYPE_CODE)
OR ( (Recinfo.PRICE_BREAK_TYPE_CODE IS NULL)
AND (X_PRICE_BREAK_TYPE_CODE IS NULL)))
AND ( ( Recinfo.PERCENT_PRICE = X_PERCENT_PRICE )
OR ( (Recinfo.PERCENT_PRICE IS NULL)
AND (X_PERCENT_PRICE IS NULL)))
AND ( ( Recinfo.PRICE_BY_FORMULA_ID = X_PRICE_BY_FORMULA_ID )
OR ( (Recinfo.PRICE_BY_FORMULA_ID IS NULL)
AND (X_PRICE_BY_FORMULA_ID IS NULL)))
AND ( ( Recinfo.NUMBER_EFFECTIVE_PERIODS = X_NUMBER_EFFECTIVE_PERIODS )
OR ( (Recinfo.NUMBER_EFFECTIVE_PERIODS IS NULL)
AND (X_NUMBER_EFFECTIVE_PERIODS IS NULL)))
AND ( ( Recinfo.EFFECTIVE_PERIOD_UOM = X_EFFECTIVE_PERIOD_UOM )
OR ( (Recinfo.EFFECTIVE_PERIOD_UOM IS NULL)
AND (X_EFFECTIVE_PERIOD_UOM IS NULL)))
AND ( ( Recinfo.ARITHMETIC_OPERATOR = X_ARITHMETIC_OPERATOR )
OR ( (Recinfo.ARITHMETIC_OPERATOR IS NULL)
AND (X_ARITHMETIC_OPERATOR IS NULL)))
AND ( ( Recinfo.OPERAND = X_OPERAND )
OR ( (Recinfo.OPERAND IS NULL)
AND (X_OPERAND IS NULL)))
/*
AND ( ( Recinfo.NEW_PRICE = X_NEW_PRICE )
OR ( (Recinfo.NEW_PRICE IS NULL)
AND (X_NEW_PRICE IS NULL)))
*/
AND ( ( Recinfo.OVERRIDE_FLAG = X_OVERRIDE_FLAG )
OR ( (Recinfo.OVERRIDE_FLAG IS NULL)
AND (X_OVERRIDE_FLAG IS NULL)))
AND ( ( Recinfo.PRINT_ON_INVOICE_FLAG = X_PRINT_ON_INVOICE_FLAG )
OR ( (Recinfo.PRINT_ON_INVOICE_FLAG IS NULL)
AND (X_PRINT_ON_INVOICE_FLAG IS NULL)))
/*
AND ( ( Recinfo.GL_CLASS_ID = X_GL_CLASS_ID )
OR ( (Recinfo.GL_CLASS_ID IS NULL)
AND (X_GL_CLASS_ID IS NULL)))
*/
AND ( ( Recinfo.REBATE_TRANSACTION_TYPE_CODE = X_REBATE_TRANSACTION_TYPE_CODE)
OR ( (Recinfo.REBATE_TRANSACTION_TYPE_CODE IS NULL)
AND (X_REBATE_TRANSACTION_TYPE_CODE IS NULL)))
/*
AND ( ( Recinfo.REBATE_SUBTYPE_CODE = X_REBATE_SUBTYPE_CODE )
OR ( (Recinfo.REBATE_SUBTYPE_CODE IS NULL)
AND (X_REBATE_SUBTYPE_CODE IS NULL)))
*/
AND ( ( Recinfo.BASE_QTY = X_BASE_QTY )
OR ( (Recinfo.BASE_QTY IS NULL)
AND (X_BASE_QTY IS NULL)))
AND ( ( Recinfo.BASE_UOM_CODE = X_BASE_UOM_CODE )
OR ( (Recinfo.BASE_UOM_CODE IS NULL)
AND (X_BASE_UOM_CODE IS NULL)))
/*
AND ( ( Recinfo.ACCRUAL_TYPE_CODE = X_ACCRUAL_TYPE_CODE )
OR ( (Recinfo.ACCRUAL_TYPE_CODE IS NULL)
AND (X_ACCRUAL_TYPE_CODE IS NULL)))
*/
AND ( ( Recinfo.ACCRUAL_QTY = X_ACCRUAL_QTY )
OR ( (Recinfo.ACCRUAL_QTY IS NULL)
AND (X_ACCRUAL_QTY IS NULL)))
AND ( ( Recinfo.ACCRUAL_UOM_CODE = X_ACCRUAL_UOM_CODE )
OR ( (Recinfo.ACCRUAL_UOM_CODE IS NULL)
AND (X_ACCRUAL_UOM_CODE IS NULL)))
AND ( ( Recinfo.ESTIM_ACCRUAL_RATE = X_ESTIM_ACCRUAL_RATE )
OR ( (Recinfo.ESTIM_ACCRUAL_RATE IS NULL)
AND (X_ESTIM_ACCRUAL_RATE IS NULL)))
/*
AND ( ( Recinfo.ACCUM_TO_ACCR_CONV_RATE = X_ACCUM_TO_ACCR_CONV_RATE )
OR ( (Recinfo.ACCUM_TO_ACCR_CONV_RATE IS NULL)
AND (X_ACCUM_TO_ACCR_CONV_RATE IS NULL)))
*/
AND ( ( Recinfo.GENERATE_USING_FORMULA_ID = X_GENERATE_USING_FORMULA_ID )
OR ( (Recinfo.GENERATE_USING_FORMULA_ID IS NULL)
AND (X_GENERATE_USING_FORMULA_ID IS NULL)))
) then
return;
PROCEDURE Update_Row(
X_LIST_LINE_ID IN OUT NUMBER
, X_CREATION_DATE DATE
, X_CREATED_BY NUMBER
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_HEADER_ID NUMBER
, X_LIST_LINE_TYPE_CODE VARCHAR2
, X_START_DATE_ACTIVE DATE
, X_END_DATE_ACTIVE DATE
, X_AUTOMATIC_FLAG VARCHAR2
, X_MODIFIER_LEVEL_CODE VARCHAR2
, X_LIST_PRICE NUMBER
, X_LIST_PRICE_UOM_CODE VARCHAR2
, X_PRIMARY_UOM_FLAG VARCHAR2
, X_INVENTORY_ITEM_ID NUMBER
, X_ORGANIZATION_ID NUMBER
, X_RELATED_ITEM_ID NUMBER
, X_RELATIONSHIP_TYPE_ID NUMBER
, X_SUBSTITUTION_CONTEXT VARCHAR2
, X_SUBSTITUTION_ATTRIBUTE VARCHAR2
, X_SUBSTITUTION_VALUE VARCHAR2
, X_REVISION VARCHAR2
, X_REVISION_DATE DATE
, X_REVISION_REASON_CODE VARCHAR2
, X_COMMENTS VARCHAR2
, X_CONTEXT VARCHAR2
, X_ATTRIBUTE1 VARCHAR2
, X_ATTRIBUTE2 VARCHAR2
, X_ATTRIBUTE3 VARCHAR2
, X_ATTRIBUTE4 VARCHAR2
, X_ATTRIBUTE5 VARCHAR2
, X_ATTRIBUTE6 VARCHAR2
, X_ATTRIBUTE7 VARCHAR2
, X_ATTRIBUTE8 VARCHAR2
, X_ATTRIBUTE9 VARCHAR2
, X_ATTRIBUTE10 VARCHAR2
, X_ATTRIBUTE11 VARCHAR2
, X_ATTRIBUTE12 VARCHAR2
, X_ATTRIBUTE13 VARCHAR2
, X_ATTRIBUTE14 VARCHAR2
, X_ATTRIBUTE15 VARCHAR2
,X_PRICE_BREAK_TYPE_CODE VARCHAR2
,X_PERCENT_PRICE NUMBER
, X_PRICE_BY_FORMULA_ID NUMBER
, X_NUMBER_EFFECTIVE_PERIODS NUMBER
, X_EFFECTIVE_PERIOD_UOM VARCHAR2
, X_ARITHMETIC_OPERATOR VARCHAR2
, X_OPERAND NUMBER
, X_NEW_PRICE NUMBER
, X_OVERRIDE_FLAG VARCHAR2
, X_PRINT_ON_INVOICE_FLAG VARCHAR2
, X_GL_CLASS_ID NUMBER
, X_REBATE_TRANSACTION_TYPE_CODE VARCHAR2
, X_REBATE_SUBTYPE_CODE VARCHAR2
, X_BASE_QTY NUMBER
, X_BASE_UOM_CODE VARCHAR2
, X_ACCRUAL_TYPE_CODE VARCHAR2
, X_ACCRUAL_QTY NUMBER
, X_ACCRUAL_UOM_CODE VARCHAR2
, X_ESTIM_ACCRUAL_RATE NUMBER
, X_ACCUM_TO_ACCR_CONV_RATE NUMBER
, X_GENERATE_USING_FORMULA_ID NUMBER
) IS
begin
UPDATE QP_LIST_LINES
SET
LIST_LINE_ID = X_LIST_LINE_ID
,CREATION_DATE = X_CREATION_DATE
,CREATED_BY = X_CREATED_BY
,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
,LAST_UPDATED_BY = X_LAST_UPDATED_BY
,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID
,PROGRAM_ID = X_PROGRAM_ID
,PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
,REQUEST_ID = X_REQUEST_ID
,LIST_HEADER_ID = X_LIST_HEADER_ID
,LIST_LINE_TYPE_CODE = X_LIST_LINE_TYPE_CODE
,START_DATE_ACTIVE = X_START_DATE_ACTIVE
,END_DATE_ACTIVE = X_END_DATE_ACTIVE
,AUTOMATIC_FLAG = X_AUTOMATIC_FLAG
,MODIFIER_LEVEL_CODE = X_MODIFIER_LEVEL_CODE
,LIST_PRICE = X_LIST_PRICE
,LIST_PRICE_UOM_CODE = X_LIST_PRICE_UOM_CODE
,PRIMARY_UOM_FLAG = X_PRIMARY_UOM_FLAG
,INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID
,ORGANIZATION_ID = X_ORGANIZATION_ID
,RELATED_ITEM_ID = X_RELATED_ITEM_ID
,RELATIONSHIP_TYPE_ID = X_RELATIONSHIP_TYPE_ID
,SUBSTITUTION_CONTEXT = X_SUBSTITUTION_CONTEXT
,SUBSTITUTION_ATTRIBUTE = X_SUBSTITUTION_ATTRIBUTE
,SUBSTITUTION_VALUE = X_SUBSTITUTION_VALUE
,REVISION = NULL
,REVISION_DATE = NULL
,REVISION_REASON_CODE = NULL
,COMMENTS = X_COMMENTS
,CONTEXT = X_CONTEXT
,ATTRIBUTE1 = X_ATTRIBUTE1
,ATTRIBUTE2 = X_ATTRIBUTE2
,ATTRIBUTE3 = X_ATTRIBUTE3
,ATTRIBUTE4 = X_ATTRIBUTE4
,ATTRIBUTE5 = X_ATTRIBUTE5
,ATTRIBUTE6 = X_ATTRIBUTE6
,ATTRIBUTE7 = X_ATTRIBUTE7
,ATTRIBUTE8 = X_ATTRIBUTE8
,ATTRIBUTE9 = X_ATTRIBUTE9
,ATTRIBUTE10 = X_ATTRIBUTE10
,ATTRIBUTE11 = X_ATTRIBUTE11
,ATTRIBUTE12 = X_ATTRIBUTE12
,ATTRIBUTE13 = X_ATTRIBUTE13
,ATTRIBUTE14 = X_ATTRIBUTE14
,ATTRIBUTE15 = X_ATTRIBUTE15
,PRICE_BREAK_TYPE_CODE = X_PRICE_BREAK_TYPE_CODE
,PERCENT_PRICE = X_PERCENT_PRICE
,PRICE_BY_FORMULA_ID = X_PRICE_BY_FORMULA_ID
,NUMBER_EFFECTIVE_PERIODS = X_NUMBER_EFFECTIVE_PERIODS
,EFFECTIVE_PERIOD_UOM = X_EFFECTIVE_PERIOD_UOM
,ARITHMETIC_OPERATOR = X_ARITHMETIC_OPERATOR
,OPERAND = X_OPERAND
--,NEW_PRICE = X_NEW_PRICE
,OVERRIDE_FLAG = X_OVERRIDE_FLAG
,PRINT_ON_INVOICE_FLAG = X_PRINT_ON_INVOICE_FLAG
--,GL_CLASS_ID = X_GL_CLASS_ID
,REBATE_TRANSACTION_TYPE_CODE = X_REBATE_TRANSACTION_TYPE_CODE
--,REBATE_SUBTYPE_CODE = X_REBATE_SUBTYPE_CODE
,BASE_QTY = X_BASE_QTY
,BASE_UOM_CODE = X_BASE_UOM_CODE
--,ACCRUAL_TYPE_CODE = X_ACCRUAL_TYPE_CODE
,ACCRUAL_QTY = X_ACCRUAL_QTY
,ACCRUAL_UOM_CODE = X_ACCRUAL_UOM_CODE
,ESTIM_ACCRUAL_RATE = X_ESTIM_ACCRUAL_RATE
--,ACCUM_TO_ACCR_CONV_RATE = X_ACCUM_TO_ACCR_CONV_RATE
,GENERATE_USING_FORMULA_ID = X_GENERATE_USING_FORMULA_ID
WHERE LIST_LINE_ID = X_LIST_LINE_ID;
END Update_Row;
PROCEDURE Delete_Row(
X_LIST_LINE_ID NUMBER
) IS
begin
delete from QP_LIST_LINES
where LIST_LINE_ID = X_LIST_LINE_ID;
END Delete_Row;