APPS.OKS_COVERAGES_PUB SQL Statements

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

Line: 10

    p_restricted_update     IN VARCHAR2 DEFAULT 'F',
    x_Actual_coverage_id    OUT NOCOPY NUMBER) IS

    l_ac_rec_in    	        AC_REC_TYPE;

Line: 40

            p_restricted_update,
            x_actual_coverage_Id);

Line: 190

	OKS_SETUP_UTIL_PUB.Delete_Contract_Line(
   											 	p_api_version     ,
    											p_init_msg_list   ,
    											p_line_id  ,
    											x_return_status,
    											x_msg_count    ,
    											x_msg_data     );

Line: 243

PROCEDURE Update_cov_eff(
    p_api_version	    IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    P_service_Line_Id       IN NUMBER,
    p_new_start_date        IN DATE,
    p_new_end_date          IN DATE)
IS

    l_api_name        CONSTANT VARCHAR2(30) := 'Update_cov_eff';

Line: 273

    oks_coverages_pvt.Update_coverage_effectivity(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
            P_service_Line_id,
            p_new_start_date,
            p_new_end_date);

Line: 323

END Update_cov_eff;

Line: 347

SELECT  oxs.Coverage_template_Id,
        cle1.start_date,
        cle1.end_date
FROM    OKC_K_LINES_B cle1,
        OKC_K_ITEMS   cim ,
        OKX_SYSTEM_ITEMS_V oxs
WHERE   cle1.Lse_Id IN (1,19,14)
AND     cim.cle_Id=cle1.Id
AND     oxs.Id1=cim.object1_Id1
AND     oxs.Id2=cim.object1_id2
AND     cle1.Id = p_cle_id;

Line: 396

        p_restricted_update     => 'F',
        x_Actual_coverage_id    => x_Actual_coverage_id);

Line: 461

PROCEDURE DELETE_COVERAGE(
    p_api_version	        IN NUMBER,
    p_init_msg_list         IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status         OUT NOCOPY VARCHAR2,
    x_msg_count             OUT NOCOPY NUMBER,
    x_msg_data              OUT NOCOPY VARCHAR2,
    P_service_Line_Id       IN NUMBER) IS

l_api_version              CONSTANT    NUMBER         := 1.0;

Line: 477

l_api_name                 CONSTANT VARCHAR2(30) := 'Delete_Coverage';

Line: 480

SELECT  id
FROM    OKC_K_LINES_B
WHERE   CLE_ID = P_service_Line_Id
AND     LSE_ID in ( 2,15,20);

Line: 590

END DELETE_COVERAGE;

Line: 1002

PROCEDURE	Delete_History(
    			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) IS

 l_api_version   NUMBER := 1;

Line: 1016

l_api_name                 VARCHAR2(30):= 'Delete_History';

Line: 1035

OKS_COVERAGES_PVT.DELETE_HISTORY (
                                p_api_version,
                                p_init_msg_list,
                                x_return_status,
                                x_msg_count,
                                x_msg_data,
                                p_chr_id);

Line: 1072

END DELETE_HISTORY;

Line: 1074

PROCEDURE Delete_Saved_Version(
    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) IS

 l_api_version   NUMBER := 1;

Line: 1088

l_api_name                 VARCHAR2(30):= 'Delete_Saved_Version';

Line: 1107

OKS_COVERAGES_PVT.Delete_Saved_Version (
                                p_api_version,
                                p_init_msg_list,
                                x_return_status,
                                x_msg_count,
                                x_msg_data,
                                p_chr_id);