APPS.OE_BLANKET_PVT SQL Statements

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

Line: 64

         OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
         OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE)  -- hashraf pack J
   THEN

        IF l_debug_level  > 0 THEN
            oe_debug_pub.add(  'CHECK BLANKET HEADER ATTRIBUTES SECURITY', 1 ) ;

Line: 124

         OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
         OR p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf Pack J
   THEN
        IF l_debug_level  > 0 THEN
            oe_debug_pub.add(  'CHECK BLANKET HEADER ENTITY SECURITY' ) ;

Line: 166

		IF p_x_header_rec.operation = oe_globals.g_opr_update THEN
 		  oe_blanket_util.update_row (p_header_rec => p_x_header_rec,
                                    x_return_status => l_return_status);

Line: 174

		  oe_blanket_util.insert_row (p_header_rec => p_x_header_rec,
                                    x_return_status => l_return_status);

Line: 181

		ELSIF p_x_header_rec.operation = oe_globals.g_opr_delete THEN
		  oe_blanket_util.delete_row (p_header_id => p_x_header_rec.header_id,
                                    x_return_status => l_return_status);

Line: 201

          oe_debug_pub.add('delete request1',2);

Line: 217

            oe_debug_pub.add('delete request1',2);

Line: 233

            oe_debug_pub.add('delete request1',2);

Line: 314

         OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
   THEN

        IF l_debug_level  > 0 THEN
            oe_debug_pub.add(  'CHECK BLANKET LINE ATTRIBUTES SECURITY' ) ;

Line: 360

         OR l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
OR l_line_rec.operation = OE_GLOBALS.G_OPR_DELETE) -- hashraf pack J
   THEN

        IF l_debug_level  > 0 THEN
            oe_debug_pub.add(  'CHECK BLANKET LINE ENTITY SECURITY' ) ;

Line: 405

		IF l_line_rec.operation = oe_globals.g_opr_update THEN
	              oe_blanket_util.update_row (p_line_rec => l_line_rec,
                                  x_return_status => l_return_status);

Line: 415

	oe_blanket_util.insert_row (p_line_rec => l_line_rec,
                                  x_return_status => l_return_status);

Line: 422

		ELSIF l_line_rec.operation = oe_globals.g_opr_delete THEN


	oe_blanket_util.delete_row (p_line_id => l_line_rec.line_id,
                                  x_return_status => l_return_status);

Line: 456

            oe_debug_pub.add('delete request1',2);

Line: 473

            oe_debug_pub.add('delete request1',2);

Line: 490

            oe_debug_pub.add('delete request1',2);