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_PAYMENTS_UTIL SQL Statements

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

Line: 9


PROCEDURE Update_Row
(   p_payment_types_rec	IN OUT NOCOPY Payment_Types_Rec_Type
)
IS
l_lock_control		NUMBER;

Line: 22


    SELECT lock_control
    INTO   l_lock_control
    FROM   OE_PRICE_ADJUSTMENTS
    WHERE  price_adjustment_id = p_payment_types_rec.price_adjustment_id;

Line: 30


    UPDATE  oe_payments
    SET     PAYMENT_TRX_ID	     = p_payment_types_rec.payment_trx_id
    ,	  COMMITMENT_APPLIED_AMOUNT     = p_payment_types_rec.commitment_applied_amount
    ,	  COMMITMENT_INTERFACED_AMOUNT  = p_payment_types_rec.commitment_interfaced_amount
/* START PREPAYMENT */
    ,       PAYMENT_SET_ID      = p_payment_types_rec.payment_set_id
    ,       PREPAID_AMOUNT      = p_payment_types_rec.prepaid_amount
    ,       PAYMENT_TYPE_CODE   = p_payment_types_rec.payment_type_code
    ,       CREDIT_CARD_CODE    = p_payment_types_rec.credit_card_code
    ,       CREDIT_CARD_NUMBER  = p_payment_types_rec.credit_card_number
    ,       CREDIT_CARD_HOLDER_NAME  = p_payment_types_rec.credit_card_holder_name
    ,       CREDIT_CARD_EXPIRATION_DATE  = p_payment_types_rec.credit_card_expiration_date
/* END PREPAYMENT */
    ,       PAYMENT_LEVEL_CODE	= p_payment_types_rec.payment_level_code
    ,       HEADER_ID              = p_payment_types_rec.header_id
    ,       LINE_ID                = p_payment_types_rec.line_id
    ,       LAST_UPDATE_DATE       = p_payment_types_rec.last_update_date
    ,       LAST_UPDATED_BY        = p_payment_types_rec.last_updated_by

    WHERE   PAYMENT_TRX_ID    = p_payment_types_rec.payment_trx_id
    ;

Line: 54


        oe_debug_pub.add(  'EXITING OE_PAYMENTS_UTIL.UPDATE_ROW.' , 1 ) ;

Line: 65


            ,   'Update_Row'
            );

Line: 71


END Update_Row;

Line: 74


PROCEDURE Insert_Row
(   p_payment_types_rec	IN OUT NOCOPY  Payment_Types_Rec_Type
)
IS
l_lock_control		NUMBER := 1;

