eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PRICE_LIST_LINE_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 164


        IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_updated_by,p_old_PRICE_LIST_LINE_rec.last_updated_by)
        THEN
            l_index := l_index + 1;

Line: 167


            l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

Line: 170


        IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_date,p_old_PRICE_LIST_LINE_rec.last_update_date)
        THEN
            l_index := l_index + 1;

Line: 173


            l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

Line: 176


        IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.last_update_login,p_old_PRICE_LIST_LINE_rec.last_update_login)
        THEN
            l_index := l_index + 1;

Line: 179


            l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

Line: 326


        IF NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.program_update_date,p_old_PRICE_LIST_LINE_rec.program_update_date)
        THEN
            l_index := l_index + 1;

Line: 329


            l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 440


    ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
        l_index := l_index + 1;

Line: 442


        l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATED_BY;

Line: 443


    ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 445


        l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_DATE;

Line: 446


    ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
        l_index := l_index + 1;

Line: 448


        l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_LAST_UPDATE_LOGIN;

Line: 521


    ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
        l_index := l_index + 1;

Line: 523


        l_src_attr_tbl(l_index) := OE_PRICE_LIST_LINE_UTIL.G_PROGRAM_UPDATE_DATE;

Line: 723


    IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_updated_by,p_old_Price_List_Line_rec.last_updated_by)
    THEN
        IF NOT OE_Validate_Attr.Last_Updated_By(p_Price_List_Line_rec.last_updated_by)
	THEN
            x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;

Line: 731


    IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_date,p_old_Price_List_Line_rec.last_update_date)
    THEN
	IF NOT OE_Validate_Attr.Last_Update_Date(p_Price_List_Line_rec.last_update_date) THEN
            x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;

Line: 738


    IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_login,p_old_Price_List_Line_rec.last_update_login)
    THEN
        IF NOT OE_Validate_Attr.Last_Update_Login(p_Price_List_Line_rec.last_update_login) THEN
            x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;

Line: 922


    IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_update_date,p_old_Price_List_Line_rec.program_update_date)
    THEN
        IF NOT OE_Validate_Attr.Program_Update_Date(p_Price_List_Line_rec.program_update_date) THEN
            x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;

Line: 1142


    IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;

Line: 1146


    IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;

Line: 1150


    IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;

Line: 1250


    IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;

Line: 1383


    IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_LINE_rec.last_updated_by := NULL;

Line: 1387


    IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_LINE_rec.last_update_date := NULL;

Line: 1391


    IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_PRICE_LIST_LINE_rec.last_update_login := NULL;

Line: 1491


    IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_PRICE_LIST_LINE_rec.program_update_date := NULL;

Line: 1529


PROCEDURE Update_Row
(   p_PRICE_LIST_LINE_rec           IN  OE_Price_List_PUB.Price_List_Line_Rec_Type
)
IS
l_list_price number := NULL;

