DBA Data[Home] [Help]

APPS.OE_INBOUND_INT SQL Statements

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

Line: 52

      SELECT list_header_id
      INTO   l_list_header_id
      FROM   qp_list_lines
      WHERE  list_line_id = l_list_line_id;
Line: 133

              p_x_line_adj_tbl(l_adj_cnt).updated_flag := 'Y'; -- Set to 'Y' to indicate that the value is updated (overridden) by caller
Line: 297

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 298

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 299

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 317

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 531

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 532

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 533

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 551

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 1045

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 1046

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 1047

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 1053

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 1067

		aSqlItem.UPDATED_FLAG := aPlsqlItem.UPDATED_FLAG;
Line: 1068

		aSqlItem.UPDATE_ALLOWED := aPlsqlItem.UPDATE_ALLOWED;
Line: 1158

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 1159

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 1160

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 1166

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 1180

		aPlsqlItem.UPDATED_FLAG := aSqlItem.UPDATED_FLAG;
Line: 1181

		aPlsqlItem.UPDATE_ALLOWED := aSqlItem.UPDATE_ALLOWED;
Line: 1339

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 1340

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 1341

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 1344

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 1483

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 1484

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 1485

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 1488

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 1660

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 1661

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 1662

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 1665

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 1689

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 1690

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 1691

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 1694

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 1749

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 1750

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 1751

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 1754

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 1776

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 1777

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 1778

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 1781

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 1845

		aSqlItem.DW_UPDATE_ADVICE_FLAG := aPlsqlItem.DW_UPDATE_ADVICE_FLAG;
Line: 1847

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 1848

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 1849

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 1855

		aSqlItem.WH_UPDATE_DATE := aPlsqlItem.WH_UPDATE_DATE;
Line: 1866

		aSqlItem.SALES_GROUP_UPDATED_FLAG := aPlsqlItem.SALES_GROUP_UPDATED_FLAG;
Line: 1892

		aPlsqlItem.DW_UPDATE_ADVICE_FLAG := aSqlItem.DW_UPDATE_ADVICE_FLAG;
Line: 1894

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 1895

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 1896

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 1902

		aPlsqlItem.WH_UPDATE_DATE := aSqlItem.WH_UPDATE_DATE;
Line: 1913

		aPlsqlItem.SALES_GROUP_UPDATED_FLAG := aSqlItem.SALES_GROUP_UPDATED_FLAG;
Line: 2033

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 2034

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 2035

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 2047

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 2094

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 2095

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 2096

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 2108

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 2252

		aSqlItem.AUTO_SELECTED_QUANTITY := aPlsqlItem.AUTO_SELECTED_QUANTITY;
Line: 2369

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 2370

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 2371

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 2416

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 2671

		aPlsqlItem.AUTO_SELECTED_QUANTITY := aSqlItem.AUTO_SELECTED_QUANTITY;
Line: 2788

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 2789

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 2790

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 2835

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 3497

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 3498

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 3499

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 3505

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 3520

		aSqlItem.UPDATED_FLAG := aPlsqlItem.UPDATED_FLAG;
Line: 3521

		aSqlItem.UPDATE_ALLOWED := aPlsqlItem.UPDATE_ALLOWED;
Line: 3613

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 3614

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 3615

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 3621

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 3636

		aPlsqlItem.UPDATED_FLAG := aSqlItem.UPDATED_FLAG;
Line: 3637

		aPlsqlItem.UPDATE_ALLOWED := aSqlItem.UPDATE_ALLOWED;
Line: 3804

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 3805

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 3806

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 3809

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 3949

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 3950

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 3951

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 3954

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 4126

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 4127

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 4128

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 4131

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 4155

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 4156

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 4157

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 4160

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 4215

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 4216

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 4217

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 4220

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 4242

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 4243

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 4244

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 4247

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 4310

		aSqlItem.DW_UPDATE_ADVICE_FLAG := aPlsqlItem.DW_UPDATE_ADVICE_FLAG;
Line: 4312

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 4313

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 4314

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 4320

		aSqlItem.WH_UPDATE_DATE := aPlsqlItem.WH_UPDATE_DATE;
