The following lines contain the word 'select', 'insert', 'update' or 'delete':
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.UPDATED_FLAG := aPlsqlItem.UPDATED_FLAG;
aSqlItem.UPDATE_ALLOWED := aPlsqlItem.UPDATE_ALLOWED;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.UPDATED_FLAG := aSqlItem.UPDATED_FLAG;
aPlsqlItem.UPDATE_ALLOWED := aSqlItem.UPDATE_ALLOWED;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.DW_UPDATE_ADVICE_FLAG := aPlsqlItem.DW_UPDATE_ADVICE_FLAG;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.WH_UPDATE_DATE := aPlsqlItem.WH_UPDATE_DATE;
aSqlItem.SALES_GROUP_UPDATED_FLAG := aPlsqlItem.SALES_GROUP_UPDATED_FLAG;
aPlsqlItem.DW_UPDATE_ADVICE_FLAG := aSqlItem.DW_UPDATE_ADVICE_FLAG;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.WH_UPDATE_DATE := aSqlItem.WH_UPDATE_DATE;
aPlsqlItem.SALES_GROUP_UPDATED_FLAG := aSqlItem.SALES_GROUP_UPDATED_FLAG;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.AUTO_SELECTED_QUANTITY := aPlsqlItem.AUTO_SELECTED_QUANTITY;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.AUTO_SELECTED_QUANTITY := aSqlItem.AUTO_SELECTED_QUANTITY;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.UPDATED_FLAG := aPlsqlItem.UPDATED_FLAG;
aSqlItem.UPDATE_ALLOWED := aPlsqlItem.UPDATE_ALLOWED;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.UPDATED_FLAG := aSqlItem.UPDATED_FLAG;
aPlsqlItem.UPDATE_ALLOWED := aSqlItem.UPDATE_ALLOWED;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.DW_UPDATE_ADVICE_FLAG := aPlsqlItem.DW_UPDATE_ADVICE_FLAG;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.WH_UPDATE_DATE := aPlsqlItem.WH_UPDATE_DATE;
aSqlItem.SALES_GROUP_UPDATED_FLAG := aPlsqlItem.SALES_GROUP_UPDATED_FLAG;
aPlsqlItem.DW_UPDATE_ADVICE_FLAG := aSqlItem.DW_UPDATE_ADVICE_FLAG;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.WH_UPDATE_DATE := aSqlItem.WH_UPDATE_DATE;
aPlsqlItem.SALES_GROUP_UPDATED_FLAG := aSqlItem.SALES_GROUP_UPDATED_FLAG;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
IF p_x_line_rec.auto_selected_quantity IS NULL THEN
p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
IF p_x_line_rec.last_updated_by IS NULL THEN
p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
IF p_x_line_rec.last_update_date IS NULL THEN
p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
IF p_x_line_rec.last_update_login IS NULL THEN
p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
IF p_x_line_rec.program_update_date IS NULL THEN
p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
IF p_x_header_rec.last_updated_by IS NULL THEN
p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
IF p_x_header_rec.last_update_date IS NULL THEN
p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
IF p_x_header_rec.last_update_login IS NULL THEN
p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
IF p_x_header_rec.program_update_date IS NULL THEN
p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;