eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_PVT SQL Statements

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

Line: 9


G_LAST_UPDATE_DATE  DATE    := SYSDATE;

Line: 10


G_LAST_UPDATED_BY   NUMBER(15)  := FND_GLOBAL.user_id;

Line: 11


G_LAST_UPDATE_LOGIN   NUMBER(15)  := FND_GLOBAL.login_id;

Line: 614


  IF ( ( p_x_route_rec.unit_receipt_update_flag IS NOT NULL AND
   p_x_route_rec.unit_receipt_update_flag <> FND_API.G_MISS_CHAR ) OR
       ( p_x_route_rec.unit_receipt_update IS NOT NULL AND
   p_x_route_rec.unit_receipt_update <> FND_API.G_MISS_CHAR ) ) THEN

    AHL_RM_ROUTE_UTIL.validate_lookup
    (
      x_return_status      => l_return_status,
      x_msg_data       => l_msg_data,
      p_lookup_type      => 'AHL_YES_NO_TYPE',
      p_lookup_meaning       => p_x_route_rec.unit_receipt_update,
      p_x_lookup_code      => p_x_route_rec.unit_receipt_update_flag
    );

Line: 637


      IF ( p_x_route_rec.unit_receipt_update IS NULL OR
     p_x_route_rec.unit_receipt_update = FND_API.G_MISS_CHAR ) THEN
           FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update_flag );

Line: 641


           FND_MESSAGE.set_token( 'FIELD', p_x_route_rec.unit_receipt_update );

Line: 697


  p_x_route_rec.last_update_date := SYSDATE;

Line: 698


  p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 699


  p_x_route_rec.last_update_login := FND_GLOBAL.login_id;

Line: 991


  IF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN
    p_x_route_rec.unit_receipt_update_flag := 'N';

Line: 1009


SELECT  route_no,
  title,
  route_type_code,
  route_type,
  process_code,
  process,
  product_type_code,
  product_type,
  --bachandr Enigma Phase I changes -- start
  model_code,
  model_meaning,
  enigma_doc_id,
  enigma_route_id,
  enigma_publish_date,
  file_id,
  --bachandr Enigma Phase I changes -- end
  --snarkhed Enigma Phase II changes --start
  enigma_source_code,
  enigma_source_meaning,
  job_card_lyt_code,
  job_card_lyt_meaning,
  --snarkhed Enigma Phase II changes End
  operator_party_id,
  operator_name,
  zone_code,
  zone,
  sub_zone_code,
  sub_zone,
  service_item_id,
  service_item_org_id,
  service_item_number,
  accounting_class_code,
  accounting_class_org_id,
  accounting_class,
  task_template_group_id,
  task_template_group,
  --MANESING::Supplier Warranty, 25-Aug-2010, added warranty template id and name
  warranty_template_id,
  warranty_template_name,
  --MANESING::VWP Enhancements, 18-Jan-2011, added Duplicate and Return to supply flags
  duplicate_flag,
  return_to_supply_flag,
  qa_inspection_type,
  qa_inspection_type_desc,
  time_span,
  start_date_active,
  end_date_active,
  revision_number,
  revision_status_code,
  revision_status,
  unit_receipt_update_flag, --pdoki Bug 6504159.
  unit_receipt_update, --pdoki Bug 6504159.
  remarks,
  REVISION_NOTES, -- JKJain Bug No 8212847, Fp for bug 8206660
  segment1,
  segment2,
  segment3,
  segment4,
  segment5,
  segment6,
  segment7,
  segment8,
  segment9,
  segment10,
  segment11,
  segment12,
  segment13,
  segment14,
  segment15,
  attribute_category,
  attribute1,
  attribute2,
  attribute3,
  attribute4,
  attribute5,
  attribute6,
  attribute7,
  attribute8,
  attribute9,
  attribute10,
  attribute11,
  attribute12,
  attribute13,
  attribute14,
  attribute15
FROM  AHL_ROUTES_V
WHERE route_id = c_route_id;

Line: 1154


  p_x_route_rec.unit_receipt_update_flag, --pdoki Bug 6504159.
  p_x_route_rec.unit_receipt_update, --pdoki Bug 6504159.
  p_x_route_rec.remarks,
  p_x_route_rec.REVISION_NOTES, -- JKJain Bug No 8212847, Fp for bug 8206660
  p_x_route_rec.segment1,
  p_x_route_rec.segment2,
  p_x_route_rec.segment3,
  p_x_route_rec.segment4,
  p_x_route_rec.segment5,
  p_x_route_rec.segment6,
  p_x_route_rec.segment7,
  p_x_route_rec.segment8,
  p_x_route_rec.segment9,
  p_x_route_rec.segment10,
  p_x_route_rec.segment11,
  p_x_route_rec.segment12,
  p_x_route_rec.segment13,
  p_x_route_rec.segment14,
  p_x_route_rec.segment15,
  p_x_route_rec.attribute_category,
  p_x_route_rec.attribute1,
  p_x_route_rec.attribute2,
  p_x_route_rec.attribute3,
  p_x_route_rec.attribute4,
  p_x_route_rec.attribute5,
  p_x_route_rec.attribute6,
  p_x_route_rec.attribute7,
  p_x_route_rec.attribute8,
  p_x_route_rec.attribute9,
  p_x_route_rec.attribute10,
  p_x_route_rec.attribute11,
  p_x_route_rec.attribute12,
  p_x_route_rec.attribute13,
  p_x_route_rec.attribute14,
  p_x_route_rec.attribute15;

Line: 1370


  IF ( p_x_route_rec.unit_receipt_update_flag IS NULL ) THEN
    p_x_route_rec.unit_receipt_update_flag := l_old_route_rec.unit_receipt_update_flag;

Line: 1372


  ELSIF ( p_x_route_rec.unit_receipt_update_flag = FND_API.G_MISS_CHAR ) THEN
    p_x_route_rec.unit_receipt_update_flag := 'N';

Line: 1838


select 'x'
from ahl_routes_app_v
where route_id = p_route_rec.route_id and
object_version_number = p_route_rec.object_version_number;

Line: 1894


  SELECT trim(fnd_profile.value('AHL_ENIGMA_3C_URL')) INTO l_enigma_avail FROM dual;

