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.QP_VALIDATE_CURR_DETAILS SQL Statements

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

Line: 50


SELECT
trunc(start_date_active) start_date_active,
trunc(end_date_active) end_date_active
FROM QP_CURRENCY_DETAILS
WHERE to_currency_code = in_to_currency_code_s and
      currency_header_id = in_currency_header_id_n and
      currency_detail_id <> nvl(in_currency_detail_id_n, -99999) and
      nvl(curr_attribute_type, '~EQUAL~') = nvl(in_curr_attribute_type, '~EQUAL~') and
      nvl(curr_attribute_context, '~EQUAL~') = nvl(in_curr_attribute_context, '~EQUAL~') and
      nvl(curr_attribute, '~EQUAL~') = nvl(in_curr_attribute, '~EQUAL~') and
      nvl(curr_attribute_value, '~EQUAL~') = nvl(in_curr_attribute_value, '~EQUAL~');

Line: 69


SELECT
trunc(start_date_active) start_date_active,
trunc(end_date_active) end_date_active
FROM QP_CURRENCY_DETAILS
WHERE to_currency_code = in_to_currency_code_s and
      currency_header_id = in_currency_header_id_n and
      currency_detail_id <> nvl(in_currency_detail_id_n, -99999) and
      nvl(precedence, -1) = in_precedence;

Line: 173


        SELECT 'X'
        INTO   l_dummy_c
        FROM   fnd_currencies_vl
        WHERE  enabled_flag = 'Y'
        and    currency_flag = 'Y'
        and    currency_code = p_CURR_DETAILS_rec.to_currency_code
        and    trunc(sysdate) between nvl(start_date_active,trunc(sysdate))
        and    nvl(end_date_active,trunc(sysdate));

Line: 198


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl fh
          WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
          and nvl(fh.end_date_active, trunc(sysdate))
          and fh.price_formula_id = p_CURR_DETAILS_rec.price_formula_id
          and  not exists (Select 'x'
                           From qp_price_formula_lines fl
                           Where fl.price_formula_id = fh.price_formula_id
                           and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
                           and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
			       and nvl(fl.end_date_active, trunc(sysdate)));

Line: 223


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl fh
          WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
          and nvl(fh.end_date_active, trunc(sysdate))
          and fh.price_formula_id = p_CURR_DETAILS_rec.price_formula_id
          and  not exists (Select 'x'
                           From qp_price_formula_lines fl
                           Where fl.price_formula_id = fh.price_formula_id
                           and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'MV'
                           and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
			       and nvl(fl.end_date_active, trunc(sysdate)));

Line: 280


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl
          WHERE trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
          and nvl(end_date_active, trunc(sysdate))
          and price_formula_id = p_CURR_DETAILS_rec.markup_formula_id;

Line: 290


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_price_formulas_vl fh
          WHERE trunc(sysdate) between nvl(fh.start_date_active, trunc(sysdate))
	  and nvl(fh.end_date_active, trunc(sysdate))
          and fh.price_formula_id = p_CURR_DETAILS_rec.markup_formula_id
          and  not exists (Select 'x'
                           From qp_price_formula_lines fl
                           Where fl.price_formula_id = fh.price_formula_id
                           and fl.PRICE_FORMULA_LINE_TYPE_CODE = 'PLL'
                           and trunc(sysdate) between nvl(fl.start_date_active, trunc(sysdate))
			       and nvl(fl.end_date_active, trunc(sysdate)));

Line: 319


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_lookups
          WHERE lookup_type = 'CONVERSION_METHOD'
          and lookup_code = p_CURR_DETAILS_rec.conversion_method;

Line: 341


          SELECT 'X'
          INTO l_dummy_c
          FROM gl_daily_conversion_types
          WHERE conversion_type = p_CURR_DETAILS_rec.conversion_type and
		conversion_type <> 'User';

Line: 351


             SELECT 'X'
             INTO l_dummy_c
             FROM qp_lookups
             WHERE lookup_type = 'CONVERSION_METHOD'
             and lookup_code = p_CURR_DETAILS_rec.conversion_type
	     and enabled_flag = 'Y' and
	     trunc(sysdate) between
	     nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));

Line: 378


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_lookups
          WHERE lookup_type = 'CONVERSION_DATE_TYPE'
          and lookup_code = p_CURR_DETAILS_rec.conversion_date_type
	  and enabled_flag = 'Y' and
	  trunc(sysdate) between
	  nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));

Line: 403


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_lookups
          WHERE lookup_type = 'MARKUP_OPERATOR'
          and lookup_code = p_CURR_DETAILS_rec.markup_operator
	  and enabled_flag = 'Y' and
	  trunc(sysdate) between
	  nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));

Line: 453


           SELECT base_currency_code
	   INTO l_base_currency_code_s
	   FROM QP_CURRENCY_LISTS_B
	   WHERE currency_header_id = p_CURR_DETAILS_rec.currency_header_id;

Line: 604


          SELECT 'X'
          INTO l_dummy_c
          FROM qp_lookups
          WHERE lookup_type = 'MULTI_CURR_ATTRIBUTE_TYPE'
          and lookup_code = p_CURR_DETAILS_rec.curr_attribute_type
	  and enabled_flag = 'Y' and
	  trunc(sysdate) between
	  nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate));

Line: 730


     	          SELECT 'X'
                  INTO l_dummy_c
	          FROM mtl_system_items_kfv
                  WHERE  inventory_item_id = to_number(p_CURR_DETAILS_rec.curr_attribute_value) and
                         organization_id = l_org_id;

Line: 753


     	          SELECT 'X'
                  INTO l_dummy_c
                  FROM qp_item_categories_v
                  WHERE  category_id = to_number(p_CURR_DETAILS_rec.curr_attribute_value) and
                         ROWNUM = 1;

Line: 1140


    IF  p_CURR_DETAILS_rec.last_updated_by IS NOT NULL AND
        (   p_CURR_DETAILS_rec.last_updated_by <>
            p_old_CURR_DETAILS_rec.last_updated_by OR
            p_old_CURR_DETAILS_rec.last_updated_by IS NULL )
    THEN
        IF NOT QP_Validate.Last_Updated_By(p_CURR_DETAILS_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1150


    IF  p_CURR_DETAILS_rec.last_update_date IS NOT NULL AND
        (   p_CURR_DETAILS_rec.last_update_date <>
            p_old_CURR_DETAILS_rec.last_update_date OR
            p_old_CURR_DETAILS_rec.last_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Date(p_CURR_DETAILS_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1160


    IF  p_CURR_DETAILS_rec.last_update_login IS NOT NULL AND
        (   p_CURR_DETAILS_rec.last_update_login <>
            p_old_CURR_DETAILS_rec.last_update_login OR
            p_old_CURR_DETAILS_rec.last_update_login IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Login(p_CURR_DETAILS_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1230


    IF  p_CURR_DETAILS_rec.program_update_date IS NOT NULL AND
        (   p_CURR_DETAILS_rec.program_update_date <>
            p_old_CURR_DETAILS_rec.program_update_date OR
            p_old_CURR_DETAILS_rec.program_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Program_Update_Date(p_CURR_DETAILS_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1511


PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_CURR_DETAILS_rec              IN  QP_Currency_PUB.Curr_Details_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1545


            ,   'Entity_Delete'
            );

Line: 1549


END Entity_Delete;