The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_API.g_attr_tbl.DELETE;
FND_API.g_attr_tbl(I).name := 'last_updated_by';
FND_API.g_attr_tbl(I).name := 'last_update_date';
FND_API.g_attr_tbl(I).name := 'last_update_login';
FND_API.g_attr_tbl(I).name := 'program_update_date';
FND_API.g_attr_tbl(I).name := 'updated_flag';
FND_API.g_attr_tbl(I).name := 'update_allowed';
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_updated_by IS NULL OR
p_last_updated_by = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
OE_Order_Util.Get_Attribute_Name('last_updated_by'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Updated_By'
);
END Last_Updated_By;
FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_update_date IS NULL OR
p_last_update_date = FND_API.G_MISS_DATE
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
OE_Order_Util.Get_Attribute_Name('last_update_date'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Update_Date'
);
END Last_Update_Date;
FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_last_update_login IS NULL OR
p_last_update_login = FND_API.G_MISS_NUM
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
OE_Order_Util.Get_Attribute_Name('last_update_login'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Last_Update_Login'
);
END Last_Update_Login;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_program_update_date IS NULL OR
p_program_update_date = FND_API.G_MISS_DATE
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
OE_Order_Util.Get_Attribute_Name('program_update_date'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Program_Update_Date'
);
END Program_Update_Date;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM qp_list_headers_vl
WHERE list_header_id = p_List_Header_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM qp_list_lines
WHERE list_line_id = p_List_Line_id;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Pricing_Phase_id');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ADJUSTED_AMOUNT');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPERAND');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARITHMETIC_OPERATOR');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
SELECT 'VALID'
INTO l_dummy
FROM qp_list_lines
WHERE list_line_no = p_List_Line_NO
AND ROWNUM=1;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'List_Line_NO');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Source_System_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_Qty');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_UOM_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Print_On_Invoice_Flag');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Expiration_Date');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Type_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Reference');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Payment_System_Code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Date');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Flag');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Accrual_Flag');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'range_break_quantity');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'accrual_conversion_rate');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'pricing_group_sequence');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'modifier_level_code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'price_break_type_code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'substitution_attribute');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'proration_type_code');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_Updated_Flag IS NULL OR
p_Updated_Flag = FND_API.G_MISS_CHAR
THEN
RETURN TRUE;
IF p_updated_flag NOT IN ('Y','N') THEN
RAISE NO_DATA_FOUND;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Updated_Flag'
);
END Updated_Flag;
FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy VARCHAR2(10);
IF p_Update_Allowed IS NULL OR
p_Update_Allowed = FND_API.G_MISS_CHAR
THEN
RETURN TRUE;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
, 'Update_Allowed'
);
END Update_Allowed;
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVERRIDE_FLAG');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);