Line: 2009


SELECT route_id
FROM   AHL_ROUTES_APP_V
WHERE  UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no))
AND    revision_number = nvl(c_revision_number,1);

Line: 2204


    SELECT CONCATENATED_SEGMENTS
    FROM AHL_ROUTES_B_KFV
    WHERE ROUTE_ID = p_x_route_rec.route_id
    AND REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL;

Line: 2213


    SELECT 'X'
    FROM AHL_ROUTES_B_KFV
    WHERE REPLACE(CONCATENATED_SEGMENTS, FND_FLEX_EXT.GET_DELIMITER('AHL', 'AHLR', 101), NULL) IS NOT NULL
    AND CONCATENATED_SEGMENTS = c_concat_segs
    AND ROUTE_NO <> c_route_no;

Line: 2223


        SELECT enigma_route_id
        FROM ahl_routes_b
        WHERE route_id = c_route_id;

Line: 2311


                UPDATE ahl_routes_b
                set file_id = p_x_route_rec.file_id
                where route_id = p_x_route_rec.route_id;

Line: 2501


  SELECT AHL_ROUTES_B_S.NEXTVAL
  INTO   p_x_route_rec.route_id
  FROM   DUAL;

Line: 2518


  AHL_ROUTES_PKG.insert_row
  (
    X_ROWID        =>  l_rowid ,
    X_ROUTE_ID         =>  p_x_route_rec.route_id ,
    X_OBJECT_VERSION_NUMBER    =>  1 ,
    X_ROUTE_NO         =>  p_x_route_rec.route_no ,
    X_APPLICATION_USG_CODE     =>  rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
    X_REVISION_NUMBER      =>  1 ,
    X_REVISION_STATUS_CODE     =>  'DRAFT' ,
    X_UNIT_RECEIPT_UPDATE_FLAG =>  p_x_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
    X_START_DATE_ACTIVE        =>  p_x_route_rec.active_start_date ,
    X_END_DATE_ACTIVE          =>  p_x_route_rec.active_end_date ,
    X_OPERATOR_PARTY_ID        =>  p_x_route_rec.operator_party_id ,
    X_QA_INSPECTION_TYPE       =>  p_x_route_rec.qa_inspection_type ,
    X_SERVICE_ITEM_ID          =>  p_x_route_rec.service_item_id ,
    X_SERVICE_ITEM_ORG_ID      =>  p_x_route_rec.service_item_org_id ,
    X_TASK_TEMPLATE_GROUP_ID   =>  p_x_route_rec.task_template_group_id ,
    X_ACCOUNTING_CLASS_CODE    =>  p_x_route_rec.accounting_class_code ,
    X_ACCOUNTING_CLASS_ORG_ID  =>  p_x_route_rec.accounting_class_org_id ,
    X_ROUTE_TYPE_CODE          =>  p_x_route_rec.route_type_code ,
    X_PRODUCT_TYPE_CODE        =>  p_x_route_rec.product_type_code ,
    --MANESING::Supplier Warranty, 25-Aug-2010, added warranty template id
    X_WARRANTY_TEMPLATE_ID     =>  p_x_route_rec.warranty_template_id,
    --MANESING::VWP Enhancements, 18-Jan-2011, added Duplicate and Return to supply flags
    X_DUPLICATE_FLAG           =>  p_x_route_rec.duplicate_flag,
    X_RETURN_TO_SUPPLY_FLAG    =>  p_x_route_rec.return_to_supply_flag,
    --bachandr Enigma Phase I changes -- start
    X_MODEL_CODE               =>  p_x_route_rec.model_code ,
    X_ENIGMA_PUBLISH_DATE      =>  p_x_route_rec.enigma_publish_date,
    X_ENIGMA_DOC_ID            =>  p_x_route_rec.enigma_doc_id,
    X_ENIGMA_ROUTE_ID          =>  p_x_route_rec.enigma_route_id,
    X_FILE_ID                  =>  p_x_route_rec.file_id,
    --bachandr Enigma Phase I changes -- end
    --snarkhed Enigma Phase II changes --start
    X_ENIGMA_SOURCE_CODE       => p_x_route_rec.enigma_source_code,
    X_JOB_CARD_LYT_CODE        =>p_x_route_rec.job_card_lyt_code,
    --snarkhed Enigma Phase II changes --end
    X_ZONE_CODE        =>  p_x_route_rec.zone_code ,
    X_SUB_ZONE_CODE      =>  p_x_route_rec.sub_zone_code ,
    X_PROCESS_CODE       =>  p_x_route_rec.process_code ,
    X_TIME_SPAN        =>  p_x_route_rec.time_span ,
    X_SEGMENT1         =>  p_x_route_rec.segment1 ,
    X_SEGMENT2         =>  p_x_route_rec.segment2 ,
    X_SEGMENT3         =>  p_x_route_rec.segment3 ,
    X_SEGMENT4         =>  p_x_route_rec.segment4 ,
    X_SEGMENT5         =>  p_x_route_rec.segment5 ,
    X_SEGMENT6         =>  p_x_route_rec.segment6 ,
    X_SEGMENT7         =>  p_x_route_rec.segment7 ,
    X_SEGMENT8         =>  p_x_route_rec.segment8 ,
    X_SEGMENT9         =>  p_x_route_rec.segment9 ,
    X_SEGMENT10        =>  p_x_route_rec.segment10 ,
    X_SEGMENT11        =>  p_x_route_rec.segment11 ,
    X_SEGMENT12        =>  p_x_route_rec.segment12 ,
    X_SEGMENT13        =>  p_x_route_rec.segment13 ,
    X_SEGMENT14        =>  p_x_route_rec.segment14 ,
    X_SEGMENT15        =>  p_x_route_rec.segment15 ,
    X_ATTRIBUTE_CATEGORY       =>  p_x_route_rec.attribute_category ,
    X_ATTRIBUTE1         =>  p_x_route_rec.attribute1 ,
    X_ATTRIBUTE2         =>  p_x_route_rec.attribute2 ,
    X_ATTRIBUTE3         =>  p_x_route_rec.attribute3 ,
    X_ATTRIBUTE4         =>  p_x_route_rec.attribute4 ,
    X_ATTRIBUTE5         =>  p_x_route_rec.attribute5 ,
    X_ATTRIBUTE6         =>  p_x_route_rec.attribute6 ,
    X_ATTRIBUTE7         =>  p_x_route_rec.attribute7 ,
    X_ATTRIBUTE8         =>  p_x_route_rec.attribute8 ,
    X_ATTRIBUTE9         =>  p_x_route_rec.attribute9 ,
    X_ATTRIBUTE10        =>  p_x_route_rec.attribute10 ,
    X_ATTRIBUTE11        =>  p_x_route_rec.attribute11 ,
    X_ATTRIBUTE12        =>  p_x_route_rec.attribute12 ,
    X_ATTRIBUTE13        =>  p_x_route_rec.attribute13 ,
    X_ATTRIBUTE14        =>  p_x_route_rec.attribute14 ,
    X_ATTRIBUTE15        =>  p_x_route_rec.attribute15 ,
    X_TITLE        =>  p_x_route_rec.title ,
    X_REMARKS        =>  p_x_route_rec.remarks ,
    X_REVISION_NOTES       =>  p_x_route_rec.revision_notes ,
    X_CREATION_DATE      =>  G_CREATION_DATE ,
    X_CREATED_BY         =>  G_CREATED_BY ,
    X_LAST_UPDATE_DATE       =>  G_LAST_UPDATE_DATE ,
    X_LAST_UPDATED_BY      =>  G_LAST_UPDATED_BY ,
    X_LAST_UPDATE_LOGIN      =>  G_LAST_UPDATE_LOGIN,
    X_ENABLED_FLAG       =>  'Y',
    X_SUMMARY_FLAG       =>  'N'
  );

