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.OKL_AM_TERMNT_INTERFACE_PVT SQL Statements

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

Line: 122


              SELECT name
              FROM   hr_operating_units
              WHERE  organization_id = l_org_id;

Line: 128


              SELECT meaning
              FROM FND_LOOKUPS
              WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';

Line: 134


              SELECT meaning
              FROM FND_LOOKUPS
              WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line: 492


  SELECT DISTINCT(quote_type_code) quote_type
  FROM OKL_TERMNT_INTERFACE
  WHERE status = 'ENTERED' AND quote_type_code IS NOT NULL;

Line: 498


  SELECT COUNT(lookup_code) code
  FROM FND_LOOKUPS
  WHERE lookup_code = p_quote_type AND lookup_type = 'OKL_QUOTE_TYPE' AND enabled_flag = 'Y';

Line: 504


  SELECT DISTINCT(quote_reason_code) quote_reason
  FROM OKL_TERMNT_INTERFACE
  WHERE status = 'ENTERED' AND quote_reason_code IS NOT NULL;

Line: 510


  SELECT COUNT(lookup_code) code
  FROM FND_LOOKUPS
  WHERE lookup_code = p_quote_reason AND lookup_type = 'OKL_QUOTE_REASON' AND enabled_flag = 'Y';

Line: 824


    	   SELECT id,sts_code,authoring_org_id
           FROM okc_k_headers_b
           WHERE contract_number=p_chr_no;

Line: 832


           SELECT oklv.id id, oklv.name num, oklv.sts_code status, oklv.item_description description
           FROM okc_k_lines_v  oklv, okc_line_styles_v ols
           WHERE oklv.chr_id= p_chr_id
           AND ((oklv.name = p_ast_number)
           OR  (oklv.id = p_ast_id))
           AND oklv.lse_id=ols.id
           AND ols.lty_code = 'FREE_FORM1';

Line: 842


           SELECT oklv.id id
           FROM okc_k_lines_v  oklv, okc_line_styles_v ols
           WHERE oklv.cle_id = p_ast_id
           AND oklv.lse_id=ols.id
           AND ols.lty_code = 'FREE_FORM2';

Line: 849


           SELECT oklv.id id
           FROM okc_k_lines_v  oklv, okc_line_styles_v ols
           WHERE oklv.cle_id = p_instance_id
           AND oklv.lse_id=ols.id
           AND ols.lty_code = 'INST_ITEM';

Line: 856


           SELECT oiiv.serial_number sno
           FROM okc_k_items_v okiv,okx_install_items_v oiiv
           WHERE okiv.cle_id = p_installbase_id
           AND okiv.object1_id1=oiiv.instance_id;

Line: 862


           SELECT current_units quantity
           FROM OKX_ASSETS_V
           WHERE asset_number = p_asset_number;

Line: 1286


    PROCEDURE update_row(p_api_version    IN NUMBER,
                         p_init_msg_list  IN VARCHAR2,
                         x_msg_count      OUT NOCOPY NUMBER,
                         x_msg_data       OUT NOCOPY VARCHAR2,
                         x_return_status  OUT NOCOPY VARCHAR2,
                         p_tif_rec        IN tif_rec_type) IS
    l_api_version            CONSTANT NUMBER       := p_api_version;