Line: 4332

		aSqlItem.SALES_GROUP_UPDATED_FLAG := aPlsqlItem.SALES_GROUP_UPDATED_FLAG;
Line: 4357

		aPlsqlItem.DW_UPDATE_ADVICE_FLAG := aSqlItem.DW_UPDATE_ADVICE_FLAG;
Line: 4359

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 4360

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 4361

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 4367

		aPlsqlItem.WH_UPDATE_DATE := aSqlItem.WH_UPDATE_DATE;
Line: 4379

		aPlsqlItem.SALES_GROUP_UPDATED_FLAG := aSqlItem.SALES_GROUP_UPDATED_FLAG;
Line: 4494

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 4495

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 4496

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 4508

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
Line: 4555

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 4556

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 4557

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 4569

		aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
Line: 4691

		aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
Line: 4692

		aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
Line: 4693

		aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
Line: 4735

		aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
Line: 4736

		aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
Line: 4737

		aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
Line: 5168

        IF p_line_tbl(i).operation IN (oe_globals.g_opr_update) AND
             Oe_Genesis_Util.G_INCOMING_FROM_DOO = FALSE -- Bug 13789481
        THEN
          -- For update operation, ignore the config/option/class items lines.
          -- Whether a line is the top model line or not, is indicated by
          -- the top_model_line_ref being the same as orig_sys_line_ref in
          -- incoming AIA payload.  This holds good even for nested models
          -- as well.
          IF p_line_tbl(i).top_model_line_ref =
                p_line_tbl(i).orig_sys_line_ref  THEN
             -- This is the top model line.
             l_line_reco     :=  p_line_tbl(i);
Line: 5296

          SELECT
                Decode(l_action_request_tbl(i).entity_code, NULL, 'LINE',
                       Fnd_Api.G_Miss_Char, 'LINE',
                       l_action_request_tbl(i).entity_code)
            INTO l_action_request_tbl(i).entity_code
          FROM DUAL;
Line: 5521

    IF ( p_header_rec.operation = oe_globals.G_OPR_UPDATE ) AND
       ( p_header_rec.header_id IS NOT NULL )               AND
       ( Nvl(x_header_rec.flow_status_code, 'NULL') = 'NULL' )
    THEN
      DECLARE
      l_hdr_fstat   oe_order_headers_all.flow_status_code%TYPE;
Line: 5528

        SELECT  h.flow_status_code
            INTO  l_hdr_fstat
        FROM    oe_order_headers_all h
        WHERE   h.header_id = p_header_rec.header_id;
Line: 5553

        SELECT  line_id
          FROM    oe_order_lines_all
          WHERE   top_model_line_id = p_top_model_line_id
          AND     line_id <> p_top_model_line_id
          AND     flow_status_code <> 'CANCELLED'
        ;
Line: 5570

        SELECT  flow_status_code, item_type_code, config_rev_nbr
            INTO  l_flow_stat, l_item_type, l_config_rev_nbr
        FROM    oe_order_lines_all l
        WHERE   l.line_id = x_line_tbl(idx).line_id;
Line: 5670

                  repr_line_rec.operation             :=  'UPDATE';
Line: 5677

                  oe_debug_pub.ADD(' Initializing the control record for UPDATE...');
Line: 5701

                    SELECT  OE_XML_MESSAGE_SEQ_S.NEXTVAL INTO l_sso_seq FROM dual;
Line: 5705

                    oe_debug_pub.ADD(' Calling Insert_Sync_Line...');
Line: 5706

                      OE_SYNC_ORDER_PVT.INSERT_SYNC_lINE(
                                  P_LINE_rec   => repr_line_tbl(1),
                                    p_change_type   => 'PRICE_CHG',
                                    p_req_id        => l_sso_seq,
                                      X_RETURN_STATUS => l_stat);
Line: 5939

        SELECT bom.bill_sequence_id, bom.organization_id
        FROM   bom_bill_of_materials bom
        WHERE  bom.ASSEMBLY_ITEM_ID = p_inv_item_id
        AND    bom.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID')
        AND    bom.ALTERNATE_BOM_DESIGNATOR IS NULL;