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

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

Line: 14


  PROCEDURE DELETE_TIMEVALUES_N_TASKS(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_chr_id            IN NUMBER  ,
    p_tve_id                IN NUMBER) IS
   BEGIN
     OKC_TIME_PVT.DELETE_TIMEVALUES_N_TASKS(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_chr_id,
       p_tve_id);

Line: 31


  END DELETE_TIMEVALUES_N_TASKS;

Line: 42


    l_talv_rec.last_updated_by       := p_talv_rec1.last_updated_by;

Line: 43


    l_talv_rec.last_update_date      := p_talv_rec1.last_update_date;

Line: 44


    l_talv_rec.last_update_login     := p_talv_rec1.last_update_login;

Line: 231


  PROCEDURE UPDATE_TPA_RELTV(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_talv_rec	            IN talv_rec_type,
    x_talv_rec              OUT NOCOPY talv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TPA_RELTV';

Line: 261


    OKC_TIME_PVT.UPDATE_TPA_RELTV(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_talv_rec,
       x_talv_rec);

Line: 309


  END UPDATE_TPA_RELTV;

Line: 311


  PROCEDURE UPDATE_TPA_RELTV(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_tbl                     IN talv_tbl_type,
    x_talv_tbl                     OUT NOCOPY talv_tbl_type) IS
    i			         NUMBER := 0;

Line: 326


        UPDATE_TPA_RELTV(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_talv_tbl(i),
	    x_talv_tbl(i));

Line: 357


  END UPDATE_TPA_RELTV;

Line: 359


  PROCEDURE DELETE_TPA_RELTV(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_talv_rec              IN talv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TPA_RELTV';

Line: 387


    OKC_TIME_PVT.DELETE_TPA_RELTV(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_talv_rec);

Line: 433


  END DELETE_TPA_RELTV;

Line: 435


  PROCEDURE DELETE_TPA_RELTV(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_tbl                     IN talv_tbl_type) IS
    i			         NUMBER := 0;

Line: 449


        DELETE_TPA_RELTV(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_talv_tbl(i));

Line: 479


  END DELETE_TPA_RELTV;

Line: 616


    l_talv_evt_rec.last_updated_by       := p_talv_evt_rec1.last_updated_by;

Line: 617


    l_talv_evt_rec.last_update_date      := p_talv_evt_rec1.last_update_date;

Line: 618


    l_talv_evt_rec.last_update_login     := p_talv_evt_rec1.last_update_login;

Line: 806


  PROCEDURE UPDATE_TPA_RELTV(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_talv_evt_rec	            IN talv_evt_rec_type,
    x_talv_evt_rec              OUT NOCOPY talv_evt_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TPA_RELTV';

Line: 836


    OKC_TIME_PVT.UPDATE_TPA_RELTV(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_talv_evt_rec,
       x_talv_evt_rec);

Line: 884


  END UPDATE_TPA_RELTV;

Line: 886


  PROCEDURE UPDATE_TPA_RELTV(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_evt_tbl                     IN talv_evt_tbl_type,
    x_talv_evt_tbl                     OUT NOCOPY talv_evt_tbl_type) IS
    i			         NUMBER := 0;

Line: 901


        UPDATE_TPA_RELTV(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_talv_evt_tbl(i),
	    x_talv_evt_tbl(i));

Line: 932


  END UPDATE_TPA_RELTV;

Line: 934


  PROCEDURE DELETE_TPA_RELTV(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_talv_evt_rec              IN talv_evt_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TPA_RELTV';

Line: 962


    OKC_TIME_PVT.DELETE_TPA_RELTV(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_talv_evt_rec);

Line: 1008


  END DELETE_TPA_RELTV;

Line: 1010


  PROCEDURE DELETE_TPA_RELTV(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_talv_evt_tbl                     IN talv_evt_tbl_type) IS
    i			         NUMBER := 0;

Line: 1024


        DELETE_TPA_RELTV(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_talv_evt_tbl(i));

Line: 1054


  END DELETE_TPA_RELTV;

Line: 1195


    l_tavv_rec.last_updated_by       := p_tavv_rec1.last_updated_by;

Line: 1196


    l_tavv_rec.last_update_date      := p_tavv_rec1.last_update_date;

Line: 1197


    l_tavv_rec.last_update_login     := p_tavv_rec1.last_update_login;

Line: 1381


  PROCEDURE UPDATE_TPA_VALUE(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tavv_rec	            IN tavv_rec_type,
    x_tavv_rec              OUT NOCOPY tavv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TPA_VALUE';

Line: 1411


    OKC_TIME_PVT.UPDATE_TPA_VALUE(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tavv_rec,
       x_tavv_rec);

Line: 1459


  END UPDATE_TPA_VALUE;

Line: 1461


  PROCEDURE UPDATE_TPA_VALUE(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tavv_tbl                     IN tavv_tbl_type,
    x_tavv_tbl                     OUT NOCOPY tavv_tbl_type) IS
    i			         NUMBER := 0;

Line: 1476


        UPDATE_TPA_VALUE(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tavv_tbl(i),
	    x_tavv_tbl(i));

Line: 1507


  END UPDATE_TPA_VALUE;

Line: 1509


  PROCEDURE DELETE_TPA_VALUE(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tavv_rec              IN tavv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TPA_VALUE';

Line: 1537


    OKC_TIME_PVT.DELETE_TPA_VALUE(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tavv_rec);

Line: 1583


  END DELETE_TPA_VALUE;

Line: 1585


  PROCEDURE DELETE_TPA_VALUE(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tavv_tbl                     IN tavv_tbl_type) IS
    i			         NUMBER := 0;

Line: 1599


        DELETE_TPA_VALUE(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tavv_tbl(i));

Line: 1629


  END DELETE_TPA_VALUE;

Line: 1770


    l_tgdv_ext_rec.last_updated_by       := p_tgdv_ext_rec1.last_updated_by;

Line: 1771


    l_tgdv_ext_rec.last_update_date      := p_tgdv_ext_rec1.last_update_date;

Line: 1772


    l_tgdv_ext_rec.last_update_login     := p_tgdv_ext_rec1.last_update_login;

Line: 1962


  PROCEDURE UPDATE_TPG_DELIMITED(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tgdv_ext_rec	            IN tgdv_ext_rec_type,
    x_tgdv_ext_rec              OUT NOCOPY tgdv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TPG_DELIMITED';

Line: 1992


    OKC_TIME_PVT.UPDATE_TPG_DELIMITED(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tgdv_ext_rec,
       x_tgdv_ext_rec);

Line: 2040


  END UPDATE_TPG_DELIMITED;

Line: 2042


  PROCEDURE UPDATE_TPG_DELIMITED(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tgdv_ext_tbl                     IN tgdv_ext_tbl_type,
    x_tgdv_ext_tbl                     OUT NOCOPY tgdv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 2057


        UPDATE_TPG_DELIMITED(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tgdv_ext_tbl(i),
	    x_tgdv_ext_tbl(i));

Line: 2088


  END UPDATE_TPG_DELIMITED;

Line: 2090


  PROCEDURE DELETE_TPG_DELIMITED(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tgdv_ext_rec              IN tgdv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TPG_DELIMITED';

Line: 2118


    OKC_TIME_PVT.DELETE_TPG_DELIMITED(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tgdv_ext_rec);

Line: 2164


  END DELETE_TPG_DELIMITED;

Line: 2166


  PROCEDURE DELETE_TPG_DELIMITED(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tgdv_ext_tbl                     IN tgdv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 2180


        DELETE_TPG_DELIMITED(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tgdv_ext_tbl(i));

Line: 2210


  END DELETE_TPG_DELIMITED;

Line: 2351


    l_tgnv_rec.last_updated_by       := p_tgnv_rec1.last_updated_by;

Line: 2352


    l_tgnv_rec.last_update_date      := p_tgnv_rec1.last_update_date;

Line: 2353


    l_tgnv_rec.last_update_login     := p_tgnv_rec1.last_update_login;

Line: 2535


  PROCEDURE UPDATE_TPG_NAMED(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tgnv_rec	            IN tgnv_rec_type,
    x_tgnv_rec              OUT NOCOPY tgnv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TPG_NAMED';

Line: 2565


    OKC_TIME_PVT.UPDATE_TPG_NAMED(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tgnv_rec,
       x_tgnv_rec);

Line: 2613


  END UPDATE_TPG_NAMED;

Line: 2615


  PROCEDURE UPDATE_TPG_NAMED(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tgnv_tbl                     IN tgnv_tbl_type,
    x_tgnv_tbl                     OUT NOCOPY tgnv_tbl_type) IS
    i			         NUMBER := 0;

Line: 2630


        UPDATE_TPG_NAMED(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tgnv_tbl(i),
	    x_tgnv_tbl(i));

Line: 2661


  END UPDATE_TPG_NAMED;

Line: 2663


  PROCEDURE DELETE_TPG_NAMED(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tgnv_rec              IN tgnv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TPG_NAMED';

Line: 2691


    OKC_TIME_PVT.DELETE_TPG_NAMED(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tgnv_rec);

Line: 2737


  END DELETE_TPG_NAMED;

Line: 2739


  PROCEDURE DELETE_TPG_NAMED(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tgnv_tbl                     IN tgnv_tbl_type) IS
    i			         NUMBER := 0;

Line: 2753


        DELETE_TPG_NAMED(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tgnv_tbl(i));

Line: 2783


  END DELETE_TPG_NAMED;

Line: 2924


    l_isev_ext_rec.last_updated_by       := p_isev_ext_rec1.last_updated_by;

Line: 2925


    l_isev_ext_rec.last_update_date      := p_isev_ext_rec1.last_update_date;

Line: 2926


    l_isev_ext_rec.last_update_login     := p_isev_ext_rec1.last_update_login;

Line: 2995


    l_isev_rel_rec.last_updated_by       := p_isev_rel_rec1.last_updated_by;

Line: 2996


    l_isev_rel_rec.last_update_date      := p_isev_rel_rec1.last_update_date;

Line: 2997


    l_isev_rel_rec.last_update_login     := p_isev_rel_rec1.last_update_login;

Line: 3185


  PROCEDURE UPDATE_IA_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_isev_ext_rec	            IN isev_ext_rec_type,
    x_isev_ext_rec              OUT NOCOPY isev_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_IA_STARTEND';

Line: 3215


    OKC_TIME_PVT.UPDATE_IA_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_isev_ext_rec,
       x_isev_ext_rec);

Line: 3263


  END UPDATE_IA_STARTEND;

Line: 3265


  PROCEDURE UPDATE_IA_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_isev_ext_tbl                     IN isev_ext_tbl_type,
    x_isev_ext_tbl                     OUT NOCOPY isev_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 3280


        UPDATE_IA_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_isev_ext_tbl(i),
	    x_isev_ext_tbl(i));

Line: 3311


  END UPDATE_IA_STARTEND;

Line: 3313


  PROCEDURE DELETE_IA_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_isev_ext_rec              IN isev_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_IA_STARTEND';

Line: 3341


    OKC_TIME_PVT.DELETE_IA_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_isev_ext_rec);

Line: 3387


  END DELETE_IA_STARTEND;

Line: 3389


  PROCEDURE DELETE_IA_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_isev_ext_tbl                     IN isev_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 3403


        DELETE_IA_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_isev_ext_tbl(i));

Line: 3433


  END DELETE_IA_STARTEND;

Line: 3689


  PROCEDURE UPDATE_IA_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_isev_rel_rec	            IN isev_rel_rec_type,
    x_isev_rel_rec              OUT NOCOPY isev_rel_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_IA_STARTEND';

Line: 3719


    OKC_TIME_PVT.UPDATE_IA_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_isev_rel_rec,
       x_isev_rel_rec);

Line: 3767


  END UPDATE_IA_STARTEND;

Line: 3769


  PROCEDURE UPDATE_IA_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_isev_rel_tbl                     IN isev_rel_tbl_type,
    x_isev_rel_tbl                     OUT NOCOPY isev_rel_tbl_type) IS
    i			         NUMBER := 0;

Line: 3784


        UPDATE_IA_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_isev_rel_tbl(i),
	    x_isev_rel_tbl(i));

Line: 3815


  END UPDATE_IA_STARTEND;

Line: 3817


  PROCEDURE DELETE_IA_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_isev_rel_rec              IN isev_rel_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_IA_STARTEND';

Line: 3845


    OKC_TIME_PVT.DELETE_IA_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_isev_rel_rec);

Line: 3891


  END DELETE_IA_STARTEND;

Line: 3893


  PROCEDURE DELETE_IA_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_isev_rel_tbl                     IN isev_rel_tbl_type) IS
    i			         NUMBER := 0;

Line: 3907


        DELETE_IA_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_isev_rel_tbl(i));

Line: 3937


  END DELETE_IA_STARTEND;

Line: 4078


    l_igsv_ext_rec.last_updated_by       := p_igsv_ext_rec1.last_updated_by;

Line: 4079


    l_igsv_ext_rec.last_update_date      := p_igsv_ext_rec1.last_update_date;

Line: 4080


    l_igsv_ext_rec.last_update_login     := p_igsv_ext_rec1.last_update_login;

Line: 4263


  PROCEDURE UPDATE_IG_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_igsv_ext_rec	            IN igsv_ext_rec_type,
    x_igsv_ext_rec              OUT NOCOPY igsv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_IG_STARTEND';

Line: 4293


    OKC_TIME_PVT.UPDATE_IG_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_igsv_ext_rec,
       x_igsv_ext_rec);

Line: 4341


  END UPDATE_IG_STARTEND;

Line: 4343


  PROCEDURE UPDATE_IG_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_igsv_ext_tbl                     IN igsv_ext_tbl_type,
    x_igsv_ext_tbl                     OUT NOCOPY igsv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 4358


        UPDATE_IG_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_igsv_ext_tbl(i),
	    x_igsv_ext_tbl(i));