Line: 1312


    UPDATE  OKL_TERMNT_INTERFACE
    SET
       OKL_TERMNT_INTERFACE.TRANSACTION_NUMBER             = p_tif_rec.transaction_number
      ,OKL_TERMNT_INTERFACE.BATCH_NUMBER                   = p_tif_rec.batch_number
      ,OKL_TERMNT_INTERFACE.CONTRACT_ID                    = p_tif_rec.contract_id
      ,OKL_TERMNT_INTERFACE.CONTRACT_NUMBER                = p_tif_rec.contract_number
      ,OKL_TERMNT_INTERFACE.ASSET_ID                       = p_tif_rec.asset_id
      ,OKL_TERMNT_INTERFACE.ASSET_NUMBER                   = p_tif_rec.asset_number
      ,OKL_TERMNT_INTERFACE.ASSET_DESCRIPTION              = p_tif_rec.asset_description
      ,OKL_TERMNT_INTERFACE.SERIAL_NUMBER                  = p_tif_rec.serial_number
      ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM                    = p_tif_rec.orig_system
      ,OKL_TERMNT_INTERFACE.ORIG_SYSTEM_REFERENCE          = p_tif_rec.orig_system_reference
      ,OKL_TERMNT_INTERFACE.UNITS_TO_TERMINATE             = p_tif_rec.units_to_terminate
      ,OKL_TERMNT_INTERFACE.COMMENTS                       = p_tif_rec.comments
      ,OKL_TERMNT_INTERFACE.DATE_PROCESSED                 = p_tif_rec.date_processed
      ,OKL_TERMNT_INTERFACE.DATE_EFFECTIVE_FROM            = p_tif_rec.date_effective_from
      ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_EMAIL = p_tif_rec.termination_notification_email
      ,OKL_TERMNT_INTERFACE.TERMINATION_NOTIFICATION_YN    = p_tif_rec.termination_notification_yn
      ,OKL_TERMNT_INTERFACE.AUTO_ACCEPT_YN                 = p_tif_rec.auto_accept_yn
      ,OKL_TERMNT_INTERFACE.QUOTE_TYPE_CODE                = p_tif_rec.quote_type_code
      ,OKL_TERMNT_INTERFACE.QUOTE_REASON_CODE              = p_tif_rec.quote_reason_code
      ,OKL_TERMNT_INTERFACE.QTE_ID                         = p_tif_rec.qte_id
      ,OKL_TERMNT_INTERFACE.STATUS                         = p_tif_rec.status
      ,OKL_TERMNT_INTERFACE.ORG_ID                         = p_tif_rec.org_id
      ,OKL_TERMNT_INTERFACE.REQUEST_ID                     = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tif_rec.request_id)
      ,OKL_TERMNT_INTERFACE.PROGRAM_APPLICATION_ID         = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tif_rec.program_application_id)
      ,OKL_TERMNT_INTERFACE.PROGRAM_ID                     = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tif_rec.program_id)
      ,OKL_TERMNT_INTERFACE.PROGRAM_UPDATE_DATE            = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tif_rec.program_update_date,SYSDATE)
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE_CATEGORY             = p_tif_rec.attribute_category
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE1                     = p_tif_rec.attribute1
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE2                     = p_tif_rec.attribute2
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE3                     = p_tif_rec.attribute3
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE4                     = p_tif_rec.attribute4
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE5                     = p_tif_rec.attribute5
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE6                     = p_tif_rec.attribute6
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE7                     = p_tif_rec.attribute7
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE8                     = p_tif_rec.attribute8
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE9                     = p_tif_rec.attribute9
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE10                    = p_tif_rec.attribute10
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE11                    = p_tif_rec.attribute11
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE12                    = p_tif_rec.attribute12
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE13                    = p_tif_rec.attribute13
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE14                    = p_tif_rec.attribute14
      ,OKL_TERMNT_INTERFACE.ATTRIBUTE15                    = p_tif_rec.attribute15
      ,OKL_TERMNT_INTERFACE.CREATED_BY                     = p_tif_rec.created_by
      ,OKL_TERMNT_INTERFACE.CREATION_DATE                  = p_tif_rec.creation_date
      ,OKL_TERMNT_INTERFACE.LAST_UPDATED_BY                = FND_GLOBAL.USER_ID
      ,OKL_TERMNT_INTERFACE.LAST_UPDATE_DATE               = SYSDATE
      ,OKL_TERMNT_INTERFACE.LAST_UPDATE_LOGIN              = FND_GLOBAL.LOGIN_ID
      ,OKL_TERMNT_INTERFACE.GROUP_NUMBER                   = p_tif_rec.group_number
    WHERE
         OKL_TERMNT_INTERFACE.ROWID =p_tif_rec.row_id;

Line: 1395


          l_msg_tbl(0).msg_text                := 'update_row:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;

Line: 1398


    END update_row;

