DBA Data[Home] [Help]

APPS.OE_VALIDATE_ADJ SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;
Line: 35

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

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

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

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

    FND_API.g_attr_tbl(I).name     := 'updated_flag';
Line: 83

    FND_API.g_attr_tbl(I).name     := 'update_allowed';
Line: 200

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DESC_FLEX');
Line: 206

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 256

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'HEADER_ID');
Line: 262

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 284

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

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 313

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATED_BY');
Line: 317

				OE_Order_Util.Get_Attribute_Name('last_updated_by'));
Line: 319

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 332

            ,   'Last_Updated_By'
            );
Line: 339

END Last_Updated_By;
Line: 341

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

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 370

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_DATE');
Line: 374

				OE_Order_Util.Get_Attribute_Name('last_update_date'));
Line: 376

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 389

            ,   'Last_Update_Date'
            );
Line: 396

END Last_Update_Date;
Line: 398

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

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 427

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LAST_UPDATE_LOGIN');
Line: 431

				OE_Order_Util.Get_Attribute_Name('last_update_login'));
Line: 433

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 446

            ,   'Last_Update_Login'
            );
Line: 453

END Last_Update_Login;
Line: 484

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_APPLICATION_ID');
Line: 490

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 541

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_ID');
Line: 547

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 569

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

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 598

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PROGRAM_UPDATE_DATE');
Line: 602

				OE_Order_Util.Get_Attribute_Name('program_update_date'));
Line: 604

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 617

            ,   'Program_Update_Date'
            );
Line: 624

END Program_Update_Date;
Line: 655

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_ID');
Line: 661

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 712

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_ADJUSTMENT_ID');
Line: 718

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 769

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_ID');
Line: 775

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 827

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'DISCOUNT_LINE_ID');
Line: 833

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 884

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'AUTOMATIC_FLAG');
Line: 890

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 953

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PERCENT');
Line: 959

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1010

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LINE_ID');
Line: 1016

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1058

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
Line: 1064

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1079

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'APPLIED_FLAG');
Line: 1085

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1127

    SELECT  'VALID'
    INTO    l_dummy
    FROM    OE_LOOKUPS
    WHERE   LOOKUP_CODE = p_change_reason_code
    AND     LOOKUP_TYPE = l_lookup_type
    AND     ENABLED_FLAG = 'Y'
    AND     SYSDATE  BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE);
Line: 1145

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
Line: 1151

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1198

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_TEXT');
Line: 1204

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1241

      SELECT  'VALID'
      INTO     l_dummy
      FROM     qp_list_headers_vl
      WHERE    list_header_id = p_List_Header_id;
Line: 1256

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_HEADER_ID');
Line: 1262

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1299

      SELECT  'VALID'
      INTO     l_dummy
      FROM     qp_list_lines
      WHERE    list_line_id = p_List_Line_id;
Line: 1314

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_ID');
Line: 1320

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1371

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'LIST_LINE_TYPE_CODE');
Line: 1377

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1430

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Pricing_Phase_id');
Line: 1436

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1488

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ADJUSTED_AMOUNT');
Line: 1494

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1547

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_FROM');
Line: 1553

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1604

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIED_TO');
Line: 1610

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1662

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'MODIFIER_MECHANISM_TYPE_CODE');
Line: 1668

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1721

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OPERAND');
Line: 1727

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1779

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'ARITHMETIC_OPERATOR');
Line: 1785

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1835

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'List_Line_NO');
Line: 1841

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1890

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Source_System_Code');
Line: 1896

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 1945

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_Qty');
Line: 1951

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2000

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Benefit_UOM_Code');
Line: 2006

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2055

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Print_On_Invoice_Flag');
Line: 2061

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2110

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Expiration_Date');
Line: 2116

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2165

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Type_Code');
Line: 2171

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2220

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Transaction_Reference');
Line: 2226

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2275

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Rebate_Payment_System_Code');
Line: 2281

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2330

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Date');
Line: 2336

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2385

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Redeemed_Flag');
Line: 2391

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2440

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'Accrual_Flag');
Line: 2446

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2495

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'range_break_quantity');
Line: 2501

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2550

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'accrual_conversion_rate');
Line: 2556

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2605

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'pricing_group_sequence');
Line: 2611

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2660

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'modifier_level_code');
Line: 2666

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2715

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'price_break_type_code');
Line: 2721

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2770

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'substitution_attribute');
Line: 2776

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2825

		OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'proration_type_code');
Line: 2831

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2852

FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 2859

    IF p_Updated_Flag IS NULL OR
        p_Updated_Flag = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 2881

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATED_FLAG');
Line: 2885

				OE_Order_Util.Get_Attribute_Name('Updated_Flag'));
Line: 2887

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2900

            ,   'Updated_Flag'
            );
Line: 2907

END Updated_Flag;
Line: 2910

FUNCTION Update_Allowed(p_Update_Allowed IN VARCHAR2)
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);
Line: 2917

    IF p_Update_Allowed IS NULL OR
        p_Update_Allowed = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 2939

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'UPDATE_ALLOWED');
Line: 2943

				OE_Order_Util.Get_Attribute_Name('Update_Allowed'));
Line: 2945

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 2958

            ,   'Update_Allowed'
            );
Line: 2965

END Update_Allowed;
Line: 2997

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATED_BY');
Line: 3003

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3054

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CREATION_DATE');
Line: 3060

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3113

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'OVERRIDE_FLAG');
Line: 3119

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
Line: 3171

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'REQUEST_DATE');
Line: 3177

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);