Line: 2615


      'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
    );

Line: 2628


  AHL_ROUTES_PKG.update_row
  (
    X_ROUTE_ID          =>  p_x_route_rec.route_id ,
    X_OBJECT_VERSION_NUMBER     =>  p_x_route_rec.object_version_number ,
    X_ROUTE_NO          =>  p_x_route_rec.route_no ,
    X_REVISION_NUMBER       =>  p_x_route_rec.revision_number ,
    X_REVISION_STATUS_CODE     =>  p_x_route_rec.revision_status_code ,
    X_UNIT_RECEIPT_UPDATE_FLAG =>  p_x_route_rec.unit_receipt_update_flag ,--pdoki Bug 6504159.
    X_START_DATE_ACTIVE        =>  p_x_route_rec.active_start_date ,
    X_END_DATE_ACTIVE          =>  p_x_route_rec.active_end_date ,
    X_OPERATOR_PARTY_ID        =>  p_x_route_rec.operator_party_id ,
    X_QA_INSPECTION_TYPE       =>  p_x_route_rec.qa_inspection_type ,
    X_SERVICE_ITEM_ID          =>  p_x_route_rec.service_item_id ,
    X_SERVICE_ITEM_ORG_ID      =>  p_x_route_rec.service_item_org_id ,
    X_TASK_TEMPLATE_GROUP_ID   =>  p_x_route_rec.task_template_group_id ,
    X_ACCOUNTING_CLASS_CODE    =>  p_x_route_rec.accounting_class_code ,
    X_ACCOUNTING_CLASS_ORG_ID  =>  p_x_route_rec.accounting_class_org_id,
    X_ROUTE_TYPE_CODE          =>  p_x_route_rec.route_type_code ,
    X_PRODUCT_TYPE_CODE        =>  p_x_route_rec.product_type_code ,
    --MANESING::Supplier Warranty, 25-Aug-2010, added warranty template id
    X_WARRANTY_TEMPLATE_ID     =>  p_x_route_rec.warranty_template_id,
    --MANESING::VWP Enhancements, 18-Jan-2011, added Duplicate and Return to supply flags
    X_DUPLICATE_FLAG           =>  p_x_route_rec.duplicate_flag,
    X_RETURN_TO_SUPPLY_FLAG    =>  p_x_route_rec.return_to_supply_flag,
    --bachandr Enigma Phase I changes -- start
    X_MODEL_CODE               =>  p_x_route_rec.model_code ,
    X_FILE_ID                  =>  p_x_route_rec.file_id,
    --bachandr Enigma Phase I changes -- end
    --snarkhed Enigma Phase II changes --start
    X_ENIGMA_SOURCE_CODE       => p_x_route_rec.enigma_source_code,
    X_JOB_CARD_LYT_CODE        => p_x_route_rec.job_card_lyt_code,
    X_ENIGMA_DOC_ID            =>p_x_route_rec.enigma_doc_id,
    --snarkhed Enigma Phase II changes --End
    X_ZONE_CODE         =>  p_x_route_rec.zone_code ,
    X_SUB_ZONE_CODE       =>  p_x_route_rec.sub_zone_code ,
    X_PROCESS_CODE        =>  p_x_route_rec.process_code ,
    X_TIME_SPAN         =>  p_x_route_rec.time_span ,
    X_SEGMENT1          =>  p_x_route_rec.segment1 ,
    X_SEGMENT2          =>  p_x_route_rec.segment2 ,
    X_SEGMENT3          =>  p_x_route_rec.segment3 ,
    X_SEGMENT4          =>  p_x_route_rec.segment4 ,
    X_SEGMENT5          =>  p_x_route_rec.segment5 ,
    X_SEGMENT6          =>  p_x_route_rec.segment6 ,
    X_SEGMENT7          =>  p_x_route_rec.segment7 ,
    X_SEGMENT8          =>  p_x_route_rec.segment8 ,
    X_SEGMENT9          =>  p_x_route_rec.segment9 ,
    X_SEGMENT10         =>  p_x_route_rec.segment10 ,
    X_SEGMENT11         =>  p_x_route_rec.segment11 ,
    X_SEGMENT12         =>  p_x_route_rec.segment12 ,
    X_SEGMENT13         =>  p_x_route_rec.segment13 ,
    X_SEGMENT14         =>  p_x_route_rec.segment14 ,
    X_SEGMENT15         =>  p_x_route_rec.segment15 ,
    X_ATTRIBUTE_CATEGORY        =>  p_x_route_rec.attribute_category ,
    X_ATTRIBUTE1          =>  p_x_route_rec.attribute1 ,
    X_ATTRIBUTE2          =>  p_x_route_rec.attribute2 ,
    X_ATTRIBUTE3          =>  p_x_route_rec.attribute3 ,
    X_ATTRIBUTE4          =>  p_x_route_rec.attribute4 ,
    X_ATTRIBUTE5          =>  p_x_route_rec.attribute5 ,
    X_ATTRIBUTE6          =>  p_x_route_rec.attribute6 ,
    X_ATTRIBUTE7          =>  p_x_route_rec.attribute7 ,
    X_ATTRIBUTE8          =>  p_x_route_rec.attribute8 ,
    X_ATTRIBUTE9          =>  p_x_route_rec.attribute9 ,
    X_ATTRIBUTE10         =>  p_x_route_rec.attribute10 ,
    X_ATTRIBUTE11         =>  p_x_route_rec.attribute11 ,
    X_ATTRIBUTE12         =>  p_x_route_rec.attribute12 ,
    X_ATTRIBUTE13         =>  p_x_route_rec.attribute13 ,
    X_ATTRIBUTE14         =>  p_x_route_rec.attribute14 ,
    X_ATTRIBUTE15         =>  p_x_route_rec.attribute15 ,
    X_TITLE         =>  p_x_route_rec.title ,
    X_REMARKS         =>  p_x_route_rec.remarks ,
    X_REVISION_NOTES        =>  p_x_route_rec.revision_notes ,
    X_LAST_UPDATE_DATE        =>  G_LAST_UPDATE_DATE ,
    X_LAST_UPDATED_BY       =>  G_LAST_UPDATED_BY ,
    X_LAST_UPDATE_LOGIN       =>  G_LAST_UPDATE_LOGIN,
    X_ENABLED_FLAG        =>  'Y',
    X_SUMMARY_FLAG        =>  'N'
  );

