APPS.AHL_FMP_MR_HEADER_PVT SQL Statements

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

Line: 12

        SELECT MR_HEADER_ID,
                       OBJECT_VERSION_NUMBER,
                       LAST_UPDATE_DATE,
                       LAST_UPDATED_BY,
                       CREATION_DATE,
                       CREATED_BY,
                       LAST_UPDATE_LOGIN,
                        TITLE,
                        VERSION_NUMBER,
                        -- pdoki, Following attrs are obsoleted after SBE Project, Start.
                        PRECEDING_MR_HEADER_ID,
                        PRECEDING_MR_TITLE,
                        PRECEDING_MR_REVISION,
                        -- pdoki, SBE Project End.
                        CATEGORY_CODE,
                        CATEGORY,
                        SERVICE_TYPE_CODE,
                        SERVICE_TYPE,
                        MR_STATUS_CODE,
                        STATUS,
                        IMPLEMENT_STATUS_CODE,
                        IMPLEMENT_STATUS,
                        REPETITIVE_FLAG,
                        REPETITIVE,
                        SHOW_REPETITIVE_CODE,
                        SHOW_REPETITIVE,
                        WHICHEVER_FIRST_CODE,
                        WHICHEVER_FIRST,
                        COPY_ACCOMPLISHMENT_FLAG,
                        COPY_ACCOMPLISHMENT,
                        PROGRAM_TYPE_CODE,
                        PROGRAM_TYPE,
                        PROGRAM_SUBTYPE_CODE,
                        PROGRAM_SUBTYPE,
                        EFFECTIVE_FROM,
                        EFFECTIVE_TO,
                        REVISION,
                        DESCRIPTION,
                        COMMENTS,
                        SERVICE_REQUEST_TEMPLATE_ID,
                        TYPE_CODE,
                        TYPE,
                        DOWN_TIME,
                        --CHANDANK, 29-Sep-2010, added supplier warranty Name and ID for supplier warranty project
                        WARRANTY_TEMPLATE_ID,
                        WARRANTY_TEMPLATE_NAME,
                        UOM_CODE,
                        UOM,
                        SPACE_CATEGORY_CODE,
                        SPACE_CATEGORY,
                        --sareepar service category rank
                        SERVICE_CATEGORY_RANK,
                        BILLING_ITEM_ID,
                        BILLING_ORG_ID,
                        BILLING_ITEM,
                        QA_INSPECTION_TYPE_CODE,
                        QA_INSPECTION_TYPE,
                        ATTRIBUTE_CATEGORY,
                        ATTRIBUTE1,
                        ATTRIBUTE2,
                        ATTRIBUTE3,
                        ATTRIBUTE4,
                        ATTRIBUTE5,
                        ATTRIBUTE6,
                        ATTRIBUTE7,
                        ATTRIBUTE8,
                        ATTRIBUTE9,
                        ATTRIBUTE10,
                        ATTRIBUTE11,
                        ATTRIBUTE12,
                        ATTRIBUTE13,
                        ATTRIBUTE14,
                        ATTRIBUTE15,
                        APPLICATION_USG_CODE,
                        AUTO_SIGNOFF_FLAG,
                        COPY_INIT_ACCOMPL_FLAG,
                        COPY_DEFERRALS_FLAG
        FROM AHL_MR_HEADERS_V
        WHERE MR_HEADER_ID=c_mr_header_id;

Line: 611

SELECT lookup_code
   FROM FND_LOOKUP_VALUES_VL
   WHERE lookup_code = c_lookup_code
   AND lookup_type = c_lookup_type
   AND sysdate between nvl(start_date_active,sysdate)
   AND nvl(end_date_active,sysdate)
   AND enabled_flag = 'Y';

Line: 654

SELECT lookup_code
   FROM FND_LOOKUP_VALUES_VL
   WHERE lookup_type= c_lookup_type
   AND upper(meaning) =upper(c_meaning)
   AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);

Line: 662

SELECT title,object_version_number
  FROM AHL_MR_HEADERS_APP_V
  WHERE mr_header_id= c_mr_header_id;

