APPS.AHL_LTP_REQST_MATRL_PUB SQL Statements

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

Line: 45

PROCEDURE Update_Planned_Materials (
   p_api_version             IN    NUMBER,
   p_init_msg_list           IN    VARCHAR2  := FND_API.g_false,
   p_commit                  IN    VARCHAR2  := FND_API.g_false,
   p_validation_level        IN    NUMBER    := FND_API.g_valid_level_full,
   p_module_type             IN    VARCHAR2  := 'JSP',
   p_planned_Materials_tbl   IN    Planned_Materials_Tbl,
   x_return_status              OUT NOCOPY VARCHAR2,
   x_msg_count                  OUT NOCOPY NUMBER,
   x_msg_data                   OUT NOCOPY VARCHAR2)

  IS


    --Standard local variables
    l_api_name	    CONSTANT	VARCHAR2(30)	:= 'Update_Planned_Materials';

Line: 74

			'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update_Planned_Materials',
			'At the start of PLSQL procedure'
		);

Line: 79

     SAVEPOINT Update_Planned_Materials;

Line: 92

			'Request for Update Material Number of Records : '|| l_planned_materials_tbl.COUNT
		);

Line: 104

    	        'Before calling ahl ltp reqst matrl pvt.Update Planned Materials'
   		  );

Line: 109

       AHL_LTP_REQST_MATRL_PVT.Update_Planned_Materials (
                 p_api_version            => l_api_version,
                 p_init_msg_list          => p_init_msg_list,
                 p_commit                 => l_commit,
                 p_validation_level       => p_validation_level,
                 p_planned_materials_tbl  => p_planned_materials_tbl,
                 x_return_status          => l_return_status,
                 x_msg_count              => l_msg_count,
                 x_msg_data               => l_msg_data);

Line: 125

	        'After calling ahl ltp reqst matrl pvt.Update Planned Materials, Return Status : '|| l_return_status
		);

Line: 145

			'ahl.plsql.AHL_LTP_REQST_MATRL_PUB.Update Planned Materials.end',
			'At the end of PLSQL procedure'
		);

Line: 152

   ROLLBACK TO Update_Planned_Materials;

Line: 160

   ROLLBACK TO Update_Planned_Materials;

Line: 168

    ROLLBACK TO Update_Planned_Materials;

Line: 171

                               p_procedure_name => 'Update_Planned_Materials',
                               p_error_text     => SUBSTR(SQLERRM,1,500));

Line: 178

  END Update_Planned_Materials;