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

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

Line: 13


PROCEDURE insert_row_exp_excl (
        x_rowid                        in out NOCOPY VARCHAR2
        ,p_exp_type                    IN   VARCHAR2
        ,p_org_id                      IN   NUMBER
        ,p_ind_cost_code               IN   VARCHAR2
        ,p_CREATED_BY                  IN   NUMBER
        ,p_CREATION_DATE               IN   DATE
        ,p_LAST_UPDATED_BY             IN   NUMBER
        ,p_LAST_UPDATE_DATE            IN   DATE
        ,p_LAST_UPDATE_LOGIN           IN   NUMBER
        ,x_return_status               OUT NOCOPY  VARCHAR2
        ,x_error_msg_code              OUT NOCOPY  VARCHAR2
                      ) IS

BEGIN
	x_return_status := 'S';

Line: 31


	print_msg('inserting row into pa_cint_exp_type_excl_all ');

Line: 32


	INSERT INTO pa_cint_exp_type_excl_all
        ( IND_COST_CODE
 	 ,EXPENDITURE_TYPE
 	 ,ORG_ID
 	 ,CREATION_DATE
 	 ,CREATED_BY
 	 ,LAST_UPDATE_DATE
 	 ,LAST_UPDATED_BY
 	 ,LAST_UPDATE_LOGIN
        ) VALUES
	(p_ind_cost_code
	,p_exp_type
	,p_org_id
	,p_CREATION_DATE
	,p_CREATED_BY
	,p_LAST_UPDATE_DATE
	,p_LAST_UPDATED_BY
	,p_LAST_UPDATE_LOGIN
        );

Line: 53


	Select rowid
	INTO x_rowid
	FROM pa_cint_exp_type_excl_all
	WHERE IND_COST_CODE = p_ind_cost_code
	AND EXPENDITURE_TYPE = p_exp_type
	AND ORG_ID = p_org_id;

Line: 60


	print_msg('Num of rows inserted['||sql%rowcount);

Line: 66


END insert_row_exp_excl;

Line: 68


 PROCEDURE update_row_exp_excl
        (p_rowid                       IN   VARCHAR2
        ,p_exp_type                    IN   VARCHAR2
        ,p_org_id                      IN   NUMBER
        ,p_ind_cost_code               IN   VARCHAR2
        ,p_LAST_UPDATED_BY             IN   NUMBER
        ,p_LAST_UPDATE_DATE            IN   DATE
        ,p_LAST_UPDATE_LOGIN           IN   NUMBER
        ,x_return_status               OUT NOCOPY  VARCHAR2
        ,x_error_msg_code              OUT NOCOPY  VARCHAR2
                      )IS


BEGIN

        x_return_status := 'S';

Line: 86


	UPDATE pa_cint_exp_type_excl_all
	SET expenditure_type = p_exp_type
           ,LAST_UPDATED_BY =p_LAST_UPDATED_BY
           ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
	   ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
	WHERE rowid = p_rowid;

Line: 99


END update_row_exp_excl;

Line: 102


 PROCEDURE  delete_row_exp_excl (p_ind_cost_code in VARCHAR2
                                ,p_exp_type     IN varchar2
                                ,p_org_id       IN NUMBER ) IS

 BEGIN
    	DELETE from pa_cint_exp_type_excl_all
	WHERE  ind_cost_code = p_ind_cost_code
	AND    expenditure_type = p_exp_type
	AND    org_id = p_org_id ;

Line: 116


 END delete_row_exp_excl;

Line: 118


 PROCEDURE delete_row_exp_excl (x_rowid      in VARCHAR2) IS

 BEGIN
	NULL;

Line: 122


 END delete_row_exp_excl;

Line: 124


PROCEDURE insert_row_rate_info (
        x_rowid                        in out NOCOPY VARCHAR2
        ,p_org_id                      IN   NUMBER
        ,p_ind_cost_code               IN   VARCHAR2
        ,p_EXP_ORG_SOURCE              IN  VARCHAR2
        ,p_PROJ_AMT_THRESHOLD         IN  NUMBER
        ,p_TASK_AMT_THRESHOLD         IN  NUMBER
        ,p_PROJ_DURATION_THRESHOLD    IN  NUMBER
        ,p_TASK_DURATION_THRESHOLD    IN  NUMBER
        ,p_CURR_PERIOD_CONVENTION      IN  VARCHAR2
        ,p_INTEREST_CALCULATION_METHOD   IN  VARCHAR2
        ,p_THRESHOLD_AMT_TYPE          IN VARCHAR2
        ,p_BUDGET_TYPE_CODE            IN VARCHAR2
        ,p_PERIOD_RATE_CODE            IN VARCHAR2
        ,p_CREATED_BY                  IN   NUMBER
        ,p_CREATION_DATE               IN   DATE
        ,p_LAST_UPDATED_BY             IN   NUMBER
        ,p_LAST_UPDATE_DATE            IN   DATE
        ,p_LAST_UPDATE_LOGIN           IN   NUMBER
        ,x_return_status               OUT NOCOPY  VARCHAR2
        ,x_error_msg_code              OUT NOCOPY  VARCHAR2
                      ) IS

 BEGIN
        x_return_status := 'S';