Line: 1546


    UPDATE  QP_LIST_LINES
    SET     ATTRIBUTE1                     = p_PRICE_LIST_LINE_rec.attribute1
    ,       ATTRIBUTE10                    = p_PRICE_LIST_LINE_rec.attribute10
    ,       ATTRIBUTE11                    = p_PRICE_LIST_LINE_rec.attribute11
    ,       ATTRIBUTE12                    = p_PRICE_LIST_LINE_rec.attribute12
    ,       ATTRIBUTE13                    = p_PRICE_LIST_LINE_rec.attribute13
    ,       ATTRIBUTE14                    = p_PRICE_LIST_LINE_rec.attribute14
    ,       ATTRIBUTE15                    = p_PRICE_LIST_LINE_rec.attribute15
    ,       ATTRIBUTE2                     = p_PRICE_LIST_LINE_rec.attribute2
    ,       ATTRIBUTE3                     = p_PRICE_LIST_LINE_rec.attribute3
    ,       ATTRIBUTE4                     = p_PRICE_LIST_LINE_rec.attribute4
    ,       ATTRIBUTE5                     = p_PRICE_LIST_LINE_rec.attribute5
    ,       ATTRIBUTE6                     = p_PRICE_LIST_LINE_rec.attribute6
    ,       ATTRIBUTE7                     = p_PRICE_LIST_LINE_rec.attribute7
    ,       ATTRIBUTE8                     = p_PRICE_LIST_LINE_rec.attribute8
    ,       ATTRIBUTE9                     = p_PRICE_LIST_LINE_rec.attribute9
    ,       COMMENTS                       = p_PRICE_LIST_LINE_rec.comments
    ,       CONTEXT                        = p_PRICE_LIST_LINE_rec.context
    ,       CREATED_BY                     = p_PRICE_LIST_LINE_rec.created_by
    ,       CREATION_DATE                  = p_PRICE_LIST_LINE_rec.creation_date
    ,       END_DATE_ACTIVE                = p_PRICE_LIST_LINE_rec.end_date_active
    ,       LAST_UPDATE_DATE               = p_PRICE_LIST_LINE_rec.last_update_date
    ,       LAST_UPDATE_LOGIN              = p_PRICE_LIST_LINE_rec.last_update_login
    ,       LIST_PRICE                     = l_list_price
    ,       LIST_HEADER_ID                 = p_PRICE_LIST_LINE_rec.price_list_id
    ,       GENERATE_USING_FORMULA_ID      = p_PRICE_LIST_LINE_rec.pricing_rule_id
    ,       PRIMARY_UOM_FLAG               = p_PRICE_LIST_LINE_rec.primary
    ,       PROGRAM_APPLICATION_ID         = p_PRICE_LIST_LINE_rec.program_application_id
    ,       PROGRAM_ID                     = p_PRICE_LIST_LINE_rec.program_id
    ,       PROGRAM_UPDATE_DATE            = p_PRICE_LIST_LINE_rec.program_update_date
    ,       REQUEST_ID                     = p_PRICE_LIST_LINE_rec.request_id
    ,       REVISION                       = p_PRICE_LIST_LINE_rec.revision
    ,       REVISION_DATE                  = p_PRICE_LIST_LINE_rec.revision_date
    ,       REVISION_REASON_CODE           = p_PRICE_LIST_LINE_rec.revision_reason_code
    ,       START_DATE_ACTIVE              = p_PRICE_LIST_LINE_rec.start_date_active
    ,       LIST_PRICE_UOM_CODE            = p_PRICE_LIST_LINE_rec.unit_code
    ,       PERCENT_PRICE                  = l_percent_price
    ,       LAST_UPDATED_BY                = p_PRICE_LIST_LINE_rec.last_updated_by
    ,       LIST_LINE_TYPE_CODE            = p_PRICE_LIST_LINE_rec.list_line_type_code
    WHERE   LIST_LINE_ID = p_PRICE_LIST_LINE_rec.price_list_line_id
    ;

Line: 1592


     maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'UPDATE', x_return_status);

Line: 1605


            ,   'Update_Row'
            );

Line: 1611


END Update_Row;

Line: 1615


PROCEDURE Insert_Row
(   p_PRICE_LIST_LINE_rec           IN  OE_Price_List_PUB.Price_List_Line_Rec_Type
)
IS
l_product_context varchar2(30);

Line: 1633


oe_debug_pub.add ( 'Insert Values' || p_PRICE_LIST_LINE_rec.comments );

Line: 1635


  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, /* START_DATE_EFFECTIVE */
  END_DATE_ACTIVE,   /* END_DATE_EFFECTIVE */
  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,
  CONTEXT,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15,
  COMMENTS,
  PRICE_BREAK_TYPE_CODE,
  PERCENT_PRICE,
  EFFECTIVE_PERIOD_UOM,
  NUMBER_EFFECTIVE_PERIODS,
  OPERAND,
  ARITHMETIC_OPERATOR,
  OVERRIDE_FLAG,
  PRINT_ON_INVOICE_FLAG,
  REBATE_TRANSACTION_TYPE_CODE,
  BASE_QTY,
  BASE_UOM_CODE,
  ACCRUAL_QTY,
  ACCRUAL_UOM_CODE,
  ESTIM_ACCRUAL_RATE,
  PRICE_BY_FORMULA_ID,
  GENERATE_USING_FORMULA_ID
  --ENH Upgrade BOAPI for orig_sys...ref RAVI
  ,orig_sys_line_ref
  ,ORIG_SYS_HEADER_REF
  /* , REPRICE_FLAG,
      TP_ATTRIBUTE1,
 TP_ATTRIBUTE2,
 TP_ATTRIBUTE3,
 TP_ATTRIBUTE4,
 TP_ATTRIBUTE5,
 TP_ATTRIBUTE6,
 TP_ATTRIBUTE7,
 TP_ATTRIBUTE8,
 TP_ATTRIBUTE9,
 TP_ATTRIBUTE10,
 TP_ATTRIBUTE11,
 TP_ATTRIBUTE12,
 TP_ATTRIBUTE13,
 TP_ATTRIBUTE14,
 TP_ATTRIBUTE15,
 TP_ATTRIBUTE_CATEGORY */ )