Line: 2720


      'AHL_ROUTES_PKG.update_row error = ['||SQLERRM||']'
    );

Line: 2832


PROCEDURE delete_route
(
 p_api_version     IN        NUMBER   := '1.0',
 p_init_msg_list   IN        VARCHAR2   := FND_API.G_TRUE,
 p_commit    IN        VARCHAR2   := FND_API.G_FALSE,
 p_validation_level  IN        NUMBER   := FND_API.G_VALID_LEVEL_FULL,
 p_default     IN        VARCHAR2   := FND_API.G_FALSE,
 p_module_type     IN        VARCHAR2   := NULL,
 x_return_status   OUT NOCOPY    VARCHAR2,
 x_msg_count     OUT NOCOPY    NUMBER,
 x_msg_data    OUT NOCOPY    VARCHAR2,
 p_route_id    IN        NUMBER,
 p_object_version_number IN        NUMBER
)
IS

l_api_name   CONSTANT   VARCHAR2(30)   := 'delete_route';

Line: 2858


SELECT doc_title_asso_id
FROM   ahl_doc_title_assos_b
WHERE  aso_object_id = c_route_id
AND    aso_object_type_code = 'ROUTE';

Line: 2865


select 'x'
from ahl_routes_app_v
where route_id = p_route_id and
object_version_number = p_object_version_number;

Line: 2875


select enigma_route_id
from ahl_routes_b
where route_id = p_route_id;

Line: 2889


  SAVEPOINT delete_route_PVT;

Line: 3007


  DELETE ahl_route_effectivities
  WHERE  ROUTE_ID = p_route_id;

Line: 3021


  DELETE AHL_RT_OPER_MATERIALS
  WHERE  OBJECT_ID = p_route_id
  AND  ASSOCIATION_TYPE_CODE = 'ROUTE';

Line: 3036


  DELETE AHL_RT_OPER_RESOURCES
  WHERE  OBJECT_ID = p_route_id
  AND  ASSOCIATION_TYPE_CODE = 'ROUTE';

Line: 3052


    ahl_doc_title_assos_pkg.delete_row
    (
      X_DOC_TITLE_ASSO_ID => I.doc_title_asso_id
    );

Line: 3063


  DELETE AHL_ROUTE_OPERATIONS
  WHERE  ROUTE_ID = p_route_id;

Line: 3073


  DELETE AHL_RT_OPER_ACCESS_PANELS
  WHERE  OBJECT_ID = p_route_id
  AND  ASSOCIATION_TYPE_CODE = 'ROUTE';

Line: 3089


    AHL_ROUTES_PKG.delete_row
    (
      X_ROUTE_ID        => p_route_id
    );

Line: 3128


    ROLLBACK TO delete_route_PVT;

Line: 3143


    ROLLBACK TO delete_route_PVT;

Line: 3158


    ROLLBACK TO delete_route_PVT;

Line: 3181


END delete_route;

Line: 3215


SELECT  MAX( revision_number )
FROM  AHL_ROUTES_APP_V
WHERE UPPER(TRIM(route_no)) = UPPER(TRIM(c_route_no));

Line: 3221


SELECT  doc_title_asso_id,
  doc_revision_id,
  document_id,
  use_latest_rev_flag,
  serial_no,
  source_ref_code,
  chapter,
  section,
  subject,
  page,
  figure,
  note,
  attribute_category,
  attribute1,
  attribute2,
  attribute3,
  attribute4,
  attribute5,
  attribute6,
  attribute7,
  attribute8,
  attribute9,
  attribute10,
  attribute11,
  attribute12,
  attribute13,
  attribute14,
  attribute15
FROM  AHL_DOC_TITLE_ASSOS_VL
WHERE aso_object_id = c_route_id
AND aso_object_type_code = 'ROUTE';

Line: 3254


  SELECT
      RT_OPER_RESOURCE_ID,
      OBJECT_ID,
      ASSOCIATION_TYPE_CODE,
      ASO_RESOURCE_ID,
      QUANTITY,
      DURATION,
      ACTIVITY_ID,
      COST_BASIS_ID,
      SCHEDULED_TYPE_ID,
      AUTOCHARGE_TYPE_ID,
      STANDARD_RATE_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      -- Bug # 7644260 (FP for ER # 6998882) -- start
      SCHEDULE_SEQ
      -- Bug # 7644260 (FP for ER # 6998882) -- end
  FROM ahl_rt_oper_resources
  WHERE object_id = c_route_id
  AND association_type_code = 'ROUTE';