Line: 668

SELECT mr_header_id,title,object_version_number
  FROM AHL_MR_HEADERS_APP_V
  WHERE UPPER(TITLE)=UPPER(LTRIM(RTRIM(c_title)))
  AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);

Line: 675

SELECT COUNT(*)
  FROM AHL_MR_HEADERS_APP_V
  WHERE UPPER(TITLE)=UPPER(c_title)
  AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);

Line: 682

SELECT mr_header_id,title,object_version_number,revision
  FROM AHL_MR_HEADERS_APP_V
  WHERE MR_HEADER_ID=C_MR_HEADER_ID
  AND trunc(nvl(effective_to,sysdate+1)) >trunc(sysdate);

Line: 691

 SELECT inventory_item_id
  FROM mtl_system_items_kfv
   WHERE STOCK_ENABLED_FLAG='N'
   AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
   AND concatenated_segments= ltrim(rtrim(c_billing_item))
   and rownum <2;

Line: 701

 SELECT warranty_template_id
  FROM AHL_WARRANTY_TEMPLATES_B
   WHERE ENABLED_FLAG='Y'
   AND upper(name) = upper(ltrim(rtrim(c_warranty_template_name)))
   and rownum <2;

Line: 708

 /*SELECT inventory_item_id
  FROM mtl_system_items_kfv
   WHERE STOCK_ENABLED_FLAG='N'
   AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
   AND upper(concatenated_segments)= upper(ltrim(rtrim(c_billing_item)))
   and rownum <2;*/

Line: 717

  SELECT short_code
  FROM qa_char_value_lookups_v
  WHERE char_id = 87
  AND upper(description) = upper(ltrim(rtrim(p_qa_inspection_type_desc)));

Line: 884

                Select count(*) INTO l_check_impl_status
                From AHL_MR_HEADERS_B
                WHERE Implement_status_code = 'OPTIONAL_DO_NOT_IMPLEMENT'
                AND   MR_HEADER_ID=p_x_mr_header_rec.MR_HEADER_ID;

Line: 892

                        Select count(*) INTO l_check_impl_status
                        From  AHL_MR_VISIT_TYPES
                        WHERE MR_HEADER_ID=p_x_mr_header_rec.MR_HEADER_ID;

Line: 962

                                FND_MESSAGE.SET_NAME('AHL','AHL_FMP_PREC_MR_ID_SELECT_LOV');

Line: 981

                select version_number into p_x_mr_header_rec.version_number
                from AHL_MR_HEADERS_APP_V
                where mr_header_id=p_x_mr_header_rec.mr_header_id;

Line: 1020

           SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id AND (relationship_code = 'LOOP' OR (relationship_code ='CHAIN' AND sequence_number <> 1)) ;

Line: 1035

           SELECT COUNT(*) INTO l_loop_chain_count FROM ahl_mr_loop_chain_relns WHERE mr_header_id = p_x_mr_header_rec.mr_header_id;

Line: 1056

SELECT * FROM AHL_MR_HEADERS_APP_V
WHERE MR_HEADER_ID=C_MR_HEADER_ID;

Line: 1077

                                        SELECT COUNT(*) INTO l_counter
                                        FROM AHL_MR_RELATIONSHIPS
                                        WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
                                        AND   RELATIONSHIP_CODE = 'PARENT';

Line: 1087

                                        SELECT COUNT(*) INTO l_counter
                                        FROM AHL_MR_EFFECTIVITIES
                                        WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
                                        AND ((PROGRAM_DURATION IS NOT NULL OR PROGRAM_DURATION_UOM_CODE IS NOT NULL)
                                        AND THRESHOLD_DATE  IS NOT NULL);

Line: 1100

                                        SELECT COUNT(B.MR_INTERVAL_ID) INTO l_counter
                                        FROM AHL_MR_EFFECTIVITIES A,AHL_MR_INTERVALS B
                                        WHERE A.MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID
                                        AND A.MR_EFFECTIVITY_ID=B.MR_EFFECTIVITY_ID;