values(
  p_PRICE_LIST_LINE_rec.price_list_line_id,
  p_PRICE_LIST_LINE_rec.creation_date,
  p_PRICE_LIST_LINE_rec.created_by,
  p_PRICE_LIST_LINE_rec.last_update_date,
  p_PRICE_LIST_LINE_rec.last_updated_by,
  p_PRICE_LIST_LINE_rec.last_update_login,
  p_PRICE_LIST_LINE_rec.program_application_id,
  p_PRICE_LIST_LINE_rec.program_id,
  p_PRICE_LIST_LINE_rec.program_update_date,
  p_PRICE_LIST_LINE_rec.request_id,
  p_PRICE_LIST_LINE_rec.price_list_id,
  'PLL',
  p_PRICE_LIST_LINE_rec.start_date_active, /* no need to do nvl */
  p_PRICE_LIST_LINE_rec.end_date_active,
  'Y',
  'LINE',
  DECODE(p_PRICE_LIST_LINE_rec.method_code, 'AMNT',p_PRICE_LIST_LINE_rec.list_price,NULL),
  p_PRICE_LIST_LINE_rec.unit_code,
  p_PRICE_LIST_LINE_rec.primary,
  NULL, /* INVENTORY_ITEM_ID */
  NULL, /* ORGANIZATION_ID */
  NULL, /* RELATED_ITEM_ID */
  NULL, /* RELATIONSHIP_TYPE_ID */
  NULL, /* SUBSTITUTION_CONTEXT */
  NULL, /* SUBSTITUTION_ATTRIBUTE */
  NULL, /* SUBSTITUTION_VALUE */
  p_PRICE_LIST_LINE_rec.revision,
  p_PRICE_LIST_LINE_rec.revision_date,
  p_PRICE_LIST_LINE_rec.revision_reason_code,
  p_PRICE_LIST_LINE_rec.context,
  p_PRICE_LIST_LINE_rec.attribute1,
  p_PRICE_LIST_LINE_rec.attribute2,
  p_PRICE_LIST_LINE_rec.attribute3,
  p_PRICE_LIST_LINE_rec.attribute4,
  p_PRICE_LIST_LINE_rec.attribute5,
  p_PRICE_LIST_LINE_rec.attribute6,
  p_PRICE_LIST_LINE_rec.attribute7,
  p_PRICE_LIST_LINE_rec.attribute8,
  p_PRICE_LIST_LINE_rec.attribute9,
  p_PRICE_LIST_LINE_rec.attribute10,
  p_PRICE_LIST_LINE_rec.attribute11,
  p_PRICE_LIST_LINE_rec.attribute12,
  p_PRICE_LIST_LINE_rec.attribute13,
  p_PRICE_LIST_LINE_rec.attribute14,
  p_PRICE_LIST_LINE_rec.attribute15,
  p_PRICE_LIST_LINE_rec.comments,
  NULL, /* p_PRICE_LIST_LINE_rec.price_break_type_code, */
  DECODE(p_PRICE_LIST_LINE_rec.method_code, 'PERC', p_PRICE_LIST_LINE_rec.list_price, NULL),
  NULL, /* EFFECTIVE_PERIOD_UOM */
  NULL, /* NUMBER_EFFECTIVE_PERIODS */
  NULL, /* OPERAND */
  NULL, /* ARITHMETIC_OPERATOR */
  NULL, /* OVERRIDE_FLAG */
  NULL, /* PRINT_ON_INVOICE_FLAG */
  NULL, /* REBATE_TRANSACTION_TYPE_CODE */
  NULL, /* BASE_QTY */
  NULL, /* BASE_UOM_CODE */
  NULL, /* ACCRUAL_QTY */
  NUll, /* ACCRUAL_UOM_CODE */
  NULL, /* ESTIM_ACCRUAL_RATE */
  NULL, /* PRICE_BY_FORMULA_ID */
  p_PRICE_LIST_LINE_rec.pricing_rule_id
  --ENH Upgrade BOAPI for orig_sys...ref RAVI
  ,to_char(p_PRICE_LIST_LINE_rec.price_list_line_id)
  ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_LINE_rec.price_list_id)
 /* , p_PRICE_LIST_LINE_rec.REPRICE_FLAG,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE1,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE2,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE3,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE4,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE5,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE6,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE7,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE8,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE9,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE10,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE11,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE12,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE13,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE14,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE15,
 p_PRICE_LIST_LINE_rec.TP_ATTRIBUTE_CATEGORY */ );

