APPS.OE_COMMITMENT_PVT SQL Statements

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

Line: 31

 select TRX_NUMBER
   FROM   RA_CUSTOMER_TRX
  WHERE  CUSTOMER_TRX_ID = p_commitment_id;

Line: 90

    SELECT nvl(transactional_curr_code,'USD')
    INTO   l_currency_code from oe_order_headers
    WHERE  header_id=p_header_id;

Line: 166

v_SelectStmt		VARCHAR2(500);

Line: 182

    v_SelectStmt :=
	'SELECT allocate_tax_freight
           INTO :allocate_fax_freight
      	   FROM  ra_cust_trx_types_all rctt
                 ,ra_customer_trx_all rcta
    	   WHERE rctt.cust_trx_type_id = rcta.cust_trx_type_id
    	   AND   rcta.customer_trx_id = :commitment_id';

Line: 190

    DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);

Line: 218

    SELECT NVL(allocate_tax_freight, 'N')
    INTO   l_allocate_tax_freight
    FROM   ra_cust_trx_types_all rctt
          ,ra_customer_trx_all rcta
    WHERE  rctt.cust_trx_type_id = rcta.cust_trx_type_id
    AND    rcta.customer_trx_id = p_line_rec.commitment_id;

Line: 349

    SELECT 	l.header_id
	        ,l.ordered_quantity
		,l.commitment_id
		,nvl(l.unit_selling_price, 0)
		,nvl(l.tax_value,0)
                -- QUOTING change
                ,l.transaction_phase_code
                ,l.split_by
    INTO   	l_header_id
		,l_ordered_quantity
		,l_new_commitment_id
		,l_unit_selling_price
		,l_tax_value
                -- QUOTING change
                ,l_transaction_phase_code
                ,l_split_by
    FROM   	oe_order_lines_all l
    WHERE  	l.line_id = l_line_id;

Line: 392

      SELECT nvl(transactional_curr_code,'USD')
      INTO   l_currency_code from oe_order_headers
      WHERE  header_id=l_header_id;

Line: 522

        oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);

Line: 526

          oe_payments_Util.Delete_Row(p_line_id => l_line_id, p_header_id => l_header_id);

Line: 535

              UPDATE oe_payments
              SET    payment_trx_id = l_new_commitment_id,
                     commitment_applied_amount = l_commitment_applied_amount,
                     payment_number = nvl(payment_number, 1)
              WHERE  line_id = l_line_id
              AND    header_id = l_header_id
              AND    nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 544

              UPDATE oe_payments
              SET    payment_trx_id = l_new_commitment_id,
                     commitment_applied_amount = l_commitment_applied_amount
              WHERE  line_id = l_line_id
              AND    header_id = l_header_id
              AND    nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 556

            /*** Fix Bug # 2511389: Call to delete_row added above should take care of this scenario also
            IF l_commitment_bal >0 OR (l_commitment_bal <= 0 AND l_commitment_applied_amount < l_payment_types_tbl(1).commitment_applied_amount) THEN
                 IF l_ordered_quantity = 0 THEN
                   Oe_Payments_Util.Delete_Row(p_line_id => p_line_id);

Line: 569

	        UPDATE oe_payments
	        SET    commitment_applied_amount = l_commitment_applied_amount,
                       payment_number = nvl(payment_number, 1)
	        WHERE  line_id = l_line_id
                AND    header_id = l_header_id
                AND    payment_trx_id = l_new_commitment_id     /* Added this condition for Bug #3536642 */
                AND    nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 578

	        UPDATE oe_payments
	        SET    commitment_applied_amount = l_commitment_applied_amount
	        WHERE  line_id = l_line_id
                AND    header_id = l_header_id
                AND    payment_trx_id = l_new_commitment_id    /* Added this condition for Bug #3536642 */
                AND    nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 605

      l_payment_types_rec.last_update_date := SYSDATE;

Line: 606

      l_payment_types_rec.last_updated_by := FND_GLOBAL.USER_ID;

Line: 613

         select (nvl(max(payment_number),0) + 1)
         into l_payment_types_rec.payment_number
         from oe_payments
         where header_id = l_header_id
         and line_id = l_line_id;

Line: 627

          oe_debug_pub.add(  'BEFORE CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;

Line: 630

      OE_Payments_Util.INSERT_ROW(p_payment_types_rec => l_payment_types_rec);

Line: 633

          oe_debug_pub.add(  'AFTER CALLING OE_PAYMENTS_UTIL.INSERT_ROW' ) ;

Line: 642

     oe_debug_pub.add('Check if a request for update commitment applied has been logged or not');

Line: 649

                                            OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
                                           );

