APPS.OE_VALIDATE_LINE_PAYMENT SQL Statements

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

Line: 136

		  SELECT trxn_extension_id
		  INTO l_hdr_trxn_extn_id
		  FROM oe_payments
		  WHERE header_id=p_Line_Payment_rec.header_id
		  AND line_id IS NULL
		  AND nvl(payment_collection_event, 'PREPAY') = 'INVOICE';

Line: 156

		     SELECT authorization_date
	             INTO l_hdr_auth_date
	             FROM IBY_TRXN_EXT_AUTHS_V
	             WHERE trxn_extension_id = l_hdr_trxn_extn_id
	             AND authorization_status=0
	             AND effective_auth_amount > 0;

Line: 165

			   SELECT creation_date
			   INTO l_lin_creation_date
			   FROM oe_order_lines_all
			   WHERE line_id=p_line_Payment_rec.line_id;

Line: 211

			Select 	invoice_to_org_id
			Into	l_invoice_to_org_id
			From	oe_order_headers_all
			Where	header_id = p_line_payment_rec.header_id;

Line: 266

         SELECT count(payment_type_code)
         INTO l_count
         FROM oe_payments
         WHERE line_id = p_Line_Payment_rec.line_id
         AND   header_id = p_Line_Payment_rec.header_id
         AND   payment_level_code = 'LINE'
         AND   nvl(payment_number, -1) <> nvl(p_Line_Payment_rec.payment_number, -1)
         AND   nvl(payment_collection_event, 'INVOICE') = 'INVOICE'
         and   payment_type_code <> 'COMMITMENT'
         and   p_Line_Payment_rec.payment_type_code <> 'COMMITMENT';

Line: 279

            SELECT count(payment_type_code)
            into l_comt_count
            from oe_payments
            where line_id = p_Line_Payment_rec.line_id
            and header_id = p_Line_Payment_rec.header_id
            and payment_level_code = 'LINE'
            and nvl(payment_number, -1) <> nvl(p_Line_Payment_rec.payment_number, -1)
            and payment_type_code = 'COMMITMENT';

Line: 301

        select count(payment_type_code) into l_prepay_count
        from oe_payments
        where (payment_collection_event = 'PREPAY'
        or prepaid_amount is not null )
        and header_id = p_Line_Payment_rec.header_id;

Line: 307

        select payment_term_id into l_term_id
        from oe_order_headers_all
        where header_id = p_Line_Payment_rec.header_id;

Line: 457

    IF  p_Line_Payment_rec.last_updated_by IS NOT NULL AND
        (   p_Line_Payment_rec.last_updated_by <>
            p_old_Line_Payment_rec.last_updated_by OR
            p_old_Line_Payment_rec.last_updated_by IS NULL )
    THEN
        IF NOT OE_Validate.Last_Updated_By(p_Line_Payment_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 467

    IF  p_Line_Payment_rec.last_update_date IS NOT NULL AND
        (   p_Line_Payment_rec.last_update_date <>
            p_old_Line_Payment_rec.last_update_date OR
            p_old_Line_Payment_rec.last_update_date IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Date(p_Line_Payment_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 477

    IF  p_Line_Payment_rec.last_update_login IS NOT NULL AND
        (   p_Line_Payment_rec.last_update_login <>
            p_old_Line_Payment_rec.last_update_login OR
            p_old_Line_Payment_rec.last_update_login IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Login(p_Line_Payment_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 826

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY VARCHAR2
,   p_Line_Payment_rec            IN  OE_Order_PUB.Line_Payment_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 834

    OE_DEBUG_PUB.Add('Entering OE_VALIDATE_Line_Payments.Entity_Delete',1);

Line: 840

    OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_Line_Payments.Entity_Delete',1);

Line: 860

            ,   'Entity_Delete'
            );

Line: 864

END Entity_Delete;