Line: 151


        print_msg('inserting row into pa_cint_rate_info_all ');

Line: 152


        INSERT INTO pa_cint_rate_info_all
        ( IND_COST_CODE
         ,ORG_ID
	 ,EXP_ORG_SOURCE
         ,PROJ_AMT_THRESHOLD
         ,TASK_AMT_THRESHOLD
         ,PROJ_DURATION_THRESHOLD
         ,TASK_DURATION_THRESHOLD
         ,CURR_PERIOD_CONVENTION
         ,INTEREST_CALCULATION_METHOD
         ,THRESHOLD_AMT_TYPE
         ,BUDGET_TYPE_CODE
         ,PERIOD_RATE_CODE
         ,CREATION_DATE
         ,CREATED_BY
         ,LAST_UPDATE_DATE
         ,LAST_UPDATED_BY
         ,LAST_UPDATE_LOGIN
        ) VALUES
        (p_ind_cost_code
        ,p_org_id
        ,p_EXP_ORG_SOURCE
        ,p_PROJ_AMT_THRESHOLD
        ,p_TASK_AMT_THRESHOLD
        ,p_PROJ_DURATION_THRESHOLD
        ,p_TASK_DURATION_THRESHOLD
        ,p_CURR_PERIOD_CONVENTION
        ,p_INTEREST_CALCULATION_METHOD
        ,p_THRESHOLD_AMT_TYPE
        ,p_BUDGET_TYPE_CODE
        ,p_PERIOD_RATE_CODE
        ,p_CREATION_DATE
        ,p_CREATED_BY
        ,p_LAST_UPDATE_DATE
        ,p_LAST_UPDATED_BY
        ,p_LAST_UPDATE_LOGIN
        );

Line: 191


        Select rowid
        INTO x_rowid
        FROM pa_cint_rate_info_all
        WHERE IND_COST_CODE = p_ind_cost_code
        AND EXP_ORG_SOURCE = p_EXP_ORG_SOURCE
        AND ORG_ID = p_org_id;

Line: 204


 END insert_row_rate_info;

Line: 206


 PROCEDURE update_row_rate_info
        (p_rowid                       IN   VARCHAR2
        ,p_org_id                      IN   NUMBER
        ,p_ind_cost_code               IN   VARCHAR2
        ,p_EXP_ORG_SOURCE              IN  VARCHAR2
        ,p_PROJ_AMT_THRESHOLD         IN  NUMBER
        ,p_TASK_AMT_THRESHOLD         IN  NUMBER
        ,p_PROJ_DURATION_THRESHOLD    IN  NUMBER
        ,p_TASK_DURATION_THRESHOLD    IN  NUMBER
        ,p_CURR_PERIOD_CONVENTION      IN  VARCHAR2
        ,p_INTEREST_CALCULATION_METHOD   IN  VARCHAR2
        ,p_THRESHOLD_AMT_TYPE          IN VARCHAR2
        ,p_BUDGET_TYPE_CODE            IN VARCHAR2
        ,p_PERIOD_RATE_CODE            IN VARCHAR2
        ,p_LAST_UPDATED_BY             IN   NUMBER
        ,p_LAST_UPDATE_DATE            IN   DATE
        ,p_LAST_UPDATE_LOGIN           IN   NUMBER
        ,x_return_status               OUT NOCOPY  VARCHAR2
        ,x_error_msg_code              OUT NOCOPY  VARCHAR2
                      )IS

 BEGIN
        x_return_status := 'S';

Line: 231


        UPDATE pa_cint_rate_info_all
        SET EXP_ORG_SOURCE = p_EXP_ORG_SOURCE
	   ,PROJ_AMT_THRESHOLD = p_PROJ_AMT_THRESHOLD
	   ,TASK_AMT_THRESHOLD = p_TASK_AMT_THRESHOLD
	   ,PROJ_DURATION_THRESHOLD = p_PROJ_DURATION_THRESHOLD
	   ,TASK_DURATION_THRESHOLD = p_TASK_DURATION_THRESHOLD
	   ,CURR_PERIOD_CONVENTION = p_CURR_PERIOD_CONVENTION
           ,INTEREST_CALCULATION_METHOD = p_INTEREST_CALCULATION_METHOD
           ,THRESHOLD_AMT_TYPE = p_THRESHOLD_AMT_TYPE
           ,BUDGET_TYPE_CODE = p_BUDGET_TYPE_CODE
           ,PERIOD_RATE_CODE  = p_PERIOD_RATE_CODE
           ,LAST_UPDATED_BY =p_LAST_UPDATED_BY
           ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
           ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
        WHERE ind_cost_code = p_ind_cost_code
        AND   org_id = p_org_id;

Line: 254


 END update_row_rate_info;

Line: 256


 PROCEDURE  delete_row_rate_info (p_ind_cost_code in VARCHAR2
                                 ,p_org_id       IN NUMBER
                                 )IS

        x_return_status VARCHAR2(1000):= 'S';

Line: 264


        DELETE from pa_cint_rate_info_all
        WHERE  ind_cost_code = p_ind_cost_code
        AND    org_id = p_org_id ;

Line: 274


 END delete_row_rate_info;