Line: 1114

                                        SELECT COUNT(*) INTO l_counter
                                        FROM AHL_MR_ROUTES
                                        WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID;

Line: 1124

                                        SELECT COUNT(*) INTO l_counter
                                        FROM AHL_MR_ACTIONS_B
                                        WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID;

Line: 1133

                                        SELECT COUNT(*) INTO l_counter
                                        FROM AHL_DOC_TITLE_ASSOS_B
                                        WHERE ASO_OBJECT_ID=p_mr_header_rec.MR_HEADER_ID
                                        AND   ASO_OBJECT_TYPE_CODE='MR';

Line: 1159

SELECT lookup_code
   FROM FND_LOOKUP_VALUES_VL
   WHERE lookup_type= c_lookup_type
   AND upper(meaning) =upper(c_meaning)
   AND sysdate between start_date_active
   AND nvl(end_date_active,sysdate);

Line: 1168

SELECT title,object_version_number
  FROM AHL_MR_HEADERS_APP_V
  WHERE mr_header_id= c_mr_header_id;

Line: 1175

 SELECT count(*)
  FROM AHL_PROG_TYPE_SUBTYPES
  WHERE
  PROGRAM_TYPE_CODE =C_PROGRAM_TYPE_CODE  AND
  PROGRAM_SUBTYPE_CODE=C_PROGRAM_SUBTYPE_CODE;

Line: 1185

  SELECT
   mr.implement_status_code,
   mr.repetitive_flag,
   mr.show_repetitive_code,
   mr.whichever_first_code,
   mr.effective_from,
   mr.copy_accomplishment_flag,
   mr.type_code,
   mtl.concatenated_segments billing_item,
   mr.billing_item_id,
   mr.qa_inspection_type qa_inspection_type_code,
   qa.description    qa_inspection_type,
   mr.space_category_code,
   mr.down_time,
   mr.uom_code
 FROM
   ahl_mr_headers_b mr,
   qa_char_value_lookups qa,
   mtl_system_items_kfv mtl
 WHERE
   mr_header_id= c_mr_header_id AND
   qa.short_code(+) = mr.qa_inspection_type AND
   qa.char_id(+) =    87 AND
   mtl.inventory_item_id(+) = mr.billing_item_id AND
   mtl.organization_id(+) =    mr.billing_org_id AND
   mr.application_usg_code =
   RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE')));

Line: 1213

 /*SELECT IMPLEMENT_STATUS_CODE,
        REPETITIVE_FLAG,
        SHOW_REPETITIVE_CODE,
        WHICHEVER_FIRST_CODE,
        EFFECTIVE_FROM,
        COPY_ACCOMPLISHMENT_FLAG,
        TYPE_CODE,
        BILLING_ITEM,
        BILLING_ITEM_ID,
        QA_INSPECTION_TYPE_CODE,
        QA_INSPECTION_TYPE,
        SPACE_CATEGORY_CODE,
        DOWN_TIME,
        UOM_CODE
 FROM   AHL_MR_HEADERS_V
 WHERE mr_header_id= c_mr_header_id;*/

Line: 1234

 SELECT MR_HEADER_ID,
        TITLE,
        VERSION_NUMBER,
        MR_STATUS_CODE,
        EFFECTIVE_FROM
 FROM AHL_MR_HEADERS_APP_V
 WHERE MR_HEADER_ID=C_MR_HEADER_ID
 AND object_version_number=p_mr_header_rec.object_Version_number;

Line: 1248

 SELECT MR_HEADER_ID,TITLE,VERSION_NUMBER,MR_STATUS_CODE,EFFECTIVE_FROM
 FROM AHL_MR_HEADERS_APP_V
 WHERE upper(TITLE)=upper(C_TITLE)
 and version_number=c_version_number-1;

Line: 1275

    select  'x'
    from    ahl_mr_routes mrr, ahl_routes_b rm
    where   mrr.route_id = rm.route_id and
            nvl(rm.route_type_code, 'X') not in ('M_PROC','O_PROC') and
            mrr.mr_header_id = c_mr_header_id;

