APPS.PA_VALUE_MAPS_PKG SQL Statements

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

Line: 9

PROCEDURE insert_rows
      ( p_value_map_def_id                 IN NUMBER                               ,
        p_source_value_arr                 IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_arr                   IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_source_value_pk1_arr             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_source_value_pk2_arr             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_source_value_pk3_arr             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_source_value_pk4_arr             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_source_value_pk5_arr             IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_pk1_arr               IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_pk2_arr               IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_pk3_arr               IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_pk4_arr               IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
				p_dest_value_pk5_arr               IN PA_PLSQL_DATATYPES.Char240TabTyp      ,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN

  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 32

		INSERT INTO pa_value_maps
		(   value_map_id            ,
		    value_map_def_id        ,
        source_value            ,
				dest_value              ,
				source_value_pk1        ,
				source_value_pk2        ,
				source_value_pk3        ,
				source_value_pk4        ,
				source_value_pk5        ,
				dest_value_pk1          ,
				dest_value_pk2          ,
				dest_value_pk3          ,
				dest_value_pk4          ,
				dest_value_pk5          ,
        creation_date           ,
        created_by              ,
        last_update_date        ,
        last_updated_by         ,
        last_update_login       )
     VALUES
	   (  pa_value_maps_s.nextval    ,
        p_value_map_def_id         ,
	    	p_source_value_arr(j)      ,
		    p_dest_value_arr(j)        ,
		    p_source_value_pk1_arr(j)  ,
		    p_source_value_pk2_arr(j)  ,
		    p_source_value_pk3_arr(j)  ,
		    p_source_value_pk4_arr(j)  ,
		    p_source_value_pk5_arr(j)  ,
		    p_dest_value_pk1_arr(j)    ,
		    p_dest_value_pk2_arr(j)    ,
		    p_dest_value_pk3_arr(j)    ,
		    p_dest_value_pk4_arr(j)    ,
		    p_dest_value_pk5_arr(j)    ,
        sysdate                      ,
        fnd_global.user_id           ,
        sysdate                      ,
        fnd_global.user_id           ,
        fnd_global.login_id          );

Line: 77

                          p_procedure_name   => 'insert_rows');

Line: 80

END insert_rows;

Line: 88

PROCEDURE delete_rows
	    ( p_value_map_def_id                 IN NUMBER                        ,
        p_value_map_def_type               IN VARCHAR2                      ,
        p_probability_list_id              IN NUMBER := NULL                ,
        x_return_status              OUT  NOCOPY VARCHAR2                          , --File.Sql.39 bug 4440895
        x_msg_count                  OUT  NOCOPY NUMBER                            , --File.Sql.39 bug 4440895
        x_msg_data                   OUT  NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
IS

BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 101

     DELETE FROM pa_value_maps
     WHERE value_map_def_id = p_value_map_def_id
     AND dest_value_pk2 = p_probability_list_id;

Line: 106

     DELETE FROM pa_value_maps
     WHERE value_map_def_id = p_value_map_def_id;

Line: 115

                          p_procedure_name   => 'delete_rows');

Line: 118

END delete_rows;