Line: 1425


    SELECT
       ROWID
      ,TRANSACTION_NUMBER
      ,BATCH_NUMBER
      ,CONTRACT_ID
      ,CONTRACT_NUMBER
      ,ASSET_ID
      ,ASSET_NUMBER
      ,ASSET_DESCRIPTION
      ,SERIAL_NUMBER
      ,ORIG_SYSTEM
      ,ORIG_SYSTEM_REFERENCE
      ,UNITS_TO_TERMINATE
      ,COMMENTS
      ,DATE_PROCESSED
      ,DATE_EFFECTIVE_FROM
      ,TERMINATION_NOTIFICATION_EMAIL
      ,TERMINATION_NOTIFICATION_YN
      ,AUTO_ACCEPT_YN
      ,QUOTE_TYPE_CODE
      ,QUOTE_REASON_CODE
      ,QTE_ID
      ,STATUS
      ,ORG_ID
      ,REQUEST_ID
      ,PROGRAM_APPLICATION_ID
      ,PROGRAM_ID
      ,PROGRAM_UPDATE_DATE
      ,ATTRIBUTE_CATEGORY
      ,ATTRIBUTE1
      ,ATTRIBUTE2
      ,ATTRIBUTE3
      ,ATTRIBUTE4
      ,ATTRIBUTE5
      ,ATTRIBUTE6
      ,ATTRIBUTE7
      ,ATTRIBUTE8
      ,ATTRIBUTE9
      ,ATTRIBUTE10
      ,ATTRIBUTE11
      ,ATTRIBUTE12
      ,ATTRIBUTE13
      ,ATTRIBUTE14
      ,ATTRIBUTE15
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
      ,GROUP_NUMBER
    FROM OKL_TERMNT_INTERFACE
    WHERE status = p_status
    ORDER BY CONTRACT_NUMBER,QUOTE_TYPE_CODE,DATE_EFFECTIVE_FROM,QUOTE_REASON_CODE,ASSET_ID;

Line: 1485


              update_row(p_api_version   => p_api_version
                        ,p_init_msg_list => OKC_API.G_FALSE
                        ,x_msg_data      => x_msg_data
                        ,x_msg_count     => x_msg_count
                        ,x_return_status => x_return_status
                        ,p_tif_rec       => p_tif_tbl(record_number));

Line: 1496


        x_tif_tbl.DELETE;

Line: 1526


        x_tif_tbl(record_number).program_update_date            :=  termnt_rec.program_update_date;

Line: 1545


        x_tif_tbl(record_number).last_updated_by                :=  termnt_rec.last_updated_by;

Line: 1546


        x_tif_tbl(record_number).last_update_date               :=  termnt_rec.last_update_date;

Line: 1547


        x_tif_tbl(record_number).last_update_login              :=  termnt_rec.last_update_login;

Line: 1601


           SELECT current_units quantity
           FROM OKX_ASSETS_V
           WHERE asset_number = p_asset_number;

Line: 1765


           SELECT oklv.id id
           FROM okc_k_lines_v  oklv, okc_line_styles_v ols
           WHERE oklv.cle_id = p_ast_id
           AND oklv.lse_id=ols.id
           AND ols.lty_code = 'FREE_FORM2';

Line: 1772


           SELECT oklv.id id
           FROM okc_k_lines_v  oklv, okc_line_styles_v ols
           WHERE oklv.cle_id = p_instance_id
           AND oklv.lse_id=ols.id
           AND ols.lty_code = 'INST_ITEM';

Line: 1779


           SELECT oiiv.serial_number sno,oiiv.quantity qty
           FROM okc_k_items_v okiv,okx_install_items_v oiiv
           WHERE okiv.cle_id = p_installbase_id
           AND okiv.object1_id1=oiiv.instance_id;

Line: 1792


          SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;

Line: 1844


                              lp_qld_tbl(qdt_counter).SELECT_YN    := 'Y';

Line: 1884


                       lp_qld_tbl.DELETE;

Line: 2129


             lp_assn_tbl.DELETE;

Line: 2130


             lp_tif_tbl.DELETE;

Line: 2132


             lx_tif_tbl.DELETE;

Line: 2185


       x_tif_tbl.DELETE;

Line: 2190


              update_row(p_api_version   => p_api_version
                        ,p_init_msg_list => OKC_API.G_FALSE
                        ,x_msg_data      => x_msg_data
                        ,x_msg_count     => x_msg_count
                        ,x_return_status => x_return_status
                        ,p_tif_rec       => x_tif_tbl(record_number));

Line: 2245


    SELECT contract_id,status
    FROM OKL_TERMNT_INTERFACE
    WHERE transaction_number = p_transaction_number;