Line: 3290


  SELECT
    route_effectivity_id
    , route_id
    , inventory_item_id
    , inventory_master_org_id
    , mc_id
    , mc_header_id ,
    OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    security_group_id,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15
  FROM ahl_route_effectivities
  WHERE route_id = c_route_id
  ;

Line: 3328


  SELECT
    AHL_ROUTE_OPERATIONS_S.NEXTVAL new_rt_op_id,
    route_operation_id old_rt_op_id,
    1 object_version_number,
    l_route_id new_route_id,
    OPERATION_ID,
    STEP,
    CHECK_POINT_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SYSDATE  last_update_date,
    FND_GLOBAL.user_id last_updated_by,
    SYSDATE creation_date,
    FND_GLOBAL.user_id created_by,
    FND_GLOBAL.login_id last_update_login
  FROM  AHL_ROUTE_OPERATIONS_V
  WHERE route_id = c_route_id
  AND      NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;

Line: 3364


    SELECT
      AHL_RT_OPER_DEP_S.NEXTVAL rt_op_dependency_id,
      1 OBJECT_VERSION_NUMBER,
      SYSDATE last_update_date,
      FND_GLOBAL.user_id last_updated_by,
      SYSDATE creation_date,
      FND_GLOBAL.user_id created_by,
      FND_GLOBAL.login_id last_update_login,
      FROM_RT_OP_ID,
      FROM_OP_STEP,
      DEPENDENCY_CODE,
      TO_RT_OP_ID,
      TO_OP_STEP,
      SECURITY_GROUP_ID,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
  FROM  AHL_RT_OPER_DEPENDENCIES_V
  WHERE ROUTE_ID = c_route_id;

Line: 3519


    SELECT AHL_ROUTES_B_S.NEXTVAL
    INTO   l_route_id
    FROM   DUAL;

Line: 3524


    AHL_ROUTES_PKG.insert_row
    (
      X_ROWID      =>  l_rowid ,
      X_ROUTE_ID     =>  l_route_id ,
      X_OBJECT_VERSION_NUMBER  =>  1 ,
      X_ROUTE_NO     =>  l_old_route_rec.route_no ,
      X_APPLICATION_USG_CODE   =>  rtrim(ltrim(FND_PROFILE.value( 'AHL_APPLN_USAGE' ))),
      X_REVISION_NUMBER    =>  l_revision_number ,
      X_REVISION_STATUS_CODE   =>  'DRAFT' ,
      X_UNIT_RECEIPT_UPDATE_FLAG =>  l_old_route_rec.unit_receipt_update_flag , --pdoki Bug 6504159.
      X_START_DATE_ACTIVE  =>  l_old_route_rec.active_start_date ,
      X_END_DATE_ACTIVE    =>  NULL ,
      X_OPERATOR_PARTY_ID  =>  l_old_route_rec.operator_party_id ,
      X_QA_INSPECTION_TYPE       =>  l_old_route_rec.qa_inspection_type ,
      X_SERVICE_ITEM_ID          =>  l_old_route_rec.service_item_id ,
      X_SERVICE_ITEM_ORG_ID      =>  l_old_route_rec.service_item_org_id ,
      X_TASK_TEMPLATE_GROUP_ID   =>  l_old_route_rec.task_template_group_id ,
      X_ACCOUNTING_CLASS_CODE    =>  l_old_route_rec.accounting_class_code ,
      X_ACCOUNTING_CLASS_ORG_ID  =>  l_old_route_rec.accounting_class_org_id ,
      X_ROUTE_TYPE_CODE          =>  l_old_route_rec.route_type_code ,
      X_PRODUCT_TYPE_CODE        =>  l_old_route_rec.product_type_code ,
      --MANESING::Supplier Warranty, 25-Aug-2010, added warranty template id
      X_WARRANTY_TEMPLATE_ID     =>  l_old_route_rec.warranty_template_id,
      --MANESING::VWP Enhancements, 18-Jan-2011, added Duplicate and Return to supply flags
      X_DUPLICATE_FLAG           =>  l_old_route_rec.duplicate_flag,
      X_RETURN_TO_SUPPLY_FLAG    =>  l_old_route_rec.return_to_supply_flag,
      --bachandr Enigma Phase I changes -- start
      X_MODEL_CODE               =>  l_old_route_rec.model_code ,
      X_ENIGMA_PUBLISH_DATE      =>  l_old_route_rec.enigma_publish_date,
      X_ENIGMA_DOC_ID            =>  l_old_route_rec.enigma_doc_id ,
      X_ENIGMA_ROUTE_ID          =>  l_old_route_rec.enigma_route_id ,
      X_FILE_ID                  =>  l_old_route_rec.file_id,
      --bachandr Enigma Phase I changes -- end
      --snarkhed Enigma Phase II changes --start
      X_ENIGMA_SOURCE_CODE       => l_old_route_rec.enigma_source_code,
      X_JOB_CARD_LYT_CODE        => l_old_route_rec.job_card_lyt_code,
      --snarkhed Enigma Phase II changes --start
      X_ZONE_CODE    =>  l_old_route_rec.zone_code ,
      X_SUB_ZONE_CODE    =>  l_old_route_rec.sub_zone_code ,
      X_PROCESS_CODE     =>  l_old_route_rec.process_code ,
      X_TIME_SPAN    =>  l_old_route_rec.time_span ,
      X_SEGMENT1     =>  l_old_route_rec.segment1 ,
      X_SEGMENT2     =>  l_old_route_rec.segment2 ,
      X_SEGMENT3     =>  l_old_route_rec.segment3 ,
      X_SEGMENT4     =>  l_old_route_rec.segment4 ,
      X_SEGMENT5     =>  l_old_route_rec.segment5 ,
      X_SEGMENT6     =>  l_old_route_rec.segment6 ,
      X_SEGMENT7     =>  l_old_route_rec.segment7 ,
      X_SEGMENT8     =>  l_old_route_rec.segment8 ,
      X_SEGMENT9     =>  l_old_route_rec.segment9 ,
      X_SEGMENT10    =>  l_old_route_rec.segment10 ,
      X_SEGMENT11    =>  l_old_route_rec.segment11 ,
      X_SEGMENT12    =>  l_old_route_rec.segment12 ,
      X_SEGMENT13    =>  l_old_route_rec.segment13 ,
      X_SEGMENT14    =>  l_old_route_rec.segment14 ,
      X_SEGMENT15    =>  l_old_route_rec.segment15 ,
      X_ATTRIBUTE_CATEGORY   =>  l_old_route_rec.attribute_category ,
      X_ATTRIBUTE1     =>  l_old_route_rec.attribute1 ,
      X_ATTRIBUTE2     =>  l_old_route_rec.attribute2 ,
      X_ATTRIBUTE3     =>  l_old_route_rec.attribute3 ,
      X_ATTRIBUTE4     =>  l_old_route_rec.attribute4 ,
      X_ATTRIBUTE5     =>  l_old_route_rec.attribute5 ,
      X_ATTRIBUTE6     =>  l_old_route_rec.attribute6 ,
      X_ATTRIBUTE7     =>  l_old_route_rec.attribute7 ,
      X_ATTRIBUTE8     =>  l_old_route_rec.attribute8 ,
      X_ATTRIBUTE9     =>  l_old_route_rec.attribute9 ,
      X_ATTRIBUTE10    =>  l_old_route_rec.attribute10 ,
      X_ATTRIBUTE11    =>  l_old_route_rec.attribute11 ,
      X_ATTRIBUTE12    =>  l_old_route_rec.attribute12 ,
      X_ATTRIBUTE13    =>  l_old_route_rec.attribute13 ,
      X_ATTRIBUTE14    =>  l_old_route_rec.attribute14 ,
      X_ATTRIBUTE15    =>  l_old_route_rec.attribute15 ,
      X_TITLE      =>  l_old_route_rec.title ,
      X_REMARKS      =>  l_old_route_rec.remarks ,
      X_REVISION_NOTES     =>  l_old_route_rec.REVISION_NOTES ,
      X_CREATION_DATE    =>  SYSDATE ,
      X_CREATED_BY     =>  FND_GLOBAL.user_id ,
      X_LAST_UPDATE_DATE   =>  SYSDATE ,
      X_LAST_UPDATED_BY    =>  FND_GLOBAL.user_id ,
      X_LAST_UPDATE_LOGIN  =>  FND_GLOBAL.login_id,
      X_ENABLED_FLAG     =>  'Y',
      X_SUMMARY_FLAG     =>  'N'
    );

