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: 555


  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: 578


      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: 582


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

Line: 601


  p_x_route_rec.last_update_date := SYSDATE;

Line: 602


  p_x_route_rec.last_updated_by := FND_GLOBAL.user_id;

Line: 603


  p_x_route_rec.last_update_login := FND_GLOBAL.login_id;

Line: 866


  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: 884


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
  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,
  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,
  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: 1004


  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.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: 1192


  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: 1194


  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: 1619


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: 1675


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

Line: 1786


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: 1977


    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: 1986


    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: 2201


  SELECT AHL_ROUTES_B_S.NEXTVAL
  INTO   p_x_route_rec.route_id
  FROM   DUAL;

Line: 2218


  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 ,
    --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
    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: 2306


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

Line: 2319


  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 ,
    --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
    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: 2401


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

Line: 2513


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: 2539


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: 2546


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

Line: 2555


select enigma_doc_id
from ahl_routes_b
where route_id = p_route_id;

Line: 2568


  SAVEPOINT delete_route_PVT;

Line: 2676


  DELETE ahl_route_effectivities
  WHERE  ROUTE_ID = p_route_id;

Line: 2690


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

Line: 2705


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

Line: 2721


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

Line: 2732


  DELETE AHL_ROUTE_OPERATIONS
  WHERE  ROUTE_ID = p_route_id;

Line: 2742


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

Line: 2758


    AHL_ROUTES_PKG.delete_row
    (
      X_ROUTE_ID        => p_route_id
    );

Line: 2797


    ROLLBACK TO delete_route_PVT;

Line: 2812


    ROLLBACK TO delete_route_PVT;

Line: 2827


    ROLLBACK TO delete_route_PVT;

Line: 2850


END delete_route;

Line: 2884


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

Line: 2890


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: 2923


  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: 2959


  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: 3111


    SELECT AHL_ROUTES_B_S.NEXTVAL
    INTO   l_route_id
    FROM   DUAL;

Line: 3116


    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 ,
      --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
      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     =>  NULL ,
      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: 3205


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

Line: 3214


    SELECT ahl_route_effectivities_s.nextval into l_route_effectivity_id
    FROM dual;

Line: 3216


    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: 3281


    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
    ;

Line: 3363


  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
  )
  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
  FROM  AHL_RT_OPER_MATERIALS
  WHERE object_id = p_route_id
  AND association_type_code = 'ROUTE';

Line: 3437


    SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
    FROM dual;

Line: 3439


    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: 3518


    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: 3580


    SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
    INTO   l_doc_title_assos_id
    FROM   DUAL;

Line: 3584


    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.attribute1,
      X_ATTRIBUTE3         => I.attribute1,
      X_ATTRIBUTE4         => I.attribute1,
      X_ATTRIBUTE5         => I.attribute1,
      X_ATTRIBUTE6         => I.attribute1,
      X_ATTRIBUTE7         => I.attribute1,
      X_ATTRIBUTE8         => I.attribute1,
      X_ATTRIBUTE9         => I.attribute1,
      X_ATTRIBUTE10        => I.attribute1,
      X_ATTRIBUTE11        => I.attribute1,
      X_ATTRIBUTE12        => I.attribute1,
      X_ATTRIBUTE13        => I.attribute1,
      X_ATTRIBUTE14        => I.attribute1,
      X_ATTRIBUTE15        => I.attribute1,
      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: 3626


  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
  WHERE route_id = p_route_id;

Line: 3689


  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';