Line: 86


    INSERT  INTO oe_payments
    (       PAYMENT_TRX_ID
    ,       COMMITMENT_APPLIED_AMOUNT
    ,       COMMITMENT_INTERFACED_AMOUNT
/* START PREPAYMENT */
    ,       PAYMENT_SET_ID
    ,       PREPAID_AMOUNT
    ,       PAYMENT_TYPE_CODE
    ,       CREDIT_CARD_CODE
    ,       CREDIT_CARD_NUMBER
    ,       CREDIT_CARD_HOLDER_NAME
    ,       CREDIT_CARD_EXPIRATION_DATE
/* END PREPAYMENT */
    ,       PAYMENT_LEVEL_CODE
    ,       HEADER_ID
    ,       LINE_ID
    ,       CREATION_DATE
    ,       CREATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_LOGIN
    ,       REQUEST_ID
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       CONTEXT
    ,       ATTRIBUTE1
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       PAYMENT_NUMBER
    )
    VALUES
    (       p_payment_types_rec.payment_trx_id
    ,       p_payment_types_rec.commitment_applied_amount
    ,       p_payment_types_rec.commitment_interfaced_amount
/* START PREPAYMENT */
    ,       p_payment_types_rec.payment_set_id
    ,       p_payment_types_rec.prepaid_amount
    ,       p_payment_types_rec.payment_type_code
    ,       p_payment_types_rec.credit_card_code
    ,       p_payment_types_rec.credit_card_number
    ,       p_payment_types_rec.credit_card_holder_name
    ,       p_payment_types_rec.credit_card_expiration_date
/* END PREPAYMENT */
    ,       p_payment_types_rec.payment_level_code
    ,       p_payment_types_rec.header_id
    ,       p_payment_types_rec.line_id
    ,       p_payment_types_rec.creation_date
    ,       p_payment_types_rec.created_by
    ,       p_payment_types_rec.last_update_date
    ,       p_payment_types_rec.last_updated_by
    ,       p_payment_types_rec.last_update_login
    ,       p_payment_types_rec.request_id
    ,       p_payment_types_rec.program_application_id
    ,       p_payment_types_rec.program_id
    ,       p_payment_types_rec.program_update_date
    ,       p_payment_types_rec.context
    ,       p_payment_types_rec.attribute1
    ,       p_payment_types_rec.attribute2
    ,       p_payment_types_rec.attribute3
    ,       p_payment_types_rec.attribute4
    ,       p_payment_types_rec.attribute5
    ,       p_payment_types_rec.attribute6
    ,       p_payment_types_rec.attribute7
    ,       p_payment_types_rec.attribute8
    ,       p_payment_types_rec.attribute9
    ,       p_payment_types_rec.attribute10
    ,       p_payment_types_rec.attribute11
    ,       p_payment_types_rec.attribute12
    ,       p_payment_types_rec.attribute13
    ,       p_payment_types_rec.attribute14
    ,       p_payment_types_rec.attribute15
    ,       p_payment_types_rec.payment_number
    );

Line: 175


        oe_debug_pub.add(  'EXITING OE_PAYMENTS_UTIL.INSERT_ROW.' , 1 ) ;

Line: 185


            ,   'Insert_Row:'||SQLERRM
            );

Line: 189


        FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

Line: 201


            ,   'Insert_Row:'||SQLERRM
            );

Line: 205


        FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

Line: 209


END Insert_Row;

Line: 212


PROCEDURE Delete_Row
(   p_payment_trx_id           IN  NUMBER := FND_API.G_MISS_NUM
,   p_header_id              IN  NUMBER := FND_API.G_MISS_NUM
,   p_line_id              IN  NUMBER := FND_API.G_MISS_NUM
)
IS
l_return_status		VARCHAR2(30);

Line: 230


      DELETE  FROM oe_payments
      WHERE   payment_trx_id = p_payment_trx_id;

Line: 236


      DELETE  FROM oe_payments
      WHERE   line_id = p_line_id
      AND     header_id = p_header_id;

Line: 245


            oe_debug_pub.add(  G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;

Line: 251


            ,   'Delete_Row'
            );

Line: 257


END Delete_Row;

Line: 297


    SELECT  PAYMENT_TRX_ID
,   COMMITMENT_APPLIED_AMOUNT
,   COMMITMENT_INTERFACED_AMOUNT
/* START PREPAYMENT */
,   PAYMENT_SET_ID
,   PREPAID_AMOUNT
,   PAYMENT_TYPE_CODE
,   CREDIT_CARD_CODE
,   CREDIT_CARD_NUMBER
,   CREDIT_CARD_HOLDER_NAME
,   CREDIT_CARD_EXPIRATION_DATE
/* END PREPAYMENT */
,   PAYMENT_LEVEL_CODE
,   HEADER_ID
,   LINE_ID
,   CREATION_DATE
,   CREATED_BY
,   LAST_UPDATE_DATE
,   LAST_UPDATED_BY
,   LAST_UPDATE_LOGIN
,   REQUEST_ID
,   PROGRAM_APPLICATION_ID
,   PROGRAM_ID
,   PROGRAM_UPDATE_DATE
,   CONTEXT
,   ATTRIBUTE1
,   ATTRIBUTE2
,   ATTRIBUTE3
,   ATTRIBUTE4
,   ATTRIBUTE5
,   ATTRIBUTE6
,   ATTRIBUTE7
,   ATTRIBUTE8
,   ATTRIBUTE9
,   ATTRIBUTE10
,   ATTRIBUTE11
,   ATTRIBUTE12
,   ATTRIBUTE13
,   ATTRIBUTE14
,   ATTRIBUTE15
,   PAYMENT_AMOUNT
    FROM   oe_payments
    WHERE  PAYMENT_TRX_ID = p_payment_trx_id
    AND    nvl(PAYMENT_TYPE_CODE, 'COMMITMENT') = 'COMMITMENT'
    AND    line_id = p_line_id
    AND	   HEADER_ID = p_header_id
  UNION
    SELECT  PAYMENT_TRX_ID
