APPS.QP_VALIDATE SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;

Line: 47

    FND_API.g_attr_tbl(I).name     := 'last_updated_by';

Line: 49

    FND_API.g_attr_tbl(I).name     := 'last_update_date';

Line: 51

    FND_API.g_attr_tbl(I).name     := 'last_update_login';

Line: 61

    FND_API.g_attr_tbl(I).name     := 'program_update_date';

Line: 980

     select currency_code
     into l_dummy
     from fnd_currencies_vl
     where enabled_flag = 'Y'
     and currency_flag='Y'
     and currency_code = p_currency_code;

Line: 1129

    SELECT FREIGHT_TERMS_CODE
    INTO l_dummy
    FROM OE_FRGHT_TERMS_ACTIVE_V
    WHERE FREIGHT_TERMS_CODE = p_freight_terms_code
    AND ROWNUM < 2;

Line: 1214

FUNCTION Last_Updated_By ( p_last_updated_by IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1220

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 1241

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by');

Line: 1254

            ,   'Last_Updated_By'
            );

Line: 1260

END Last_Updated_By;

Line: 1262

FUNCTION Last_Update_Date ( p_last_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1268

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 1289

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_date');

Line: 1302

            ,   'Last_Update_Date'
            );

Line: 1308

END Last_Update_Date;

Line: 1310

FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1316

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN
        RETURN TRUE;

Line: 1337

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_update_login');

Line: 1350

            ,   'Last_Update_Login'
            );

Line: 1356

END Last_Update_Login;

Line: 1420

    SELECT LOOKUP_CODE
    INTO l_dummy
    FROM QP_LOOKUPS
    WHERE LOOKUP_TYPE = 'LIST_TYPE_CODE'
    AND LOOKUP_CODE = p_list_type_code
    AND ROWNUM < 2;

Line: 1554

FUNCTION Program_Update_Date ( p_program_update_date IN DATE )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 1560

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN
        RETURN TRUE;

Line: 1581

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','program_update_date');

Line: 1594

            ,   'Program_Update_Date'
            );

Line: 1600

END Program_Update_Date;

Line: 1721

    SELECT -1*PRECISION,
           -1*EXTENDED_PRECISION
    INTO   l_precision,
           l_extended_precision
    FROM   FND_CURRENCIES
   WHERE   CURRENCY_CODE = P_CURRENCY_CODE;

Line: 1743

                     FND_MESSAGE.SET_NAME('QP', 'QP_ROUNDING_FACTOR_NO_UPDATE');

Line: 1762

                     FND_MESSAGE.SET_NAME('QP', 'QP_ROUNDING_FACTOR_NO_UPDATE');

Line: 1832

    SELECT LOOKUP_CODE
    INTO l_dummy
    FROM OE_SHIP_METHODS_V
    WHERE LOOKUP_TYPE = 'SHIP_METHOD'
    AND LOOKUP_CODE = p_ship_method_code
    AND ROWNUM < 2;

Line: 1933

    SELECT TERM_ID
    INTO l_term_id
    FROM RA_TERMS
    WHERE TERM_ID = p_terms_id
    AND ROWNUM < 2;

Line: 5625

    SELECT  lookup_code
    INTO    l_dummy
    FROM    QP_LOOKUPS
    WHERE   lookup_type = 'COMPARISON_OPERATOR'
    AND     lookup_code = p_comparison_operator_code;

Line: 5674

        SELECT  'VALID'
        INTO     l_dummy
        FROM     QP_QUALIFIER_RULES
        WHERE    qualifier_rule_id  = p_created_from_rule_id;

Line: 6638

	select pte_code, source_system_code into l_pte_code, l_ss_code from qp_list_headers_all_b
	where list_header_id = p_list_header_id;

Line: 6641

	for cl in (select distinct /*+ ORDERED  c.CATEGORY_SET_ID from qp_pte_source_systems B,
           	QP_SOURCESYSTEM_FNAREA_MAP A, mtl_default_category_sets c
           	where B.PTE_CODE = l_pte_code and
           	B.APPLICATION_SHORT_NAME = l_ss_code and
           	A.PTE_SOURCE_SYSTEM_ID = B.PTE_SOURCE_SYSTEM_ID and
      	c.FUNCTIONAL_AREA_ID = a.FUNCTIONAL_AREA_ID and
           	A.ENABLED_FLAG = 'Y' and B.ENABLED_FLAG = 'Y')
	loop
		oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>inside loop cl.category_set_id: '||cl.category_set_id);

Line: 6650

  		select count(*) into l_temp
  		from MTL_CATEGORY_SET_VALID_CATS cats,
  		MTL_CATEGORY_SETS_B d
  		where cats.category_id = p_category_id
  		and cats.category_set_id = cl.category_set_id
  		and d.category_set_id = cl.category_set_id
  		and d.HIERARCHY_ENABLED = 'Y'
  		and rownum = 1;

Line: 6671

  select count(*) into l_valid_uom
  from mtl_item_uoms_view
  where organization_id = l_org_id
  and inventory_item_id in ( select inventory_item_id
                            from mtl_item_categories cat
                            where organization_id = l_org_id and
                            category_id = p_category_id

                            UNION --note this select below will not be executed if basic pricing
                             --or if any of  the category_set_ids is not hierarchy enabled
                            select inventory_item_id
                            from mtl_item_categories cat
                            where organization_id = l_org_id
                            and l_temp > 0
                            and category_id in ( select child_id
                            FROM   eni_denorm_hierarchies
                            WHERE  parent_id = p_category_id)
                            )
  and uom_code =  p_product_uom_code --uom_code being validated
  and rownum = 1;

Line: 12190

    SELECT   COUNT(*) INTO V_COUNT
     FROM   QP_LIST_HEADERS_TL
     WHERE  ( p_list_header_id IS NULL
                    OR LIST_HEADER_ID <> p_list_header_id )
     AND    NAME = p_name
     AND    LANGUAGE = userenv('LANG')
     AND    nvl(VERSION_NO, '-1') = nvl(p_version_no, '-1');

Line: 12283

    SELECT  lookup_code
    INTO    l_dummy
    FROM    QP_LOOKUPS
    WHERE   lookup_type = 'QP_LIMIT_BASIS'
    AND     lookup_code = p_basis;

Line: 12333

    SELECT  lookup_code
    INTO    l_dummy
    FROM    QP_LOOKUPS
    WHERE   lookup_type = 'LIMIT_EXCEED_ACTION'
    AND     lookup_code = p_limit_exceed_action_code;

Line: 12485

    SELECT  lookup_code
    INTO    l_dummy
    FROM    QP_LOOKUPS
    WHERE   lookup_type = 'LIMIT_LEVEL'
    AND     lookup_code = p_limit_level_code;

Line: 13112

    SELECT  lookup_code
    INTO    l_dummy
    FROM    QP_LOOKUPS
    WHERE   lookup_type = 'LIMIT_ATTRIBUTE_TYPE'
    AND     lookup_code = p_limit_attribute_type;