Line: 3622


      'AHL_ROUTES_PKG.insert_row error = ['||SQLERRM||']'
    );

Line: 3631


    SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
    FROM dual;

Line: 3633


    INSERT INTO ahl_route_effectivities
    (
      route_effectivity_id
    , route_id
    , inventory_item_id
    , inventory_master_org_id
    , mc_id
    , mc_header_id ,
    OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    security_group_id,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15
    )
    VALUES
    (
      l_route_effectivity_id,
      l_route_id,
      l_get_route_efcts.inventory_item_id,
      l_get_route_efcts.inventory_master_org_id,
      l_get_route_efcts.mc_id,
      l_get_route_efcts.mc_header_id,
      1,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.user_id,
      l_get_route_efcts.security_group_id,
      l_get_route_efcts.ATTRIBUTE_CATEGORY,
      l_get_route_efcts.ATTRIBUTE1,
      l_get_route_efcts.ATTRIBUTE2,
      l_get_route_efcts.ATTRIBUTE3,
      l_get_route_efcts.ATTRIBUTE4,
      l_get_route_efcts.ATTRIBUTE5,
      l_get_route_efcts.ATTRIBUTE6,
      l_get_route_efcts.ATTRIBUTE7,
      l_get_route_efcts.ATTRIBUTE8,
      l_get_route_efcts.ATTRIBUTE9,
      l_get_route_efcts.ATTRIBUTE10,
      l_get_route_efcts.ATTRIBUTE11,
      l_get_route_efcts.ATTRIBUTE12,
      l_get_route_efcts.ATTRIBUTE13,
      l_get_route_efcts.ATTRIBUTE14,
      l_get_route_efcts.ATTRIBUTE15
    );

Line: 3698


    INSERT INTO AHL_RT_OPER_MATERIALS
  (
    RT_OPER_MATERIAL_ID,
    OBJECT_VERSION_NUMBER,
    OBJECT_ID,
    ASSOCIATION_TYPE_CODE,
    POSITION_PATH_ID,
    ITEM_GROUP_ID,
    INVENTORY_ITEM_ID,
    INVENTORY_ORG_ID,
    UOM_CODE,
    QUANTITY,
    ITEM_COMP_DETAIL_ID,
    EXCLUDE_FLAG,
    REWORK_PERCENT,
    REPLACE_PERCENT,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    IN_SERVICE --pdoki added for OGMA 105 issue
  ) SELECT
    AHL_RT_OPER_MATERIALS_S.NEXTVAL,
    1,
    l_route_effectivity_id,
    'DISPOSITION',
    position_path_id ,
    item_group_id,
    inventory_item_id,
    inventory_org_id,
    uom_code,
    quantity,
    item_comp_detail_id,
    exclude_flag,
    rework_percent,
    replace_percent,
    attribute_category,
    attribute1,
    attribute2,
    attribute3,
    attribute4,
    attribute5,
    attribute6,
    attribute7,
    attribute8,
    attribute9,
    attribute10,
    attribute11,
    attribute12,
    attribute13,
    attribute14,
    attribute15,
    last_update_date,
    last_updated_by,
    creation_date,
    created_by,
    last_update_login,
    in_service --pdoki added for OGMA 105 issue
    FROM  AHL_RT_OPER_MATERIALS
    WHERE OBJECT_ID = l_get_route_efcts.route_effectivity_id
   	 -- Added condition for fixing bug #12733884 - sthilak; sorao for backporting project