Line: 2252


    SELECT id,object1_id1,object1_id2,jtot_object1_code
    FROM OKC_K_PARTY_ROLES_B
    WHERE  dnz_chr_id = p_chr_id
    AND chr_id = dnz_chr_id
    AND rle_code = p_role_code;

Line: 2259


    SELECT party_number,name
    FROM OKX_VENDORS_V
    WHERE id1 = p_object1_id1 AND id2 = p_object1_id2;

Line: 2265


    SELECT party_name,party_number,email_address
    FROM HZ_PARTIES
    WHERE ((party_id = p_object1_id1) AND party_type IN ( 'PERSON','ORGANIZATION'));

Line: 2561


PROCEDURE update_party(p_api_version    IN NUMBER,
                       p_init_msg_list  IN VARCHAR2,
                       x_msg_count      OUT NOCOPY NUMBER,
                       x_msg_data       OUT NOCOPY VARCHAR2,
                       x_return_status  OUT NOCOPY VARCHAR2,
                       p_tip_rec        IN tip_rec_type) IS
    l_api_version            CONSTANT NUMBER       := p_api_version;

Line: 2587


    UPDATE  OKL_TERMNT_INTF_PTY
    SET
       OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ID                = p_tip_rec.contract_party_id,
       OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_ROLE              = p_tip_rec.contract_party_role,
       OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NAME              = p_tip_rec.contract_party_name,
       OKL_TERMNT_INTF_PTY.CONTRACT_PARTY_NUMBER            = p_tip_rec.contract_party_number,
       OKL_TERMNT_INTF_PTY.PARTY_OBJECT_CODE                = p_tip_rec.party_object_code,
       OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID1                 = p_tip_rec.party_object_id1,
       OKL_TERMNT_INTF_PTY.PARTY_OBJECT_ID2                 = p_tip_rec.party_object_id2,
       OKL_TERMNT_INTF_PTY.EMAIL_ADDRESS                    = p_tip_rec.email_address,
       OKL_TERMNT_INTF_PTY.ALLOCATION_PERCENTAGE            = p_tip_rec.allocation_percentage,
       OKL_TERMNT_INTF_PTY.DELAY_DAYS                       = p_tip_rec.delay_days,
       OKL_TERMNT_INTF_PTY.QPY_ID                           = p_tip_rec.qpy_id,
       OKL_TERMNT_INTF_PTY.TRANSACTION_NUMBER               = p_tip_rec.transaction_number,
       OKL_TERMNT_INTF_PTY.STATUS                           = p_tip_rec.status,
       OKL_TERMNT_INTF_PTY.REQUEST_ID                       = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1, NULL,FND_GLOBAL.CONC_REQUEST_ID),p_tip_rec.request_id),
       OKL_TERMNT_INTF_PTY.PROGRAM_APPLICATION_ID           = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_tip_rec.program_application_id),
       OKL_TERMNT_INTF_PTY.PROGRAM_ID                       = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_tip_rec.program_id),
       OKL_TERMNT_INTF_PTY.PROGRAM_UPDATE_DATE              = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_tip_rec.program_update_date,SYSDATE),
       OKL_TERMNT_INTF_PTY.ATTRIBUTE_CATEGORY               = p_tip_rec.attribute_category,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE1                       = p_tip_rec.attribute1,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE2                       = p_tip_rec.attribute2,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE3                       = p_tip_rec.attribute3,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE4                       = p_tip_rec.attribute4,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE5                       = p_tip_rec.attribute5,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE6                       = p_tip_rec.attribute6,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE7                       = p_tip_rec.attribute7,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE8                       = p_tip_rec.attribute8,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE9                       = p_tip_rec.attribute9,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE10                      = p_tip_rec.attribute10,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE11                      = p_tip_rec.attribute11,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE12                      = p_tip_rec.attribute12,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE13                      = p_tip_rec.attribute13,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE14                      = p_tip_rec.attribute14,
       OKL_TERMNT_INTF_PTY.ATTRIBUTE15                      = p_tip_rec.attribute15,
       OKL_TERMNT_INTF_PTY.CREATED_BY                       = p_tip_rec.created_by,
       OKL_TERMNT_INTF_PTY.CREATION_DATE                    = p_tip_rec.creation_date,
       OKL_TERMNT_INTF_PTY.LAST_UPDATED_BY                  = FND_GLOBAL.USER_ID,
       OKL_TERMNT_INTF_PTY.LAST_UPDATE_DATE                 = SYSDATE,
       OKL_TERMNT_INTF_PTY.LAST_UPDATE_LOGIN                = FND_GLOBAL.LOGIN_ID,
       OKL_TERMNT_INTF_PTY.QUOTE_ROLE_CODE                  = p_tip_rec.quote_role_code
    WHERE
         OKL_TERMNT_INTF_PTY.ROWID =p_tip_rec.row_id;

