APPS.ASL_SUMM_LOAD_GLBL_PKG SQL Statements

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

Line: 5

PROCEDURE Delete_Rows (
             p_table_name        IN  VARCHAR2
           , p_category_set_id   IN  NUMBER
	        , p_organization_id   IN  NUMBER
	        , p_category_id       IN  NUMBER
	        , x_err_msg           OUT NOCOPY VARCHAR2
	        , x_err_code          OUT NOCOPY VARCHAR2
	   ) IS

	   l_del_sql        VARCHAR2(2000);

Line: 19

	   l_select         VARCHAR2(2000);

Line: 26

         l_del_sql    :=  'DELETE FROM ' || p_table_name ;

Line: 39

         l_del_sql := ' DELETE FROM ASL_INVENTORY_PRICING AI WHERE AI.INVENTORY_ITEM_ID IN (';

Line: 40

         l_select  := ' SELECT AI.INVENTORY_ITEM_ID FROM ASL_INVENTORY_PRICING AI, ASL_INVENTORY_ITEM_DENORM AD';

Line: 48

            EXECUTE IMMEDIATE l_del_sql||l_select||l_where||l_del_where1||l_del_where2||l_close  using p_category_set_id, p_organization_id;

Line: 50

            EXECUTE IMMEDIATE l_del_sql||l_select||l_where||l_del_where1||l_del_where2||l_del_where3||l_close using p_category_set_id, p_organization_id, p_category_id;

Line: 63

         x_err_msg  := 'Delete_Rows: PASS';

Line: 66

END Delete_Rows;

Line: 79

		      , p_delete_mode   IN   VARCHAR2 DEFAULT NULL
		) IS

BEGIN

     IF p_action = 'I'  -- Insert
     THEN
         FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_INSERTED' );

Line: 90

     ELSIF p_action = 'U'   -- Update
     THEN
         FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_UPDATED' );

Line: 96

     ELSIF p_action = 'D'   -- Delete
     THEN
         FND_MESSAGE.SET_NAME( 'ASL', 'ASL_LOAD_ROWS_DELETED' );

Line: 119

         FND_MESSAGE.SET_TOKEN( 'DELETE_MODE', p_delete_mode );