Line: 687

  SELECT
    payment_type_code
  , NVL(payment_amount, 0)
  INTO
    l_payment_type_code
  , l_payment_amount
  FROM  oe_order_headers_all
  WHERE header_id = l_header_id;

Line: 751

    SELECT NVL(commitment_applied_amount, 0)
    INTO  l_commitment_applied_amount
    FROM  oe_payments
    WHERE line_id = p_line_id
    AND  header_id = p_header_id
    AND  payment_trx_id = p_commitment_id;

Line: 778

PROCEDURE update_commitment(
 p_line_id		IN 	NUMBER
,x_return_status OUT NOCOPY VARCHAR2

)
IS
l_split_by		VARCHAR2(30);

Line: 805

SELECT line_id,commitment_id,header_id,
       ordered_quantity,unit_selling_price,tax_value
FROM   oe_order_lines_all
WHERE  header_id = l_header_id
AND split_from_line_id = p_line_id;

Line: 817

      oe_debug_pub.add(  'ENTERING UPDATE_COMMITMENT FOR LINE_ID '||P_LINE_ID , 1 ) ;

Line: 821

    SELECT 	l.header_id
		,l.commitment_id
                ,l.split_by
                ,l.split_from_line_id
                -- QUOTING change
                ,l.transaction_phase_code
    INTO   	l_header_id
		,l_new_commitment_id
               ,l_split_by
               ,l_split_from_line_id
                -- QUOTING change
               ,l_transaction_phase_code
    FROM   oe_order_lines l
    WHERE  l.line_id = p_line_id;

Line: 851

    SELECT commitment_applied_amount
    INTO   l_commitment_applied_amount
    FROM   oe_payments oop
    WHERE  nvl(payment_type_code,'COMMITMENT') = 'COMMITMENT'
    AND    line_id=p_line_id
    AND    header_id = l_header_id;

Line: 902

       update oe_payments
       set commitment_applied_amount = 0
       WHERE line_id = l_children_line_id
       AND   header_id = l_header_id
       AND   nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 909

      update oe_payments
      set commitment_applied_amount = l_children_commitment
      where line_id = l_children_line_id
      and   header_id = l_header_id
      and   nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 918

      update oe_payments
      set commitment_applied_amount = nvl(oe_globals.g_commitment_balance, 0)
      where line_id = l_children_line_id
      and   header_id =l_header_id
      and   nvl(payment_type_code, 'COMMITMENT') = 'COMMITMENT';

Line: 931

      oe_debug_pub.add(  'Exiting UPDATE_COMMITMENT. ', 1 ) ;

Line: 934

END update_commitment;

Line: 962

        'SELECT ALLOCATE_TAX_FREIGHT
         FROM   RA_CUST_TRX_TYPES_ALL
         WHERE  ROWNUM = 1';

Line: 979

         'SELECT PROMISED_COMMITMENT_AMOUNT
          FROM   RA_INTERFACE_LINES_ALL
          WHERE  ROWNUM = 1';

Line: 1015

procedure update_commitment_applied(
  p_line_id             IN NUMBER
, p_amount              IN NUMBER
, p_header_id           IN NUMBER
, p_commitment_id       IN NUMBER
, x_return_status OUT NOCOPY VARCHAR2

) IS

l_commitment_applied_amount	NUMBER := 0;

Line: 1044

     oe_debug_pub.add('OEXVCMTB: Entering UPDATE_COMMITMENT_APPLIED FOR LINE_ID '||P_LINE_ID, 1 );

Line: 1066

  SELECT nvl(commitment_applied_amount,0)
  INTO   l_commitment_applied_amount
  FROM   oe_payments
  WHERE  header_id = p_header_id
  AND    line_id = p_line_id
  AND    payment_trx_id = p_commitment_id;

Line: 1111

      SELECT nvl(transactional_curr_code,'USD')
      INTO   l_currency_code from oe_order_headers
      WHERE  header_id=p_header_id;

Line: 1137

  UPDATE oe_payments
  SET    commitment_applied_amount = l_amount_to_apply
  WHERE  header_id = p_header_id
  AND    line_id   = p_line_id
  AND    payment_trx_id = p_commitment_id;

Line: 1144

     oe_debug_pub.add('OEXVCMTB: Exiting UPDATE_COMMITMENT_APPLIED. ', 1 );

Line: 1147

END update_commitment_applied;