Line: 4389


  END UPDATE_IG_STARTEND;

Line: 4391


  PROCEDURE DELETE_IG_STARTEND(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_igsv_ext_rec              IN igsv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_IG_STARTEND';

Line: 4419


    OKC_TIME_PVT.DELETE_IG_STARTEND(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_igsv_ext_rec);

Line: 4465


  END DELETE_IG_STARTEND;

Line: 4467


  PROCEDURE DELETE_IG_STARTEND(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_igsv_ext_tbl                     IN igsv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 4481


        DELETE_IG_STARTEND(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_igsv_ext_tbl(i));

Line: 4511


  END DELETE_IG_STARTEND;

Line: 4651


    l_cylv_ext_rec.last_updated_by       := p_cylv_ext_rec1.last_updated_by;

Line: 4652


    l_cylv_ext_rec.last_update_date      := p_cylv_ext_rec1.last_update_date;

Line: 4653


    l_cylv_ext_rec.last_update_login     := p_cylv_ext_rec1.last_update_login;

Line: 4841


  PROCEDURE UPDATE_CYCLE(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_cylv_ext_rec	            IN cylv_ext_rec_type,
    x_cylv_ext_rec              OUT NOCOPY cylv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_CYCLE';

Line: 4871


    OKC_TIME_PVT.UPDATE_CYCLE(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_cylv_ext_rec,
       x_cylv_ext_rec);

Line: 4919


  END UPDATE_CYCLE;

Line: 4921


  PROCEDURE UPDATE_CYCLE(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cylv_ext_tbl                     IN cylv_ext_tbl_type,
    x_cylv_ext_tbl                     OUT NOCOPY cylv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 4936


        UPDATE_CYCLE(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cylv_ext_tbl(i),
	    x_cylv_ext_tbl(i));

Line: 4967


  END UPDATE_CYCLE;

Line: 4969


  PROCEDURE DELETE_CYCLE(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_cylv_ext_rec              IN cylv_ext_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_CYCLE';

Line: 4997


    OKC_TIME_PVT.DELETE_CYCLE(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_cylv_ext_rec);

Line: 5043


  END DELETE_CYCLE;

Line: 5045


  PROCEDURE DELETE_CYCLE(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cylv_ext_tbl                     IN cylv_ext_tbl_type) IS
    i			         NUMBER := 0;

Line: 5059


        DELETE_CYCLE(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cylv_ext_tbl(i));

Line: 5089


  END DELETE_CYCLE;

Line: 5230


    l_spnv_rec.last_updated_by       := p_spnv_rec1.last_updated_by;

Line: 5231


    l_spnv_rec.last_update_date      := p_spnv_rec1.last_update_date;

Line: 5232


    l_spnv_rec.last_update_login     := p_spnv_rec1.last_update_login;

Line: 5396


  PROCEDURE UPDATE_SPAN(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_spnv_rec	            IN spnv_rec_type,
    x_spnv_rec              OUT NOCOPY spnv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_SPAN';

Line: 5426


    OKC_TIME_PVT.UPDATE_SPAN(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_spnv_rec,
       x_spnv_rec);

Line: 5474


  END UPDATE_SPAN;

Line: 5476


  PROCEDURE UPDATE_SPAN(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_tbl                     IN spnv_tbl_type,
    x_spnv_tbl                     OUT NOCOPY spnv_tbl_type) IS
    i			         NUMBER := 0;

Line: 5491


        UPDATE_SPAN(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_spnv_tbl(i),
	    x_spnv_tbl(i));

Line: 5522


  END UPDATE_SPAN;

Line: 5524


  PROCEDURE DELETE_SPAN(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_spnv_rec              IN spnv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_SPAN';

Line: 5552


    OKC_TIME_PVT.DELETE_SPAN(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_spnv_rec);

Line: 5598


  END DELETE_SPAN;

Line: 5600


  PROCEDURE DELETE_SPAN(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_spnv_tbl                     IN spnv_tbl_type) IS
    i			         NUMBER := 0;

Line: 5614


        DELETE_SPAN(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_spnv_tbl(i));

Line: 5644


  END DELETE_SPAN;

Line: 5787


    l_tcuv_rec.last_updated_by       := p_tcuv_rec1.last_updated_by;

Line: 5788


    l_tcuv_rec.last_update_date      := p_tcuv_rec1.last_update_date;

Line: 5789


    l_tcuv_rec.last_update_login     := p_tcuv_rec1.last_update_login;

Line: 5967


  PROCEDURE UPDATE_TIME_CODE_UNITS(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tcuv_rec	            IN tcuv_rec_type,
    x_tcuv_rec              OUT NOCOPY tcuv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_TIME_CODE_UNITS';

Line: 5997


    OKC_TIME_PVT.UPDATE_TIME_CODE_UNITS(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tcuv_rec,
       x_tcuv_rec);

Line: 6045


  END UPDATE_TIME_CODE_UNITS;

Line: 6047


  PROCEDURE UPDATE_TIME_CODE_UNITS(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tcuv_tbl                     IN tcuv_tbl_type,
    x_tcuv_tbl                     OUT NOCOPY tcuv_tbl_type) IS
    i			         NUMBER := 0;

Line: 6062


        UPDATE_TIME_CODE_UNITS(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tcuv_tbl(i),
	    x_tcuv_tbl(i));

Line: 6093


  END UPDATE_TIME_CODE_UNITS;

Line: 6095


  PROCEDURE DELETE_TIME_CODE_UNITS(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_tcuv_rec              IN tcuv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_TIME_CODE_UNITS';

Line: 6123


    OKC_TIME_PVT.DELETE_TIME_CODE_UNITS(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_tcuv_rec);

Line: 6169


  END DELETE_TIME_CODE_UNITS;

Line: 6171


  PROCEDURE DELETE_TIME_CODE_UNITS(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tcuv_tbl                     IN tcuv_tbl_type) IS
    i			         NUMBER := 0;

Line: 6185


        DELETE_TIME_CODE_UNITS(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_tcuv_tbl(i));

Line: 6215


  END DELETE_TIME_CODE_UNITS;

Line: 6359


    l_rtvv_rec.last_updated_by       := p_rtvv_rec1.last_updated_by;

Line: 6360


    l_rtvv_rec.last_update_date      := p_rtvv_rec1.last_update_date;

Line: 6361


    l_rtvv_rec.last_update_login     := p_rtvv_rec1.last_update_login;

Line: 6519


  PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rtvv_rec	            IN rtvv_rec_type,
    x_rtvv_rec              OUT NOCOPY rtvv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'UPDATE_RESOLVED_TIMEVALUES';

Line: 6549


    OKC_TIME_PVT.UPDATE_RESOLVED_TIMEVALUES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_rtvv_rec,
       x_rtvv_rec);

Line: 6597


  END UPDATE_RESOLVED_TIMEVALUES;

Line: 6599


  PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rtvv_tbl                     IN rtvv_tbl_type,
    x_rtvv_tbl                     OUT NOCOPY rtvv_tbl_type) IS
    i			         NUMBER := 0;

Line: 6614


        UPDATE_RESOLVED_TIMEVALUES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_rtvv_tbl(i),
	    x_rtvv_tbl(i));

Line: 6645


  END UPDATE_RESOLVED_TIMEVALUES;

Line: 6647


  PROCEDURE DELETE_RESOLVED_TIMEVALUES(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 ,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    p_rtvv_rec              IN rtvv_rec_type) IS
    l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_RESOLVED_TIMEVALUES';

Line: 6675


    OKC_TIME_PVT.DELETE_RESOLVED_TIMEVALUES(
       p_api_version,
       p_init_msg_list,
       x_return_status,
       x_msg_count,
       x_msg_data,
       p_rtvv_rec);

Line: 6721


  END DELETE_RESOLVED_TIMEVALUES;

Line: 6723


  PROCEDURE DELETE_RESOLVED_TIMEVALUES(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rtvv_tbl                     IN rtvv_tbl_type) IS
    i			         NUMBER := 0;

Line: 6737


        DELETE_RESOLVED_TIMEVALUES(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_rtvv_tbl(i));

Line: 6767


  END DELETE_RESOLVED_TIMEVALUES;