Line: 3781


  INSERT INTO AHL_RT_OPER_MATERIALS
  (
    RT_OPER_MATERIAL_ID,
    OBJECT_VERSION_NUMBER,
    OBJECT_ID,
    ASSOCIATION_TYPE_CODE,
    ITEM_GROUP_ID,
    INVENTORY_ITEM_ID,
    INVENTORY_ORG_ID,
    UOM_CODE,
    QUANTITY,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    EXCLUDE_FLAG,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    IN_SERVICE, --pdoki added for OGMA 105 issue
    --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
    MC_ID,
    POSITION_KEY
  )
  SELECT
    AHL_RT_OPER_MATERIALS_S.NEXTVAL,
    1,
    l_route_id,
    ASSOCIATION_TYPE_CODE,
    ITEM_GROUP_ID,
    INVENTORY_ITEM_ID,
    INVENTORY_ORG_ID,
    UOM_CODE,
    QUANTITY,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    EXCLUDE_FLAG,
    SYSDATE,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    FND_GLOBAL.login_id,
    IN_SERVICE, --pdoki added for OGMA 105 issue
    --sukhwsin::SB Effectivity - added two columns for position based mat. requirements
    MC_ID,
    POSITION_KEY
  FROM  AHL_RT_OPER_MATERIALS
  WHERE object_id = p_route_id
  AND association_type_code = 'ROUTE';

Line: 3861


    SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
    FROM dual;

Line: 3863


    INSERT INTO AHL_RT_OPER_RESOURCES
    (
      RT_OPER_RESOURCE_ID,
      OBJECT_VERSION_NUMBER,
      OBJECT_ID,
      ASSOCIATION_TYPE_CODE,
      ASO_RESOURCE_ID,
      QUANTITY,
      DURATION,
      ACTIVITY_ID,
      COST_BASIS_ID,
      SCHEDULED_TYPE_ID,
      AUTOCHARGE_TYPE_ID,
      STANDARD_RATE_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      -- Bug # 7644260 (FP for ER # 6998882) -- start
      SCHEDULE_SEQ
      -- Bug # 7644260 (FP for ER # 6998882) -- end
    )
    VALUES
    (
      l_rt_oper_resource_id,
      1,
      l_route_id,
      l_get_rt_oper_resources.ASSOCIATION_TYPE_CODE,
      l_get_rt_oper_resources.ASO_RESOURCE_ID,
      l_get_rt_oper_resources.QUANTITY,
      l_get_rt_oper_resources.DURATION,
      l_get_rt_oper_resources.ACTIVITY_ID,
      l_get_rt_oper_resources.COST_BASIS_ID,
      l_get_rt_oper_resources.SCHEDULED_TYPE_ID,
      l_get_rt_oper_resources.AUTOCHARGE_TYPE_ID,
      l_get_rt_oper_resources.STANDARD_RATE_FLAG,
      l_get_rt_oper_resources.ATTRIBUTE_CATEGORY,
      l_get_rt_oper_resources.ATTRIBUTE1,
      l_get_rt_oper_resources.ATTRIBUTE2,
      l_get_rt_oper_resources.ATTRIBUTE3,
      l_get_rt_oper_resources.ATTRIBUTE4,
      l_get_rt_oper_resources.ATTRIBUTE5,
      l_get_rt_oper_resources.ATTRIBUTE6,
      l_get_rt_oper_resources.ATTRIBUTE7,
      l_get_rt_oper_resources.ATTRIBUTE8,
      l_get_rt_oper_resources.ATTRIBUTE9,
      l_get_rt_oper_resources.ATTRIBUTE10,
      l_get_rt_oper_resources.ATTRIBUTE11,
      l_get_rt_oper_resources.ATTRIBUTE12,
      l_get_rt_oper_resources.ATTRIBUTE13,
      l_get_rt_oper_resources.ATTRIBUTE14,
      l_get_rt_oper_resources.ATTRIBUTE15,
      SYSDATE,
      FND_GLOBAL.user_id,
      SYSDATE,
      FND_GLOBAL.user_id,
      FND_GLOBAL.login_id,
      -- Bug # 7644260 (FP for ER # 6998882) -- start
      l_get_rt_oper_resources.SCHEDULE_SEQ
      -- Bug # 7644260 (FP for ER # 6998882) -- end
    );

Line: 3942


    INSERT INTO AHL_ALTERNATE_RESOURCES
    (
  ALTERNATE_RESOURCE_ID,
  OBJECT_VERSION_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY,
  LAST_UPDATE_LOGIN,
  RT_OPER_RESOURCE_ID,
  ASO_RESOURCE_ID,
  PRIORITY,
  ATTRIBUTE_CATEGORY,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15
      )
      SELECT
  AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
  1,
  SYSDATE,
  FND_GLOBAL.user_id,
  SYSDATE,
  FND_GLOBAL.user_id,
  FND_GLOBAL.login_id,
  l_rt_oper_resource_id,
  aso_resource_id,
  priority,
  ATTRIBUTE_CATEGORY,
  ATTRIBUTE1,
  ATTRIBUTE2,
  ATTRIBUTE3,
  ATTRIBUTE4,
  ATTRIBUTE5,
  ATTRIBUTE6,
  ATTRIBUTE7,
  ATTRIBUTE8,
  ATTRIBUTE9,
  ATTRIBUTE10,
  ATTRIBUTE11,
  ATTRIBUTE12,
  ATTRIBUTE13,
  ATTRIBUTE14,
  ATTRIBUTE15
      FROM  AHL_ALTERNATE_RESOURCES
      WHERE rt_oper_resource_id = l_get_rt_oper_resources.rt_oper_resource_id;

Line: 4004


    SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
    INTO   l_doc_title_assos_id
    FROM   DUAL;