,   COMMITMENT_APPLIED_AMOUNT
,   COMMITMENT_INTERFACED_AMOUNT
/* START PREPAYMENT */
,   PAYMENT_SET_ID
,   PREPAID_AMOUNT
,   PAYMENT_TYPE_CODE
,   CREDIT_CARD_CODE
,   CREDIT_CARD_NUMBER
,   CREDIT_CARD_HOLDER_NAME
,   CREDIT_CARD_EXPIRATION_DATE
/* END PREPAYMENT */
,   PAYMENT_LEVEL_CODE
,   HEADER_ID
,   LINE_ID
,   CREATION_DATE
,   CREATED_BY
,   LAST_UPDATE_DATE
,   LAST_UPDATED_BY
,   LAST_UPDATE_LOGIN
,   REQUEST_ID
,   PROGRAM_APPLICATION_ID
,   PROGRAM_ID
,   PROGRAM_UPDATE_DATE
,   CONTEXT
,   ATTRIBUTE1
,   ATTRIBUTE2
,   ATTRIBUTE3
,   ATTRIBUTE4
,   ATTRIBUTE5
,   ATTRIBUTE6
,   ATTRIBUTE7
,   ATTRIBUTE8
,   ATTRIBUTE9
,   ATTRIBUTE10
,   ATTRIBUTE11
,   ATTRIBUTE12
,   ATTRIBUTE13
,   ATTRIBUTE14
,   ATTRIBUTE15
,   PAYMENT_AMOUNT
    FROM  oe_payments
    WHERE line_id = p_line_id
    AND   nvl(PAYMENT_TYPE_CODE, 'COMMITMENT') = 'COMMITMENT'
    AND   header_id = p_header_id
    ;

Line: 443


        x_payment_types_tbl(l_count).last_update_date := l_implicit_rec.LAST_UPDATE_DATE;

Line: 444


        x_payment_types_tbl(l_count).last_updated_by := l_implicit_rec.LAST_UPDATED_BY;

Line: 445


        x_payment_types_tbl(l_count).last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;

Line: 449


        x_payment_types_tbl(l_count).program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;

Line: 537


          SELECT
          SUM(nvl(commitment_applied_amount, 0)
            - nvl(commitment_interfaced_amount,0))
          INTO   l_uninv_commitment_bal
          FROM   oe_payments opt
          WHERE  opt.payment_trx_id  = p_customer_trx_id;

Line: 549


           SELECT
           NVL( SUM( ( NVL( ordered_quantity, 0 ) -
		       --bug3604062
--                       NVL( cancelled_quantity, 0 ) -
                       NVL( invoiced_quantity, 0 )
                     ) *
                       NVL( unit_selling_price, 0 )
                     ), 0 )
           INTO  l_uninv_commitment_bal
           FROM  oe_order_lines_all
           WHERE commitment_id    = p_customer_trx_id
           AND   NVL(line_category_code,'STANDARD') <> 'RETURN'
	   AND   NVL(invoice_interface_status_code,'NO') <> 'YES';

Line: 571


        SELECT
          NVL( SUM( ( NVL( ordered_quantity, 0 ) -
                      NVL( cancelled_quantity, 0 ) -
                      NVL( invoiced_quantity, 0 )
                    ) *
                      NVL( selling_price, 0 )
                   ), 0 )
          INTO   l_uninv_commitment_bal
          FROM   so_lines
          WHERE  commitment_id    = p_customer_trx_id
          AND    line_type_code  IN ( 'REGULAR', 'DETAIL');