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

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

Line: 130


G_operation	VARCHAR2(30);	-- values will be Insert, Update or Delete

Line: 220


    G_operation := 'INSERT';	-- Bug 2659435

Line: 248


    	log_msg('Calling private API to insert record.');

Line: 290


    	log_msg('1 row inserted');

Line: 370


PROCEDURE Update_Allocation_Definition
(
p_api_version                   IN  NUMBER                      ,
p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE ,
p_commit                        IN  VARCHAR2 := FND_API.G_FALSE ,

x_return_status                 OUT NOCOPY VARCHAR2                    ,
x_msg_count                     OUT NOCOPY NUMBER                      ,
x_msg_data                      OUT NOCOPY VARCHAR2                    ,

p_allocation_definition_rec     IN  Allocation_Definition_Rec_Type
)
IS
	l_api_name              CONSTANT VARCHAR2(30)   := 'Update_Allocation_Definition' ;

Line: 395


    SAVEPOINT    Update_Alloc_Definition_PUB;

Line: 415


    	log_msg('Beginning Update Allocation Definition process.');

Line: 418


    G_operation := 'UPDATE';	-- Bug 2659435

Line: 464


    SELECT count(1)
      INTO l_cnt
      FROM gl_aloc_bas
     WHERE alloc_id = l_alloc_def_rec.alloc_id
       AND line_no  = l_alloc_def_rec.line_no ;

Line: 489


   IF l_alloc_def_rec.delete_mark = 1 THEN
	add_header_to_error_stack(l_alloc_def_rec); -- Bug 2659435

Line: 501


    GMF_AllocationDefinition_PVT.Update_Allocation_Definition
    ( p_api_version    		  => 3.0
    , p_init_msg_list  		  => FND_API.G_FALSE
    , p_commit         		  => FND_API.G_FALSE

    , x_return_status  		  => l_return_status
    , x_msg_count      		  => l_count
    , x_msg_data       		  => l_data

    , p_allocation_definition_rec => l_alloc_def_rec
    , p_user_id			  => l_user_id
    );

Line: 554


        ROLLBACK TO  Update_Alloc_Definition_PUB;

Line: 561


        ROLLBACK TO  Update_Alloc_Definition_PUB;

Line: 568


        ROLLBACK TO  Update_Alloc_Definition_PUB;

Line: 583


END Update_Allocation_Definition ;

Line: 618


PROCEDURE Delete_Allocation_Definition
(
p_api_version                   IN  NUMBER                      ,
p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE ,
p_commit                        IN  VARCHAR2 := FND_API.G_FALSE ,

x_return_status                 OUT NOCOPY VARCHAR2                    ,
x_msg_count                     OUT NOCOPY NUMBER                      ,
x_msg_data                      OUT NOCOPY VARCHAR2                    ,

p_allocation_definition_rec     IN Allocation_Definition_Rec_Type
)
IS
	l_api_name              CONSTANT VARCHAR2(30)   := 'Delete_Allocation_Definition' ;

Line: 646


    SAVEPOINT    Delete_Alloc_Definition_PUB;

Line: 666


    	log_msg('Beginning Delete Allocation Definition process.');

Line: 805


    SELECT count(1)
      INTO l_cnt
      FROM gl_aloc_bas
     WHERE alloc_id = l_alloc_def_rec.alloc_id
       AND line_no  = l_alloc_def_rec.line_no ;

Line: 831


    l_alloc_def_rec.delete_mark := 1;

Line: 834


    	log_msg('deleteing record for alloc_id : ' ||
				l_alloc_def_rec.alloc_id ||' line_no : ' || l_alloc_def_rec.line_no);

Line: 838


    GMF_AllocationDefinition_PVT.Update_Allocation_Definition
    ( p_api_version    		  => 3.0
    , p_init_msg_list  		  => FND_API.G_FALSE
    , p_commit         		  => FND_API.G_FALSE

    , x_return_status  		  => l_return_status
    , x_msg_count      		  => l_count
    , x_msg_data       		  => l_data

    , p_allocation_definition_rec => l_alloc_def_rec
    , p_user_id			  => l_user_id
   );

Line: 875


    	log_msg(l_no_rows_del || ' rows deleted.');

Line: 891


        ROLLBACK TO  Delete_Alloc_Definition_PUB;

Line: 898


        ROLLBACK TO  Delete_Alloc_Definition_PUB;

Line: 905


        ROLLBACK TO  Delete_Alloc_Definition_PUB;

Line: 920


END Delete_Allocation_Definition ;

Line: 970


    l_delete_mark           NUMBER                              ; -- := FND_API.G_MISS_NUM ;

Line: 1001


    l_delete_mark         := p_alloc_def_rec.delete_mark ;

Line: 1021


    	log_msg('delete_mark   : ' || l_delete_mark);

Line: 1048


      	SELECT legal_entity_id
      	  INTO l_legal_entity_id
      	  FROM gl_aloc_mst
      	 WHERE alloc_id = l_alloc_id ;

Line: 1261


	    G_operation = 'UPDATE') OR
	   (G_operation = 'INSERT') THEN
      	add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1321


       ELSIF (l_basis_account_key = FND_API.G_MISS_CHAR AND	G_operation = 'UPDATE') OR
            	     (G_operation = 'INSERT') THEN
            	       add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1348


	    G_operation = 'UPDATE') OR
	   (G_operation = 'INSERT') THEN
	       add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1376


	       G_operation = 'UPDATE') OR
	      (G_operation = 'INSERT') THEN
	       add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1446


       	ELSIF (l_fixed_percent = FND_API.G_MISS_NUM AND	G_operation = 'UPDATE') OR
      	       (G_operation = 'INSERT') THEN
      	       add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1546


	   G_operation = 'UPDATE') OR
	  (G_operation = 'INSERT') THEN
	add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1573


	   G_operation = 'UPDATE') OR
	  (G_operation = 'INSERT') THEN
	  add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1584


    IF (l_delete_mark <> FND_API.G_MISS_NUM) AND
       (l_delete_mark IS NOT NULL) THEN
      IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN	-- Bug 2659435
      	log_msg('validating delete_mark :' || l_delete_mark);

Line: 1590


      IF l_delete_mark NOT IN (0,1) THEN
      	add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1592


      	FND_MESSAGE.SET_NAME('GMF','GMF_API_INVALID_DELETE_MARK');

Line: 1593


      	FND_MESSAGE.SET_TOKEN('DELETE_MARK',l_delete_mark);

Line: 1597


    ELSIF (l_delete_mark = FND_API.G_MISS_NUM AND	G_operation = 'UPDATE') OR
	  (G_operation = 'INSERT') THEN
	       add_header_to_error_stack(p_alloc_def_rec); -- Bug 2659435

Line: 1600


          FND_MESSAGE.SET_NAME('GMF','GMF_API_DELETE_MARK_REQ');

Line: 1650


    x_alloc_def_rec.delete_mark         := l_delete_mark ;

Line: 1698


      SELECT distinct alloc_method
        FROM gl_aloc_bas
       WHERE alloc_id = p_alloc_id
         AND delete_mark = 0;

Line: 1751


      SELECT nvl(sum(fixed_percent),0)
        FROM gl_aloc_bas
       WHERE alloc_id     = p_alloc_id
         AND delete_mark  = 0
         AND alloc_method = 1 ;

Line: 1807


      SELECT count(1)
        FROM gl_aloc_bas
       WHERE alloc_id = p_alloc_id
         AND line_no  = p_line_no ;