DBA Data[Home] [Help]

APPS.OE_CNCL_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: 223

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

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

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

    IF p_last_updated_by IS NULL OR
        p_last_updated_by = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 280

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

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

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

            ,   'Last_Updated_By'
            );
Line: 306

END Last_Updated_By;
Line: 308

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

    IF p_last_update_date IS NULL OR
        p_last_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 337

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

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

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

            ,   'Last_Update_Date'
            );
Line: 363

END Last_Update_Date;
Line: 365

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

    IF p_last_update_login IS NULL OR
        p_last_update_login = FND_API.G_MISS_NUM
    THEN

        RETURN TRUE;
Line: 394

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

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

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

            ,   'Last_Update_Login'
            );
Line: 420

END Last_Update_Login;
Line: 451

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

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

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

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

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

    IF p_program_update_date IS NULL OR
        p_program_update_date = FND_API.G_MISS_DATE
    THEN

        RETURN TRUE;
Line: 565

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

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

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

            ,   'Program_Update_Date'
            );
Line: 591

END Program_Update_Date;
Line: 622

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT  'VALID'
    INTO     l_dummy
    FROM     qp_list_lines
    WHERE    list_line_no = p_List_Line_NO
    AND      ROWNUM=1;
Line: 1801

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    IF p_Updated_Flag IS NULL OR
        p_Updated_Flag = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 2853

    IF p_updated_flag NOT IN ('Y','N') THEN
		RAISE NO_DATA_FOUND;
Line: 2872

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

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

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

            ,   'Updated_Flag'
            );
Line: 2898

END Updated_Flag;
Line: 2901

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

    IF p_Update_Allowed IS NULL OR
        p_Update_Allowed = FND_API.G_MISS_CHAR
    THEN

        RETURN TRUE;
Line: 2930

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

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

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

            ,   'Update_Allowed'
            );
Line: 2956

END Update_Allowed;
Line: 2988

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

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

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

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

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

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

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

	      OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);