Line: 1286

    select  'x'
    from    ahl_mr_effectivities
    where   mr_header_id = c_mr_header_id;

Line: 1300

    select  'x'
    from    ahl_mr_relationships
    where   relationship_code <> 'PARENT'
    and     (mr_header_id = c_mr_header_id
    or      related_mr_header_id = c_mr_header_id);

Line: 1311

    select  'x'
    from    AHL_SB_POSITION_RULES
    where   mr_header_id = c_mr_header_id;

Line: 1319

  select 'x'
  from  AHL_MR_RELATIONSHIPS
  where relationship_code = 'PARENT'
  and  (MR_HEADER_ID=c_mr_header_id or RELATED_MR_HEADER_ID=c_mr_header_id);

Line: 1326

  select 'x'
  from   AHL_MR_LOOP_CHAIN_RELNS
  where  MR_HEADER_ID= c_mr_header_id
  and    relationship_code = c_relationship_code;

Line: 1336

  SELECT COUNT(*)
  FROM   AHL_MR_VISIT_TYPES
  WHERE  mr_header_id = c_mr_header_id;

Line: 1803

           SELECT COUNT(*) INTO l_title_counter
                  FROM AHL_MR_HEADERS_APP_V
                  WHERE upper(ltrim(rtrim(TITLE)))=upper(ltrim(rtrim(l_mr_header_rec.title)));

Line: 1879

        SELECT program_type_code INTO l_old_prog_type FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_rec.mr_header_id;

Line: 1912

        SELECT program_type_code INTO l_old_prog_type FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_rec.mr_header_id;

Line: 1985

        SELECT implement_status_code INTO l_old_impl_status FROM ahl_mr_headers_b WHERE mr_header_id = p_mr_header_rec.mr_header_id;

Line: 2034

        SELECT COUNT(*) INTO l_counter
        FROM  AHL_MR_HEADERS_B
        WHERE APPLICATION_USG_CODE=G_APPLN_USAGE
        START WITH MR_HEADER_ID=P_MR_HEADER_ID
        CONNECT BY PRIOR MR_HEADER_ID=PRECEDING_MR_HEADER_ID;

Line: 2200

         select AHL_MR_HEADERS_B_S.NEXTVAL INTO p_x_mr_header_rec.mr_header_id  from dual;