Line: 1807


 maintain_pricing_attributes(p_PRICE_LIST_LINE_rec, 'INSERT', x_return_status);

Line: 1813


/* insertion into translation table may need to be done */
/********************************************************/

    EXCEPTION

    WHEN OTHERS THEN

        x_return_status                := FND_API.G_RET_STS_ERROR;

Line: 1826


            ,   'Insert_Row'
            );

Line: 1830


END Insert_Row;

Line: 1834


PROCEDURE Delete_Row
(   p_price_list_line_id            IN  NUMBER
)
IS

l_list_line_type_code varchar2(30);

Line: 1842


select to_rltd_modifier_id, rltd_modifier_id
from qp_rltd_modifiers
where from_rltd_modifier_id = p_price_list_line_id;

Line: 1847


oe_debug_pub.add ( 'AAA - deleted ');

Line: 1849


   /* If list_line_type_code = 'PBH', we need to delete all the children
      list lines */

    select list_line_type_code
    into l_list_line_type_code
    from qp_list_lines
    where list_line_id = p_price_list_line_id;

Line: 1862


           DELETE  FROM QP_LIST_LINES
           WHERE   LIST_LINE_ID = child_lines_rec.to_rltd_modifier_id;

Line: 1865


           DELETE FROM QP_PRICING_ATTRIBUTES
           WHERE LIST_LINE_ID = child_lines_rec.to_rltd_modifier_id;

Line: 1868


           QP_RLTD_MODIFIER_PVT.Delete_Row(child_lines_rec.rltd_modifier_id);

Line: 1876


        DELETE from QP_RLTD_MODIFIERS
        where TO_RLTD_MODIFIER_ID = p_price_list_line_id;

Line: 1885


    	DELETE FROM QP_PRICING_ATTRIBUTES
    	WHERE LIST_LINE_ID = p_price_list_line_id;

Line: 1888


        DELETE FROM QP_LIST_LINES
    	WHERE LIST_LINE_ID = p_price_list_line_id;

Line: 1901


            ,   'Delete_Row'
            );

Line: 1907


END Delete_Row;

Line: 1941


    SELECT  ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       CUSTOMER_ITEM_ID
    ,       END_DATE_ACTIVE
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_PRICE
    ,       METHOD_CODE
    ,       PRICE_LIST_ID
    ,       PRICE_LIST_LINE_ID
    ,       PRICING_ATTRIBUTE1
    ,       PRICING_ATTRIBUTE10
    ,       PRICING_ATTRIBUTE11
    ,       PRICING_ATTRIBUTE12
    ,       PRICING_ATTRIBUTE13
    ,       PRICING_ATTRIBUTE14
    ,       PRICING_ATTRIBUTE15
    ,       PRICING_ATTRIBUTE2
    ,       PRICING_ATTRIBUTE3
    ,       PRICING_ATTRIBUTE4
    ,       PRICING_ATTRIBUTE5
    ,       PRICING_ATTRIBUTE6
    ,       PRICING_ATTRIBUTE7
    ,       PRICING_ATTRIBUTE8
    ,       PRICING_ATTRIBUTE9
    ,       PRICING_CONTEXT
    ,       PRICING_RULE_ID
    ,       PRIMARY
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REPRICE_FLAG
    ,       REQUEST_ID
    ,       REVISION
    ,       REVISION_DATE
    ,       REVISION_REASON_CODE
    ,       START_DATE_ACTIVE
    ,       UNIT_CODE
    FROM    QP_PRICE_LIST_LINES_V
    WHERE ( PRICE_LIST_LINE_ID = p_price_list_line_id)
    OR (PRICE_LIST_ID = p_price_list_id);

