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,
                        PRECEDING_MR_HEADER_ID,
                        PRECEDING_MR_TITLE,
                        PRECEDING_MR_REVISION,
                        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,
                        UOM_CODE,
                        UOM,
                        SPACE_CATEGORY_CODE,
                        SPACE_CATEGORY,
                        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: 575

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

Line: 601

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

SELECT title,object_version_number
  FROM AHL_MR_HEADERS_APP_V
  WHERE mr_header_id= c_mr_header_id;

Line: 615

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

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

Line: 629

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

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

 /*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: 654

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

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

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

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

Line: 910

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

SELECT * FROM AHL_MR_HEADERS_APP_V
WHERE MR_HEADER_ID=C_MR_HEADER_ID;

Line: 948

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

Line: 957

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

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

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

Line: 994

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

Line: 1003

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

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

SELECT title,object_version_number
  FROM AHL_MR_HEADERS_APP_V
  WHERE mr_header_id= c_mr_header_id;

Line: 1045

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

Line: 1055

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

 /*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: 1104

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

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

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

    select  'x'
    from    ahl_mr_effectivities
    where   mr_header_id = c_mr_header_id;

Line: 1593

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

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

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

         select AHL_MR_HEADERS_B_S.NEXTVAL INTO p_x_mr_header_rec.mr_header_id  from dual;

Line: 1880

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

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

        SAVEPOINT UPDATE_MR_HEADER_PVT;

Line: 2117

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

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2227

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2236

    ROLLBACK TO UPDATE_MR_HEADER_PVT;

Line: 2264

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

/*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: 2321

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

 Select * from ahl_mr_Routes
 Where mr_header_id=c_mr_header_id;

Line: 2350

 Select * from ahl_mr_Effectivities
 Where mr_header_id=c_mr_header_id;

Line: 2356

 Select * from ahl_mr_effectivity_dtls
 Where mr_effectivity_id=c_mr_effectivity_id;

Line: 2361

 Select * from ahl_mr_intervals
 Where mr_effectivity_id=c_mr_effectivity_id;

Line: 2366

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

Line: 2372

        SAVEPOINT DELETE_MR_HEADER_PVT;

Line: 2394

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

Line: 2423

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

        Delete AHL_MR_ROUTES
        WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id;

Line: 2440

        Delete AHL_MR_EFFECTIVITY_DTLS
        Where MR_effectivity_id=l_mr_effect_rec.MR_EFFECTIVITY_ID;

Line: 2443

        Delete AHL_MR_INTERVALS
        Where MR_effectivity_id=l_mr_effect_rec.mr_effectivity_id;

Line: 2445

        Delete AHL_MR_EFFECTIVITIES
        Where mr_effectivity_id=l_mr_effect_rec.mr_effectivity_id;

Line: 2457

              Delete from AHL_DOC_TITLE_ASSOS_TL
              Where DOC_TITLE_ASSO_ID    = l_mr_doc_rec.DOC_TITLE_ASSO_ID;

Line: 2460

              Delete from AHL_DOC_TITLE_ASSOS_B
              Where DOC_TITLE_ASSO_ID = l_mr_doc_rec.DOC_TITLE_ASSO_ID;

Line: 2469

    Delete AHL_MR_RELATIONSHIPS
    Where mr_header_id=p_mr_header_id
    or RELATED_MR_HEADER_ID=P_MR_HEADER_ID;

Line: 2481

        AHL_MR_HEADERS_PKG.DELETE_ROW
        (
        X_MR_HEADER_ID  =>p_mr_header_id
        );

Line: 2502

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2512

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2522

    ROLLBACK TO DELETE_MR_HEADER_PVT;

Line: 2537

END DELETE_MR_HEADER;