Line: 2658


         l_msg_tbl(0).msg_text    := 'update_party:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;

Line: 2661


END update_party;

Line: 2674


PROCEDURE select_party_info(
                            p_api_version    IN NUMBER,
                            p_init_msg_list  IN VARCHAR2,
                            x_msg_count      OUT NOCOPY NUMBER,
                            x_msg_data       OUT NOCOPY VARCHAR2,
                            x_return_status  OUT NOCOPY VARCHAR2,
                            p_tip_tbl        IN tip_tbl_type,
                            x_tip_tbl        OUT NOCOPY tip_tbl_type,
                            p_pty_status     IN VARCHAR2
                            ) IS
    record_number            NUMBER;

Line: 2689


SELECT
     ROWID
    ,CONTRACT_PARTY_ID
    ,CONTRACT_PARTY_ROLE
    ,CONTRACT_PARTY_NAME
    ,CONTRACT_PARTY_NUMBER
    ,PARTY_OBJECT_CODE
    ,PARTY_OBJECT_ID1
    ,PARTY_OBJECT_ID2
    ,EMAIL_ADDRESS
    ,ALLOCATION_PERCENTAGE
    ,DELAY_DAYS
    ,QPY_ID
    ,TRANSACTION_NUMBER
    ,STATUS
    ,REQUEST_ID
    ,PROGRAM_APPLICATION_ID
    ,PROGRAM_ID
    ,PROGRAM_UPDATE_DATE
    ,ATTRIBUTE_CATEGORY
    ,ATTRIBUTE1
    ,ATTRIBUTE2
    ,ATTRIBUTE3
    ,ATTRIBUTE4
    ,ATTRIBUTE5
    ,ATTRIBUTE6
    ,ATTRIBUTE7
    ,ATTRIBUTE8
    ,ATTRIBUTE9
    ,ATTRIBUTE10
    ,ATTRIBUTE11
    ,ATTRIBUTE12
    ,ATTRIBUTE13
    ,ATTRIBUTE14
    ,ATTRIBUTE15
    ,CREATED_BY
    ,CREATION_DATE
    ,LAST_UPDATED_BY
    ,LAST_UPDATE_DATE
    ,LAST_UPDATE_LOGIN
    ,QUOTE_ROLE_CODE
FROM OKL_TERMNT_INTF_PTY
WHERE STATUS = P_STATUS
ORDER BY TRANSACTION_NUMBER;

Line: 2741


           update_party(p_api_version   => p_api_version
                       ,p_init_msg_list => OKC_API.G_FALSE
                       ,x_msg_data      => x_msg_data
                       ,x_msg_count     => x_msg_count
                       ,x_return_status => x_return_status
                       ,p_tip_rec       => p_tip_tbl(record_number));

Line: 2752


     x_tip_tbl.DELETE;

Line: 2772


        x_tip_tbl(record_number).program_update_date            :=  party_rec.program_update_date;

Line: 2791


        x_tip_tbl(record_number).last_updated_by                :=  party_rec.last_updated_by;

Line: 2792


        x_tip_tbl(record_number).last_update_date               :=  party_rec.last_update_date;

Line: 2793


        x_tip_tbl(record_number).last_update_login              :=  party_rec.last_update_login;

Line: 2806


         l_msg_tbl(0).msg_text                := 'select_party_info:ended with unexpected error sqlcode: '||sqlcode||' sqlerrm: '||sqlerrm;

Line: 2810


END select_party_info;

Line: 2902


                         lx_tif_tbl.DELETE;

Line: 2928


                      update_party(p_api_version    => p_api_version
                                  ,p_init_msg_list => OKC_API.G_FALSE
                                  ,x_msg_data      => x_msg_data
                                  ,x_msg_count     => x_msg_count
                                  ,x_return_status => x_return_status
                                  ,p_tip_rec       => l_tip_rec);