Line: 2054


        l_PRICE_LIST_LINE_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 2055


        l_PRICE_LIST_LINE_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 2056


        l_PRICE_LIST_LINE_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 2081


        l_PRICE_LIST_LINE_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 2173


, X_LAST_UPDATE_DATE		=> p_PRICE_LIST_LINE_rec.last_update_date
, X_LAST_UPDATED_BY		=> p_PRICE_LIST_LINE_rec.last_updated_by
, X_LAST_UPDATE_LOGIN		=> p_PRICE_LIST_LINE_rec.last_update_login
, X_PROGRAM_APPLICATION_ID	=> p_PRICE_LIST_LINE_rec.program_application_id
, X_PROGRAM_ID			=> p_PRICE_LIST_LINE_rec.program_id
, X_PROGRAM_UPDATE_DATE		=> p_PRICE_LIST_LINE_rec.program_update_date
, X_REQUEST_ID			=> p_PRICE_LIST_LINE_rec.request_id
, X_LIST_HEADER_ID		=> p_PRICE_LIST_LINE_rec.price_list_id
, X_LIST_LINE_TYPE_CODE		=> l_list_line_type_code
, X_START_DATE_ACTIVE		=> p_PRICE_LIST_LINE_rec.start_date_active
, X_END_DATE_ACTIVE		=> p_PRICE_LIST_LINE_rec.end_date_active
, X_AUTOMATIC_FLAG		=> l_automatic_flag
, X_MODIFIER_LEVEL_CODE		=> l_modifier_level_code
, X_LIST_PRICE			=> l_list_price
, X_LIST_PRICE_UOM_CODE		=> p_PRICE_LIST_LINE_rec.unit_code
, X_PRIMARY_UOM_FLAG		=> p_PRICE_LIST_LINE_rec.primary
, X_INVENTORY_ITEM_ID		=> NULL
, X_ORGANIZATION_ID		=> NULL
, X_RELATED_ITEM_ID		=> NULL
, X_RELATIONSHIP_TYPE_ID	=> NULL
, X_SUBSTITUTION_CONTEXT	=> NULL
, X_SUBSTITUTION_ATTRIBUTE	=> NULL
, X_SUBSTITUTION_VALUE		=> NULL
, X_REVISION			=> p_PRICE_LIST_LINE_rec.revision
, X_REVISION_DATE		=> p_PRICE_LIST_LINE_rec.revision_date
, X_REVISION_REASON_CODE	=> p_PRICE_LIST_LINE_rec.revision_reason_code
, X_COMMENTS			=> p_PRICE_LIST_LINE_rec.comments
, X_CONTEXT			=> p_PRICE_LIST_LINE_rec.context
, X_ATTRIBUTE1			=> p_PRICE_LIST_LINE_rec.attribute1
, X_ATTRIBUTE2			=> p_PRICE_LIST_LINE_rec.attribute2
, X_ATTRIBUTE3			=> p_PRICE_LIST_LINE_rec.attribute3
, X_ATTRIBUTE4			=> p_PRICE_LIST_LINE_rec.attribute4
, X_ATTRIBUTE5			=> p_PRICE_LIST_LINE_rec.attribute5
, X_ATTRIBUTE6			=> p_PRICE_LIST_LINE_rec.attribute6
, X_ATTRIBUTE7			=> p_PRICE_LIST_LINE_rec.attribute7
, X_ATTRIBUTE8			=> p_PRICE_LIST_LINE_rec.attribute8
, X_ATTRIBUTE9			=> p_PRICE_LIST_LINE_rec.attribute9
, X_ATTRIBUTE10			=> p_PRICE_LIST_LINE_rec.attribute10
, X_ATTRIBUTE11			=> p_PRICE_LIST_LINE_rec.attribute11
, X_ATTRIBUTE12			=> p_PRICE_LIST_LINE_rec.attribute12
, X_ATTRIBUTE13			=> p_PRICE_LIST_LINE_rec.attribute13
, X_ATTRIBUTE14			=> p_PRICE_LIST_LINE_rec.attribute14
, X_ATTRIBUTE15			=> p_PRICE_LIST_LINE_rec.attribute15
,X_PRICE_BREAK_TYPE_CODE	=> NULL /* p_PRICE_LIST_LINE_rec.price_break_type_code */
, X_PERCENT_PRICE		=> l_percent_price
, X_PRICE_BY_FORMULA_ID		=> NULL
, X_NUMBER_EFFECTIVE_PERIODS	=> NULL
, X_EFFECTIVE_PERIOD_UOM	=> NULL
, X_ARITHMETIC_OPERATOR		=> NULL
, X_OPERAND			=> NULL
, X_NEW_PRICE                   => NULL
, X_OVERRIDE_FLAG		=> NULL
, X_PRINT_ON_INVOICE_FLAG	=> NULL
, X_GL_CLASS_ID                 => NULL
, X_REBATE_TRANSACTION_TYPE_CODE => NULL
, X_REBATE_SUBTYPE_CODE          => NULL
, X_BASE_QTY			 => NULL
, X_BASE_UOM_CODE		 => NULL
, X_ACCRUAL_TYPE_CODE            => NULL
, X_ACCRUAL_QTY			 => NULL
, X_ACCRUAL_UOM_CODE		 => NULL
, X_ESTIM_ACCRUAL_RATE		 => NULL
, X_ACCUM_TO_ACCR_CONV_RATE      => NULL
, X_GENERATE_USING_FORMULA_ID	 => p_PRICE_LIST_LINE_rec.pricing_rule_id);