Line: 2209

         AHL_MR_HEADERS_PKG.INSERT_ROW (
          X_MR_HEADER_ID                        =>p_x_mr_header_rec.mr_header_id,
          X_OBJECT_VERSION_NUMBER               =>1,
          X_TITLE                               =>p_x_mr_header_rec.TITLE,
          X_VERSION_NUMBER                      =>1,
          X_EFFECTIVE_FROM                      =>p_x_mr_header_rec.EFFECTIVE_FROM,
          X_EFFECTIVE_TO                        =>NULL,
          X_REVISION                            =>p_x_mr_header_rec.REVISION,
          X_CATEGORY_CODE                       =>p_x_mr_header_rec.CATEGORY_CODE,
          X_SERVICE_TYPE_CODE                   =>p_x_mr_header_rec.SERVICE_TYPE_CODE,
          X_MR_STATUS_CODE                      =>p_x_mr_header_rec.MR_STATUS_CODE,
          X_IMPLEMENT_STATUS_CODE               =>p_x_mr_header_rec.IMPLEMENT_STATUS_CODE,
          X_REPETITIVE_FLAG                     =>p_x_mr_header_rec.REPETITIVE_FLAG,
          X_SHOW_REPETITIVE_CODE                =>p_x_mr_header_rec.SHOW_REPETITIVE_CODE,
          X_WHICHEVER_FIRST_CODE                =>p_x_mr_header_rec.WHICHEVER_FIRST_CODE,
          X_COPY_ACCOMPLISHMENT_FLAG            =>nvl(p_x_mr_header_rec.COPY_ACCOMPLISHMENT_FLAG,'N'),
          X_PROGRAM_TYPE_CODE                   =>p_x_mr_header_rec.PROGRAM_TYPE_CODE ,
          X_PROGRAM_SUBTYPE_CODE                =>p_x_mr_header_rec.PROGRAM_SUBTYPE_CODE,
          X_ATTRIBUTE_CATEGORY                  =>p_x_mr_header_rec.ATTRIBUTE_CATEGORY,
          X_PRECEDING_MR_HEADER_ID              =>p_x_mr_header_rec.PRECEDING_MR_HEADER_ID,
          X_SERVICE_REQUEST_TEMPLATE_ID         =>p_x_mr_header_rec.SERVICE_REQUEST_TEMPLATE_ID,
          X_TYPE_CODE                           =>p_x_mr_header_rec.TYPE_CODE,
          X_DOWN_TIME                           =>p_x_mr_header_rec.DOWN_TIME,
          --CHANDANK, 29-Sep-2010, added supplier warranty ID for supplier warranty project
          X_WARRANTY_TEMPLATE_ID                =>p_x_mr_header_rec.WARRANTY_TEMPLATE_ID,
          X_UOM_CODE                            =>p_x_mr_header_rec.UOM_CODE,
          X_DESCRIPTION                         =>p_x_mr_header_rec.DESCRIPTION,
          X_COMMENTS                            =>p_x_mr_header_rec.COMMENTS,
          X_SPACE_CATEGORY_CODE                 =>p_x_mr_header_rec.SPACE_CATEGORY_CODE,
          --sareepar SERVICE CATEGORY RANK
          X_SERVICE_CATEGORY_RANK               =>p_x_mr_header_rec.SERVICE_CATEGORY_RANK,
          X_QA_INSPECTION_TYPE_CODE             =>p_x_mr_header_rec.QA_INSPECTION_TYPE_CODE,
          X_BILLING_ITEM_ID                     =>p_x_mr_header_rec.BILLING_ITEM_ID,
          X_AUTO_SIGNOFF_FLAG                   =>nvl(p_x_mr_header_rec.AUTO_SIGNOFF_FLAG,'N'),
          X_COPY_INIT_ACCOMPL_FLAG              =>nvl(p_x_mr_header_rec.COPY_INIT_ACCOMPL_FLAG,'N'),
          X_COPY_DEFERRALS_FLAG                 =>nvl(p_x_mr_header_rec.COPY_DEFERRALS_FLAG,'N'),
          X_ATTRIBUTE1                          =>p_x_mr_header_rec.ATTRIBUTE1,
          X_ATTRIBUTE2                          =>p_x_mr_header_rec.ATTRIBUTE2,
          X_ATTRIBUTE3                          =>p_x_mr_header_rec.ATTRIBUTE3,
          X_ATTRIBUTE4                          =>p_x_mr_header_rec.ATTRIBUTE4,
          X_ATTRIBUTE5                          =>p_x_mr_header_rec.ATTRIBUTE5,
          X_ATTRIBUTE6                          =>p_x_mr_header_rec.ATTRIBUTE6,
          X_ATTRIBUTE7                          =>p_x_mr_header_rec.ATTRIBUTE7,
          X_ATTRIBUTE8                          =>p_x_mr_header_rec.ATTRIBUTE8,
          X_ATTRIBUTE9                          =>p_x_mr_header_rec.ATTRIBUTE9,
          X_ATTRIBUTE10                         =>p_x_mr_header_rec.ATTRIBUTE10,
          X_ATTRIBUTE11                         =>p_x_mr_header_rec.ATTRIBUTE11,
          X_ATTRIBUTE12                         =>p_x_mr_header_rec.ATTRIBUTE12,
          X_ATTRIBUTE13                         =>p_x_mr_header_rec.ATTRIBUTE13,
          X_ATTRIBUTE14                         =>p_x_mr_header_rec.ATTRIBUTE14,
          X_ATTRIBUTE15                         =>p_x_mr_header_rec.ATTRIBUTE15,
          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.user_id);

