DBA Data[Home] [Help]

APPS.OE_INBOUND_INT SQL Statements

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

Line: 96

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

		aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
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: 1908

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        IF p_x_line_rec.auto_selected_quantity IS NULL THEN
            p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
Line: 6030

        IF p_x_line_rec.last_updated_by IS NULL THEN
            p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
Line: 6034

        IF p_x_line_rec.last_update_date IS NULL THEN
            p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
Line: 6038

        IF p_x_line_rec.last_update_login IS NULL THEN
            p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
Line: 6218

        IF p_x_line_rec.program_update_date IS NULL THEN
            p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
Line: 7029

        IF p_x_header_rec.last_updated_by IS NULL THEN
            p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
Line: 7033

        IF p_x_header_rec.last_update_date IS NULL THEN
            p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
Line: 7037

        IF p_x_header_rec.last_update_login IS NULL THEN
            p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
Line: 7113

        IF p_x_header_rec.program_update_date IS NULL THEN
            p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;