Line: 2251


            FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');

Line: 2710


  select 1
  into l_count
  from qp_pricing_attributes
  where list_line_id = p_list_line_id
  for update nowait;

Line: 2795


   IF operation = 'UPDATE' THEN
   oe_debug_pub.add ( 'Geresh 14 :: Before Query Maintain attributes ' );

Line: 2954


     /* call update row for pricing attributes */

     QP_PRICING_ATTRIBUTE_PVT.Update_Row(
  X_PRICING_ATTRIBUTE_ID => l_pricing_attr_tbl(I).pricing_attribute_id
, X_CREATION_DATE        => l_pricing_attr_tbl(I).creation_date
, X_CREATED_BY		 => l_pricing_attr_tbl(I).created_by
, X_LAST_UPDATE_DATE	 => l_pricing_attr_tbl(I).last_update_date
, X_LAST_UPDATED_BY	 => l_pricing_attr_tbl(I).last_updated_by
, X_LAST_UPDATE_LOGIN	 => l_pricing_attr_tbl(I).last_update_login
, X_PROGRAM_APPLICATION_ID => l_pricing_attr_tbl(I).program_application_id
, X_PROGRAM_ID             => l_pricing_attr_tbl(I).program_id
, X_PROGRAM_UPDATE_DATE    => l_pricing_attr_tbl(I).program_update_date
, X_REQUEST_ID		   => l_pricing_attr_tbl(I).request_id
, X_LIST_LINE_ID	   => l_pricing_attr_tbl(I).list_line_id
, X_EXCLUDER_FLAG	   => l_pricing_attr_tbl(I).excluder_flag
, X_ACCUMULATE_FLAG	   => l_pricing_attr_tbl(I).accumulate_flag
, X_PRODUCT_ATTRIBUTE_CONTEXT => l_pricing_attr_tbl(I).product_attribute_context
, X_PRODUCT_ATTRIBUTE	      => l_pricing_attr_tbl(I).product_attribute
, X_PRODUCT_ATTR_VALUE	      => l_pricing_attr_tbl(I).product_attr_value
, X_PRODUCT_UOM_CODE	      => l_pricing_attr_tbl(I).product_uom_code
, X_PRICING_ATTRIBUTE_CONTEXT => l_pricing_attr_tbl(I).pricing_attribute_context
, X_PRICING_ATTRIBUTE	      => l_pricing_attr_tbl(I).pricing_attribute
, X_PRICING_ATTR_VALUE_FROM   => l_pricing_attr_tbl(I).pricing_attr_value_from
, X_PRICING_ATTR_VALUE_TO     => l_pricing_attr_tbl(I).pricing_attr_value_to
, X_ATTRIBUTE_GROUPING_NO     => l_pricing_attr_tbl(I).attribute_grouping_no
, X_CONTEXT		      => l_pricing_attr_tbl(I).context
, X_ATTRIBUTE1		      => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE2                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE3                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE4                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE5                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE6                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE7                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE8                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE9                => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE10               => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE11               => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE12               => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE13               => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE14               => l_pricing_attr_tbl(I).attribute1
, X_ATTRIBUTE15               => l_pricing_attr_tbl(I).attribute1 );