Line: 2313

 PROCEDURE UPDATE_MR_HEADER
 (
 p_api_version               IN         NUMBER:=1.0,
 p_init_msg_list             IN         VARCHAR2:=FND_API.G_FALSE,
 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_x_mr_header_rec           IN OUT     NOCOPY  MR_HEADER_REC)
as
 l_api_name     CONSTANT VARCHAR2(30) := 'UPDATE_MR_HEADER';

Line: 2334

        SAVEPOINT UPDATE_MR_HEADER_PVT;

Line: 2454

        AHL_MR_HEADERS_PKG.UPDATE_ROW (
          X_MR_HEADER_ID                        =>p_x_mr_header_rec.mr_header_id,
          X_OBJECT_VERSION_NUMBER               =>p_x_mr_header_rec.object_version_number,
          X_CATEGORY_CODE                       =>p_x_mr_header_rec.CATEGORY_CODE,
          X_SERVICE_TYPE_CODE                   =>p_x_mr_header_rec.SERVICE_TYPE_CODE,
          X_MR_STATUS_CODE                      =>p_x_mr_header_rec.MR_STATUS_CODE,
          X_IMPLEMENT_STATUS_CODE               =>p_x_mr_header_rec.IMPLEMENT_STATUS_CODE,
          X_REPETITIVE_FLAG                     =>p_x_mr_header_rec.REPETITIVE_FLAG,
          X_SHOW_REPETITIVE_CODE                =>p_x_mr_header_rec.SHOW_REPETITIVE_CODE,
          X_WHICHEVER_FIRST_CODE                =>p_x_mr_header_rec.WHICHEVER_FIRST_CODE,
          X_COPY_ACCOMPLISHMENT_FLAG            =>p_x_mr_header_rec.COPY_ACCOMPLISHMENT_FLAG,
          X_PROGRAM_TYPE_CODE                   =>p_x_mr_header_rec.PROGRAM_TYPE_CODE ,
          X_PROGRAM_SUBTYPE_CODE                =>p_x_mr_header_rec.PROGRAM_SUBTYPE_CODE,
          X_EFFECTIVE_FROM                      =>p_x_mr_header_rec.EFFECTIVE_FROM,
          X_EFFECTIVE_TO                        =>NVL(p_x_mr_header_rec.EFFECTIVE_TO,NULL),
          X_REVISION                            =>p_x_mr_header_rec.REVISION,
          X_ATTRIBUTE_CATEGORY                  =>p_x_mr_header_rec.ATTRIBUTE_CATEGORY,
          X_ATTRIBUTE1                          =>p_x_mr_header_rec.ATTRIBUTE1,
          X_ATTRIBUTE2                          =>p_x_mr_header_rec.ATTRIBUTE2,
          X_ATTRIBUTE3                          =>p_x_mr_header_rec.ATTRIBUTE3,
          X_ATTRIBUTE4                          =>p_x_mr_header_rec.ATTRIBUTE4,
          X_ATTRIBUTE5                          =>p_x_mr_header_rec.ATTRIBUTE5,
          X_ATTRIBUTE6                          =>p_x_mr_header_rec.ATTRIBUTE6,
          X_ATTRIBUTE7                          =>p_x_mr_header_rec.ATTRIBUTE7,
          X_ATTRIBUTE8                          =>p_x_mr_header_rec.ATTRIBUTE8,
          X_ATTRIBUTE9                          =>p_x_mr_header_rec.ATTRIBUTE9,
          X_ATTRIBUTE10                         =>p_x_mr_header_rec.ATTRIBUTE10,
          X_ATTRIBUTE11                         =>p_x_mr_header_rec.ATTRIBUTE11,
          X_ATTRIBUTE12                         =>p_x_mr_header_rec.ATTRIBUTE12,
          X_ATTRIBUTE13                         =>p_x_mr_header_rec.ATTRIBUTE13,
          X_ATTRIBUTE14                         =>p_x_mr_header_rec.ATTRIBUTE14,
          X_ATTRIBUTE15                         =>p_x_mr_header_rec.ATTRIBUTE15,
          X_TITLE                               =>p_x_mr_header_rec.TITLE,
          X_VERSION_NUMBER                      =>p_x_mr_header_rec.VERSION_NUMBER,
          -- pdoki, Preceding MR Header ID is obsoleted after SBE Project.
          X_PRECEDING_MR_HEADER_ID              =>p_x_mr_header_rec.PRECEDING_MR_HEADER_ID,
          X_SERVICE_REQUEST_TEMPLATE_ID         =>p_x_mr_header_rec.SERVICE_REQUEST_TEMPLATE_ID,
          X_TYPE_CODE                           =>p_x_mr_header_rec.TYPE_CODE,
          X_DOWN_TIME                           =>p_x_mr_header_rec.DOWN_TIME,
          --CHANDANK, 29-Sep-2010, added supplier warranty ID for supplier warranty project
          X_WARRANTY_TEMPLATE_ID                =>p_x_mr_header_rec.WARRANTY_TEMPLATE_ID,
          X_UOM_CODE                            =>p_x_mr_header_rec.UOM_CODE,
          X_DESCRIPTION                         =>p_x_mr_header_rec.DESCRIPTION,
          X_COMMENTS                            =>p_x_mr_header_rec.COMMENTS,
          X_SPACE_CATEGORY_CODE                 =>p_x_mr_header_rec.SPACE_CATEGORY_CODE,
          --sareepar SERVICE CATEGORY RANK
          X_SERVICE_CATEGORY_RANK               =>p_x_mr_header_rec.SERVICE_CATEGORY_RANK,
          X_QA_INSPECTION_TYPE_CODE             =>p_x_mr_header_rec.QA_INSPECTION_TYPE_CODE,
          X_BILLING_ITEM_ID                     =>p_x_mr_header_rec.BILLING_ITEM_ID,
          X_AUTO_SIGNOFF_FLAG                   =>p_x_mr_header_rec.AUTO_SIGNOFF_FLAG,
          X_COPY_INIT_ACCOMPL_FLAG              =>p_x_mr_header_rec.COPY_INIT_ACCOMPL_FLAG,
          X_COPY_DEFERRALS_FLAG                 =>p_x_mr_header_rec.COPY_DEFERRALS_FLAG,
          X_LAST_UPDATE_DATE                    =>sysdate,
          X_LAST_UPDATED_BY                     =>fnd_global.user_id,
          X_LAST_UPDATE_LOGIN                   =>fnd_global.user_id);