Line: 2981


    SELECT
       ROWID
      ,TRANSACTION_NUMBER
      ,BATCH_NUMBER
      ,CONTRACT_ID
      ,CONTRACT_NUMBER
      ,ASSET_ID
      ,ASSET_NUMBER
      ,ASSET_DESCRIPTION
      ,SERIAL_NUMBER
      ,ORIG_SYSTEM
      ,ORIG_SYSTEM_REFERENCE
      ,UNITS_TO_TERMINATE
      ,COMMENTS
      ,DATE_PROCESSED
      ,DATE_EFFECTIVE_FROM
      ,TERMINATION_NOTIFICATION_EMAIL
      ,TERMINATION_NOTIFICATION_YN
      ,AUTO_ACCEPT_YN
      ,QUOTE_TYPE_CODE
      ,QUOTE_REASON_CODE
      ,QTE_ID
      ,STATUS
      ,ORG_ID
      ,REQUEST_ID
      ,PROGRAM_APPLICATION_ID
      ,PROGRAM_ID
      ,PROGRAM_UPDATE_DATE
      ,ATTRIBUTE_CATEGORY
      ,ATTRIBUTE1
      ,ATTRIBUTE2
      ,ATTRIBUTE3
      ,ATTRIBUTE4
      ,ATTRIBUTE5
      ,ATTRIBUTE6
      ,ATTRIBUTE7
      ,ATTRIBUTE8
      ,ATTRIBUTE9
      ,ATTRIBUTE10
      ,ATTRIBUTE11
      ,ATTRIBUTE12
      ,ATTRIBUTE13
      ,ATTRIBUTE14
      ,ATTRIBUTE15
      ,CREATED_BY
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,LAST_UPDATE_LOGIN
      ,GROUP_NUMBER
    FROM OKL_TERMNT_INTERFACE
    WHERE status = p_status
    ORDER BY CONTRACT_NUMBER;

Line: 3065


        SELECT trunc(SYSDATE) INTO l_sys_date FROM DUAL;

Line: 3097


        l_tif_tbl(record_number).program_update_date             :=  termnt_rec.program_update_date;

Line: 3116


        l_tif_tbl(record_number).last_updated_by                 :=  termnt_rec.last_updated_by;

Line: 3117


        l_tif_tbl(record_number).last_update_date                :=  termnt_rec.last_update_date;

Line: 3118


        l_tif_tbl(record_number).last_update_login               :=  termnt_rec.last_update_login;

Line: 3132


        l_tif_tbl.DELETE;

Line: 3134


        lx_tif_tbl.DELETE;

Line: 3144


        l_tif_tbl.DELETE;

Line: 3146


        lx_tif_tbl.DELETE;

Line: 3156


        l_tif_tbl.DELETE;

Line: 3158


        lx_tif_tbl.DELETE;

Line: 3160


        select_party_info(p_api_version    => l_api_version,
                          p_init_msg_list  => OKC_API.G_FALSE,
                          x_msg_count      => x_msg_count,
                          x_msg_data       => x_msg_data,
                          x_return_status  => x_return_status,
                          p_tip_tbl        => l_tip_tbl,
                          x_tip_tbl        => lx_tip_tbl,
                          p_pty_status     => 'ENTERED');

Line: 3168


        l_tip_tbl.DELETE;

Line: 3170


        lx_tip_tbl.DELETE;

Line: 3181


        l_tip_tbl.DELETE;

Line: 3183


        lx_tip_tbl.DELETE;

Line: 3185


        l_tif_tbl.DELETE;

Line: 3187


        lx_tif_tbl.DELETE;

Line: 3189


        select_party_info(p_api_version    => l_api_version,
                          p_init_msg_list  => OKC_API.G_FALSE,
                          x_msg_count      => x_msg_count,
                          x_msg_data       => x_msg_data,
                          x_return_status  => x_return_status,
                          p_tip_tbl        => l_tip_tbl,
                          x_tip_tbl        => lx_tip_tbl,
                          p_pty_status     => 'WORKING');

Line: 3197


        l_tip_tbl.DELETE;

Line: 3199


        lx_tip_tbl.DELETE;

Line: 3210


        l_tif_tbl.DELETE;

Line: 3212


        lx_tif_tbl.DELETE;

Line: 3222


        l_tif_tbl.DELETE;

Line: 3224


        lx_tif_tbl.DELETE;