Line: 2999


    END IF; /* If operation = UPDATE */

Line: 3001


   IF ( operation = 'INSERT') THEN

   oe_debug_pub.add ( 'Geresh 20 :: Insert Maintain attributes ' );

Line: 3037


   oe_debug_pub.add ( 'Geresh 21 :: Insert Maintain attributes ' );

Line: 3073


   oe_debug_pub.add ( 'Geresh 23 :: Insert Maintain attributes ' );

Line: 3111


   oe_debug_pub.add ( 'Geresh 24 :: Insert Maintain attributes ' );

Line: 3188


   /* select attribute grouping no first */


    SELECT QP_PRICING_ATTR_GROUP_NO_S.nextval
		INTO   l_pricing_attr_grouping_no
		FROM   DUAL;

Line: 3195


   oe_debug_pub.add ( 'Geresh 18 :: Before Insert into Pricing attributes Maintain attributes ' );

Line: 3199


    SELECT QP_PRICING_ATTRIBUTES_S.nextval
          INTO l_pricing_attribute_id
          from dual;

Line: 3203


    QP_PRICING_ATTRIBUTE_PVT.Insert_Row(
  X_PRICING_ATTRIBUTE_ID 	=> l_pricing_attribute_id
, X_CREATION_DATE		=> p_PRICE_LIST_LINE_rec.creation_date
, X_CREATED_BY                  => p_PRICE_LIST_LINE_rec.created_by
, X_LAST_UPDATE_DATE		=> p_PRICE_LIST_LINE_rec.last_update_date
, X_LAST_UPDATED_BY		=> p_PRICE_LIST_LINE_rec.last_updated_by
, X_LAST_UPDATE_LOGIN		=> p_PRICE_LIST_LINE_rec.last_update_login
, X_PROGRAM_APPLICATION_ID	=> p_PRICE_LIST_LINE_rec.program_application_id
, X_PROGRAM_ID			=> p_PRICE_LIST_LINE_rec.program_id
, X_PROGRAM_UPDATE_DATE		=> p_PRICE_LIST_LINE_rec.program_update_date
, X_REQUEST_ID			=> p_PRICE_LIST_LINE_rec.request_id
, X_LIST_LINE_ID		=> p_PRICE_LIST_LINE_rec.price_list_line_id
, X_EXCLUDER_FLAG		=> 'N'
, X_ACCUMULATE_FLAG             => 'N'
, X_PRODUCT_ATTRIBUTE_CONTEXT   => l_product_context
, X_PRODUCT_ATTRIBUTE		=> l_product_attr
, X_PRODUCT_ATTR_VALUE		=> p_PRICE_LIST_LINE_rec.inventory_item_id
, X_PRODUCT_UOM_CODE		=> p_PRICE_LIST_LINE_rec.unit_code
, X_PRICING_ATTRIBUTE_CONTEXT	=> l_pricing_attr_tbl(I).pricing_attribute_context
, X_PRICING_ATTRIBUTE		=> l_pricing_attr_tbl(I).pricing_attribute
, X_PRICING_ATTR_VALUE_FROM	=> l_pricing_attr_tbl(I).pricing_attr_value_from
, X_PRICING_ATTR_VALUE_TO	=> l_pricing_attr_tbl(I).pricing_attr_value_to
, X_ATTRIBUTE_GROUPING_NO	=> l_pricing_attr_grouping_no
, X_CONTEXT			=> NULL
, X_ATTRIBUTE1			=> NULL
, X_ATTRIBUTE2			=> NULL
, X_ATTRIBUTE3			=> NULL
, X_ATTRIBUTE4			=> NULL
, X_ATTRIBUTE5			=> NULL
, X_ATTRIBUTE6			=> NULL
, X_ATTRIBUTE7			=> NULL
, X_ATTRIBUTE8			=> NULL
, X_ATTRIBUTE9			=> NULL
, X_ATTRIBUTE10			=> NULL
, X_ATTRIBUTE11			=> NULL
, X_ATTRIBUTE12			=> NULL
, X_ATTRIBUTE13			=> NULL
, X_ATTRIBUTE14			=> NULL
, X_ATTRIBUTE15			=> NULL
);