Line: 2561

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2571

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2580

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2608

 SELECT
   mr_status_code
 FROM
   ahl_mr_headers_b
 WHERE
   application_usg_code = RTRIM(LTRIM(fnd_profile.value('AHL_APPLN_USAGE'))) AND
   mr_header_id=C_MR_HEADER_ID AND
   object_version_number=C_OBJECT_VERSION_NUMBER;

Line: 2617

/*SELECT MR_STATUS_CODE
FROM AHL_MR_HEADERS_V
WHERE MR_HEADER_ID=C_MR_HEADER_ID
AND OBJECT_VERSION_NUMBER=C_OBJECT_VERSION_NUMBER;*/

Line: 2665

 PROCEDURE DELETE_MR_HEADER
 (
 p_api_version               IN         NUMBER:=1.0,
 p_init_msg_list             IN         VARCHAR2:=FND_API.G_FALSE,
 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_mr_header_id              IN                 NUMBER,
 p_object_version_number     IN                 NUMBER)
as
 l_api_name     CONSTANT VARCHAR2(30) := 'DELETE_MR_HEADER';

Line: 2688

 Select * from ahl_mr_Routes
 Where mr_header_id=c_mr_header_id;

Line: 2694

 Select * from ahl_mr_Effectivities
 Where mr_header_id=c_mr_header_id;

Line: 2700

 Select * from ahl_mr_effectivity_dtls
 Where mr_effectivity_id=c_mr_effectivity_id;

Line: 2705

 Select * from ahl_mr_intervals
 Where mr_effectivity_id=c_mr_effectivity_id;