Line: 4009


    AHL_DOC_TITLE_ASSOS_PKG.insert_row
    (
      X_ROWID          => l_rowid,
      X_DOC_TITLE_ASSO_ID      => l_doc_title_assos_id,
      X_SERIAL_NO        => I.serial_no,
      X_ATTRIBUTE_CATEGORY       => I.attribute_category,
      X_ATTRIBUTE1         => I.attribute1,
      X_ATTRIBUTE2         => I.attribute2,
      X_ATTRIBUTE3         => I.attribute3,
      X_ATTRIBUTE4         => I.attribute4,
      X_ATTRIBUTE5         => I.attribute5,
      X_ATTRIBUTE6         => I.attribute6,
      X_ATTRIBUTE7         => I.attribute7,
      X_ATTRIBUTE8         => I.attribute8,
      X_ATTRIBUTE9         => I.attribute9,
      X_ATTRIBUTE10        => I.attribute10,
      X_ATTRIBUTE11        => I.attribute11,
      X_ATTRIBUTE12        => I.attribute12,
      X_ATTRIBUTE13        => I.attribute13,
      X_ATTRIBUTE14        => I.attribute14,
      X_ATTRIBUTE15        => I.attribute15,
      X_ASO_OBJECT_TYPE_CODE       => 'ROUTE',
      X_SOURCE_REF_CODE        => I.source_ref_code,
      X_ASO_OBJECT_ID        => l_route_id,
      X_DOCUMENT_ID        => I.document_id,
      X_USE_LATEST_REV_FLAG      => I.use_latest_rev_flag,
      X_DOC_REVISION_ID        => I.doc_revision_id,
      X_OBJECT_VERSION_NUMBER      => 1,
      X_CHAPTER          => I.chapter,
      X_SECTION          => I.section,
      X_SUBJECT          => I.subject,
      X_FIGURE           => I.figure,
      X_PAGE           => I.page,
      X_NOTE           => I.note,
      X_CREATION_DATE        => SYSDATE,
      X_CREATED_BY         => fnd_global.user_id ,
      X_LAST_UPDATE_DATE       => SYSDATE,
      X_LAST_UPDATED_BY        => fnd_global.user_id ,
      X_LAST_UPDATE_LOGIN      => fnd_global.login_id
    );

Line: 4053


  /*INSERT INTO AHL_ROUTE_OPERATIONS
  (
    ROUTE_OPERATION_ID,
    OBJECT_VERSION_NUMBER,
    ROUTE_ID,
    OPERATION_ID,
    STEP,
    CHECK_POINT_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  )
  SELECT
    AHL_ROUTE_OPERATIONS_S.NEXTVAL,
    1,
    l_route_id,
    OPERATION_ID,
    STEP,
    CHECK_POINT_FLAG,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SYSDATE,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    FND_GLOBAL.login_id
  FROM  AHL_ROUTE_OPERATIONS_V
  WHERE route_id = p_route_id
  AND      NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;

Line: 4119


    INSERT INTO AHL_ROUTE_OPERATIONS
    (
      ROUTE_OPERATION_ID,
      OBJECT_VERSION_NUMBER,
      ROUTE_ID,
      OPERATION_ID,
      STEP,
      CHECK_POINT_FLAG,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN
    )
    VALUES
    (
    I.NEW_RT_OP_ID,
    I.OBJECT_VERSION_NUMBER,
    I.NEW_ROUTE_ID,
    I.OPERATION_ID,
    I.STEP,
    I.CHECK_POINT_FLAG,
    I.ATTRIBUTE_CATEGORY,
    I.ATTRIBUTE1,
    I.ATTRIBUTE2,
    I.ATTRIBUTE3,
    I.ATTRIBUTE4,
    I.ATTRIBUTE5,
    I.ATTRIBUTE6,
    I.ATTRIBUTE7,
    I.ATTRIBUTE8,
    I.ATTRIBUTE9,
    I.ATTRIBUTE10,
    I.ATTRIBUTE11,
    I.ATTRIBUTE12,
    I.ATTRIBUTE13,
    I.ATTRIBUTE14,
    I.ATTRIBUTE15,
    I.LAST_UPDATE_DATE,
    I.LAST_UPDATED_BY,
    I.CREATION_DATE,
    I.CREATED_BY,
    I.LAST_UPDATE_LOGIN
    );

Line: 4185


  INSERT INTO AHL_RT_OPER_ACCESS_PANELS
  (
    RT_OPER_PANEL_ID,
    OBJECT_VERSION_NUMBER,
    OBJECT_ID,
    ASSOCIATION_TYPE_CODE,
    PANEL_TYPE_ID,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  )
  SELECT
    AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
    1,
    l_route_id,
    ASSOCIATION_TYPE_CODE,
    PANEL_TYPE_ID,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    SYSDATE,
    FND_GLOBAL.user_id,
    SYSDATE,
    FND_GLOBAL.user_id,
    FND_GLOBAL.login_id
  FROM  AHL_RT_OPER_ACCESS_PANELS
  WHERE object_id = p_route_id
  AND association_type_code = 'ROUTE';

Line: 4249


    INSERT INTO AHL_RT_OPER_DEPENDENCIES
    (RT_OP_DEPENDENCY_ID,
        OBJECT_VERSION_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        FROM_RT_OP_ID,
        FROM_OP_STEP,
        DEPENDENCY_CODE,
        TO_RT_OP_ID,
        TO_OP_STEP,
        SECURITY_GROUP_ID,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15)
    VALUES
    (
        I.RT_OP_DEPENDENCY_ID,
        I.OBJECT_VERSION_NUMBER,
        I.LAST_UPDATE_DATE,
        I.LAST_UPDATED_BY,
        I.CREATION_DATE,
        I.CREATED_BY,
        I.LAST_UPDATE_LOGIN,
        l_rt_op_id_tbl(I.FROM_RT_OP_ID),
        I.FROM_OP_STEP,
        I.DEPENDENCY_CODE,
        l_rt_op_id_tbl(I.TO_RT_OP_ID),
        I.TO_OP_STEP,
        I.SECURITY_GROUP_ID,
        I.ATTRIBUTE_CATEGORY,
        I.ATTRIBUTE1,
        I.ATTRIBUTE2,
        I.ATTRIBUTE3,
        I.ATTRIBUTE4,
        I.ATTRIBUTE5,
        I.ATTRIBUTE6,
        I.ATTRIBUTE7,
        I.ATTRIBUTE8,
        I.ATTRIBUTE9,
        I.ATTRIBUTE10,
        I.ATTRIBUTE11,
        I.ATTRIBUTE12,
        I.ATTRIBUTE13,
        I.ATTRIBUTE14,
        I.ATTRIBUTE15
    );