Line: 3248


   oe_debug_pub.add ( 'Geresh 31 :: Before Insert into Pricing attributes Maintain attributes ' );

Line: 3252


      select qp_rltd_modifier_grp_no_s.nextval
      into l_rltd_modifier_grp_no
      from dual;

Line: 3255


   oe_debug_pub.add ( 'Geresh 30 :: Before Insert into Pricing attributes Maintain attributes ' );

Line: 3257


      select qp_rltd_modifiers_s.nextval
      into l_related_modifier_id
      from dual;

Line: 3264


      QP_RLTD_MODIFIER_PVT.Insert_Row(
       	X_RLTD_MODIFIER_ID 	=> l_related_modifier_id
, X_CREATION_DATE 		=> p_PRICE_LIST_LINE_rec.creation_date
, X_CREATED_BY			=> p_PRICE_LIST_LINE_rec.created_by
, X_LAST_UPDATE_DATE		=> p_PRICE_LIST_LINE_rec.last_update_date
, X_LAST_UPDATED_BY		=> p_PRICE_LIST_LINE_rec.last_updated_by
, X_LAST_UPDATE_LOGIN           => p_PRICE_LIST_LINE_rec.last_update_login
, X_RLTD_MODIFIER_GRP_NO        => l_rltd_modifier_grp_no
, X_FROM_RLTD_MODIFIER_ID       => p_PRICE_LIST_LINE_rec.price_break_parent_line
, X_TO_RLTD_MODIFIER_ID		=> p_PRICE_LIST_LINE_rec.price_list_line_id
, X_CONTEXT               	=> NULL
, X_ATTRIBUTE1			=> NULL
, X_ATTRIBUTE2                  => NULL
, X_ATTRIBUTE3                  => NULL
, X_ATTRIBUTE4                  => NULL
, X_ATTRIBUTE5                  => NULL
, X_ATTRIBUTE6                  => NULL
, X_ATTRIBUTE7                  => NULL
, X_ATTRIBUTE8                  => NULL
, X_ATTRIBUTE9                  => NULL
, X_ATTRIBUTE10                 => NULL
, X_ATTRIBUTE11                 => NULL
, X_ATTRIBUTE12                 => NULL
, X_ATTRIBUTE13                 => NULL
, X_ATTRIBUTE14                 => NULL
, X_ATTRIBUTE15                 => NULL
); */

Line: 3296


 END IF;  /* If operation = 'INSERT' */

Line: 3341


    SELECT  ACCUMULATE_FLAG
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE_GROUPING_NO
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EXCLUDER_FLAG
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_LINE_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
    FROM    QP_PRICING_ATTRIBUTES
    WHERE ( PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
    )
    OR (    LIST_LINE_ID = p_list_line_id
    );

Line: 3415


        l_PRICING_ATTR_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 3416


        l_PRICING_ATTR_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 3417


        l_PRICING_ATTR_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 3430


        l_PRICING_ATTR_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;