Line: 2710

 Select * from AHL_DOC_TITLE_ASSOS_B
 Where  ASO_OBJECT_ID=C_MR_HEADER_ID
 And    ASO_OBJECT_TYPE_CODE='MR';

Line: 2718

 SELECT * FROM ahl_mr_loop_chain_relns WHERE
 mr_relationship_id IN
    (SELECT mr_relationship_id
    FROM ahl_mr_loop_chain_relns
    WHERE mr_header_id = p_mr_header_id_csr
    AND mr_relationship_id <> start_mr_relationship_id
    );

Line: 2732

SELECT title
  FROM AHL_MR_HEADERS_B
  WHERE mr_header_id= c_mr_header_id;

Line: 2743

        SAVEPOINT DELETE_MR_HEADER_PVT;

Line: 2765

         AHL_DEBUG_PUB.debug( 'AHL_FMP_MR_HEADERS_PVT.','+DELETE_MR_HEADER+');

Line: 2794

        Delete AHL_MR_ROUTE_SEQUENCES
        WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id or
        RELATED_MR_ROUTE_ID=l_mr_route_rec.mr_route_id;

Line: 2798

        Delete AHL_MR_ROUTES
        WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id;

Line: 2811

        Delete AHL_MR_EFFECTIVITY_DTLS
        Where MR_effectivity_id=l_mr_effect_rec.MR_EFFECTIVITY_ID;

Line: 2814

        Delete AHL_MR_INTERVALS
        Where MR_effectivity_id=l_mr_effect_rec.mr_effectivity_id;

Line: 2816

        Delete AHL_MR_EFFECTIVITIES
        Where mr_effectivity_id=l_mr_effect_rec.mr_effectivity_id;

Line: 2828

              Delete from AHL_DOC_TITLE_ASSOS_TL
              Where DOC_TITLE_ASSO_ID    = l_mr_doc_rec.DOC_TITLE_ASSO_ID;

Line: 2831

              Delete from AHL_DOC_TITLE_ASSOS_B
              Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;

Line: 2840

    Delete AHL_MR_RELATIONSHIPS
    Where mr_header_id=p_mr_header_id
    or RELATED_MR_HEADER_ID=P_MR_HEADER_ID;

Line: 2846

    DELETE FROM AHL_MR_LOOP_CHAIN_RELNS
    WHERE
    start_mr_relationship_id IN
      (SELECT mr_relationship_id
      FROM ahl_mr_loop_chain_relns
      WHERE mr_header_id = P_MR_HEADER_ID
      );

Line: 2856

      SELECT COUNT(sequence_number) INTO l_seq_count FROM ahl_mr_loop_chain_relns WHERE sequence_number = l_mr_loop_chain_rel_rec.sequence_number AND start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;

Line: 2859

        DELETE FROM ahl_mr_loop_chain_relns WHERE start_mr_relationship_id = l_mr_loop_chain_rel_rec.start_mr_relationship_id;

Line: 2862

        DELETE FROM ahl_mr_loop_chain_relns WHERE mr_relationship_id = l_mr_loop_chain_rel_rec.mr_relationship_id;

Line: 2871

    select program_type_code
    into l_program_type
    from ahl_mr_headers_b
    where mr_header_id = p_mr_header_id;

Line: 2878

        AHL_SB_RULES_PVT.Delete_Rules_For_MR
      (
            p_api_version                 =>  1.0,
            p_commit                      =>  FND_API.G_FALSE,
            p_mr_header_id                =>  p_mr_header_id,
            x_return_status               =>  x_return_status,
            x_msg_count                   =>  x_msg_count,
            x_msg_data                    =>  x_msg_data
     );

Line: 2901

        Delete from AHL_MR_ORGANIZATIONS
              Where MR_TITLE = l_mr_title;

Line: 2917

        AHL_MR_HEADERS_PKG.DELETE_ROW
        (
        X_MR_HEADER_ID  =>p_mr_header_id
        );

Line: 2938

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2948

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2958

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2973

END DELETE_MR_HEADER;